diff options
| author | monty@narttu.mysql.fi <> | 2003-10-08 18:53:31 +0300 |
|---|---|---|
| committer | monty@narttu.mysql.fi <> | 2003-10-08 18:53:31 +0300 |
| commit | 9e57c12b5a0d623a72be968f8cbd2ad769a84a29 (patch) | |
| tree | 91c3c750d9a03c42d9da0b2335928ae4a162e4ea /mysql-test/r/ansi.result | |
| parent | 246febee424759c8ea3dc34eaa29b60a68a0a72b (diff) | |
| download | mariadb-git-9e57c12b5a0d623a72be968f8cbd2ad769a84a29.tar.gz | |
Fixed bug in error handling of CREATE ... SELECT
More tests cases
After merge fixes
Diffstat (limited to 'mysql-test/r/ansi.result')
| -rw-r--r-- | mysql-test/r/ansi.result | 17 |
1 files changed, 9 insertions, 8 deletions
diff --git a/mysql-test/r/ansi.result b/mysql-test/r/ansi.result index 6ec909f84bb..0b86634f67b 100644 --- a/mysql-test/r/ansi.result +++ b/mysql-test/r/ansi.result @@ -1,4 +1,12 @@ drop table if exists t1; +set sql_mode="MySQL40"; +select @@sql_mode; +@@sql_mode +NO_FIELD_OPTIONS,MYSQL40 +set @@sql_mode="ANSI"; +select @@sql_mode; +@@sql_mode +REAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,ONLY_FULL_GROUP_BY,ANSI SELECT 'A' || 'B'; 'A' || 'B' AB @@ -8,11 +16,4 @@ id NULL 1 1.1 a SELECT id FROM t1 GROUP BY id2; ERROR 42000: 'test.t1.id' isn't in GROUP BY drop table t1; -set sql_mode="MySQL40"; -select @@sql_mode; -@@sql_mode -NO_FIELD_OPTIONS,MYSQL40 -set sql_mode="ANSI"; -select @@sql_mode; -@@sql_mode -REAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,ONLY_FULL_GROUP_BY,ANSI +SET @@SQL_MODE=""; |