Note 1003 select default('') AS `default(str)`,default('') AS `default(strnull)`,default('0') AS `default(intg)`,default('0') AS `default(rel)` from `test`.`t1`
CREATE TABLE t1 (id int(11), s varchar(20));INSERT INTO t1 VALUES (1, 'one'), (2, 'two'), (3, 'three');SELECT s, 32 AS mi FROM t1 GROUP BY s HAVING DEFAULT(mi) IS NULL;ERROR HY000: Field 'mi' doesn't have a default valueDROP TABLE t1;