MariaDB [test]> create table t1 (a int, b int)engine=columnstore;
|
Query OK, 0 rows affected (0.525 sec)
|
|
MariaDB [test]> insert into t1 values (1, 0), (1, 1), (0, 1), (0, 0);
|
Query OK, 4 rows affected (1.154 sec)
|
Records: 4 Duplicates: 0 Warnings: 0
|
|
MariaDB [test]> select * from t1;
|
+------+------+
|
| a | b |
|
+------+------+
|
| 1 | 0 |
|
| 1 | 1 |
|
| 0 | 1 |
|
| 0 | 0 |
|
+------+------+
|
4 rows in set (0.126 sec)
|
|
MariaDB [test]> select a || b from t1;
|
ERROR 1178 (42000): The storage engine for the table doesn't support MCS-2030: Predicate and Logic operators can not be used where an expression is expected.
|
|
MariaDB [test]> select a xor b from t1;
|
ERROR 1178 (42000): The storage engine for the table doesn't support MCS-2030: Predicate and Logic operators can not be used where an expression is expected.
|