diff options
| author | Jan Wieck | 1999-05-12 15:02:39 +0000 |
|---|---|---|
| committer | Jan Wieck | 1999-05-12 15:02:39 +0000 |
| commit | 79c2576f775b962c67cac136722c5c7cc98201aa (patch) | |
| tree | 3da66174208ed6b258542dde2ba9f00c0e706c07 /src/test | |
| parent | 1a87c14c9cf2c58009dd653c5356f68d605dff2f (diff) | |
Replaced targetlist entry in GroupClause by reference number
in Resdom and GroupClause so changing of resno's doesn't confuse
the grouping any more.
Jan
Diffstat (limited to 'src/test')
| -rw-r--r-- | src/test/regress/expected/opr_sanity.out | 5 | ||||
| -rw-r--r-- | src/test/regress/sql/opr_sanity.sql | 5 |
2 files changed, 6 insertions, 4 deletions
diff --git a/src/test/regress/expected/opr_sanity.out b/src/test/regress/expected/opr_sanity.out index f626651949c..f6b4bc4373c 100644 --- a/src/test/regress/expected/opr_sanity.out +++ b/src/test/regress/expected/opr_sanity.out @@ -1,7 +1,8 @@ QUERY: SELECT p1.oid, p1.proname FROM pg_proc as p1 -WHERE p1.prolang = 0 OR p1.prorettype = 0 OR - p1.pronargs < 0 OR p1.pronargs > 9; +WHERE (p1.prolang = 0 OR p1.prorettype = 0 OR + p1.pronargs < 0 OR p1.pronargs > 9) + AND p1.proname !~ '^pl[^_]+_call_handler$'; oid|proname ---+------- (0 rows) diff --git a/src/test/regress/sql/opr_sanity.sql b/src/test/regress/sql/opr_sanity.sql index f3d84ebe3d0..d6f3b293af9 100644 --- a/src/test/regress/sql/opr_sanity.sql +++ b/src/test/regress/sql/opr_sanity.sql @@ -25,8 +25,9 @@ SELECT p1.oid, p1.proname FROM pg_proc as p1 -WHERE p1.prolang = 0 OR p1.prorettype = 0 OR - p1.pronargs < 0 OR p1.pronargs > 9; +WHERE (p1.prolang = 0 OR p1.prorettype = 0 OR + p1.pronargs < 0 OR p1.pronargs > 9) + AND p1.proname !~ '^pl[^_]+_call_handler$'; -- Look for conflicting proc definitions (same names and input datatypes). |