diff options
author | unknown <bell@sanja.is.com.ua> | 2003-06-25 01:19:09 +0300 |
---|---|---|
committer | unknown <bell@sanja.is.com.ua> | 2003-06-25 01:19:09 +0300 |
commit | cd01f7cda08f8cff241e02835a16fc5aca6280e2 (patch) | |
tree | 3901dd64b034ab8dace10e8512b33cddbdd64e38 /mysql-test/t/subselect.test | |
parent | 3eaf8865ecdb8db3e5bc7c1b59716dfcff79dc92 (diff) | |
download | mariadb-git-cd01f7cda08f8cff241e02835a16fc5aca6280e2.tar.gz |
Fixed error handling to be able do not interrupt update (907) (SCRUM)
fixed bug of current select pointer in subselect execution
fixed layuot
mysql-test/r/subselect.result:
test of update with IGNORE option and error in subselect
mysql-test/t/subselect.test:
test of update with IGNORE option and error in subselect
sql/item_subselect.cc:
fixed bug of current select pointer
sql/mysqld.cc:
error converting to warnings if hd->lex.current_select->no_error id true
layout fixed
sql/sql_lex.cc:
initialization
sql/sql_lex.h:
flag which force converting errors to warnings
sql/sql_select.cc:
switch on error convering to warnings in select executing if IGNORE option present
Diffstat (limited to 'mysql-test/t/subselect.test')
-rw-r--r-- | mysql-test/t/subselect.test | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/t/subselect.test b/mysql-test/t/subselect.test index 1528f53ff0d..0131c807b68 100644 --- a/mysql-test/t/subselect.test +++ b/mysql-test/t/subselect.test @@ -732,3 +732,17 @@ CREATE TABLE t1 ( INSERT INTO t1 VALUES (1,0,NULL,NULL),(2,0,NULL,NULL); SELECT DISTINCT REF_ID FROM t1 WHERE ID= (SELECT DISTINCT REF_ID FROM t1 WHERE ID=2); DROP TABLE t1; + +# +# uninterruptable update +# +create table t1 (a int, b int); +create table t2 (a int, b int); + +insert into t1 values (1,0), (2,0), (3,0); +insert into t2 values (1,1), (2,1), (3,1), (2,2); + +update ignore t1 set b=(select b from t2 where t1.a=t2.a); +select * from t1; + +drop table t1, t2; |