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

[Draft] Different results on debug and non-debug build

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Cannot Reproduce
    • 5.5, 10.1
    • N/A
    • Optimizer
    • None

    Description

      Debug

      SELECT COUNT(*) FROM ( ( SELECT DISTINCT SQ1_alias1.* FROM ( table1000_aria_latin1 AS SQ1_alias1 INNER JOIN view_table10_innodb_latin1_0 AS SQ1_alias2 ON (SQ1_alias2.`col_smallint_null` = SQ1_alias1.`col_tinyint_null` ) ) WHERE SQ1_alias1.`col_tinyint_unsigned_not_null` <> 0 ) AS alias1, `table20_aria_utf8` AS alias2 ) WHERE alias1.`col_bit_null` IN ( SELECT SQ2_alias1.`col_bigint_not_null` AS SQ2_ifield1 FROM table20_myisam_latin1 AS SQ2_alias1 ) 
      ;
      COUNT(*)
      0
      

      non-debug

      SELECT COUNT(*) FROM ( ( SELECT DISTINCT SQ1_alias1.* FROM ( table1000_aria_latin1 AS SQ1_alias1 INNER JOIN view_table10_innodb_latin1_0 AS SQ1_alias2 ON (SQ1_alias2.`col_smallint_null` = SQ1_alias1.`col_tinyint_null` ) ) WHERE SQ1_alias1.`col_tinyint_unsigned_not_null` <> 0 ) AS alias1, `table20_aria_utf8` AS alias2 ) WHERE alias1.`col_bit_null` IN ( SELECT SQ2_alias1.`col_bigint_not_null` AS SQ2_ifield1 FROM table20_myisam_latin1 AS SQ2_alias1 ) 
      ;
      COUNT(*)
      1
      

      15f9931f6d2b0eb4006fdc42072c2905fd67c1aa

      Attachments

        Activity

          People

            Unassigned Unassigned
            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.