[MCOL-4203] DROP multiple tables throws error Created: 2020-07-21  Updated: 2023-10-26  Resolved: 2023-10-26

Status: Closed
Project: MariaDB ColumnStore
Component/s: DDLProc
Affects Version/s: None
Fix Version/s: Icebox

Type: Bug Priority: Major
Reporter: susil.behera Assignee: Unassigned
Resolution: Won't Fix Votes: 0
Labels: None
Environment:

Server version: 10.5.4-MariaDB MariaDB Server
Columnstore: 1.5.2-1


 Description   

Drop multiple tables fails when one of the tables is a columnstore table.

MariaDB [test]> CREATE TABLE t_innodb (id INT) ENGINE=Innodb;
Query OK, 0 rows affected (0.013 sec)

MariaDB [test]> CREATE TABLE t_mcs1 (id INT) ENGINE=Columnstore;
Query OK, 0 rows affected (0.226 sec)

MariaDB [test]> CREATE TABLE t_mcs2 (id INT) ENGINE=Columnstore;
Query OK, 0 rows affected (0.229 sec)

MariaDB [test]> DROP TABLE t_mcs1, t_mcs2;
ERROR 1178 (42000): The storage engine for the table doesn't support The syntax or the data type(s) is not supported by Columnstore. Please check the Columnstore syntax guide for supported syntax or data types.

MariaDB [test]> DROP TABLE t_mcs1, t_innodb;
ERROR 1178 (42000): The storage engine for the table doesn't support The syntax or the data type(s) is not supported by Columnstore. Please check the Columnstore syntax guide for supported syntax or data types.

 Comments   
Comment by susil.behera [ 2020-07-28 ]

On the latest (pls see below) build the problem is not seen and seems to be fixed.
Server version: 10.5.5-MariaDB
Columnstore: 1.5.3-1

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