Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
1.2
-
None
Description
The latest merge with server changed the way case constructs, especially those in a where or having clause, are passed to Columnstore. The following test fails with a goofy syntax error:
queries/working_tpch1/qa_fe_postProcessedFunctions/CASE1.DM.sql
MariaDB [tpch1]> 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
MariaDB [tpch1]>
Attachments
Issue Links
- duplicates
-
MCOL-1331 CASE1.DM.sql test fails
- Closed