[MDEV-3219] LP:695684 - subselect3_jcl6 differs from subselect3 Created: 2010-12-30  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: Sergei Golubchik Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: Launchpad

Attachments: XML File LPexportBug695684.xml    

 Description   

comparing subselect3.result and subselect3_jcl6.result one can see few differences.
Different EXPLAIN output is expected.
Few queries return rows in different order - which is normal too.
But one query return different results, which looks like a bug:

— r/subselect3.result 2010-11-02 10:48:15.000000000 +0100
+++ r/subselect3_jcl6.result 2010-11-02 10:48:15.000000000 +0100
@@ -1031,6 +1035,7 @@
t22.a in (select t12.a from t11, t12 where t11.a in(255,256) and t11.a = t12.a and t11.c is null) and t22.c is null order by t21.a;
a b c
256 67 NULL
+256 67 NULL
drop table t1, t11, t12, t21, t22;
create table t1(a int);
insert into t1 values (0),(1);



 Comments   
Comment by Sergei Golubchik [ 2011-01-11 ]

Re: subselect3_jcl6 differs from subselect3
already fixed in the latest 5.3

Comment by Rasmus Johansson (Inactive) [ 2011-12-13 ]

Launchpad bug id: 695684

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