#
# 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 IGNORE 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	Truncated incorrect datetime value: ''
CREATE TABLE t1 (a ENUM('a'), b DATE, c INT, KEY(b)) ENGINE=InnoDB;
INSERT IGNORE 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	Truncated incorrect datetime value: ''
SELECT * FROM t1 IGNORE KEY (b) WHERE b='';
a	b	c
	0000-00-00	0
Warnings:
Warning	1292	Truncated incorrect datetime value: ''
SELECT * FROM t1 WHERE a=b;
a	b	c
	0000-00-00	0
Warnings:
Warning	1292	Truncated incorrect datetime value: ''
SELECT 1 FROM t1 WHERE (SELECT a FROM t1 group by c) = b;
1
1
Warnings:
Warning	1292	Truncated incorrect datetime value: ''
ALTER TABLE t1 ENGINE=MyISAM;
SELECT * FROM t1 WHERE b='';
a	b	c
	0000-00-00	0
Warnings:
Warning	1292	Truncated incorrect datetime value: ''
SELECT * FROM t1 IGNORE KEY (b) WHERE b='';
a	b	c
	0000-00-00	0
Warnings:
Warning	1292	Truncated incorrect datetime value: ''
SELECT * FROM t1 WHERE a=b;
a	b	c
	0000-00-00	0
Warnings:
Warning	1292	Truncated incorrect datetime value: ''
SELECT 1 FROM t1 WHERE (SELECT a FROM t1 group by c) = b;
1
1
Warnings:
Warning	1292	Truncated 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	Truncated incorrect datetime value: ''
CREATE TABLE t1 (a ENUM('a'), b DATETIME, c INT, KEY(b)) ENGINE=InnoDB;
INSERT IGNORE 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	Truncated incorrect datetime value: ''
SELECT * FROM t1 IGNORE KEY (b) WHERE b='';
a	b	c
	0000-00-00 00:00:00	0
Warnings:
Warning	1292	Truncated incorrect datetime value: ''
SELECT * FROM t1 WHERE a=b;
a	b	c
	0000-00-00 00:00:00	0
Warnings:
Warning	1292	Truncated incorrect datetime value: ''
SELECT 1 FROM t1 WHERE (SELECT a FROM t1 group by c) = b;
1
1
Warnings:
Warning	1292	Truncated 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	Truncated incorrect datetime value: ''
SELECT * FROM t1 IGNORE KEY (b) WHERE b='';
a	b	c
	0000-00-00 00:00:00	0
Warnings:
Warning	1292	Truncated incorrect datetime value: ''
SELECT * FROM t1 WHERE a=b;
a	b	c
	0000-00-00 00:00:00	0
Warnings:
Warning	1292	Truncated incorrect datetime value: ''
SELECT 1 FROM t1 WHERE (SELECT a FROM t1 group by c) = b;
1
1
Warnings:
Warning	1292	Truncated incorrect datetime value: ''
DROP TABLE t1;
CREATE TABLE t1 (d DATE) ENGINE=InnoDB;
INSERT INTO t1 VALUES ('2012-12-21');
SELECT * FROM t1 WHERE LEAST( UTC_TIME(), d );
d
2012-12-21
DROP TABLE t1;
#
# MDEV-17969 Assertion `name' failed in THD::push_warning_truncated_value_for_field
#
CREATE TABLE t1 (c1 DATE , c2 TIMESTAMP) ENGINE=InnoDB;
INSERT INTO t1  VALUES ('2006-07-17','0000-00-00 00:00:00');
CREATE TABLE t2 (pk INT, a1 TIME) Engine=InnoDB;
INSERT INTO t2 VALUES (6,'00:00:00');
SET SESSION sql_mode= 'strict_all_tables,no_zero_date';
CREATE TABLE tbl SELECT * FROM t1 WHERE t1.c1 = (SELECT c2 FROM t2 WHERE pk = 6);
ERROR 22007: Truncated incorrect datetime value: '0000-00-00 00:00:00'
DROP TABLE t1,t2;
SET sql_mode=DEFAULT;