[MCOL-133] DROP TABLE w/ list of tables fails Created: 2016-06-12  Updated: 2021-01-16  Resolved: 2021-01-16

Status: Closed
Project: MariaDB ColumnStore
Component/s: N/A
Affects Version/s: None
Fix Version/s: 5.5.1

Type: Bug Priority: Minor
Reporter: Justin Swanhart (Inactive) Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: None

Epic Link: ColumnStore Compatibility Improvements

 Description   

mysql> show tables;
------------------

Tables_in_ssb_cs

------------------

customer
dim_date
lineorder
part
supplier
t1
t1_c
t1_m
t2_c
t2_m

------------------
10 rows in set (0.00 sec)

mysql> drop table t1,t1_c,t1_m,t2_c, t2_m;
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.
mysql> show tables;
------------------

Tables_in_ssb_cs

------------------

customer
dim_date
lineorder
part
supplier
t1
t1_c
t2_c

------------------
8 rows in set (0.00 sec)

 Comments   
Comment by Justin Swanhart (Inactive) [ 2016-06-12 ]

mysql> drop table t1,t1_c,t2_c;
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.

mysql> drop table t1;drop table t1_c;drop table t2_c;
Query OK, 0 rows affected (0.38 sec)

Query OK, 0 rows affected (0.36 sec)

Query OK, 0 rows affected (0.44 sec)

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