[MCOL-4156] CREATE OR REPLACE TABLE ... ENGINE =ColumnStore on InnoDB table can fail with: table already exists (your schema is probably out-of-sync) Created: 2020-07-09  Updated: 2020-07-09  Resolved: 2020-07-09

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

Type: Bug Priority: Major
Reporter: Geoff Montee (Inactive) Assignee: Todd Stoffel (Inactive)
Resolution: Not a Bug Votes: 0
Labels: None


 Description   

Using MariaDB Enterprise Server 10.5.4-2 with ColumnStore 1.5.3, I started with the following tables:

MariaDB [innodb_db]> SHOW TABLES
 
    ->    FROM columnstore_db;
 
+--------------------------+
 
| Tables_in_columnstore_db |
 
+--------------------------+
 
| analytics_test           |
 
| htap_test1               |
 
| htap_test2               |
 
+--------------------------+
 
3 rows in set (0.001 sec)

Initially, htap_test1 used the InnoDB storage engine. I tried to convert it to ColumnStore with the following query:

CREATE OR REPLACE TABLE columnstore_db.htap_test1
 
  ENGINE=COLUMNSTORE
 
  SELECT * FROM innodb_db.htap_test1;

This failed with the following error:

ERROR 1815 (HY000): Internal error: CAL0009: Internal create table error for columnstore_db.htap_test1 : table already exists (your schema is probably out-of-sync)

And now the table also disappeared completely:

MariaDB [innodb_db]> SHOW TABLES
 
    ->    FROM columnstore_db;
 
+--------------------------+
 
| Tables_in_columnstore_db |
 
+--------------------------+
 
| analytics_test           |
 
| htap_test2               |
 
+--------------------------+
 
2 rows in set (0.001 sec)

The definition of the table is very basic:

CREATE TABLE htap_test1 (id INT) ENGINE = InnoDB;


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