summaryrefslogtreecommitdiff
path: root/mysql-test/main/compound.test
diff options
context:
space:
mode:
authorDmitry Shulga <dmitry.shulga@mariadb.com>2021-04-29 17:16:56 +0700
committerSergei Golubchik <serg@mariadb.org>2021-06-17 19:30:24 +0200
commitf536974b73dec47ddd87cb525f2f0d26d84f1a1d (patch)
tree4f86f612a51b76f6779e3a4cbfcd85691d489701 /mysql-test/main/compound.test
parent8754fce8b086911a2446cb414f770ece13ef1d27 (diff)
downloadmariadb-git-f536974b73dec47ddd87cb525f2f0d26d84f1a1d.tar.gz
MDEV-16708: Unsupported commands for prepared statements
Fixed failures of the tests main.compound, main.union
Diffstat (limited to 'mysql-test/main/compound.test')
-rw-r--r--mysql-test/main/compound.test4
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/main/compound.test b/mysql-test/main/compound.test
index 1f901e2a2b3..c902ef77b52 100644
--- a/mysql-test/main/compound.test
+++ b/mysql-test/main/compound.test
@@ -94,7 +94,7 @@ end loop|
show tables|
# REPEAT
-set @a=0;
+set @a=0|
repeat
set @a = @a + 1;
until @a > 5
@@ -146,7 +146,7 @@ drop table t1|
# MDEV-6609 SQL inside an anonymous block is executed with wrong SQL_MODE
#
-set @@sql_mode="STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION";
+set @@sql_mode="STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"|
begin not atomic select @@sql_mode; end|
create table t1 (a int)|
select a from t1 having a > 1|