main.type_date w1 [ fail ]
|
Test ended at 2016-06-29 00:00:00
|
|
CURRENT_TEST: main.type_date
|
--- /opt/buildbot-slave/mariadb/dan_demeter2/build/mysql-test/r/type_date.result 2016-06-28 11:45:27.916481633 -0400
|
+++ /opt/buildbot-slave/mariadb/dan_demeter2/build/mysql-test/r/type_date.reject 2016-06-29 00:00:00.714427156 -0400
|
@@ -168,27 +168,27 @@
|
INSERT INTO t1 VALUES (DATE(NOW()), 1);
|
SELECT COUNT(*) FROM t1 WHERE a = NOW();
|
COUNT(*)
|
-0
|
+1
|
EXPLAIN SELECT COUNT(*) FROM t1 WHERE a = NOW();
|
id select_type table type possible_keys key key_len ref rows Extra
|
-1 SIMPLE NULL NULL NULL NULL NULL NULL NULL Impossible WHERE noticed after reading const tables
|
+1 SIMPLE t1 system PRIMARY NULL NULL NULL 1
|
INSERT INTO t1 VALUES (DATE(NOW()), 2);
|
SELECT COUNT(*) FROM t1 WHERE a = NOW();
|
COUNT(*)
|
-0
|
+2
|
EXPLAIN SELECT COUNT(*) FROM t1 WHERE a = NOW();
|
id select_type table type possible_keys key key_len ref rows Extra
|
-1 SIMPLE NULL NULL NULL NULL NULL NULL NULL Impossible WHERE noticed after reading const tables
|
+1 SIMPLE t1 ref PRIMARY PRIMARY 3 const 1 Using where; Using index
|
SELECT COUNT(*) FROM t1 WHERE a = NOW() AND b = 1;
|
COUNT(*)
|
-0
|
+1
|
EXPLAIN SELECT COUNT(*) FROM t1 WHERE a = NOW() AND b = 1;
|
id select_type table type possible_keys key key_len ref rows Extra
|
-1 SIMPLE NULL NULL NULL NULL NULL NULL NULL Impossible WHERE noticed after reading const tables
|
+1 SIMPLE t1 const PRIMARY PRIMARY 7 const,const 1 Using index
|
ALTER TABLE t1 DROP PRIMARY KEY;
|
SELECT COUNT(*) FROM t1 WHERE a = NOW();
|
COUNT(*)
|
-0
|
+2
|
EXPLAIN SELECT COUNT(*) FROM t1 WHERE a = NOW();
|
id select_type table type possible_keys key key_len ref rows Extra
|
1 SIMPLE t1 ALL NULL NULL NULL NULL 2 Using where
|
@@ -432,7 +432,7 @@
|
explain
|
select 1 from t1 as t1_0 inner join t1 as t2 on (t1_0.a <=> now()) join t1 on 1;
|
id select_type table type possible_keys key key_len ref rows Extra
|
-1 SIMPLE t1_0 ref a a 4 const 0 Using where; Using index
|
+1 SIMPLE t1_0 ref a a 4 const 1 Using where; Using index
|
1 SIMPLE t2 index NULL a 4 NULL 2 Using index; Using join buffer (flat, BNL join)
|
1 SIMPLE t1 index NULL a 4 NULL 2 Using index; Using join buffer (incremental, BNL join)
|
select 1 from t1 as t1_0 inner join t1 as t2 on (t1_0.a <=> now()) join t1 on 1;
|