After a MINVALUE/MAXVALUE bound, allow only more of the same.

[postgresql] / src / test / regress / sql / inherit.sql

diff --git a/src/test/regress/sql/inherit.sql b/src/test/regress/sql/inherit.sql
index 01780d497734ccc2f23e12d87acf76bad497deb1..169d0dc0f567e1dfae8920a377688e6c9cd27ebc 100644 (file)
--- a/src/test/regress/sql/inherit.sql
+++ b/src/test/regress/sql/inherit.sql
@@ -664,12 +664,12 @@ drop table range_list_parted;
 -- check that constraint exclusion is able to cope with the partition
 -- constraint emitted for multi-column range partitioned tables
 create table mcrparted (a int, b int, c int) partition by range (a, abs(b), c);
-create table mcrparted0 partition of mcrparted for values from (minvalue, 0, 0) to (1, 1, 1);
+create table mcrparted0 partition of mcrparted for values from (minvalue, minvalue, minvalue) to (1, 1, 1);
 create table mcrparted1 partition of mcrparted for values from (1, 1, 1) to (10, 5, 10);
 create table mcrparted2 partition of mcrparted for values from (10, 5, 10) to (10, 10, 10);
 create table mcrparted3 partition of mcrparted for values from (11, 1, 1) to (20, 10, 10);
 create table mcrparted4 partition of mcrparted for values from (20, 10, 10) to (20, 20, 20);
-create table mcrparted5 partition of mcrparted for values from (20, 20, 20) to (maxvalue, 0, 0);
+create table mcrparted5 partition of mcrparted for values from (20, 20, 20) to (maxvalue, maxvalue, maxvalue);
 explain (costs off) select * from mcrparted where a = 0;       -- scans mcrparted0
 explain (costs off) select * from mcrparted where a = 10 and abs(b) < 5;       -- scans mcrparted1
 explain (costs off) select * from mcrparted where a = 10 and abs(b) = 5;       -- scans mcrparted1, mcrparted2