Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-10316

main.type_date fails around midnight sporadically

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 5.5.50, 10.0.26, 10.1.14, 10.2.0
    • Fix Version/s: 5.5.51
    • Component/s: Tests
    • Labels:
      None

      Description

      Failed in bb: http://buildbot.askmonty.org/buildbot/builders/bld-dan-release/builds/3685/steps/test/logs/stdio

      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;
      

      There's explanation why this may fail in type_date.test

        Attachments

          Activity

            People

            • Assignee:
              svoj Sergey Vojtovich
              Reporter:
              svoj Sergey Vojtovich
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: