diff options
Diffstat (limited to 'src/test/regress/input/constraints.source')
| -rw-r--r-- | src/test/regress/input/constraints.source | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/src/test/regress/input/constraints.source b/src/test/regress/input/constraints.source index ee396f37037..0d278212c02 100644 --- a/src/test/regress/input/constraints.source +++ b/src/test/regress/input/constraints.source @@ -376,26 +376,26 @@ CREATE TABLE circles ( c1 CIRCLE, c2 TEXT, EXCLUDE USING gist - (c1 WITH &&, (c2::circle) WITH ~=) + (c1 WITH &&, (c2::circle) WITH &&) WHERE (circle_center(c1) <> '(0,0)') ); -- these should succeed because they don't match the index predicate INSERT INTO circles VALUES('<(0,0), 5>', '<(0,0), 5>'); -INSERT INTO circles VALUES('<(0,0), 5>', '<(0,0), 5>'); +INSERT INTO circles VALUES('<(0,0), 5>', '<(0,0), 4>'); -- succeed INSERT INTO circles VALUES('<(10,10), 10>', '<(0,0), 5>'); -- fail, overlaps -INSERT INTO circles VALUES('<(20,20), 10>', '<(0,0), 5>'); +INSERT INTO circles VALUES('<(20,20), 10>', '<(0,0), 4>'); -- succeed because c1 doesn't overlap INSERT INTO circles VALUES('<(20,20), 1>', '<(0,0), 5>'); --- succeed because c2 is not the same -INSERT INTO circles VALUES('<(20,20), 10>', '<(1,1), 5>'); +-- succeed because c2 doesn't overlap +INSERT INTO circles VALUES('<(20,20), 10>', '<(10,10), 5>'); -- should fail on existing data without the WHERE clause ALTER TABLE circles ADD EXCLUDE USING gist - (c1 WITH &&, (c2::circle) WITH ~=); + (c1 WITH &&, (c2::circle) WITH &&); DROP TABLE circles; |