diff options
| author | Alexander Barkov <bar@mariadb.org> | 2017-01-24 17:29:51 +0400 |
|---|---|---|
| committer | Alexander Barkov <bar@mariadb.org> | 2017-01-24 17:29:51 +0400 |
| commit | 106fbadaba03daf51a62c40c1edbe9afb386d149 (patch) | |
| tree | 21706b3ae45900df9bbb76723718c853634e7309 /mysql-test/t/sql_mode.test | |
| parent | ae91690d893c13e86fd9f84e0c37fd9640bca257 (diff) | |
| download | mariadb-git-106fbadaba03daf51a62c40c1edbe9afb386d149.tar.gz | |
MDEV-11848 Automatic statement repreparation changes query semantics
Diffstat (limited to 'mysql-test/t/sql_mode.test')
| -rw-r--r-- | mysql-test/t/sql_mode.test | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/t/sql_mode.test b/mysql-test/t/sql_mode.test index 869bf45dbf3..263437a0bf1 100644 --- a/mysql-test/t/sql_mode.test +++ b/mysql-test/t/sql_mode.test @@ -513,3 +513,17 @@ SET @@sql_mode= @org_mode; --echo --echo #End of Test for Bug#12601974 + +--echo # +--echo # MDEV-11848 Automatic statement repreparation changes query semantics +--echo # +SET sql_mode=DEFAULT; +CREATE OR REPLACE TABLE t1 (a TEXT); +PREPARE stmt FROM 'INSERT INTO t1 (a) VALUES (2||3)'; +EXECUTE stmt; +SET sql_mode=ORACLE; +EXECUTE stmt; +ALTER TABLE t1 ADD b INT; +EXECUTE stmt; +SELECT * FROM t1; +DROP TABLE t1; |