Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Won't Do
-
None
-
None
Description
Here are the steps to reproduce the issue:
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) |