[MDEV-3403] LP:731276 - NULLs returned from SUBTIME() are not properly handled in IN() context Created: 2011-03-08  Updated: 2015-02-02  Resolved: 2012-10-04

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Bug Priority: Major
Reporter: Philip Stoev (Inactive) Assignee: Sergei Golubchik
Resolution: Fixed Votes: 0
Labels: Launchpad

Attachments: XML File LPexportBug731276.xml    

 Description   

Not repeatable in mysql-5.1. The following query:

SELECT * FROM t1 WHERE f1 NOT IN ('00:08:08', SUBTIME( '0000-00-00 00:00:00' , '00:00:00' ));

returns rows even though SUBTIME() returns NULL, which should make the entire NOT IN predicate NULL .

Test case:

CREATE TABLE t1 (f1 TIME);
INSERT INTO t1 VALUES ('01:01:01');

SELECT * FROM t1 WHERE f1 NOT IN ('00:08:08', SUBTIME( '0000-00-00 00:00:00' , '00:00:00' ));

 Comments   
Comment by Sergei Golubchik [ 2011-03-08 ]

Re: NULLs returned from SUBTIME() are not properly handled in IN() context
it is MySQL bug http://bugs.mysql.com/bug.php?id=60400

Comment by Sergei Golubchik [ 2011-07-20 ]

Re: NULLs returned from SUBTIME() are not properly handled in IN() context
fixed upstream as http://bugs.mysql.com/bug.php?id=59270

Comment by Rasmus Johansson (Inactive) [ 2011-10-28 ]

Launchpad bug id: 731276

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