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

LP:1001510 - Crash on a query whose where condition contains CASE expression

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Critical
        • Resolution: Fixed
        • Affects Version/s: None
        • Fix Version/s: None
        • Component/s: None
        • Labels:

          Description

          The following simple test case causes a crash of the server in MariaDB 5.2/5.3/5.5:

          CREATE TABLE t1(a YEAR);
          SELECT 1 FROM t1 WHERE a=1 AND CASE 1 WHEN a THEN 1 ELSE 1 END;
          DROP TABLE t1;

          See also bug #57135 from bugs.mysql.com

          This bug is similar to LP bug #1001505.

            Gliffy Diagrams

              Attachments

                Activity

                Ascending order - Click to sort in descending order
                Hide
                Permalink
                sanja Oleksandr Byelkin added a comment -

                Re: Crash on a query whose where condition contains CASE expression
                It is somehow connected to qualities propagation of zerofield so it can't be fixed fast by me... Will be postponed after dynamic columns.

                Show
                sanja Oleksandr Byelkin added a comment - Re: Crash on a query whose where condition contains CASE expression It is somehow connected to qualities propagation of zerofield so it can't be fixed fast by me... Will be postponed after dynamic columns.
                Hide
                Permalink
                ratzpo Rasmus Johansson added a comment -

                Launchpad bug id: 1001510

                Show
                ratzpo Rasmus Johansson added a comment - Launchpad bug id: 1001510

                  People

                  • Assignee:
                    sanja Oleksandr Byelkin
                    Reporter:
                    igor Igor Babaev
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    0 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved: