[MCOL-3794] DROP multiple columnstore tables throws error Created: 2020-02-14  Updated: 2023-10-25  Resolved: 2023-10-25

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: Cannot Reproduce Votes: 0
Labels: None


 Description   

Build tested: 1.4.3-1
OS: centos 7
Stack: single server

At present DROP supports only to drop a single columnstore table. When we try drop multiple tables DROP throws error.

CREATE TABLE t1 (c int);
CREATE TABLE t2 (c int);
DROP TABLE t1, t2;
CREATE TABLE t1 (c int) engine=columnstore;
CREATE TABLE t2 (c int) engine=columnstore;
DROP TABLE t1, t2;
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.

DROP should support multiple columnstore tables in a single statement.


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