Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
5.5.32, 5.3.12
-
None
-
None
-
Linux
Description
set @h0="20111107"; |
set @h1="0"; |
select
|
COALESCE(date(@h0),date("1901-01-01")) as h0d, |
COALESCE(date(@h1),date(now())) as h1d, |
COALESCE(date(@h0),date("1901-01-01"))>COALESCE(date(@h1),date(now())) as compare_h0_gt_h1; |
Date comparing is true in 5.5.32 but in 5.5.30 is false. False is the good result.