MariaDB [test]> create table t2 (a int, b int)engine=columnstore;
|
Query OK, 0 rows affected (0.372 sec)
|
|
MariaDB [test]> insert into t2 values (1,1), (1,2), (2,1);
|
Query OK, 3 rows affected (0.439 sec)
|
Records: 3 Duplicates: 0 Warnings: 0
|
|
MariaDB [test]> select a, (case when a in (1,2) then b in (1,2) else b in (1,3) end) from t2;
|
+------+------------------------------------------------------------+
|
| a | (case when a in (1,2) then b in (1,2) else b in (1,3) end) |
|
+------+------------------------------------------------------------+
|
| 1 | 0 |
|
| 1 | 0 |
|
| 2 | 0 |
|
+------+------------------------------------------------------------+
|
3 rows in set (0.067 sec)
|