-- source include/have_partition.inc
|
|
create or replace table t1 (x int) with system versioning
|
partition by system_time limit 1 partitions 4;
|
insert into t1 values (1);
|
|
update t1 set x= x + 1;
|
update t1 set x= x + 2;
|
update t1 set x= x + 3;
|
|
select partition_name, table_rows from information_schema.partitions
|
where table_name = 't1';
|
|
create or replace table t1 (x int) with system versioning
|
partition by system_time limit 1 partitions 4;
|
insert into t1 values (1);
|
|
--connect con3, localhost, root
|
--connect con2, localhost, root
|
--connect con1, localhost, root
|
|
--connection con1
|
send update t1 set x= x + 10;
|
--connection con2
|
send update t1 set x= x + 20;
|
--connection con3
|
send update t1 set x= x + 30;
|
--connection con1
|
reap;
|
--connection con2
|
reap;
|
--connection con3
|
reap;
|
|
--disconnect con1
|
--disconnect con2
|
--disconnect con3
|
|
--connection default
|
select partition_name, table_rows from information_schema.partitions
|
where table_name = 't1';
|
|
drop tables t1;
|