[MDEV-31334] MariaDB should not accept dates with 'T' on the end Created: 2023-05-24  Updated: 2023-06-20

Status: Open
Project: MariaDB Server
Component/s: Data types
Affects Version/s: 10.6
Fix Version/s: 10.6

Type: Bug Priority: Minor
Reporter: Michael Widenius Assignee: Alexander Barkov
Resolution: Unresolved Votes: 0
Labels: beginner-friendly


 Description   

MariaDB [test]> create table t1 (a date);
MariaDB [test]> insert into t1 values ("2003-02-05T");
The above should be an error (in strict mode). Now it's accepted even without a warning.

 Comments   
Comment by Marko Mäkelä [ 2023-05-24 ]

I was curious about this and checked the Wikipedia article on ISO 8601. It seems to agree with the description: T is the optional start marker of a time part, and there are no examples given where a date without a time would be terminated in T, or T would not be followed with a time of day.

Generated at Thu Feb 08 10:23:03 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.