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

[Draft] Wrong result

        Details

        • Type: Bug
        • Status: Open
        • Priority: Minor
        • Resolution: Unresolved
        • Affects Version/s: 10.0
        • Fix Version/s: 10.0
        • Component/s: Optimizer
        • Labels:
          None

          Description

          Note: Note: there is certainly a problem, but it's not new, and I don't see any capacity for fixing now, and besides it might well be a duplicate of a known issue. So I won't waste time on creating a proper bug report just yet.

          SELECT alias1.`col_varchar_10_utf8_key` AS field1 FROM view_H AS alias1 LEFT JOIN A AS alias2 LEFT JOIN view_F AS alias3 LEFT JOIN view_C AS alias4 ON alias3.`pk` = alias4.`pk` ON alias2.`col_int` = alias4.`col_int` ON alias1.`pk` = alias2.`col_int` WHERE alias4.`col_varchar_1024_utf8` NOT BETWEEN 'b' AND 'z' OR alias4.`col_varchar_1024_utf8` >= 'd' AND alias4.`col_varchar_1024_utf8` <= 'z' OR alias2.`col_varchar_10_utf8` > 'c' AND alias2.`col_varchar_10_utf8` < 'z'
;
field1
SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, "=off", "=on" );
SELECT alias1.`col_varchar_10_utf8_key` AS field1 FROM view_H AS alias1 LEFT JOIN A AS alias2 LEFT JOIN view_F AS alias3 LEFT JOIN view_C AS alias4 ON alias3.`pk` = alias4.`pk` ON alias2.`col_int` = alias4.`col_int` ON alias1.`pk` = alias2.`col_int` WHERE alias4.`col_varchar_1024_utf8` NOT BETWEEN 'b' AND 'z' OR alias4.`col_varchar_1024_utf8` >= 'd' AND alias4.`col_varchar_1024_utf8` <= 'z' OR alias2.`col_varchar_10_utf8` > 'c' AND alias2.`col_varchar_10_utf8` < 'z'
;
field1
z

          Test case is attached.

            Gliffy Diagrams

              Attachments

                Activity

                There are no comments yet on this issue.

                  People

                  • Assignee:
                    elenst Elena Stepanova
                    Reporter:
                    elenst Elena Stepanova
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    2 Start watching this issue

                    Dates

                    • Created:
                      Updated: