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

spider.partition_mrr - results not consistent

    XMLWordPrintable

Details

    Description

      https://buildbot.mariadb.org/#/builders/502/builds/7007 10.11-656f88677

      --- /home/buildbot/amd64-debian-11-aocc/build/storage/spider/mysql-test/spider/r/partition_mrr.result	2024-02-12 03:02:32.000000000 +0000
      +++ /home/buildbot/amd64-debian-11-aocc/build/storage/spider/mysql-test/spider/r/partition_mrr.reject	2024-02-12 07:43:42.224973982 +0000
      @@ -141,10 +141,10 @@
       argument
       select `pkey` from `auto_test_remote`.`tbl_a` order by `pkey`
       select a.id,b.`pkey` from auto_test_remote.tmp_spider_bka_xxxx a,`auto_test_remote`.`tbl_b` b where a.c0 <=> b.`pkey`
      -select `pkey` from `auto_test_remote`.`tbl_a` order by `pkey`
      -select `pkey` from `auto_test_remote`.`tbl_b` order by `pkey`
      -select `pkey` from `auto_test_remote`.`tbl_b` order by `pkey`
       select `pkey` from `auto_test_remote`.`tbl_b` order by `pkey`
      +select `pkey` from `auto_test_remote`.`tbl_a` order by `pkey`
      +select `pkey` from `auto_test_remote`.`tbl_a` order by `pkey`
      +select `pkey` from `auto_test_remote`.`tbl_a` order by `pkey`
       SELECT argument FROM mysql.general_log WHERE command_type != 'Execute' AND argument LIKE '%select %'
       SELECT pkey FROM tbl_a ORDER BY pkey ;
       SELECT pkey FROM tbl_b ORDER BY pkey;
      @@ -175,10 +175,10 @@
       argument
       select `pkey` from `auto_test_remote2`.`tbl_a` order by `pkey`
       select a.id,b.`pkey` from auto_test_remote2.tmp_spider_bka_xxxx a,`auto_test_remote2`.`tbl_b` b where a.c0 <=> b.`pkey`
      -select `pkey` from `auto_test_remote2`.`tbl_a` order by `pkey`
      -select `pkey` from `auto_test_remote2`.`tbl_b` order by `pkey`
      -select `pkey` from `auto_test_remote2`.`tbl_b` order by `pkey`
       select `pkey` from `auto_test_remote2`.`tbl_b` order by `pkey`
      +select `pkey` from `auto_test_remote2`.`tbl_a` order by `pkey`
      +select `pkey` from `auto_test_remote2`.`tbl_a` order by `pkey`
      +select `pkey` from `auto_test_remote2`.`tbl_a` order by `pkey`
       SELECT argument FROM mysql.general_log WHERE command_type != 'Execute' AND argument LIKE '%select %'
       SELECT pkey FROM tbl_a ORDER BY pkey ;
       SELECT pkey FROM tbl_b ORDER BY pkey;
      @@ -209,10 +209,10 @@
       argument
       select `pkey` from `auto_test_remote3`.`tbl_a` order by `pkey`
       select a.id,b.`pkey` from auto_test_remote3.tmp_spider_bka_xxxx a,`auto_test_remote3`.`tbl_b` b where a.c0 <=> b.`pkey`
      -select `pkey` from `auto_test_remote3`.`tbl_a` order by `pkey`
      -select `pkey` from `auto_test_remote3`.`tbl_b` order by `pkey`
      -select `pkey` from `auto_test_remote3`.`tbl_b` order by `pkey`
       select `pkey` from `auto_test_remote3`.`tbl_b` order by `pkey`
      +select `pkey` from `auto_test_remote3`.`tbl_a` order by `pkey`
      +select `pkey` from `auto_test_remote3`.`tbl_a` order by `pkey`
      +select `pkey` from `auto_test_remote3`.`tbl_a` order by `pkey`
       SELECT argument FROM mysql.general_log WHERE command_type != 'Execute' AND argument LIKE '%select %'
       SELECT pkey FROM tbl_a ORDER BY pkey ;
       SELECT pkey FROM tbl_b ORDER BY pkey;
      

      10.4 example

      mainly esoteric builders:
      https://buildbot.mariadb.net/ci/reports/cross_reference#branch=&revision=&platform=&fail_name=spider.partition_mrr&fail_variant=&fail_info_full=&typ=&info=&dt=&limit=100&fail_info_short=

      Attachments

        Activity

          People

            ycp Yuchen Pei
            danblack Daniel Black
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.