Bug #70761 Missing rows when specifyieng dates in where clause like {d 'yyyy-mm-dd'}

• Submitted: 29 Oct 2013 6:20
• Modified: 30 Oct 2013 6:23
• Reporter: I G
• Status: Duplicate
• Category: MySQL Server: Optimizer
• Severity: S1 (Critical)
• Version: 5.6.10 - 5.6.14
• OS: Windows (8)
• CPU Architecture: Any

[29 Oct 2013 6:20] I G

Description:
http://scn.sap.com/thread/3359300  => true story

I've run the same query from HeidiSQL, and the same issue occurs. Some times, I get the full result, and some times only the rows with data on all queried tables.

How to repeat:
SELECT * 
FROM T1
LEFT JOIN T2 ON T2.INT_COL = T1.INT_COL
WHERE T1.DATE_COL >= {d 'YYYY-MM-DD'} AND T1.DATE_COL <= {d 'YYYY-MM-DD'}

[29 Oct 2013 8:56] MySQL Verification Team

Hello!!

Thank you for the bug report.
I can not repeat described behavior with the dummy data etc.
Could you please provide complete test case ( schema, data - make it private if you prefer) to reproduce?

This looks similar to Bug #69233

Thanks,
Umesh

[29 Oct 2013 15:33] I G

I agree, it's the same bug, but it happened to me with only one table in the left join clause.

[30 Oct 2013 6:20] MySQL Verification Team

Thank you for the bug report, duplicate of Bug #69233