summaryrefslogtreecommitdiff
path: root/mysql-test/t/subselect.test
diff options
context:
space:
mode:
authormonty@mashka.mysql.fi <>2003-05-13 11:15:11 +0300
committermonty@mashka.mysql.fi <>2003-05-13 11:15:11 +0300
commit60dfb25be3806eefb26504fdf17a0ba1fcb11673 (patch)
tree69892a7f220c327725015304f7314967001536d6 /mysql-test/t/subselect.test
parent091d6f3b731d94128d3f35942126a29e2cadae49 (diff)
downloadmariadb-git-60dfb25be3806eefb26504fdf17a0ba1fcb11673.tar.gz
Give warning if MySQL doesn't honor given storage engine
Allow syntax CREATE TABLE t1 (LIKE t2)
Diffstat (limited to 'mysql-test/t/subselect.test')
-rw-r--r--mysql-test/t/subselect.test2
1 files changed, 2 insertions, 0 deletions
diff --git a/mysql-test/t/subselect.test b/mysql-test/t/subselect.test
index 30cb7b05d74..8e8a3dfe1d4 100644
--- a/mysql-test/t/subselect.test
+++ b/mysql-test/t/subselect.test
@@ -678,6 +678,8 @@ INSERT INTO t1 VALUES (1);
UPDATE t1 SET i=i+(SELECT MAX(i) FROM (SELECT 1) t) WHERE i=(SELECT MAX(i));
-- error 1111
UPDATE t1 SET i=i+1 WHERE i=(SELECT MAX(i));
+--error 1109
+UPDATE t1 SET t.i=i+(SELECT MAX(i) FROM (SELECT 1) t);
drop table t1;
#