-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Critical
-
Resolution: Fixed
-
Affects Version/s: 5.5.32, 5.3.12
-
Component/s: None
-
Labels:None
-
Environment:Linux
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.