[MCOL-1592] DML(Delete) Error Created: 2018-07-25  Updated: 2023-10-25  Resolved: 2023-10-25

Status: Closed
Project: MariaDB ColumnStore
Component/s: DMLProc
Affects Version/s: 1.1.4
Fix Version/s: Icebox

Type: Bug Priority: Major
Reporter: ossk_db Assignee: Roman
Resolution: Won't Fix Votes: 0
Labels: None
Environment:

[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~~



 Comments   
Comment by Roman [ 2018-07-29 ]

Greetings and thank you for your report! We will look into it.

Generated at Thu Feb 08 02:29:54 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.