Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
1.1.4
-
None
-
2018-08
Description
The third query in working_tpch1/qa_fe_postProcessedFunctions/CASE1.DM.sql fails:
select cidx, CDATE from datatypetestm order by CASE CDATE WHEN '9999-12-27' THEN '2009-01-01' WHEN '9999-12-27' THEN '2009-01-01' ELSE NULL END, cidx; |
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '<cache>('9999-12-27') then '2009-01-01' when <cache>('9999-12-27') then '2009-01' at line 1 |
I suspect this is a regression due to the recent CASE handling changes.
Attachments
Issue Links
- is duplicated by
-
MCOL-1432 Regression in CASE1.DM.sql
- Closed