Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
1.5.3
-
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; |