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

Add optimizer trace to main/order_by_innodb.test to diagnose debian build issue

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Minor
    • Resolution: Unresolved
    • 10.11
    • 10.11
    • Optimizer
    • None
    • IBM s390, debian

    Description

      mysql test failing, add trace to aid diagnostics

      CURRENT_TEST: main.order_by_innodb
      --- /<<PKGBUILDDIR>>/mysql-test/main/order_by_innodb.result	2022-11-14 18:10:21.000000000 +0000
      +++ /<<PKGBUILDDIR>>/mysql-test/main/order_by_innodb.reject	2023-02-06 01:30:20.732947938 +0000
      @@ -250,7 +250,7 @@
       id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
       1	PRIMARY	t1	index	NULL	PRIMARY	4	NULL	#	Using index
       1	PRIMARY	t2	eq_ref	PRIMARY,id2	PRIMARY	4	func	#	Using where
      -2	DEPENDENT SUBQUERY	dd	range	id2,for_latest_sort	for_latest_sort	6	NULL	#	Using where
      +2	DEPENDENT SUBQUERY	dd	ref	id2,for_latest_sort	id2	4	test.t1.id	#	Using where; Using filesort
       drop table t1,t2,t3;
      

      Attachments

        Activity

          People

            Johnston Rex Johnston
            Johnston Rex Johnston
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.