[MCOL-1432] Regression in CASE1.DM.sql Created: 2018-05-21  Updated: 2018-05-21  Resolved: 2018-05-21

Status: Closed
Project: MariaDB ColumnStore
Component/s: MariaDB Server
Affects Version/s: 1.2
Fix Version/s: Icebox

Type: Bug Priority: Major
Reporter: David Hall (Inactive) Assignee: Andrew Hutchings (Inactive)
Resolution: Duplicate Votes: 0
Labels: None

Issue Links:
Duplicate
duplicates MCOL-1331 CASE1.DM.sql test fails Closed

 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]>



 Comments   
Comment by Andrew Hutchings (Inactive) [ 2018-05-21 ]

This is a duplicate of MCOL-1331. Whilst it has been merged into the develop-1.1 server tree the fix has not yet been merged up into develop.

For now it may be best to use server from develop-1.1 with the engine from develop until the merge up happens. At the moment there is no real difference between the two.

Generated at Thu Feb 08 02:28:43 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.