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

LP:1001505 - Crash on a query over a table with ZEROFILL column whose where condition contains IN predicate using this column

        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 an assertion abort in MariaDB 5.2/5.3/5.5

          CREATE TABLE t1(a INT ZEROFILL);
          SELECT 1 FROM t1 WHERE t1.a IN (1, t1.a) AND t1.a=2;
          DROP TABLE t1;

          (see also bug #57692 from bugs.mysql.com)

            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 over a table with ZEROFILL column whose where condition contains IN predicate using this column
                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 over a table with ZEROFILL column whose where condition contains IN predicate using this column 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: 1001505

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

                  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: