[#MDEV-5132] Crash on a simple join query with IS NULL and IS NOT NULL in where

[MDEV-5132] Crash on a simple join query with IS NULL and IS NOT NULL in where Created: 2013-10-12 Updated: 2013-10-13 Resolved: 2013-10-13
Status:	Closed
Project:	MariaDB Server
Component/s:	None
Affects Version/s:	5.3.13
Fix Version/s:	5.3.13

Type:

Bug

Priority:

Major

Reporter:

Igor Babaev

Assignee:

Igor Babaev

Resolution:

Fixed

Votes:

Labels:

None

Description

After rev 3702 the following test case causes a crash of the server

CREATE TABLE t1 (a DATE, b INT, c INT, KEY(a), KEY(b), KEY(c)) ENGINE=MyISAM;

CREATE TABLE t2 (d DATE) ENGINE=MyISAM;

SELECT  * FROM t1,t2 WHERE  1 IS NOT NULL AND t1.b IS NULL;

DROP TABLE t1,t2;

Comments

Comment by Igor Babaev [ 2013-10-13 ]

The bug was fixed in the revision 3704.

Generated at Thu Feb 08 07:01:55 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.