Wrong result (missing rows) on LEFT JOINs and <non-nullable datetime field> IS NULL

Description

Expected result:

Actual result:

On 5.3, the problem appeared with the revision below; but on 5.5 it had apparently existed long before that, and still does.

MariaDB 5.2, MySQL 5.1, MySQL 5.6 return 2 rows.

Environment

None

Assignee

Igor Babaev

Reporter

Elena Stepanova

Labels

None

Fix versions

Affects versions

Priority

Major
Configure