[MDEV-4651] Crash in my_decimal2decimal in a ORDER BY query Created: 2013-06-13  Updated: 2013-06-18  Resolved: 2013-06-18

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: 5.3.12
Fix Version/s: 10.0.4, 5.5.32, 5.3.13

Type: Bug Priority: Major
Reporter: Alexander Barkov Assignee: Alexander Barkov
Resolution: Fixed Votes: 0
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;



 Comments   
Comment by Alexander Barkov [ 2013-06-13 ]

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

Comment by Alexander Barkov [ 2013-06-18 ]

Fixed. Pushed into 5.3.13 and 5.5.32.

Generated at Thu Feb 08 06:58:05 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.