[MCOL-3480] XOR() returns "Non-supported item in Order By clause" Created: 2019-09-04  Updated: 2023-03-06  Resolved: 2023-03-06

Status: Closed
Project: MariaDB ColumnStore
Component/s: N/A
Affects Version/s: 1.4.0
Fix Version/s: Icebox

Type: Bug Priority: Major
Reporter: Daniel Lee (Inactive) Assignee: Unassigned
Resolution: Won't Do Votes: 0
Labels: None


 Description   

Build tested: 1.4.0-1

[dlee@master centos7]$ cat gitversionInfo.txt
server commit:
67452bc
engine commit:
4d2a159

Autopilot test case: features.funcForText

Queries in the following syntax pattern returned an error:

select cidx, CBIGINT from datatypetestm order by CBIGINT XOR -1, cidx;

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

It also occur to other all other types

 Comments   
Comment by Roman [ 2019-12-09 ]

Since sorting was run by MDB previously the only fast workaround is to fallback to rowstore API and thus disable: select handler, derived handler and group by handler.

set columnstore_select_handler=off;
 
set columnstore_derived_handler=off;
 
set columnstore_group_by_handler=off;

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