summaryrefslogtreecommitdiff
path: root/mysql-test/t/subselect.test
diff options
context:
space:
mode:
authorunknown <bell@sanja.is.com.ua>2003-06-25 01:19:09 +0300
committerunknown <bell@sanja.is.com.ua>2003-06-25 01:19:09 +0300
commitcd01f7cda08f8cff241e02835a16fc5aca6280e2 (patch)
tree3901dd64b034ab8dace10e8512b33cddbdd64e38 /mysql-test/t/subselect.test
parent3eaf8865ecdb8db3e5bc7c1b59716dfcff79dc92 (diff)
downloadmariadb-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.test14
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;