[MCOL-1457] operating mode 0 fails under certain conditions. Created: 2018-06-06  Updated: 2018-07-18  Resolved: 2018-07-18

Status: Closed
Project: MariaDB ColumnStore
Component/s: MDB Plugin
Affects Version/s: 1.2
Fix Version/s: 1.2.0

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

Issue Links:
Relates
relates to MCOL-1456 Query doesn't try REDO_PHASE1 Closed
Sprint: 2018-14

 Description   

in working_tpch1_compareLogOnly/tableMode/tablemode.sql, we find:

set infinidb_vtable_mode=0;

SELECT SUM( c_acctbal* (1-c_acctbal)) AS REVENUE FROM CUSTOMER, nation WHERE C_MKTSEGMENT = 'BUILDING' and c_nationkey<3 AND C_nationkey = n_nationkey GROUP BY c_custkey ORDER BY REVENUE DESC;

This breaks with:
ERROR 1178 (42000): The storage engine for the table doesn't support IDB-3011: Non-supported item in Order By clause.

The problem appears to be an aggregate used as an ORDER BY.

This doesn't break with vtable mode = 1.

 Comments   
Comment by Roman [ 2018-06-21 ]

Please review the fix.

Comment by Daniel Lee (Inactive) [ 2018-07-18 ]

Build verified: 1.2.0-1 source

/root/columnstore/mariadb-columnstore-server
commit 3bfc3ad5f1e91e6f325b89fefaf62a6b38ca889a
Merge: 4334641 742af4d
Author: David.Hall <david.hall@mariadb.com>
Date: Thu May 31 09:40:12 2018 -0500

Merge pull request #119 from mariadb-corporation/1.1-merge-up-20180531

Merge develop-1.1 into develop

/root/columnstore/mariadb-columnstore-server/mariadb-columnstore-engine
commit 4a3f8b77c2e3fe2ec311150c79551900324e59e8
Merge: 6aedf1d a62a2e3
Author: Andrew Hutchings <andrew@linuxjedi.co.uk>
Date: Wed Jul 18 09:34:13 2018 +0100

Merge pull request #519 from drrtuy/MCOL-1510

MCOL-1510 GROUP BY handler doesn't support operations on aggregate functions when projecting columns.

.
.
.

-99649906.7004
-99689241.5525
-99748757.7549
-99788511.6864
-99791108.9525
-99877637.2044
-99979800.7701

----------------
3641 rows in set (0.49 sec)

MariaDB [tpch1]>

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