[MCOL-5048] Improved ANSI SQL support Created: 2022-04-12  Updated: 2023-12-15

Status: Open
Project: MariaDB ColumnStore
Component/s: Columnstore Select Handler
Affects Version/s: None
Fix Version/s: Icebox

Type: New Feature Priority: Major
Reporter: Faisal Saeed (Inactive) Assignee: Max Mether
Resolution: Unresolved Votes: 1
Labels: None

Issue Links:
Relates
relates to MCOL-5049 OR Criteria in JOINS does not work Open

 Description   

The null safe `<=>` operator does not work, here is an example case.

CREATE TABLE t3(id INT) ENGINE=COLUMNSTORE;
CREATE TABLE t4(id INT) ENGINE=COLUMNSTORE;
 
SELECT *
FROM t3
LEFT JOIN
(
  SELECT *
  FROM t4
) t4 ON t3.id <=> t4.id;
 
"Internal Error: MCS-1000: 't3' and 'sub-query' are not joined".

This fails with the error as above. The query is generated by Tableau and other ORMs which the user can't control. It will be great to have this support implemented.


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