2 drop table if exists t1,t2;
6 create table t1(str varchar(10) default 'def',strnull varchar(10),intg int default '10',rel double default '3.14');
8 insert into t1 values ('','',0,0.0);
9 select default(str), default(strnull), default(intg), default(rel) from t1;
10 explain extended select default(str), default(strnull), default(intg), default(rel) from t1;
11 select * from t1 where str <> default(str);
12 explain select * from t1 where str <> default(str);
14 #TODO: uncomment when bug will be fixed
15 #create table t2 select default(str), default(strnull), default(intg), default(rel) from t1;
16 #show create table from t1;
17 #insert into t2 select select default(str), default(strnull), default(intg), default(rel) from t1;
24 # Bug #11314 (HAVING DEFAULT() hangs)
26 CREATE TABLE t1 (id int(11), s varchar(20));
27 INSERT INTO t1 VALUES (1, 'one'), (2, 'two'), (3, 'three');
29 SELECT s, 32 AS mi FROM t1 GROUP BY s HAVING DEFAULT(mi) IS NULL;