Details
-
Type:
New Feature
-
Status: Open (View Workflow)
-
Priority:
Major
-
Resolution: Unresolved
-
Affects Version/s: None
-
Fix Version/s: Icebox
-
Component/s: DMLProc
-
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.