A few fixes for regression test cases and a variable name change

3 files changed, 6 insertions, 6 deletions

diff --git a/src/test/regress/expected/transactions_1.out b/src/test/regress/expected/transactions_1.out
index 3cf5273814..cfbd1f13f1 100644
--- a/src/test/regress/expected/transactions_1.out
+++ b/src/test/regress/expected/transactions_1.out
@@ -564,7 +564,7 @@ insert into abc values (5);
 ERROR:  current transaction is aborted, commands ignored until end of transaction block
 insert into abc values (10);
 ERROR:  current transaction is aborted, commands ignored until end of transaction block
-declare foo cursor for select * from abc;
+declare foo cursor for select * from abc order by a;
 ERROR:  current transaction is aborted, commands ignored until end of transaction block
 fetch from foo;
 ERROR:  current transaction is aborted, commands ignored until end of transaction block
@@ -579,7 +579,7 @@ create table abc (a int);
 insert into abc values (5);
 insert into abc values (10);
 insert into abc values (15);
-declare foo cursor for select * from abc;
+declare foo cursor for select * from abc order by a;
 fetch from foo;
  a 
 ---
diff --git a/src/test/regress/expected/create_misc_1.out b/src/test/regress/output/create_misc_1.source
index 3706e5aff2..3e827fb2a4 100644
--- a/src/test/regress/expected/create_misc_1.out
+++ b/src/test/regress/output/create_misc_1.source
@@ -5,7 +5,7 @@
 --	(any resemblance to real life is purely coincidental)
 --
 INSERT INTO tenk2 SELECT * FROM tenk1;
-COPY tenk2 FROM '/home/michael/bin/regress/data/tenk.data';
+COPY tenk2 FROM '@abs_srcdir@/data/tenk.data';
 SELECT * INTO TABLE onek2 FROM onek;
 ERROR:  INTO clause not yet supported
 CREATE TABLE onek2 (
@@ -26,7 +26,7 @@ CREATE TABLE onek2 (
 	stringu2	name,
 	string4		name
 );
-COPY onek2 FROM '/home/michael/bin/regress/data/onek.data';
+COPY onek2 FROM '@abs_srcdir@/data/onek.data';
 INSERT INTO fast_emp4000 SELECT * FROM slow_emp4000;
 SELECT *
    INTO TABLE Bprime
diff --git a/src/test/regress/sql/transactions.sql b/src/test/regress/sql/transactions.sql
index 2788308e9c..dc33e7b694 100644
--- a/src/test/regress/sql/transactions.sql
+++ b/src/test/regress/sql/transactions.sql
@@ -342,7 +342,7 @@ savepoint x;
 create table abc (a int);
 insert into abc values (5);
 insert into abc values (10);
-declare foo cursor for select * from abc;
+declare foo cursor for select * from abc order by a;
 fetch from foo;
 rollback to x;
 
@@ -356,7 +356,7 @@ create table abc (a int);
 insert into abc values (5);
 insert into abc values (10);
 insert into abc values (15);
-declare foo cursor for select * from abc;
+declare foo cursor for select * from abc order by a;
 
 fetch from foo;