diff options
Diffstat (limited to 'src/test/regress/sql/polymorphism.sql')
| -rw-r--r-- | src/test/regress/sql/polymorphism.sql | 46 |
1 files changed, 23 insertions, 23 deletions
diff --git a/src/test/regress/sql/polymorphism.sql b/src/test/regress/sql/polymorphism.sql index bbac7d11a55..c01871de007 100644 --- a/src/test/regress/sql/polymorphism.sql +++ b/src/test/regress/sql/polymorphism.sql @@ -350,29 +350,29 @@ insert into t values(3,array[3],'a'); insert into t values(3,array[3],'b'); -- test the successfully created polymorphic aggregates -select f3, myaggp01a(*) from t group by f3; -select f3, myaggp03a(*) from t group by f3; -select f3, myaggp03b(*) from t group by f3; -select f3, myaggp05a(f1) from t group by f3; -select f3, myaggp06a(f1) from t group by f3; -select f3, myaggp08a(f1) from t group by f3; -select f3, myaggp09a(f1) from t group by f3; -select f3, myaggp09b(f1) from t group by f3; -select f3, myaggp10a(f1) from t group by f3; -select f3, myaggp10b(f1) from t group by f3; -select f3, myaggp20a(f1) from t group by f3; -select f3, myaggp20b(f1) from t group by f3; -select f3, myaggn01a(*) from t group by f3; -select f3, myaggn01b(*) from t group by f3; -select f3, myaggn03a(*) from t group by f3; -select f3, myaggn05a(f1) from t group by f3; -select f3, myaggn05b(f1) from t group by f3; -select f3, myaggn06a(f1) from t group by f3; -select f3, myaggn06b(f1) from t group by f3; -select f3, myaggn08a(f1) from t group by f3; -select f3, myaggn08b(f1) from t group by f3; -select f3, myaggn09a(f1) from t group by f3; -select f3, myaggn10a(f1) from t group by f3; +select f3, myaggp01a(*) from t group by f3 order by f3; +select f3, myaggp03a(*) from t group by f3 order by f3; +select f3, myaggp03b(*) from t group by f3 order by f3; +select f3, myaggp05a(f1) from t group by f3 order by f3; +select f3, myaggp06a(f1) from t group by f3 order by f3; +select f3, myaggp08a(f1) from t group by f3 order by f3; +select f3, myaggp09a(f1) from t group by f3 order by f3; +select f3, myaggp09b(f1) from t group by f3 order by f3; +select f3, myaggp10a(f1) from t group by f3 order by f3; +select f3, myaggp10b(f1) from t group by f3 order by f3; +select f3, myaggp20a(f1) from t group by f3 order by f3; +select f3, myaggp20b(f1) from t group by f3 order by f3; +select f3, myaggn01a(*) from t group by f3 order by f3; +select f3, myaggn01b(*) from t group by f3 order by f3; +select f3, myaggn03a(*) from t group by f3 order by f3; +select f3, myaggn05a(f1) from t group by f3 order by f3; +select f3, myaggn05b(f1) from t group by f3 order by f3; +select f3, myaggn06a(f1) from t group by f3 order by f3; +select f3, myaggn06b(f1) from t group by f3 order by f3; +select f3, myaggn08a(f1) from t group by f3 order by f3; +select f3, myaggn08b(f1) from t group by f3 order by f3; +select f3, myaggn09a(f1) from t group by f3 order by f3; +select f3, myaggn10a(f1) from t group by f3 order by f3; select mysum2(f1, f1 + 1) from t; -- test inlining of polymorphic SQL functions |