diff options
author | unknown <bell@sanja.is.com.ua> | 2004-11-05 17:29:47 +0200 |
---|---|---|
committer | unknown <bell@sanja.is.com.ua> | 2004-11-05 17:29:47 +0200 |
commit | 8b0ece5e88de965aeb2af410d193bf8c6d96dcde (patch) | |
tree | 7c3c0f2fa9d3f0ef56c352118e5174450230fec2 /mysql-test/t/view.test | |
parent | e981c836104675533a2eb6810f7c1606377b0491 (diff) | |
download | mariadb-git-8b0ece5e88de965aeb2af410d193bf8c6d96dcde.tar.gz |
new lock for multiupdate:
- open and create derived tables
- detect which tables should be locked for write
- lock and fill derived tables
some unitialized variables fixed
mysql-test/r/lock_multi.result:
correct results returned
mysql-test/r/multi_update.result:
correct results returned
mysql-test/r/view.result:
correct results returned
mysql-test/t/multi_update.test:
correct results returned
mysql-test/t/view.test:
correct results returned
sql/mysql_priv.h:
derived tables processing splited on table creation and table filling
sql/sql_base.cc:
derived tables processing splited on table creation and table filling
sql/sql_class.h:
function to detect when we need fill derived tables
sql/sql_derived.cc:
derived tables processing splited on table creation and table filling
sql/sql_lex.cc:
fixed uninitialized value
sql/sql_load.cc:
fixed uninitialized value
sql/sql_parse.cc:
initialization muved (will be done for all queries)
sql/sql_prepare.cc:
preparation of multiupdate changed a bit because new locking procedure
sql/sql_update.cc:
new lock for multiupdate:
- open and create derived tables
- detect which tables should be locked for write
- lock and fill derived tables
sql/table.h:
place to store select_result between creation and filling tables
Diffstat (limited to 'mysql-test/t/view.test')
-rw-r--r-- | mysql-test/t/view.test | 4 |
1 files changed, 0 insertions, 4 deletions
diff --git a/mysql-test/t/view.test b/mysql-test/t/view.test index 17077d1d086..8e38b5616f8 100644 --- a/mysql-test/t/view.test +++ b/mysql-test/t/view.test @@ -1300,13 +1300,9 @@ update v1,t1 set v1.s1='c' where t1.s1=v1.s1; select * from v1; prepare stmt1 from "update v1,t1 set v1.s1=? where t1.s1=v1.s1"; set @arg='d'; --- QQ This should not generate an error ---error 1036 execute stmt1 using @arg; select * from v1; set @arg='e'; --- QQ This should not generate an error ---error 1036 execute stmt1 using @arg; select * from v1; deallocate prepare stmt1; |