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

main.type_date fails around midnight sporadically

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 5.5.50, 10.0.26, 10.1.14, 10.2.0
    • 5.5.51
    • Tests
    • 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

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

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.