diff options
| author | unknown <gkodinov/kgeorge@magare.gmz> | 2007-04-04 13:38:19 +0300 |
|---|---|---|
| committer | unknown <gkodinov/kgeorge@magare.gmz> | 2007-04-04 13:38:19 +0300 |
| commit | dbd125fd909c531b2296a7bd90283d259a62fb59 (patch) | |
| tree | eadca488e3a499272286b4979dc55cd37cb478c6 /mysql-test/r/errors.result | |
| parent | 7bf304a6bd85c6fdfdf2c6ff8c4a7a2d0ce3c681 (diff) | |
| download | mariadb-git-dbd125fd909c531b2296a7bd90283d259a62fb59.tar.gz | |
BUG 27513: fixed left-over sql mode from a test case.
Diffstat (limited to 'mysql-test/r/errors.result')
| -rw-r--r-- | mysql-test/r/errors.result | 7 |
1 files changed, 1 insertions, 6 deletions
diff --git a/mysql-test/r/errors.result b/mysql-test/r/errors.result index 0b12853ab80..94debb1785f 100644 --- a/mysql-test/r/errors.result +++ b/mysql-test/r/errors.result @@ -28,21 +28,16 @@ ERROR 42000: Display width out of range for column 'a' (max = 255) set sql_mode='traditional'; create table t1 (a varchar(66000)); ERROR 42000: Column length too big for column 'a' (max = 65535); use BLOB or TEXT instead +set sql_mode=default; CREATE TABLE t1 (a INT); SELECT a FROM t1 WHERE a IN(1, (SELECT IF(1=0,1,2/0))); a -Warnings: -Error 1365 Division by 0 INSERT INTO t1 VALUES(1); SELECT a FROM t1 WHERE a IN(1, (SELECT IF(1=0,1,2/0))); a 1 -Warnings: -Error 1365 Division by 0 INSERT INTO t1 VALUES(2),(3); SELECT a FROM t1 WHERE a IN(1, (SELECT IF(1=0,1,2/0))); a 1 -Warnings: -Error 1365 Division by 0 DROP TABLE t1; |