Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Do
-
5.6.1
-
None
Description
CREATE OR REPLACE TABLE with engine columnstore is returning Error but dropping already existing table
expected: table is not dropped after the reception of Error
note : that problem appears when issue CREATE OR REPLACE TABLE
changing the engine from InnoDB to columnstore , not backwards
MariaDB [a]> CREATE OR REPLACE TABLE example_cum (p INT, o INT, i INT);
|
Query OK, 0 rows affected (0.018 sec)
|
|
|
MariaDB [a]> show create table example_cum;
|
+-------------+--------------------------------------------------------------------------------------------------------------------------------------------------------+
|
| Table | Create Table |
|
+-------------+--------------------------------------------------------------------------------------------------------------------------------------------------------+
|
| example_cum | CREATE TABLE `example_cum` (
|
`p` int(11) DEFAULT NULL,
|
`o` int(11) DEFAULT NULL,
|
`i` int(11) DEFAULT NULL
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
|
+-------------+--------------------------------------------------------------------------------------------------------------------------------------------------------+
|
1 row in set (0.000 sec)
|
|
|
MariaDB [a]> INSERT INTO example_cum VALUES
|
-> (100, 1, 10),(100, 2, 30),(100, 2, 5),(100, 3, 11),(100, 3, 120),
|
-> (200, 1, 10000),(200, 1, 200),(200, 1, 808080),(200, 2, 33333),(200, 3, null), (200, 3, 4),
|
-> (300, 1, null), (300, 1, null);
|
Query OK, 13 rows affected (0.010 sec)
|
Records: 13 Duplicates: 0 Warnings: 0
|
|
|
MariaDB [a]> select count(*) from example_cum ;
|
+----------+
|
| count(*) |
|
+----------+
|
| 13 |
|
+----------+
|
1 row in set (0.001 sec)
|
|
|
|
|
MariaDB [a]> CREATE OR REPLACE TABLE example_cum (p INT, o INT, i INT) engine columnstore ;
|
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 [a]> select count(*) from example_cum ;
|
ERROR 1146 (42S02): Table 'a.example_cum' doesn't exist
|
|