[MCOL-171] 0000-00-00 dates are not supported and are munged to NULL with no warnings Created: 2016-06-22  Updated: 2016-10-11  Resolved: 2016-09-13

Status: Closed
Project: MariaDB ColumnStore
Component/s: DMLProc
Affects Version/s: None
Fix Version/s: 1.0.3

Type: Bug Priority: Major
Reporter: Justin Swanhart (Inactive) Assignee: Daniel Lee (Inactive)
Resolution: Fixed Votes: 0
Labels: relnote

Issue Links:
Duplicate
duplicates MCOL-170 Invalid dates are truncacted to NULL ... Closed
PartOf
is part of MCOL-280 Beta issues Closed
Relates
relates to MCOL-271 Improved support for NULL for Varchar... Closed
relates to MCOL-350 can't select date value of 0000-00-00 Closed
Sprint: 1.0.3

 Description   

create table t2(d date, dt datetime) engine=columnstore;

MariaDB [test]> insert into t2 values ('0000-00-00','0000-00-00');
Query OK, 1 row affected (0.25 sec)

MariaDB [test]> select * from t2;
----------+

d dt

----------+

NULL NULL

----------+
1 row in set (0.06 sec)

MariaDB [test]> select * from t2 where dt='0000-00-00';
Empty set (0.00 sec)

MariaDB [test]> select * from t2 where dt is null;
----------+

d dt

----------+

NULL NULL

----------+
1 row in set (0.01 sec)

 Comments   
Comment by Andrew Hutchings (Inactive) [ 2016-08-19 ]

Marked as In Progress as this is getting fixed as part of my fix for MCOL-271. NULL handling is basically completely missing at the moment.

Comment by Andrew Hutchings (Inactive) [ 2016-08-23 ]

note that year < 1400 is also invalid in ColumnStore's checks. Will be fixed as part of my patch

Comment by Andrew Hutchings (Inactive) [ 2016-08-24 ]

The fix for this is now in my patch for MCOL-271. But is not ready yet due to a few issues around VARCHAR handling in 271.

Note: after merge this page will need updating as the DATETIME limits are now in-line with MariaDB's with my fix: https://mariadb.com/kb/en/mariadb/columnstore-data-types/

Comment by Andrew Hutchings (Inactive) [ 2016-08-30 ]

On hold for now. My fix for this is working great, but without fixing MCOL-271 as well it will break CHAR/VARCHAR handling. I need more time to work on MCOL-271.

Comment by Andrew Hutchings (Inactive) [ 2016-08-30 ]

https://github.com/mariadb-corporation/mariadb-columnstore-engine/pull/5

This is a fix for MCOL-171 and can be used to build the fix for MCOL-271. Required the fix for MCOL-274 to land first.

Comment by David Hall (Inactive) [ 2016-09-02 ]

Test and close

Comment by Daniel Lee (Inactive) [ 2016-09-13 ]

Build verified:

Name : mariadb-columnstore-platform
Version : 1.0.3
Release : 1
Architecture: x86_64
Install Date: Tue 13 Sep 2016 09:26:32 AM CDT

Generated at Thu Feb 08 02:19:02 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.