#
# MDEV-9604 crash in Item::save_in_field with empty enum value
#
SELECT TIME'00:00:00'='';
TIME'00:00:00'=''
1
Warnings:
Warning	1292	Truncated incorrect time value: ''
CREATE TABLE t1 (a ENUM('a'), b TIME, c INT, KEY(b)) ENGINE=InnoDB;
INSERT INTO t1 VALUES ('','00:00:00',0);
Warnings:
Warning	1265	Data truncated for column 'a' at row 1
SELECT * FROM t1 WHERE b='';
a	b	c
	00:00:00	0
Warnings:
Warning	1292	Truncated incorrect time value: ''
SELECT * FROM t1 IGNORE KEY (b) WHERE b='';
a	b	c
	00:00:00	0
Warnings:
Warning	1292	Truncated incorrect time value: ''
SELECT * FROM t1 WHERE a=b;
a	b	c
	00:00:00	0
Warnings:
Warning	1292	Truncated incorrect time value: ''
SELECT 1 FROM t1 WHERE (SELECT a FROM t1 group by c) = b;
1
1
Warnings:
Warning	1292	Truncated incorrect time value: ''
ALTER TABLE t1 ENGINE=MyISAM;
SELECT * FROM t1 WHERE b='';
a	b	c
	00:00:00	0
Warnings:
Warning	1292	Truncated incorrect time value: ''
SELECT * FROM t1 IGNORE KEY (b) WHERE b='';
a	b	c
	00:00:00	0
Warnings:
Warning	1292	Truncated incorrect time value: ''
SELECT * FROM t1 WHERE a=b;
a	b	c
	00:00:00	0
Warnings:
Warning	1292	Truncated incorrect time value: ''
SELECT 1 FROM t1 WHERE (SELECT a FROM t1 group by c) = b;
1
1
Warnings:
Warning	1292	Truncated incorrect time value: ''
DROP TABLE t1;
SELECT DATE'0000-00-00'='';
DATE'0000-00-00'=''
1
Warnings:
Warning	1292	Incorrect datetime value: ''
CREATE TABLE t1 (a ENUM('a'), b DATE, c INT, KEY(b)) ENGINE=InnoDB;
INSERT INTO t1 VALUES ('','0000-00-00',0);
Warnings:
Warning	1265	Data truncated for column 'a' at row 1
SELECT * FROM t1 WHERE b='';
a	b	c
	0000-00-00	0
Warnings:
Warning	1292	Incorrect datetime value: ''
SELECT * FROM t1 IGNORE KEY (b) WHERE b='';
a	b	c
	0000-00-00	0
Warnings:
Warning	1292	Incorrect datetime value: ''
SELECT * FROM t1 WHERE a=b;
a	b	c
	0000-00-00	0
Warnings:
Warning	1292	Incorrect datetime value: ''
SELECT 1 FROM t1 WHERE (SELECT a FROM t1 group by c) = b;
1
1
Warnings:
Warning	1292	Incorrect datetime value: ''
ALTER TABLE t1 ENGINE=MyISAM;
SELECT * FROM t1 WHERE b='';
a	b	c
	0000-00-00	0
Warnings:
Warning	1292	Incorrect datetime value: ''
SELECT * FROM t1 IGNORE KEY (b) WHERE b='';
a	b	c
	0000-00-00	0
Warnings:
Warning	1292	Incorrect datetime value: ''
SELECT * FROM t1 WHERE a=b;
a	b	c
	0000-00-00	0
Warnings:
Warning	1292	Incorrect datetime value: ''
SELECT 1 FROM t1 WHERE (SELECT a FROM t1 group by c) = b;
1
1
Warnings:
Warning	1292	Incorrect datetime value: ''
DROP TABLE t1;
SELECT TIMESTAMP'0000-00-00 00:00:00'='';
TIMESTAMP'0000-00-00 00:00:00'=''
1
Warnings:
Warning	1292	Incorrect datetime value: ''
CREATE TABLE t1 (a ENUM('a'), b DATETIME, c INT, KEY(b)) ENGINE=InnoDB;
INSERT INTO t1 VALUES ('','0000-00-00 00:00:00',0);
Warnings:
Warning	1265	Data truncated for column 'a' at row 1
SELECT * FROM t1 WHERE b='';
a	b	c
	0000-00-00 00:00:00	0
Warnings:
Warning	1292	Incorrect datetime value: ''
SELECT * FROM t1 IGNORE KEY (b) WHERE b='';
a	b	c
	0000-00-00 00:00:00	0
Warnings:
Warning	1292	Incorrect datetime value: ''
SELECT * FROM t1 WHERE a=b;
a	b	c
	0000-00-00 00:00:00	0
Warnings:
Warning	1292	Incorrect datetime value: ''
SELECT 1 FROM t1 WHERE (SELECT a FROM t1 group by c) = b;
1
1
Warnings:
Warning	1292	Incorrect datetime value: ''
ALTER TABLE t1 ENGINE=MyISAM;
SELECT * FROM t1 WHERE b='';
a	b	c
	0000-00-00 00:00:00	0
Warnings:
Warning	1292	Incorrect datetime value: ''
SELECT * FROM t1 IGNORE KEY (b) WHERE b='';
a	b	c
	0000-00-00 00:00:00	0
Warnings:
Warning	1292	Incorrect datetime value: ''
SELECT * FROM t1 WHERE a=b;
a	b	c
	0000-00-00 00:00:00	0
Warnings:
Warning	1292	Incorrect datetime value: ''
SELECT 1 FROM t1 WHERE (SELECT a FROM t1 group by c) = b;
1
1
Warnings:
Warning	1292	Incorrect datetime value: ''
DROP TABLE t1;