Below is the list of changes that have just been committed into a local
5.0 repository of psergey. When psergey does a push these changes will
be propagated to the main repository and, within 24 hours after the
push, to the public repository.
For information on how to access the public repository
see http://dev.mysql.com/doc/mysql/en/installing-source-tree.html
ChangeSet
1.1924 05/08/03 03:47:07 sergefp@stripped +14 -0
Manual merge
mysql-test/t/sp.test
1.137 05/08/03 03:47:04 sergefp@stripped +18 -23
Manual merge
sql/sql_trigger.h
1.12 05/08/03 03:44:30 sergefp@stripped +0 -0
Auto merged
sql/sql_parse.cc
1.456 05/08/03 03:44:30 sergefp@stripped +0 -0
Auto merged
sql/sql_lex.cc
1.160 05/08/03 03:44:30 sergefp@stripped +0 -0
Auto merged
sql/sql_class.h
1.253 05/08/03 03:44:30 sergefp@stripped +0 -0
Auto merged
sql/sql_class.cc
1.197 05/08/03 03:44:30 sergefp@stripped +0 -0
Auto merged
sql/sql_base.cc
1.275 05/08/03 03:44:29 sergefp@stripped +0 -0
Auto merged
sql/sp_head.h
1.64 05/08/03 03:44:29 sergefp@stripped +0 -0
Auto merged
sql/sp_head.cc
1.162 05/08/03 03:44:29 sergefp@stripped +0 -0
Auto merged
sql/sp.cc
1.85 05/08/03 03:44:29 sergefp@stripped +0 -0
Auto merged
sql/item_func.cc
1.238 05/08/03 03:44:29 sergefp@stripped +0 -0
Auto merged
mysql-test/t/view.test
1.92 05/08/03 03:44:29 sergefp@stripped +0 -0
Auto merged
mysql-test/r/view.result
1.97 05/08/03 03:44:29 sergefp@stripped +0 -0
Auto merged
mysql-test/r/sp.result
1.141 05/08/03 03:44:29 sergefp@stripped +0 -0
Auto merged
# This is a BitKeeper patch. What follows are the unified diffs for the
# set of deltas contained in the patch. The rest of the patch, the part
# that BitKeeper cares about, is below these diffs.
# User: sergefp
# Host: newbox.mylan
# Root: /home/psergey/mysql-5.0-sp-no-lock-r7/RESYNC
--- 1.237/sql/item_func.cc 2005-08-02 00:54:53 +00:00
+++ 1.238/sql/item_func.cc 2005-08-03 03:44:29 +00:00
@@ -4656,7 +4656,7 @@
THD *thd= current_thd;
ulong old_client_capabilites;
int res= -1;
- bool save_in_sub_stmt= thd->transaction.in_sub_stmt;
+ bool save_in_sub_stmt= thd->in_sub_stmt;
my_bool save_no_send_ok;
#ifndef NO_EMBEDDED_ACCESS_CHECKS
st_sp_security_context save_ctx;
@@ -4694,11 +4694,11 @@
*/
tmp_disable_binlog(thd); /* don't binlog the substatements */
- thd->transaction.in_sub_stmt= TRUE;
+ thd->in_sub_stmt= TRUE;
res= m_sp->execute_function(thd, args, arg_count, itp);
- thd->transaction.in_sub_stmt= save_in_sub_stmt;
+ thd->in_sub_stmt= save_in_sub_stmt;
reenable_binlog(thd);
if (res && mysql_bin_log.is_open() &&
(m_sp->m_chistics->daccess == SP_CONTAINS_SQL ||
--- 1.274/sql/sql_base.cc 2005-07-31 09:49:47 +00:00
+++ 1.275/sql/sql_base.cc 2005-08-03 03:44:29 +00:00
@@ -391,6 +391,8 @@
LOCK_open
skip_derived Set to 1 (0 = default) if we should not free derived
tables.
+ stopper When closing tables from thd->open_tables(->next)*,
+ don't close/remove tables starting from stopper.
IMPLEMENTATION
Unlocks tables and frees derived tables.
@@ -474,6 +476,7 @@
We are in prelocked mode, so we have to leave it now with doing
implicit UNLOCK TABLES if need.
*/
+ DBUG_PRINT("info",("thd->prelocked_mode= NON_PRELOCKED"));
thd->prelocked_mode= NON_PRELOCKED;
if (prelocked_mode == PRELOCKED_UNDER_LOCK_TABLES)
@@ -1792,6 +1795,7 @@
DBUG_RETURN(1);
}
+
/*
Open all tables in list
@@ -1843,10 +1847,6 @@
statement for which table list for prelocking is already built, let
us cache routines and try to build such table list.
- NOTE: If we want queries with functions to work under explicit
- LOCK TABLES we have to additionaly lock mysql.proc table in it.
- At least until Monty will fix SP loading :)
-
NOTE: We can't delay prelocking until we will met some sub-statement
which really uses tables, since this will imply that we have to restore
its table list to be able execute it in some other context.
@@ -1860,16 +1860,23 @@
mode we will have some locked tables, because queries which use only
derived/information schema tables and views possible. Thus "counter"
may be still zero for prelocked statement...
+
+ NOTE: The above notes may be out of date. Please wait for psergey to
+ document new prelocked behavior.
*/
- if (!thd->prelocked_mode && !thd->lex->requires_prelocking() &&
- thd->lex->sroutines.records)
+
+ if (!thd->prelocked_mode && !thd->lex->requires_prelocking() &&
+ thd->lex->sroutines_list.elements)
{
+ bool first_no_prelocking, need_prelocking;
TABLE_LIST **save_query_tables_last= thd->lex->query_tables_last;
DBUG_ASSERT(thd->lex->query_tables == *start);
+ sp_get_prelocking_info(thd, &need_prelocking, &first_no_prelocking);
- if (sp_cache_routines_and_add_tables(thd, thd->lex) ||
- *start)
+ if ((sp_cache_routines_and_add_tables(thd, thd->lex,
+ first_no_prelocking) ||
+ *start) && need_prelocking)
{
query_tables_last_own= save_query_tables_last;
*start= thd->lex->query_tables;
@@ -1891,14 +1898,32 @@
DBUG_RETURN(-1);
}
(*counter)++;
+
if (!tables->table &&
!(tables->table= open_table(thd, tables, &new_frm_mem, &refresh, 0)))
{
free_root(&new_frm_mem, MYF(MY_KEEP_PREALLOC));
+
if (tables->view)
{
/* VIEW placeholder */
(*counter)--;
+
+ /*
+ tables->next_global list consists of two parts:
+ 1) Query tables and underlying tables of views.
+ 2) Tables used by all stored routines that this statement invokes on
+ execution.
+ We need to know where the bound between these two parts is. If we've
+ just opened a view, which was the last table in part #1, and it
+ has added its base tables after itself, adjust the boundary pointer
+ accordingly.
+ */
+ if (query_tables_last_own &&
+ query_tables_last_own == &(tables->next_global) &&
+ tables->view->query_tables)
+ query_tables_last_own= tables->view->query_tables_last;
+
/*
Again if needed we have to get cache all routines used by this view
and add tables used by them to table list.
@@ -2323,6 +2348,7 @@
and was marked as occupied during open_tables() as free for reuse.
*/
mark_real_tables_as_free_for_reuse(first_not_own);
+ DBUG_PRINT("info",("prelocked_mode= PRELOCKED"));
thd->prelocked_mode= PRELOCKED;
}
}
@@ -2346,6 +2372,7 @@
if (thd->lex->requires_prelocking())
{
mark_real_tables_as_free_for_reuse(first_not_own);
+ DBUG_PRINT("info", ("thd->prelocked_mode= PRELOCKED_UNDER_LOCK_TABLES"));
thd->prelocked_mode= PRELOCKED_UNDER_LOCK_TABLES;
}
}
--- 1.196/sql/sql_class.cc 2005-08-03 03:37:28 +00:00
+++ 1.197/sql/sql_class.cc 2005-08-03 03:44:30 +00:00
@@ -523,6 +523,10 @@
if this is the slave SQL thread.
*/
variables.pseudo_thread_id= thread_id;
+ /*
+ We have to call thr_lock_info_init() again here as THD may have been
+ created in another thread
+ */
thr_lock_info_init(&lock_info);
return 0;
}
--- 1.252/sql/sql_class.h 2005-08-02 19:09:44 +00:00
+++ 1.253/sql/sql_class.h 2005-08-03 03:44:30 +00:00
@@ -1132,6 +1132,10 @@
thr_lock_type update_lock_default;
delayed_insert *di;
my_bool tablespace_op; /* This is TRUE in DISCARD/IMPORT TABLESPACE */
+
+ /* TRUE if we are inside of trigger or stored function. */
+ bool in_sub_stmt;
+
/* container for handler's private per-connection data */
void *ha_data[MAX_HA];
struct st_transactions {
@@ -1139,8 +1143,6 @@
THD_TRANS all; // Trans since BEGIN WORK
THD_TRANS stmt; // Trans for current statement
bool on; // see ha_enable_transaction()
- /* TRUE if we are inside of trigger or stored function. */
- bool in_sub_stmt;
XID xid; // transaction identifier
enum xa_states xa_state; // used by external XA only
/*
--- 1.159/sql/sql_lex.cc 2005-07-28 13:12:38 +00:00
+++ 1.160/sql/sql_lex.cc 2005-08-03 03:44:30 +00:00
@@ -2008,6 +2008,7 @@
time_zone_tables_used= 0;
if (sroutines.records)
my_hash_reset(&sroutines);
+ sroutines_list.empty();
}
--- 1.455/sql/sql_parse.cc 2005-08-02 00:54:53 +00:00
+++ 1.456/sql/sql_parse.cc 2005-08-03 03:44:30 +00:00
@@ -27,6 +27,7 @@
#include "sp_head.h"
#include "sp.h"
+#include "sp_cache.h"
#ifdef HAVE_OPENSSL
/*
@@ -124,7 +125,7 @@
{
int error=0;
DBUG_ENTER("end_active_trans");
- if (unlikely(thd->transaction.in_sub_stmt))
+ if (unlikely(thd->in_sub_stmt))
{
my_error(ER_COMMIT_NOT_ALLOWED_IN_SF_OR_TRG, MYF(0));
DBUG_RETURN(1);
@@ -147,11 +148,7 @@
static bool begin_trans(THD *thd)
{
int error=0;
- /*
- QQ: May be it is better to simply prohibit COMMIT and ROLLBACK in
- stored routines as SQL2003 suggests?
- */
- if (unlikely(thd->transaction.in_sub_stmt))
+ if (unlikely(thd->in_sub_stmt))
{
my_error(ER_COMMIT_NOT_ALLOWED_IN_SF_OR_TRG, MYF(0));
return 1;
@@ -1340,11 +1337,7 @@
int res= 0;
DBUG_ENTER("end_trans");
- /*
- QQ: May be it is better to simply prohibit COMMIT and ROLLBACK in
- stored routines as SQL2003 suggests?
- */
- if (unlikely(thd->transaction.in_sub_stmt))
+ if (unlikely(thd->in_sub_stmt))
{
my_error(ER_COMMIT_NOT_ALLOWED_IN_SF_OR_TRG, MYF(0));
DBUG_RETURN(1);
@@ -4129,9 +4122,8 @@
goto error;
/*
- By this moment all needed SPs should be in cache so no need
- to look into DB. Moreover we may be unable to do it becuase
- we may don't have read lock on mysql.proc
+ By this moment all needed SPs should be in cache so no need to look
+ into DB.
*/
if (!(sp= sp_find_procedure(thd, lex->spname, TRUE)))
{
@@ -4196,7 +4188,7 @@
select_limit= thd->variables.select_limit;
thd->variables.select_limit= HA_POS_ERROR;
- thd->row_count_func= 0;
+ thd->row_count_func= 0;
tmp_disable_binlog(thd); /* don't binlog the substatements */
res= sp->execute_procedure(thd, &lex->value_list);
reenable_binlog(thd);
--- 1.96/mysql-test/r/view.result 2005-07-25 16:06:53 +00:00
+++ 1.97/mysql-test/r/view.result 2005-08-03 03:44:29 +00:00
@@ -581,6 +581,11 @@
drop view v1;
create view v1 (a,a) as select 'a','a';
ERROR 42S21: Duplicate column name 'a'
+drop procedure if exists p1;
+create procedure p1 () begin declare v int; create view v1 as select v; end;//
+call p1();
+ERROR HY000: View's SELECT contains a variable or parameter
+drop procedure p1;
create table t1 (col1 int,col2 char(22));
insert into t1 values(5,'Hello, world of views');
create view v1 as select * from t1;
--- 1.91/mysql-test/t/view.test 2005-07-31 09:49:46 +00:00
+++ 1.92/mysql-test/t/view.test 2005-08-03 03:44:29 +00:00
@@ -491,15 +491,15 @@
#
# SP variables inside view test
#
-# QQ This can't be tested with the new table locking for functions,
-# QQ since views created in an SP can't be used within the same SP
-# QQ (just as for tables). Instead it fails with error 1146.
-#delimiter //;
-#create procedure p1 () begin declare v int; create view v1 as select v; end;//
-#delimiter ;//
-#-- error 1351
-#call p1();
-#drop procedure p1;
+--disable_warnings
+drop procedure if exists p1;
+--enable_warnings
+delimiter //;
+create procedure p1 () begin declare v int; create view v1 as select v; end;//
+delimiter ;//
+-- error 1351
+call p1();
+drop procedure p1;
#
# updatablity should be transitive
--- 1.11/sql/sql_trigger.h 2005-07-28 19:39:07 +00:00
+++ 1.12/sql/sql_trigger.h 2005-08-03 03:44:30 +00:00
@@ -82,7 +82,7 @@
if (bodies[event][time_type])
{
- bool save_in_sub_stmt= thd->transaction.in_sub_stmt;
+ bool save_in_sub_stmt= thd->in_sub_stmt;
#ifndef EMBEDDED_LIBRARY
/* Surpress OK packets in case if we will execute statements */
my_bool nsok= thd->net.no_send_ok;
@@ -111,11 +111,11 @@
does NOT go into binlog.
*/
tmp_disable_binlog(thd);
- thd->transaction.in_sub_stmt= TRUE;
+ thd->in_sub_stmt= TRUE;
res= bodies[event][time_type]->execute_function(thd, 0, 0, 0);
- thd->transaction.in_sub_stmt= save_in_sub_stmt;
+ thd->in_sub_stmt= save_in_sub_stmt;
reenable_binlog(thd);
#ifndef EMBEDDED_LIBRARY
--- 1.140/mysql-test/r/sp.result 2005-07-29 20:39:04 +00:00
+++ 1.141/mysql-test/r/sp.result 2005-08-03 03:44:29 +00:00
@@ -1,10 +1,9 @@
use test;
-drop table if exists t1;
+drop table if exists t1,t2,t3,t4;
create table t1 (
id char(16) not null default '',
data int not null
);
-drop table if exists t2;
create table t2 (
s char(16),
i int,
@@ -85,7 +84,6 @@
kaka 3
delete from t1|
drop procedure setcontext|
-drop table if exists t3|
create table t3 ( d date, i int, f double, s varchar(32) )|
drop procedure if exists nullset|
create procedure nullset()
@@ -521,7 +519,6 @@
insert into test.t3 values ("into4", x);
end|
delete from t1|
-drop table if exists t3|
create table t3 ( s char(16), d int)|
call into_test4()|
Warnings:
@@ -565,13 +562,12 @@
create temporary table test.t3 select * from test.t1;
insert into test.t3 values (concat(x, "2"), y+2);
end|
-drop table if exists t3|
call create_select("cs", 90)|
select * from t1, t3|
id data id data
cs 90 cs 90
cs 90 cs2 92
-drop table if exists t3|
+drop table t3|
delete from t1|
drop procedure create_select|
drop function if exists e|
@@ -702,7 +698,6 @@
hndlr3 13
delete from t1|
drop procedure hndlr3|
-drop table if exists t3|
create table t3 ( id char(16), data int )|
drop procedure if exists hndlr4|
create procedure hndlr4()
@@ -745,7 +740,6 @@
bar 15
zap 663
drop procedure cur1|
-drop table if exists t3|
create table t3 ( s char(16), i int )|
drop procedure if exists cur2|
create procedure cur2()
@@ -1309,7 +1303,6 @@
t1max()
5
drop function t1max|
-drop table if exists t3|
create table t3 (
v char(16) not null primary key,
c int unsigned not null
@@ -1430,7 +1423,6 @@
2 NULL
drop table t70|
drop procedure bug1656|
-drop table if exists t3|
create table t3(a int)|
drop procedure if exists bug1862|
create procedure bug1862()
@@ -1555,7 +1547,6 @@
42
drop procedure bug2776_1|
drop procedure bug2776_2|
-drop table if exists t3|
create table t3 (s1 smallint)|
insert into t3 values (123456789012)|
Warnings:
@@ -1616,7 +1607,6 @@
drop procedure bug1863|
drop temporary table temp_t1;
drop table t3, t4|
-drop table if exists t3, t4|
create table t3 (
OrderID int not null,
MarketID int,
@@ -1694,7 +1684,6 @@
@i time
2 01-01-1970 03:16:40
drop procedure bug3426|
-drop table if exists t3, t4|
create table t3 (
a int primary key,
ach char(1)
@@ -1724,7 +1713,6 @@
1 a 1 b
drop procedure bug3448|
drop table t3, t4|
-drop table if exists t3|
create table t3 (
id int unsigned auto_increment not null primary key,
title VARCHAR(200),
@@ -1873,7 +1861,6 @@
1+2
3
drop procedure bug3843|
-drop table if exists t3|
create table t3 ( s1 char(10) )|
insert into t3 values ('a'), ('b')|
drop procedure if exists bug3368|
@@ -1889,7 +1876,6 @@
yz,yz
drop procedure bug3368|
drop table t3|
-drop table if exists t3|
create table t3 (f1 int, f2 int)|
insert into t3 values (1,1)|
drop procedure if exists bug4579_1|
@@ -1914,7 +1900,6 @@
drop procedure bug4579_1|
drop procedure bug4579_2|
drop table t3|
-drop table if exists t3|
drop procedure if exists bug2773|
create function bug2773() returns int return null|
create table t3 as select bug2773()|
@@ -1936,7 +1921,6 @@
bug3788()
5
drop function bug3788|
-drop table if exists t3|
create table t3 (f1 int, f2 int, f3 int)|
insert into t3 values (1,1,1)|
drop procedure if exists bug4726|
@@ -2097,7 +2081,6 @@
Id User Host db Command Time State Info
# root localhost test Query # NULL show processlist
drop procedure bug4902_2|
-drop table if exists t3|
drop procedure if exists bug4904|
create procedure bug4904()
begin
@@ -2286,7 +2269,6 @@
flush query cache|
delete from t1|
drop procedure bug3583|
-drop table if exists t3|
drop procedure if exists bug4905|
create table t3 (s1 int,primary key (s1))|
drop procedure if exists bug4905|
@@ -2344,7 +2326,6 @@
y z
1 1
drop procedure bug8540|
-drop table if exists t3|
create table t3 (s1 int)|
drop procedure if exists bug6642|
create procedure bug6642()
@@ -2427,7 +2408,6 @@
drop procedure bug7992_1|
drop procedure bug7992_2|
drop table t3|
-drop table if exists t3|
create table t3 ( userid bigint(20) not null default 0 )|
drop procedure if exists bug8116|
create procedure bug8116(in _userid int)
@@ -2588,7 +2568,6 @@
drop procedure if exists bug6900|
drop procedure if exists bug9074|
drop procedure if exists bug6900_9074|
-drop table if exists t3|
create table t3 (w char unique, x char)|
insert into t3 values ('a', 'b')|
create procedure bug6900()
@@ -3042,32 +3021,6 @@
drop procedure if exists bug6063|
drop procedure if exists bug7088_1|
drop procedure if exists bug7088_2|
-create procedure bug6063()
-call bug6063()|
-show create procedure bug6063|
-Procedure sql_mode Create Procedure
-bug6063 CREATE PROCEDURE `test`.`bug6063`()
-l?bel: begin end
-set character set utf8|
-create procedure bug7088_1()
-label1: begin end label1|
-create procedure bug7088_2()
-läbel1: begin end|
-call bug7088_1()|
-call bug7088_2()|
-set character set default|
-show create procedure bug7088_1|
-Procedure sql_mode Create Procedure
-bug7088_1 CREATE PROCEDURE `test`.`bug7088_1`()
-label1: begin end label1
-show create procedure bug7088_2|
-Procedure sql_mode Create Procedure
-bug7088_2 CREATE PROCEDURE `test`.`bug7088_2`()
-drop procedure bug6063|
-drop procedure bug7088_1|
-drop procedure bug7088_2|
drop procedure if exists bug9565_sub|
drop procedure if exists bug9565|
create procedure bug9565_sub()
--- 1.136/mysql-test/t/sp.test 2005-07-31 09:51:08 +00:00
+++ 1.137/mysql-test/t/sp.test 2005-08-03 03:47:04 +00:00
@@ -22,15 +22,12 @@
# t3 and up are created and dropped when needed.
#
--disable_warnings
-drop table if exists t1;
+drop table if exists t1,t2,t3,t4;
--enable_warnings
create table t1 (
id char(16) not null default '',
data int not null
);
---disable_warnings
-drop table if exists t2;
---enable_warnings
create table t2 (
s char(16),
i int,
@@ -150,9 +147,6 @@
# Set things to null
---disable_warnings
-drop table if exists t3|
---enable_warnings
create table t3 ( d date, i int, f double, s varchar(32) )|
--disable_warnings
@@ -686,9 +680,6 @@
end|
delete from t1|
---disable_warnings
-drop table if exists t3|
---enable_warnings
create table t3 ( s char(16), d int)|
call into_test4()|
select * from t3|
@@ -744,14 +735,9 @@
insert into test.t3 values (concat(x, "2"), y+2);
end|
---disable_warnings
-drop table if exists t3|
---enable_warnings
call create_select("cs", 90)|
select * from t1, t3|
---disable_warnings
-drop table if exists t3|
---enable_warnings
+drop table t3|
delete from t1|
drop procedure create_select|
@@ -925,9 +911,6 @@
# Variables might be uninitialized when using handlers
# (Otherwise the compiler can detect if a variable is not set, but
# not in this case.)
---disable_warnings
-drop table if exists t3|
---enable_warnings
create table t3 ( id char(16), data int )|
--disable_warnings
@@ -980,9 +963,6 @@
select * from t1|
drop procedure cur1|
---disable_warnings
-drop table if exists t3|
---enable_warnings
create table t3 ( s char(16), i int )|
--disable_warnings
@@ -1619,9 +1599,6 @@
select t1max()|
drop function t1max|
---disable_warnings
-drop table if exists t3|
---enable_warnings
create table t3 (
v char(16) not null primary key,
c int unsigned not null
@@ -1755,9 +1732,6 @@
#
# BUG#1862
#
---disable_warnings
-drop table if exists t3|
---enable_warnings
create table t3(a int)|
--disable_warnings
@@ -2018,9 +1992,6 @@
#
# BUG#2780
#
---disable_warnings
-drop table if exists t3|
---enable_warnings
create table t3 (s1 smallint)|
insert into t3 values (123456789012)|
@@ -2094,9 +2065,6 @@
#
# BUG#2656
#
---disable_warnings
-drop table if exists t3, t4|
---enable_warnings
create table t3 (
OrderID int not null,
@@ -2184,8 +2152,6 @@
# BUG#3448
#
--disable_warnings
-drop table if exists t3, t4|
-
create table t3 (
a int primary key,
ach char(1)
@@ -2217,9 +2183,6 @@
#
# BUG#3734
#
---disable_warnings
-drop table if exists t3|
---enable_warnings
create table t3 (
id int unsigned auto_increment not null primary key,
title VARCHAR(200),
@@ -2395,9 +2358,6 @@
#
# BUG#3368
#
---disable_warnings
-drop table if exists t3|
---enable_warnings
create table t3 ( s1 char(10) )|
insert into t3 values ('a'), ('b')|
@@ -2417,9 +2377,6 @@
#
# BUG#4579
#
---disable_warnings
-drop table if exists t3|
---enable_warnings
create table t3 (f1 int, f2 int)|
insert into t3 values (1,1)|
@@ -2454,7 +2411,6 @@
# BUG#2773: Function's data type ignored in stored procedures
#
--disable_warnings
-drop table if exists t3|
drop procedure if exists bug2773|
--enable_warnings
@@ -2483,10 +2439,6 @@
#
# BUG#4726
#
---disable_warnings
-drop table if exists t3|
---enable_warnings
-
create table t3 (f1 int, f2 int, f3 int)|
insert into t3 values (1,1,1)|
@@ -2517,29 +2469,24 @@
# BUG#4318
#
#QQ Don't know if HANDLER commands can work with SPs, or at all...
---disable_parsing
---disable_warnings
-drop table if exists t3|
---enable_warnings
-
-create table t3 (s1 int)|
-insert into t3 values (3), (4)|
-
---disable_warnings
-drop procedure if exists bug4318|
---enable_warnings
-create procedure bug4318()
- handler t3 read next|
-
-handler t3 open|
-# Expect no results, as tables are closed, but there shouldn't be any errors
-call bug4318()|
-call bug4318()|
-handler t3 close|
-
-drop procedure bug4318|
-drop table t3|
---enable_parsing
+#
+#create table t3 (s1 int)|
+#insert into t3 values (3), (4)|
+#
+#--disable_warnings
+#drop procedure if exists bug4318|
+#--enable_warnings
+#create procedure bug4318()
+# handler t3 read next|
+#
+#handler t3 open|
+## Expect no results, as tables are closed, but there shouldn't be any errors
+#call bug4318()|
+#call bug4318()|
+#handler t3 close|
+#
+#drop procedure bug4318|
+#drop table t3|
#
# BUG#4902: Stored procedure with SHOW WARNINGS leads to packet error
@@ -2605,10 +2552,6 @@
# BUG#4904
#
--disable_warnings
-drop table if exists t3|
---enable_warnings
-
---disable_warnings
drop procedure if exists bug4904|
--enable_warnings
create procedure bug4904()
@@ -2861,7 +2804,6 @@
# BUG#4905: Stored procedure doesn't clear for "Rows affected"
#
--disable_warnings
-drop table if exists t3|
drop procedure if exists bug4905|
--enable_warnings
@@ -2961,9 +2903,6 @@
#
# BUG#6642: Stored procedure crash if expression with set function
#
---disable_warnings
-drop table if exists t3|
---enable_warnings
create table t3 (s1 int)|
--disable_warnings
@@ -3051,9 +2990,6 @@
# BUG#8116: calling simple stored procedure twice in a row results
# in server crash
#
---disable_warnings
-drop table if exists t3|
---enable_warnings
create table t3 ( userid bigint(20) not null default 0 )|
--disable_warnings
@@ -3296,7 +3232,6 @@
drop procedure if exists bug6900|
drop procedure if exists bug9074|
drop procedure if exists bug6900_9074|
-drop table if exists t3|
--enable_warnings
create table t3 (w char unique, x char)|
@@ -3825,26 +3760,27 @@
drop procedure if exists bug7088_2|
--enable_warnings
-create procedure bug6063()
-call bug6063()|
-# QQ Known bug: this will not show the label correctly.
-show create procedure bug6063|
-
-set character set utf8|
-create procedure bug7088_1()
- label1: begin end label1|
-create procedure bug7088_2()
- läbel1: begin end|
-call bug7088_1()|
-call bug7088_2()|
-set character set default|
-show create procedure bug7088_1|
-show create procedure bug7088_2|
-
-drop procedure bug6063|
-drop procedure bug7088_1|
-drop procedure bug7088_2|
+# psergey: temporarily disabled until Bar fixes BUG#11986
+# create procedure bug6063()
+# call bug6063()|
+# # QQ Known bug: this will not show the label correctly.
+# show create procedure bug6063|
+#
+# set character set utf8|
+# create procedure bug7088_1()
+# label1: begin end label1|
+# create procedure bug7088_2()
+# läbel1: begin end|
+# call bug7088_1()|
+# call bug7088_2()|
+# set character set default|
+# show create procedure bug7088_1|
+# show create procedure bug7088_2|
+#
+# drop procedure bug6063|
+# drop procedure bug7088_1|
+# drop procedure bug7088_2|
#
# BUG#9565: "Wrong locking in stored procedure if a sub-sequent procedure
--- 1.84/sql/sp.cc 2005-07-28 13:08:52 +00:00
+++ 1.85/sql/sp.cc 2005-08-03 03:44:29 +00:00
@@ -1176,6 +1176,43 @@
/*
+ Check if
+ - current statement (the one in thd->lex) needs table prelocking
+ - first routine in thd->lex->sroutines_list needs to execute its body in
+ prelocked mode.
+
+ SYNOPSIS
+ sp_get_prelocking_info()
+ thd Current thread, thd->lex is the statement to be
+ checked.
+ need_prelocking OUT TRUE - prelocked mode should be activated
+ before executing the statement
+ FALSE - Don't activate prelocking
+ first_no_prelocking OUT TRUE - Tables used by first routine in
+ thd->lex->sroutines_list should be
+ prelocked.
+ FALSE - Otherwise.
+ NOTES
+ This function assumes that for any "CALL proc(...)" statement routines_list
+ will have 'proc' as first element (it may have several, consider e.g.
+ "proc(sp_func(...)))". This property is currently guaranted by the parser.
+*/
+
+void sp_get_prelocking_info(THD *thd, bool *need_prelocking,
+ bool *first_no_prelocking)
+{
+ Sroutine_hash_entry *routine;
+ routine= (Sroutine_hash_entry*)thd->lex->sroutines_list.first;
+
+ DBUG_ASSERT(routine);
+ bool first_is_procedure= (routine->key.str[0] == TYPE_ENUM_PROCEDURE);
+
+ *first_no_prelocking= first_is_procedure;
+ *need_prelocking= !first_is_procedure || test(routine->next);
+}
+
+
+/*
Auxilary function that adds new element to the set of stored routines
used by statement.
@@ -1312,11 +1349,13 @@
SYNOPSIS
sp_cache_routines_and_add_tables_aux()
- thd - thread context
- lex - LEX representing statement
- start - first routine from the list of routines to be cached
- (this list defines mentioned sub-set).
-
+ thd - thread context
+ lex - LEX representing statement
+ start - first routine from the list of routines to be cached
+ (this list defines mentioned sub-set).
+ first_no_prelock - If true, don't add tables or cache routines used by
+ the body of the first routine (i.e. *start)
+ will be executed in non-prelocked mode.
NOTE
If some function is missing this won't be reported here.
Instead this fact will be discovered during query execution.
@@ -1328,10 +1367,11 @@
static bool
sp_cache_routines_and_add_tables_aux(THD *thd, LEX *lex,
- Sroutine_hash_entry *start)
+ Sroutine_hash_entry *start,
+ bool first_no_prelock)
{
bool result= FALSE;
-
+ bool first= TRUE;
DBUG_ENTER("sp_cache_routines_and_add_tables_aux");
for (Sroutine_hash_entry *rt= start; rt; rt= rt->next)
@@ -1367,9 +1407,13 @@
}
if (sp)
{
- sp_update_stmt_used_routines(thd, lex, &sp->m_sroutines);
- result|= sp->add_used_tables_to_table_list(thd, &lex->query_tables_last);
+ if (!(first && first_no_prelock))
+ {
+ sp_update_stmt_used_routines(thd, lex, &sp->m_sroutines);
+ result|= sp->add_used_tables_to_table_list(thd, &lex->query_tables_last);
+ }
}
+ first= FALSE;
}
DBUG_RETURN(result);
}
@@ -1382,20 +1426,22 @@
SYNOPSIS
sp_cache_routines_and_add_tables()
- thd - thread context
- lex - LEX representing statement
-
+ thd - thread context
+ lex - LEX representing statement
+ first_no_prelock - If true, don't add tables or cache routines used by
+ the body of the first routine (i.e. *start)
+
RETURN VALUE
TRUE - some tables were added
FALSE - no tables were added.
*/
bool
-sp_cache_routines_and_add_tables(THD *thd, LEX *lex)
+sp_cache_routines_and_add_tables(THD *thd, LEX *lex, bool first_no_prelock)
{
-
return sp_cache_routines_and_add_tables_aux(thd, lex,
- (Sroutine_hash_entry *)lex->sroutines_list.first);
+ (Sroutine_hash_entry *)lex->sroutines_list.first,
+ first_no_prelock);
}
@@ -1417,8 +1463,8 @@
Sroutine_hash_entry **last_cached_routine_ptr=
(Sroutine_hash_entry **)lex->sroutines_list.next;
sp_update_stmt_used_routines(thd, lex, &aux_lex->sroutines);
- (void)sp_cache_routines_and_add_tables_aux(thd, lex,
- *last_cached_routine_ptr);
+ (void)sp_cache_routines_and_add_tables_aux(thd, lex,
+ *last_cached_routine_ptr, FALSE);
}
@@ -1456,7 +1502,8 @@
}
}
(void)sp_cache_routines_and_add_tables_aux(thd, lex,
- *last_cached_routine_ptr);
+ *last_cached_routine_ptr,
+ FALSE);
}
}
--- 1.161/sql/sp_head.cc 2005-08-01 22:43:36 +00:00
+++ 1.162/sql/sp_head.cc 2005-08-03 03:44:29 +00:00
@@ -883,7 +883,10 @@
octx= new sp_rcontext(csize, hmax, cmax);
tmp_octx= TRUE;
}
+
+ /* Evaluate SP arguments (i.e. get the values passed as parameters) */
// QQ: Should do type checking?
+ DBUG_PRINT("info",(" %.*s: eval args", m_name.length, m_name.str));
for (i = 0 ; (it= li++) && i < params ; i++)
{
sp_pvar_t *pvar= m_pcont->find_pvar(i);
@@ -920,6 +923,15 @@
}
}
+ /*
+ Okay, got values for all arguments. Close tables that might be used by
+ arguments evaluation. If arguments evaluation required prelocking mode,
+ we'll leave it here.
+ */
+ if (!thd->in_sub_stmt)
+ close_thread_tables(thd, 0, 0, 0);
+
+ DBUG_PRINT("info",(" %.*s: eval args done", m_name.length, m_name.str));
// The rest of the frame are local variables which are all IN.
// Default all variables to null (those with default clauses will
// be set by an set instruction).
@@ -1464,8 +1476,27 @@
implemented at the same time as ability not to store LEX for
instruction if it is not really used.
*/
- reinit_stmt_before_use(thd, m_lex);
+ if (thd->prelocked_mode == NON_PRELOCKED)
+ {
+ /*
+ This statement will enter/leave prelocked mode on its own.
+ Entering prelocked mode changes table list and related members
+ of LEX, so we'll need to restore them.
+ */
+ if (lex_query_tables_own_last)
+ {
+ /*
+ We've already entered/left prelocked mode with this statement.
+ Attach the list of tables that need to be prelocked and mark m_lex
+ as having such list attached.
+ */
+ *lex_query_tables_own_last= prelocking_tables;
+ m_lex->mark_as_requiring_prelocking(lex_query_tables_own_last);
+ }
+ }
+
+ reinit_stmt_before_use(thd, m_lex);
/*
If requested check whenever we have access to tables in LEX's table list
and open and lock them before executing instructtions core function.
@@ -1483,6 +1514,26 @@
thd->proc_info="closing tables";
close_thread_tables(thd);
+ if (m_lex->query_tables_own_last)
+ {
+ /*
+ We've entered and left prelocking mode when executing statement
+ stored in m_lex.
+ m_lex->query_tables(->next_global)* list now has a 'tail' - a list
+ of tables that are added for prelocking. (If this is the first
+ execution, the 'tail' was added by open_tables(), otherwise we've
+ attached it above in this function).
+ Now we'll save the 'tail', and detach it.
+ */
+ DBUG_ASSERT(!lex_query_tables_own_last ||
+ lex_query_tables_own_last == m_lex->query_tables_own_last &&
+ prelocking_tables == *(m_lex->query_tables_own_last));
+
+ lex_query_tables_own_last= m_lex->query_tables_own_last;
+ prelocking_tables= *lex_query_tables_own_last;
+ *lex_query_tables_own_last= NULL;
+ m_lex->mark_as_requiring_prelocking(NULL);
+ }
thd->rollback_item_tree_changes();
/*
--- 1.63/sql/sp_head.h 2005-07-28 19:39:07 +00:00
+++ 1.64/sql/sp_head.h 2005-08-03 03:44:29 +00:00
@@ -282,6 +282,10 @@
/*
Multi-set representing optimized list of tables to be locked by this
routine. Does not include tables which are used by invoked routines.
+
+ Note: for prelocking-free SPs this multiset is constructed too.
+ We do so because the same instance of sp_head may be called both
+ in prelocked mode and in non-prelocked mode.
*/
HASH m_sptabs;
@@ -383,7 +387,8 @@
public:
sp_lex_keeper(LEX *lex, bool lex_resp)
- : m_lex(lex), m_lex_resp(lex_resp)
+ : m_lex(lex), m_lex_resp(lex_resp),
+ lex_query_tables_own_last(NULL)
{
lex->sp_lex_in_use= TRUE;
}
@@ -418,6 +423,25 @@
for LEX deletion.
*/
bool m_lex_resp;
+
+ /*
+ Support for being able to execute this statement in two modes:
+ a) inside prelocked mode set by the calling procedure or its ancestor.
+ b) outside of prelocked mode, when this statement enters/leaves
+ prelocked mode itself.
+ */
+
+ /*
+ List of additional tables this statement needs to lock when it
+ enters/leaves prelocked mode on its own.
+ */
+ TABLE_LIST *prelocking_tables;
+
+ /*
+ The value m_lex->query_tables_own_last should be set to this when the
+ statement enters/leaves prelocked mode on its own.
+ */
+ TABLE_LIST **lex_query_tables_own_last;
};
| Thread |
|---|
| • bk commit into 5.0 tree (sergefp:1.1924) | Sergey Petrunia | 3 Aug |
