mirror of
https://github.com/MariaDB/server.git
synced 2025-02-15 18:05:32 +01:00
28 lines
884 B
Text
28 lines
884 B
Text
# This is the test for bug #54044. Special handle MYSQL_TYPE_NULL type
|
|
# during create table, so it will not trigger assertion failure.
|
|
|
|
--source include/have_innodb.inc
|
|
|
|
# This 'create table' operation no longer uses the NULL datatype.
|
|
|
|
CREATE TEMPORARY TABLE table_54044 ENGINE = INNODB
|
|
AS SELECT IF(NULL IS NOT NULL, NULL, NULL);
|
|
SHOW CREATE TABLE table_54044;
|
|
DROP TABLE table_54044;
|
|
|
|
# This 'create table' should pass since it uses a Field_string of size 0.
|
|
|
|
CREATE TABLE tmp ENGINE = INNODB
|
|
AS SELECT COALESCE(NULL, NULL, NULL), GREATEST(NULL, NULL), NULL;
|
|
SHOW CREATE TABLE tmp;
|
|
DROP TABLE tmp;
|
|
|
|
# These 'create table' operations should fail because of
|
|
# using NULL datatype
|
|
|
|
CREATE TABLE t1 (a VARCHAR(3)) ENGINE=InnoDB;
|
|
INSERT INTO t1 VALUES ('foo'),('bar');
|
|
FLUSH TABLES;
|
|
--error 1005
|
|
CREATE TEMPORARY TABLE tmp ENGINE=InnoDB AS SELECT VALUES(a) FROM t1;
|
|
DROP TABLE t1;
|