6
drop table if exists t1;
9
set sql_mode="MySQL40";
11
set @@sql_mode="ANSI";
14
# Test some functions that works different in ansi mode
18
# Test GROUP BY behaviour
20
CREATE TABLE t1 (id INT, id2 int);
21
SELECT id,NULL,1,1.1,'a' FROM t1 GROUP BY id;
22
#No --error 1055 error due to temporary fix for BUG#8510:
23
#ONLY_FULL_GROUP_BY is overly restrictive, so remove it from ANSI mode.
24
SELECT id FROM t1 GROUP BY id2;
31
CREATE TABLE t1 (i int auto_increment NOT NULL, PRIMARY KEY (i));
33
SET @@SQL_MODE="MYSQL323";
35
SET @@SQL_MODE="MYSQL40";
37
SET @@SQL_MODE="NO_FIELD_OPTIONS";