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

Crash in my_decimal2decimal in a ORDER BY query

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Major
        • Resolution: Fixed
        • Affects Version/s: 5.3.12
        • Fix Version/s: 10.0.4, 5.5.32, 5.3.13
        • Component/s: None
        • Labels:
          None

          Description

          This script crashes mysqld:

          set @@time_zone='+00:00';
drop table if exists t1;
create table t1 (a datetime(4) not null);
insert into t1 values ('2001-01-01 00:00:00'),('2000-00-00 00:00:00');
select unix_timestamp(a) from t1 order by 1;

            Gliffy Diagrams

              Attachments

                Activity

                Ascending order - Click to sort in descending order
                Hide
                Permalink
                bar Alexander Barkov added a comment - - edited

                The problem seems to be in a missing call for:
                set_persist_maybe_null(1);
                which was added in 5.5.

                Show
                bar Alexander Barkov added a comment - - edited The problem seems to be in a missing call for: set_persist_maybe_null(1); which was added in 5.5.
                Hide
                Permalink
                bar Alexander Barkov added a comment -

                Fixed. Pushed into 5.3.13 and 5.5.32.

                Show
                bar Alexander Barkov added a comment - Fixed. Pushed into 5.3.13 and 5.5.32.

                  People

                  • Assignee:
                    bar Alexander Barkov
                    Reporter:
                    bar Alexander Barkov
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    2 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved: