-- 1. create a columnstore table
|
create table t(a int) engine=ColumnStore;
|
|
-- 2. fill table with insert .. select without using cpimport
|
set statement columnstore_use_import_for_batchinsert=off for
|
insert into t(a)
|
select 1;
|
|
-- 3. t exists, seems to works fine
|
select count(*) from t; /* returns 1 */
|
|
-- 4. when t is renamed, it turns out t was somehow corrupted
|
rename table t to t2;
|
select count(*) from t2; /* returns Error Code: 1815. Internal error: IDB-2006: 'mydb.t2' does not exist in Columnstore */
|
|
-- 5. after systemctl restart mariadb-columnstore, t2 works normally
|
select count(*) from t2; /* returns 1 */
|
|