Details
-
Bug
-
Status: Resolved
-
Major
-
Resolution: Fixed
-
None
-
None
-
None
Description
In the case of a next query, "col3 like '1993-11-24%';" condition removed by optimized.
select a.* from ( select L_RETURNFLAG as col1, L_EXTENDEDPRICE as col2, concat(L_RECEIPTDATE, L_LINESTATUS) as col3 from lineitem ) a where col2 > 0 && col3 like '1993-11-24%';