Bug #43635 Maria: subselect_jcl6 misses rows with engine=maria
Submitted: 13 Mar 2009 14:27 Modified: 26 May 2010 17:52
Reporter: Guilhem Bichot Email Updates:
Status: Unsupported Impact on me:
None 
Category:MySQL Server: Maria storage engine Severity:S3 (Non-critical)
Version: OS:Linux
Assigned to: CPU Architecture:Any
Triage: Triaged: D2 (Serious)

[13 Mar 2009 14:27] Guilhem Bichot 
Description:
Latest 6.0-maria:
revision-id:guilhem@mysql.com-20090313141043-73a6mr7hsrqm3djc

./mtr --mysqld=--default-storage-engine=maria main.subselect3_jcl6

shows in the diff:

 select t21.* from t21,t22 where t21.a = t22.a and
 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

Before the revision above was pushed, the two rows were missing.

How to repeat:
see description