oceanbase

1
--disable_query_log
2
set @@session.explicit_defaults_for_timestamp=off;
3
--enable_query_log
4
#owner : dachuan.sdc
5
#owner group : sql2
6
#description : test information_schema.partitions
7

8
--disable_warnings
9
drop table if exists pt1;
10
--enable_warnings
11
create table pt1 (c1 int primary key, c2 int) partition by key(c1) partitions 3;
12
--replace_column 20 "YYYY-MM-DD hh:mm:ss"
13
select * from information_schema.partitions where table_name = 'pt1' order by TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, PARTITION_NAME;
14
select table_schema, table_name from information_schema.partitions where table_name = 'pt1' order by TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, PARTITION_NAME;
15
desc information_schema.partitions;
16
drop table pt1;
17