[MCOL-3896] working_tpch1_compareLogOnly/view failures Created: 2020-03-20  Updated: 2022-09-13  Resolved: 2022-09-13

Status: Closed
Project: MariaDB ColumnStore
Component/s: ExeMgr, PrimProc
Affects Version/s: None
Fix Version/s: 22.08.1

Type: Bug Priority: Critical
Reporter: Roman Assignee: David Hall (Inactive)
Resolution: Fixed Votes: 0
Labels: None


 Description   

There is a combination of non-deterministic sorting order and known issues that produces failures in the test except in one.

mts_view.50.sql and mts_view.80.sql both fail b/c of unpredicted sorting order.
mts_view.60.sql and mts_view.90.sql fails with
+ERROR 1178 (42000) at line 72: The storage engine for the table doesn't support IDB-1001: Function 'istrue' can only be used in the outermost select or order by clause and cannot be used in conjunction with an aggregate function.

mts_view.sql is the interesting one.
Some of the queries fail with:
ERROR 1815 (HY000) at line 50: Internal error: column is not found in info map
Other errors are combination of the first two types mentioned in this issue.

 Comments   
Comment by Roman [ 2020-03-20 ]

mts_view.sql contains query with order on projection subselect that fails. It produces the errors in syslog.

Mar 20 06:55:35 drrtuy-devel-1 ExeMgr[19255]: 35.015048 |2395|0|0| D 16 CAL0041: Start SQL statement: select * from v1 order by 1,2,3,4; |tpch1|
 
Mar 20 06:55:35 drrtuy-devel-1 joblist[19255]: 35.024655 |2395|0|0| D 05 CAL0059: JobListFactory makeJoblist error: (-1, $exp) not found in tuple info map.
 
Mar 20 06:55:35 drrtuy-devel-1 joblist[19255]: 35.024891 |2395|0|0| E 05 CAL0059: JobListFactory makeJoblist error: column is not found in info map.

Here are the steps to reproduce

MariaDB [tpch1]> create table cs42(i bigint)engine=columnstore;
 
iQuery OK, 0 rows affected (0.391 sec)
 
 
 
MariaDB [tpch1]> insert into cs42 values (105),(0),(42);
 
Query OK, 3 rows affected (0.265 sec)
 
Records: 3  Duplicates: 0  Warnings: 0
 
 
 
MariaDB [tpch1]> select i,(select i from cs42 order by i limit 1) c2 from cs42;
 
+------+------+
 
| i    | c2   |
 
+------+------+
 
|  105 |    0 |
 
|    0 |    0 |
 
|   42 |    0 |
 
+------+------+
 
3 rows in set (0.055 sec)
 
 
 
MariaDB [tpch1]> select i,(select i from cs42 order by i limit 1) c2 from cs42 order by 1;
 
+------+------+
 
| i    | c2   |
 
+------+------+
 
|    0 |    0 |
 
|   42 |    0 |
 
|  105 |    0 |
 
+------+------+
 
3 rows in set (0.012 sec)
 
 
 
MariaDB [tpch1]> select i,(select i from cs42 order by i limit 1) c2 from cs42 order by 2;
 
ERROR 1815 (HY000): Internal error: column is not found in info map.

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