Debian Codegraph @

mysql-test/suite/innodb/r/innodb_bug54044.result

raw
1 CREATE TEMPORARY TABLE table_54044 ENGINE = INNODB
2 AS SELECT IF(NULL IS NOT NULL, NULL, NULL);
3 SHOW CREATE TABLE table_54044;
4 Table Create Table
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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
8 DROP TABLE table_54044;
9 CREATE TABLE tmp ENGINE = INNODB
10 AS SELECT COALESCE(NULL, NULL, NULL), GREATEST(NULL, NULL), NULL;
11 SHOW CREATE TABLE tmp;
12 Table Create Table
13 tmp CREATE TABLE `tmp` (
14 `COALESCE(NULL, NULL, NULL)` binary(0) DEFAULT NULL,
15 `GREATEST(NULL, NULL)` binary(0) DEFAULT NULL,
16 `NULL` binary(0) DEFAULT NULL
17 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
18 DROP TABLE tmp;