summaryrefslogtreecommitdiff
path: root/mysql-test/suite/innodb/r/innodb_bug54044.result
blob: 29b0127f20b9221e028c5850e13619de4d87153c (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
CREATE TEMPORARY TABLE table_54044 ENGINE = INNODB
AS SELECT IF(NULL  IS NOT NULL, NULL, NULL);
SHOW CREATE TABLE table_54044;
Table	Create Table
table_54044	CREATE TEMPORARY TABLE `table_54044` (
  `IF(NULL  IS NOT NULL, NULL, NULL)` binary(0) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1
DROP TABLE table_54044;
CREATE TABLE tmp ENGINE = INNODB
AS SELECT COALESCE(NULL, NULL, NULL), GREATEST(NULL, NULL), NULL;
SHOW CREATE TABLE tmp;
Table	Create Table
tmp	CREATE TABLE `tmp` (
  `COALESCE(NULL, NULL, NULL)` binary(0) DEFAULT NULL,
  `GREATEST(NULL, NULL)` binary(0) DEFAULT NULL,
  `NULL` binary(0) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1
DROP TABLE tmp;