diff options
Diffstat (limited to 'mysql-test/t/cast.test')
| -rw-r--r-- | mysql-test/t/cast.test | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/t/cast.test b/mysql-test/t/cast.test index 58f91571ebb..6d097d85f1a 100644 --- a/mysql-test/t/cast.test +++ b/mysql-test/t/cast.test @@ -174,12 +174,14 @@ select hex(cast(_latin1'a' AS char(2))) as c5; select cast(1000 as CHAR(3)); +set sql_mode = 'NO_ENGINE_SUBSTITUTION'; create table t1 select cast(_latin1'ab' AS char) as c1, cast(_latin1'a ' AS char) as c2, cast(_latin1'abc' AS char(2)) as c3, cast(_latin1'a ' AS char(2)) as c4, cast(_latin1'a' AS char(2)) as c5; +set sql_mode = DEFAULT; select c1,c2,c3,c4,hex(c5) from t1; show create table t1; drop table t1; @@ -194,12 +196,14 @@ select cast(_koi8r'Æ ' AS nchar(2)) as c4, cast(_koi8r'Æ' AS nchar(2)) as c5; +set sql_mode = 'NO_ENGINE_SUBSTITUTION'; create table t1 select cast(_koi8r'ÆÇ' AS nchar) as c1, cast(_koi8r'Æ ' AS nchar) as c2, cast(_koi8r'ÆÇÈ' AS nchar(2)) as c3, cast(_koi8r'Æ ' AS nchar(2)) as c4, cast(_koi8r'Æ' AS nchar(2)) as c5; +set sql_mode = DEFAULT; select * from t1; show create table t1; drop table t1; @@ -421,8 +425,10 @@ DROP TABLE t1; --echo # Bug#14096619 UNABLE TO RESTORE DATABASE DUMP --echo # +SET sql_mode = 'NO_ENGINE_SUBSTITUTION'; CREATE TABLE t1 AS SELECT CONCAT(CAST(REPEAT('9', 1000) AS SIGNED)), CONCAT(CAST(REPEAT('9', 1000) AS UNSIGNED)); +SET sql_mode = DEFAULT; SHOW CREATE TABLE t1; DROP TABLE t1; |