[MCOL-1479] INFINIDB_ORDERED hint parse error Created: 2018-06-17  Updated: 2020-10-14  Resolved: 2019-07-10

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

Type: Bug Priority: Major
Reporter: David Thompson (Inactive) Assignee: Andrew Hutchings (Inactive)
Resolution: Won't Fix Votes: 0
Labels: beginner-friendly


 Description   

if you run a query with a large number of joins and want to hint / override the join order, the INFINIDB_ORDERED hint is supposed to be used for this, however it causes a parse error in 1.1 versions:

select /*! INFINIDB_ORDERED */
..
ERROR 1054 (42S22): Unknown column 'INFINIDB_ORDERED' in 'field list'



 Comments   
Comment by Roman [ 2020-10-14 ]

Use columnstore_ordered_only session variable as a replacement.

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