ansi.test
上传用户:romrleung
上传日期:2022-05-23
资源大小:18897k
文件大小:1k
- #
- # Test of ansi mode
- #
- --disable_warnings
- drop table if exists t1;
- --enable_warnings
- set sql_mode="MySQL40";
- select @@sql_mode;
- set @@sql_mode="ANSI";
- select @@sql_mode;
- # Test some functions that works different in ansi mode
- SELECT 'A' || 'B';
- # Test GROUP BY behaviour
- CREATE TABLE t1 (id INT, id2 int);
- SELECT id,NULL,1,1.1,'a' FROM t1 GROUP BY id;
- #No --error 1055 error due to temporary fix for BUG#8510:
- #ONLY_FULL_GROUP_BY is overly restrictive, so remove it from ANSI mode.
- SELECT id FROM t1 GROUP BY id2;
- drop table t1;
- SET @@SQL_MODE="";
- # End of 4.1 tests