[MCOL-1331] CASE1.DM.sql test fails Created: 2018-04-09  Updated: 2018-05-21  Resolved: 2018-04-17

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

Type: Bug Priority: Critical
Reporter: Andrew Hutchings (Inactive) Assignee: Daniel Lee (Inactive)
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Duplicate
is duplicated by MCOL-1432 Regression in CASE1.DM.sql Closed
Sprint: 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.

 Comments   
Comment by Andrew Hutchings (Inactive) [ 2018-04-09 ]

assigned back to me as it looks like this could be something from the recent server merge

Comment by Andrew Hutchings (Inactive) [ 2018-04-10 ]

confirmed, this happened during the 10.2.14 merge

Comment by Andrew Hutchings (Inactive) [ 2018-04-10 ]

Appears to be due to a change in the item.cc/.h code.

Comment by Andrew Hutchings (Inactive) [ 2018-04-10 ]

correction... item_cmpfunc.cc/.h

Comment by Andrew Hutchings (Inactive) [ 2018-04-11 ]

For QA: the test in the description should pass after this patch. It failed after the 10.2.14 merge.

Comment by Daniel Lee (Inactive) [ 2018-04-17 ]

Build verified: 1.1.4-1 source

/root/columnstore/mariadb-columnstore-server
commit 5199dd1a096fd3457e8fc0508bf5fb24cedec435
Merge: fce3c5e e554e04
Author: David.Hall <david.hall@mariadb.com>
Date: Wed Apr 11 11:04:46 2018 -0500

Merge pull request #108 from mariadb-corporation/MCOL-1331

MCOL-1331 Fix CASE1.DM.sql

/root/columnstore/mariadb-columnstore-server/mariadb-columnstore-engine
[root@localhost mariadb-columnstore-engine]# git show
commit ae04b8a6877c87f3ed3566f2bf721bf285ca625f
Merge: 2ab632c dbcbd6c
Author: david hill <david.hill@mariadb.com>
Date: Tue Apr 10 10:55:56 2018 -0400

Merge pull request #438 from mariadb-corporation/MCOL-1323

MCOL-1323 cpimport Splitter has incorrect SIGPIPE mapping

diff --cc writeengine/splitter/we_splitterapp.cpp
index f52f362,0077ebd..402d2b0
mode 100755,100644..100755
— a/writeengine/splitter/we_splitterapp.cpp
+++ b/writeengine/splitter/we_splitterapp.cpp

MariaDB [mytest]> 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;
----------------+

cidx CDATE

----------------+

1 1000-01-01
2 1000-01-01
3 1000-01-02
4 1000-01-03
5 1000-01-04
6 9999-12-28
7 9999-12-29
8 9999-12-30
9 9999-12-31
10 9999-12-31
11 NULL

----------------+
11 rows in set (0.00 sec)

MariaDB [mytest]>

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