Details
-
New Feature
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
None
-
None
-
Server version: 10.5.6
MCS version: 1.5.4-1
Description
Like Innodb engine, we should support for SELECT <col> <operator> <value>.
MariaDB [mysql]> CREATE TABLE t1(i INT) ENGINE=Columnstore;
Query OK, 0 rows affected (0.128 sec)
MariaDB [mysql]> INSERT INTO t1 VALUES(1),(2);
Query OK, 2 rows affected (0.324 sec)
Records: 2 Duplicates: 0 Warnings: 0
MariaDB [mysql]> SELECT i = 10 FROM t1;
ERROR 1178 (42000): The storage engine for the table doesn't support IDB-1001: Function '=' isn't supported.
MariaDB [mysql]> SELECT i < 10 FROM t1;
ERROR 1178 (42000): The storage engine for the table doesn't support IDB-1001: Function '<' isn't supported.