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

main.rowid_filter_innodb failed in buildbot with wrong result

    XMLWordPrintable

Details

    • Bug
    • Status: Stalled (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.4, 10.5
    • 10.4, 10.5
    • Tests
    • None

    Description

      http://buildbot.askmonty.org/buildbot/builders/kvm-fulltest/builds/19924

      10.4 c1a2778e689030fcbb6cdc93d8c1f1d8

      main.rowid_filter_innodb 'innodb'        w2 [ fail ]
              Test ended at 2019-09-07 05:41:19
       
      CURRENT_TEST: main.rowid_filter_innodb
      --- /mnt/buildbot/build/mariadb-10.4.8/mysql-test/main/rowid_filter_innodb.result	2019-09-07 03:37:56.000000000 -0400
      +++ /mnt/buildbot/build/mariadb-10.4.8/mysql-test/main/rowid_filter_innodb.reject	2019-09-07 05:41:19.377566069 -0400
      @@ -1634,7 +1634,7 @@
             "key_length": "9",
             "used_key_parts": ["o_totaldiscount"],
             "rows": 41,
      -      "filtered": 2.0711,
      +      "filtered": 2.0467,
             "index_condition": "orders.o_totaldiscount between 18000 and 20000",
             "attached_condition": "orders.o_totalprice between 200000 and 220000 and orders.o_orderDATE between '1992-12-01' and '1997-01-01'"
           },
      @@ -1664,7 +1664,7 @@
       o_totalprice BETWEEN 200000 AND 220000 AND
       l_shipdate BETWEEN '1996-10-01' AND '1996-12-01';
       id	select_type	table	type	possible_keys	key	key_len	ref	rows	r_rows	filtered	r_filtered	Extra
      -1	SIMPLE	orders	range	PRIMARY,i_o_orderdate,i_o_totalprice,i_o_totaldiscount	i_o_totaldiscount	9	NULL	41	41.00	2.07	2.44	Using index condition; Using where
      +1	SIMPLE	orders	range	PRIMARY,i_o_orderdate,i_o_totalprice,i_o_totaldiscount	i_o_totaldiscount	9	NULL	41	41.00	2.05	2.44	Using index condition; Using where
       1	SIMPLE	lineitem	ref	PRIMARY,i_l_shipdate,i_l_orderkey,i_l_orderkey_quantity	PRIMARY	4	dbt3_s001.orders.o_orderkey	4	6.00	3.05	66.67	Using where
       set statement optimizer_switch='rowid_filter=on' for ANALYZE FORMAT=JSON SELECT o_totaldiscount, o_totalprice, l_shipdate
       FROM v1, lineitem
      @@ -1694,7 +1694,7 @@
             "rows": 41,
             "r_rows": 41,
             "r_total_time_ms": "REPLACED",
      -      "filtered": 2.0711,
      +      "filtered": 2.0467,
             "r_filtered": 2.439,
             "index_condition": "orders.o_totaldiscount between 18000 and 20000",
             "attached_condition": "orders.o_totalprice between 200000 and 220000 and orders.o_orderDATE between '1992-12-01' and '1997-01-01'"
      @@ -1765,7 +1765,7 @@
             "key_length": "9",
             "used_key_parts": ["o_totaldiscount"],
             "rows": 41,
      -      "filtered": 2.0711,
      +      "filtered": 2.0467,
             "index_condition": "orders.o_totaldiscount between 18000 and 20000",
             "attached_condition": "orders.o_totalprice between 200000 and 220000 and orders.o_orderDATE between '1992-12-01' and '1997-01-01'"
           },
      @@ -1795,7 +1795,7 @@
       o_totalprice BETWEEN 200000 AND 220000 AND
       l_shipdate BETWEEN '1996-10-01' AND '1996-12-01';
       id	select_type	table	type	possible_keys	key	key_len	ref	rows	r_rows	filtered	r_filtered	Extra
      -1	SIMPLE	orders	range	PRIMARY,i_o_orderdate,i_o_totalprice,i_o_totaldiscount	i_o_totaldiscount	9	NULL	41	41.00	2.07	2.44	Using index condition; Using where
      +1	SIMPLE	orders	range	PRIMARY,i_o_orderdate,i_o_totalprice,i_o_totaldiscount	i_o_totaldiscount	9	NULL	41	41.00	2.05	2.44	Using index condition; Using where
       1	SIMPLE	lineitem	ref	PRIMARY,i_l_shipdate,i_l_orderkey,i_l_orderkey_quantity	PRIMARY	4	dbt3_s001.orders.o_orderkey	4	6.00	3.05	66.67	Using where
       set statement optimizer_switch='rowid_filter=off' for ANALYZE FORMAT=JSON SELECT o_totaldiscount, o_totalprice, l_shipdate
       FROM v1, lineitem
      @@ -1825,7 +1825,7 @@
             "rows": 41,
             "r_rows": 41,
             "r_total_time_ms": "REPLACED",
      -      "filtered": 2.0711,
      +      "filtered": 2.0467,
             "r_filtered": 2.439,
             "index_condition": "orders.o_totaldiscount between 18000 and 20000",
             "attached_condition": "orders.o_totalprice between 200000 and 220000 and orders.o_orderDATE between '1992-12-01' and '1997-01-01'"
       
      mysqltest: Result content mismatch
      

      Attachments

        Activity

          People

            psergei Sergei Petrunia
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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