diff options
| author | Marc G. Fournier | 1997-05-22 00:17:24 +0000 |
|---|---|---|
| committer | Marc G. Fournier | 1997-05-22 00:17:24 +0000 |
| commit | 5e7c0a0b9ac226add5029afe0af67409438294bc (patch) | |
| tree | 3377f3307a5aef00fc2c246070dd984256f6b117 /src/test | |
| parent | 021ccf0b8cde8ba2e522f0b3e0ba9c030a136cd6 (diff) | |
From: Darren King <aixssd!darrenk@abs.net>
Subject: [PATCHES] DROP AGGREGATE patch/fix.
Here's a patch that fixes the DROP AGGREGATE command to delete
the desired aggregate for a specific type.
Diffstat (limited to 'src/test')
| -rw-r--r-- | src/test/regress/sql/destroy.sql | 8 | ||||
| -rw-r--r-- | src/test/regress/sql/errors.sql | 11 |
2 files changed, 14 insertions, 5 deletions
diff --git a/src/test/regress/sql/destroy.sql b/src/test/regress/sql/destroy.sql index 345af37c36f..4d183f3de87 100644 --- a/src/test/regress/sql/destroy.sql +++ b/src/test/regress/sql/destroy.sql @@ -1,7 +1,7 @@ -- -- destroy.source -- --- $Header: /cvsroot/pgsql/src/test/regress/sql/Attic/destroy.sql,v 1.2 1997/04/27 04:35:31 scrappy Exp $ +-- $Header: /cvsroot/pgsql/src/test/regress/sql/Attic/destroy.sql,v 1.3 1997/05/22 00:17:15 scrappy Exp $ -- -- @@ -74,11 +74,11 @@ DROP TYPE widget; -- -- AGGREGATE REMOVAL -- -DROP AGGREGATE newavg; +DROP AGGREGATE newavg int4; -DROP AGGREGATE newsum; +DROP AGGREGATE newsum int4; -DROP AGGREGATE newcnt; +DROP AGGREGATE newcnt int4; -- diff --git a/src/test/regress/sql/errors.sql b/src/test/regress/sql/errors.sql index e3a080e02a4..225029e306c 100644 --- a/src/test/regress/sql/errors.sql +++ b/src/test/regress/sql/errors.sql @@ -1,7 +1,7 @@ -- -- errors.source -- --- $Header: /cvsroot/pgsql/src/test/regress/sql/errors.sql,v 1.1 1997/04/27 03:56:21 scrappy Exp $ +-- $Header: /cvsroot/pgsql/src/test/regress/sql/errors.sql,v 1.2 1997/05/22 00:17:24 scrappy Exp $ -- bad in postquel, but ok in postsql @@ -182,6 +182,15 @@ drop aggregate 314159; -- no such aggregate drop aggregate nonesuch; +-- missing aggregate type +drop aggregate newcnt1; + +-- bad aggregate type +drop aggregate newcnt nonesuch; + +-- no such aggregate for type +drop aggregate newcnt float4; + -- -- REMOVE FUNCTION |