Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Fix
-
1.1.4
-
None
-
[root@server87 ~]# cat /etc/redhat-release
CentOS release 6.9 (Final)
Description
Hi, Team!!
There is a problem in the condition processing of Where and under when deleting the data in the column store table.
MariaDB [edw]> create table t_main (id int, nm varchar(10)) engine=columnstore;
Query OK, 0 rows affected (2.39 sec)
MariaDB [edw]>
MariaDB [edw]> create table t_sub (id int, nm varchar(10)) engine=columnstore;
Query OK, 0 rows affected (1.50 sec)
MariaDB [edw]> insert into t_main values(1,'AAA');
Query OK, 1 row affected (0.49 sec)
MariaDB [edw]> insert into t_main values(2, 'BBB');
Query OK, 1 row affected (0.24 sec)
MariaDB [edw]> insert into t_sub values(1,'CCC');
Query OK, 1 row affected (0.36 sec)
MariaDB [edw]> delete from t_main
-> where id in (select id from t_sub)
-> and 1=0;
Query OK, 0 rows affected (0.01 sec)
MariaDB [edw]> select * from t_main;
----------+
id | nm |
----------+
1 | AAA |
2 | BBB |
----------+
2 rows in set (0.16 sec)
MariaDB [edw]> delete from t_main
-> where id in (select id from t_sub)
-> and 0=0;
Query OK, 2 rows affected (0.34 sec)
MariaDB [edw]> select * from t_main;
Empty set (0.03 sec)
MariaDB [edw]>OMG~~