1
CREATE TEMPORARY TABLE table_54044 ENGINE = INNODB
2
AS SELECT IF(NULL IS NOT NULL, NULL, NULL);
3
SHOW CREATE TABLE table_54044;
5
table_54044 CREATE TEMPORARY TABLE `table_54044` (
6
`IF(NULL IS NOT NULL, NULL, NULL)` binary(0) DEFAULT NULL
7
) ENGINE=InnoDB DEFAULT CHARSET=latin1
8
DROP TABLE table_54044;
9
CREATE TABLE tmp ENGINE = INNODB AS SELECT COALESCE(NULL, NULL, NULL), GREATEST(NULL, NULL), NULL;
10
SHOW CREATE TABLE tmp;
12
tmp CREATE TABLE `tmp` (
13
`COALESCE(NULL, NULL, NULL)` binary(0) DEFAULT NULL,
14
`GREATEST(NULL, NULL)` binary(0) DEFAULT NULL,
15
`NULL` binary(0) DEFAULT NULL
16
) ENGINE=InnoDB DEFAULT CHARSET=latin1