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

main.derived fails, buildbot is broken

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: N/A
    • Fix Version/s: N/A
    • Component/s: Tests
    • Labels:
      None

      Description

      main.derived                             [ fail ]
              Test ended at 2016-08-01 01:28:48
       
      CURRENT_TEST: main.derived
      --- /data/bld/10.1/mysql-test/r/derived.result	2016-06-14 18:49:07.000000000 +0300
      +++ /data/bld/10.1/mysql-test/r/derived.reject	2016-08-01 01:28:47.987460888 +0300
      @@ -621,13 +621,13 @@
       );
       id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
       1	PRIMARY	<derived2>	system	NULL	NULL	NULL	NULL	1	100.00	
      -1	PRIMARY	<subquery4>	eq_ref	distinct_key	distinct_key	4	sq.f2	1	100.00	
      +1	PRIMARY	<subquery4>	eq_ref	distinct_key	distinct_key	4	const	1	100.00	
       1	PRIMARY	t2	ALL	NULL	NULL	NULL	NULL	2	100.00	Using where; FirstMatch(<subquery4>); Using join buffer (flat, BNL join)
       4	MATERIALIZED	t2	ALL	NULL	NULL	NULL	NULL	2	100.00	
       2	DERIVED	t1	system	NULL	NULL	NULL	NULL	1	100.00	
       Warnings:
       Note	1276	Field or reference 'sq.f2' of SELECT #3 was resolved in SELECT #1
      -Note	1003	select 6 AS `f1` from  <materialize> (select `test`.`t2`.`f3` from `test`.`t2` having (`test`.`t2`.`f3` >= 8)) semi join (`test`.`t2`) where ((`test`.`t2`.`f3` = 6) and (9 = `<subquery4>`.`f3`))
      +Note	1003	select 6 AS `f1` from  <materialize> (select `test`.`t2`.`f3` from `test`.`t2` having (`test`.`t2`.`f3` >= 8)) semi join (`test`.`t2`) where ((`test`.`t2`.`f3` = 6) and (`<subquery4>`.`f3` = 9))
       DROP TABLE t2,t1;
       #
       # MDEV-9462: Out of memory using explain on 2 empty tables 
       
      mysqltest: Result content mismatch
      

      Please fix asap, buildbot is completely broken.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                psergey Sergei Petrunia
                Reporter:
                elenst Elena Stepanova
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: