Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Not a Bug
-
1.1.6
-
None
-
2PM system on Docker Ubuntu 18.04.1 LTS
Description
This works as expected:
create table t2 (c1 int) engine=columnstore;
|
Query OK, 0 rows affected (0.21 sec)
|
|
|
MariaDB [test]> select count(*) from t2;
|
+----------+
|
| count(*) |
|
+----------+
|
| 0 |
|
+----------+
|
1 row in set (0.05 sec)
|
|
|
select * from calpontsys.systable where tablename='t2';
|
+-----------+--------+----------+------------+------------+------+------+-----------+-----------+-------------+---------------+
|
| tablename | schema | objectid | createdate | lastupdate | init | next | numofrows | avgrowlen | numofblocks | autoincrement |
|
+-----------+--------+----------+------------+------------+------+------+-----------+-----------+-------------+---------------+
|
| t2 | test | 3292 | 2018-09-20 | NULL | NULL | NULL | NULL | NULL | NULL | 0 |
|
+-----------+--------+----------+------------+------------+------+------+-----------+-----------+-------------+---------------+
|
1 row in set (0.01 sec)
|
|
This does not work as expected:
create table t3 (c1 int) engine=columnstore COMMENT='schema sync only';
|
Query OK, 0 rows affected (0.01 sec)
|
|
|
MariaDB [test]> select count(*) from t3;
|
ERROR 1815 (HY000): Internal error: IDB-2006: 'test.t3' does not exist in Columnstore.
|
|
|
select * from calpontsys.systable where tablename='t3';
|
Empty set (0.02 sec)
|
|
|
show create table t3\G
|
*************************** 1. row ***************************
|
Table: t3
|
Create Table: CREATE TABLE `t3` (
|
`c1` int(11) DEFAULT NULL
|
) ENGINE=Columnstore DEFAULT CHARSET=latin1 COMMENT='schema sync only'
|
1 row in set (0.00 sec)
|