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

main.derived fails, buildbot is broken

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Blocker
    • Resolution: Fixed
    • N/A
    • N/A
    • Tests
    • 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

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

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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