mirror of
https://github.com/MariaDB/server.git
synced 2025-02-07 06:12:18 +01:00
18 lines
740 B
Text
18 lines
740 B
Text
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=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
|
|
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=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
|
|
DROP TABLE tmp;
|