[MCOL-4212] DML Statement with order by clause is not currently supported Created: 2020-07-27  Updated: 2023-10-26  Resolved: 2023-10-26

Status: Closed
Project: MariaDB ColumnStore
Component/s: DMLProc
Affects Version/s: None
Fix Version/s: Icebox

Type: New Feature Priority: Major
Reporter: susil.behera Assignee: Todd Stoffel (Inactive)
Resolution: Won't Fix Votes: 0
Labels: None
Environment:

Server version: 10.5.4-MariaDB MariaDB Server
Columnstore: 1.5.2-1


 Description   

Like Innodb, Columnstore should also support DML Statement with order by clause.

CREATE TABLE t1 (a INT, b INT) ENGINE=Columnstore;
INSERT INTO t1 VALUES (1,1),(1,2),(1,3);
UPDATE t1 SET b=99 WHERE a=1 ORDER BY b;
ERROR 1815 (HY000): Internal error: DML Statement with order by clause is not currently supported.
DELETE FROM t1 WHERE a=1 ORDER BY b;
ERROR 1815 (HY000): Internal error: DML Statement with order by clause is not currently supported.
Generated at Thu Feb 08 02:48:38 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.