mirror of
https://github.com/HypoPG/hypopg
synced 2026-05-23 17:18:44 +00:00
17 lines
759 B
MySQL
17 lines
759 B
MySQL
|
-- Test for pg versions that don't support declarative partitioning
|
||
|
|
-- ================================================================
|
||
|
|
|
||
|
|
-- 0. Dropping any hypothetical object
|
||
|
|
SELECT * FROM hypopg_reset();
|
||
|
|
-- 1. partition test
|
||
|
|
CREATE TABLE hypo_part_range (id integer, val text);
|
||
|
|
SELECT * FROM hypopg_partition_table('hypo_part_range', 'PARTITION BY RANGE (id)');
|
||
|
|
SELECT tablename FROM hypopg_add_partition('hypo_part_range_1_10000', 'PARTITION OF hypo_part_range FOR VALUES FROM (1) TO (10000)');
|
||
|
|
-- 2. other functions
|
||
|
|
SELECT * FROM hypopg_reset_table();
|
||
|
|
SELECT * FROM hypopg_drop_table('hypo_part_range'::regclass);
|
||
|
|
SELECT * FROM hypopg_table();
|
||
|
|
SELECT * FROM hypopg_analyze('hypo_part_range');
|
||
|
|
SELECT * FROM hypopg_statistic();
|
||
|
|
SELECT * FROM hypopg_stats;
|