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 Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: Optimizer Severity:S1 (Critical)
Version:5.6.10 - 5.6.14 OS:Windows (8)
Assigned to: 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

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.041 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.