[MCOL-1387] CASE statement returned internal error due to non-support conversion Created: 2018-05-04  Updated: 2019-06-10  Resolved: 2019-06-10

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

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


 Description   

Build tested: 1.1.4-1

MariaDB [mytest]> select cidx, CDOUBLE, CASE CDOUBLE WHEN -9999999.99 THEN 1 WHEN -9999999.99 THEN 1 ELSE NULL END CaseCol from datatypetestm order by cidx;
ERROR 1815 (HY000): Internal error: An unexpected condition within the query caused an internal processing error within InfiniDB. Please check the log files for more details. Additional Information: error in BatchPrimitiveProces
MariaDB [mytest]> select cidx, CFLOAT, CASE CFLOAT WHEN -9999999.99 THEN 1 WHEN -9999999.99 THEN 1 ELSE NULL END CaseCol from datatypetestm order by cidx;
ERROR 1815 (HY000): Internal error: An unexpected condition within the query caused an internal processing error within InfiniDB. Please check the log files for more details. Additional Information: error in BatchPrimitiveProces
MariaDB [mytest]> select cidx, CDOUBLE from datatypetestm where CASE CDOUBLE WHEN -9999999.99 THEN 1 WHEN -9999999.99 THEN 1 ELSE NULL END <> 0 order by cidx;
ERROR 1815 (HY000): Internal error: An unexpected condition within the query caused an internal processing error within InfiniDB. Please check the log files for more details. Additional Information: error in BatchPrimitiveProces
MariaDB [mytest]> select cidx, CFLOAT from datatypetestm where CASE CFLOAT WHEN -9999999.99 THEN 1 WHEN -9999999.99 THEN 1 ELSE NULL END <> 0 order by cidx;
ERROR 1815 (HY000): Internal error: An unexpected condition within the query caused an internal processing error within InfiniDB. Please check the log files for more details. Additional Information: error in BatchPrimitiveProces

err.log reported the following:

May 4 15:36:36 localhost PrimProc[16098]: 36.835541 |0|0|0| C 28 CAL0000: TreeNode::getDecimalVal: non-support conversion from double
May 4 15:36:53 localhost PrimProc[16098]: 53.498092 |0|0|0| C 28 CAL0000: TreeNode::getDecimalVal: non-support conversion from float
May 4 15:37:09 localhost PrimProc[16098]: 09.838103 |0|0|0| C 28 CAL0000: TreeNode::getDecimalVal: non-support conversion from double
May 4 15:37:22 localhost PrimProc[16098]: 22.974184 |0|0|0| C 28 CAL0000: TreeNode::getDecimalVal: non-support conversion from float

 Comments   
Comment by David Hall (Inactive) [ 2018-05-07 ]

While we're fixing this, we need to also change the message from InfiniDB to Columnstore.

Comment by Andrew Hutchings (Inactive) [ 2019-06-10 ]

Recent changes in 1.2 have fixed this.

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