1 2 #Get deafult engine value 3--let $DEFAULT_ENGINE = `select @@global.default_storage_engine` 4 5# 6# Test of ansi mode 7# 8 9--disable_warnings 10drop table if exists t1; 11--enable_warnings 12 13set sql_mode="MySQL40"; 14select @@sql_mode; 15set @@sql_mode="ANSI"; 16select @@sql_mode; 17 18# Test some functions that works different in ansi mode 19 20SELECT 'A' || 'B'; 21 22# Test GROUP BY behaviour 23 24CREATE TABLE t1 (id INT, id2 int); 25SELECT id,NULL,1,1.1,'a' FROM t1 GROUP BY id; 26# ONLY_FULL_GROUP_BY is included in ANSI: 27--error ER_WRONG_FIELD_WITH_GROUP 28SELECT id FROM t1 GROUP BY id2; 29drop table t1; 30 31SET @@SQL_MODE=""; 32 33# Bug#14515 34 35CREATE TABLE t1 (i int auto_increment NOT NULL, PRIMARY KEY (i)); 36 37#Replace default engine value with static engine string 38--replace_result $DEFAULT_ENGINE ENGINE 39SHOW CREATE TABLE t1; 40SET @@SQL_MODE="MYSQL323"; 41 42#Replace default engine value with static engine string 43--replace_result $DEFAULT_ENGINE ENGINE 44SHOW CREATE TABLE t1; 45SET @@SQL_MODE="MYSQL40"; 46 47#Replace default engine value with static engine string 48--replace_result $DEFAULT_ENGINE ENGINE 49SHOW CREATE TABLE t1; 50SET @@SQL_MODE="NO_FIELD_OPTIONS"; 51 52#Replace default engine value with static engine string 53--replace_result $DEFAULT_ENGINE ENGINE 54SHOW CREATE TABLE t1; 55DROP TABLE t1; 56 57# End of 4.1 tests 58