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

main.derived_split_innodb

    XMLWordPrintable

    Details

      Description

      Fails in new buildbot on amd64-ubuntu-2004-icc with

      CURRENT_TEST: main.derived_split_innodb
      --- /buildbot/amd64-ubuntu-2004-icc/build/mysql-test/main/derived_split_innodb.result	2021-03-24 16:56:51.000000000 +0000
      +++ /buildbot/amd64-ubuntu-2004-icc/build/mysql-test/main/derived_split_innodb.reject	2021-03-24 20:07:01.754138195 +0000
      @@ -48,9 +48,9 @@
       id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
       1	PRIMARY	t2	ALL	NULL	NULL	NULL	NULL	1	Using where
       1	PRIMARY	<derived2>	ref	key0	key0	5	test.t2.id2	2	
      -2	DERIVED	t3	ALL	NULL	NULL	NULL	NULL	1	Using where; Using temporary; Using filesort
      -2	DERIVED	t1	eq_ref	PRIMARY,id2	PRIMARY	4	test.t3.i3	1	
      -2	DERIVED	t2	ALL	NULL	NULL	NULL	NULL	1	Using where; Using join buffer (flat, BNL join)
      +2	LATERAL DERIVED	t3	ALL	NULL	NULL	NULL	NULL	1	Using where; Using temporary; Using filesort
      +2	LATERAL DERIVED	t1	eq_ref	PRIMARY,id2	PRIMARY	4	test.t3.i3	1	Using where
      +2	LATERAL DERIVED	t2	ALL	NULL	NULL	NULL	NULL	1	Using where; Using join buffer (flat, BNL join)
       SELECT id3
       FROM (SELECT t3.id3, t2.i2, t1.id2  FROM t3,t1,t2
       WHERE t3.i3=t1.id1 AND t2.id2=t1.id2
      

      This is random failure but is important to get fixed so to make protected branches work

        Attachments

          Activity

            People

            Assignee:
            psergey Sergei Petrunia
            Reporter:
            monty Michael Widenius
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: