You've already forked mariadb-columnstore-engine
mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-07-04 04:42:30 +03:00
14 lines
327 B
Plaintext
14 lines
327 B
Plaintext
USE tpch1;
|
|
drop table if exists t1;
|
|
create table t1(f1 varchar(5)) engine=columnstore;
|
|
insert into t1(f1) select if(max(f1) is null, '2000',max(f1)+1) from t1;
|
|
select * from t1 order by 1;
|
|
f1
|
|
2000
|
|
insert into t1(f1) select if(max(f1) is null, '2000',max(f1)+1) from t1;
|
|
select * from t1 order by 1;
|
|
f1
|
|
2000
|
|
2001
|
|
drop table t1;
|