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

connect.part_table and connect.mysql_index test failure - ppc64le only

Details

    Description

      CURRENT_TEST: connect.part_table
      --- /home/buildbot/ppc64le-centos-stream9/build/storage/connect/mysql-test/connect/r/part_table.result	2023-10-21 19:58:20.000000000 +0000
      +++ /home/buildbot/ppc64le-centos-stream9/build/storage/connect/mysql-test/connect/r/part_table.reject	2023-10-21 20:12:09.992690246 +0000
      @@ -153,8 +153,8 @@
       Note	1105	xt3: 1 affected rows
       SELECT * FROM t1 WHERE id > 50;
       id	msg
      -60	soixante
       72	number
      +60	soixante
       81	eighty one
       UPDATE t1 SET msg = 'big' WHERE id > 50;
       Warnings:
       
      mysqltest: Result content mismatch
       
       - saving '/home/buildbot/ppc64le-centos-stream9/build/mysql-test/var/2/log/connect.part_table/' to '/home/buildbot/ppc64le-centos-stream9/build/mysql-test/var/log/connect.part_table/'
       
      Retrying test connect.part_table, attempt(2/3)...
      

      Attachments

        Issue Links

          Activity

            danblack Daniel Black added a comment - - edited

            Like connect.mysql_index - showing up in 11.4 ppc64le only. So probably a deeper problem.

            danblack Daniel Black added a comment - - edited Like connect.mysql_index - showing up in 11.4 ppc64le only. So probably a deeper problem.

            Moved back to Daniel as I have been unassigned from the PR.

            TheLinuxJedi Andrew Hutchings (Inactive) added a comment - Moved back to Daniel as I have been unassigned from the PR.
            danblack Daniel Black added a comment -

            11.4-c9284ae6d

            CURRENT_TEST: connect.mysql_index
            --- /home/buildbot/ppc64le-rhel-9/build/storage/connect/mysql-test/connect/r/mysql_index.result	2024-07-12 10:53:16.000000000 +0000
            +++ /home/buildbot/ppc64le-rhel-9/build/storage/connect/mysql-test/connect/r/mysql_index.reject	2024-07-12 11:36:03.878646901 +0000
            @@ -71,22 +71,22 @@
             7	seven
             explain SELECT * FROM t2 WHERE id <= 3;
             id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
            -1	SIMPLE	t2	range	PRIMARY	PRIMARY	4	NULL	2	Using where
            +1	SIMPLE	t2	ALL	PRIMARY	NULL	NULL	NULL	10	Using where
             SELECT * FROM t2 WHERE id <= 3;
             id	msg
             1	Un
            -2	Two
             3	Trois
            +2	Two
             SELECT * FROM t2 WHERE id BETWEEN 3 AND 5;
             id	msg
             3	Trois
            -4	Four
             5	Cinq
            +4	Four
             SELECT * FROM t2 WHERE id > 2 AND id < 6;
             id	msg
             3	Trois
            -4	Four
             5	Cinq
            

            danblack Daniel Black added a comment - 11.4-c9284ae6d CURRENT_TEST: connect.mysql_index --- /home/buildbot/ppc64le-rhel-9/build/storage/connect/mysql-test/connect/r/mysql_index.result 2024-07-12 10:53:16.000000000 +0000 +++ /home/buildbot/ppc64le-rhel-9/build/storage/connect/mysql-test/connect/r/mysql_index.reject 2024-07-12 11:36:03.878646901 +0000 @@ -71,22 +71,22 @@ 7 seven explain SELECT * FROM t2 WHERE id <= 3; id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t2 range PRIMARY PRIMARY 4 NULL 2 Using where +1 SIMPLE t2 ALL PRIMARY NULL NULL NULL 10 Using where SELECT * FROM t2 WHERE id <= 3; id msg 1 Un -2 Two 3 Trois +2 Two SELECT * FROM t2 WHERE id BETWEEN 3 AND 5; id msg 3 Trois -4 Four 5 Cinq +4 Four SELECT * FROM t2 WHERE id > 2 AND id < 6; id msg 3 Trois -4 Four 5 Cinq
            danblack Daniel Black added a comment -

            11.4-c9284ae6d https://buildbot.mariadb.org/#/builders/500/builds/13546

            CURRENT_TEST: connect.part_table
            --- /home/buildbot/ppc64le-centos-stream9/build/storage/connect/mysql-test/connect/r/part_table.result	2024-07-12 10:53:16.000000000 +0000
            +++ /home/buildbot/ppc64le-centos-stream9/build/storage/connect/mysql-test/connect/r/part_table.reject	2024-07-12 12:32:37.510416793 +0000
            @@ -153,8 +153,8 @@
             Note	1105	xt3: 1 affected rows
             SELECT * FROM t1 WHERE id > 50;
             id	msg
            -60	soixante
             72	number
            +60	soixante
             81	eighty one
             UPDATE t1 SET msg = 'big' WHERE id > 50;
             Warnings:
            

            danblack Daniel Black added a comment - 11.4-c9284ae6d https://buildbot.mariadb.org/#/builders/500/builds/13546 CURRENT_TEST: connect.part_table --- /home/buildbot/ppc64le-centos-stream9/build/storage/connect/mysql-test/connect/r/part_table.result 2024-07-12 10:53:16.000000000 +0000 +++ /home/buildbot/ppc64le-centos-stream9/build/storage/connect/mysql-test/connect/r/part_table.reject 2024-07-12 12:32:37.510416793 +0000 @@ -153,8 +153,8 @@ Note 1105 xt3: 1 affected rows SELECT * FROM t1 WHERE id > 50; id msg -60 soixante 72 number +60 soixante 81 eighty one UPDATE t1 SET msg = 'big' WHERE id > 50; Warnings:

            People

              danblack Daniel Black
              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.