diff options
Diffstat (limited to 'src/test/regress/sql/transactions.sql')
| -rw-r--r-- | src/test/regress/sql/transactions.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/src/test/regress/sql/transactions.sql b/src/test/regress/sql/transactions.sql index 76b22cd99c..c670ae18d0 100644 --- a/src/test/regress/sql/transactions.sql +++ b/src/test/regress/sql/transactions.sql @@ -212,7 +212,7 @@ SELECT 1; -- this should work -- check non-transactional behavior of cursors BEGIN; - DECLARE c CURSOR FOR SELECT unique2 FROM tenk1; + DECLARE c CURSOR FOR SELECT unique2 FROM tenk1 ORDER BY unique2; SAVEPOINT one; FETCH 10 FROM c; ROLLBACK TO SAVEPOINT one; @@ -220,7 +220,7 @@ BEGIN; RELEASE SAVEPOINT one; FETCH 10 FROM c; CLOSE c; - DECLARE c CURSOR FOR SELECT unique2/0 FROM tenk1; + DECLARE c CURSOR FOR SELECT unique2/0 FROM tenk1 ORDER BY unique2; SAVEPOINT two; FETCH 10 FROM c; ROLLBACK TO SAVEPOINT two; |