Changeset: 442ba34bac81 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=442ba34bac81
Modified Files:
sql/src/test/BugTracker-2010/Tests/multiple-updates-in-transaction.Bug-2543.sql
sql/src/test/BugTracker-2010/Tests/multiple-updates-in-transaction.Bug-2543.stable.out
Branch: Oct2010
Log Message:
Add some order.
diffs (62 lines):
diff -r 7c67771f47bf -r 442ba34bac81
sql/src/test/BugTracker-2010/Tests/multiple-updates-in-transaction.Bug-2543.sql
---
a/sql/src/test/BugTracker-2010/Tests/multiple-updates-in-transaction.Bug-2543.sql
Tue Oct 26 17:15:39 2010 +0200
+++
b/sql/src/test/BugTracker-2010/Tests/multiple-updates-in-transaction.Bug-2543.sql
Tue Oct 26 23:30:02 2010 +0200
@@ -2,12 +2,12 @@
INSERT INTO people (id,name) SELECT 0,'Phil Ivey';
INSERT INTO people (id,name) SELECT 1,'Michael Jordan';
INSERT INTO people (id,name) SELECT 2,'Lionel Messi';
-SELECT * FROM people;
+SELECT * FROM people ORDER BY id;
START TRANSACTION;
UPDATE people SET id = -1 WHERE name='Phil Ivey';
-SELECT * FROM people;
+SELECT * FROM people ORDER BY id;
UPDATE people SET id = -2 WHERE name='Phil Ivey';
-SELECT * FROM people;
+SELECT * FROM people ORDER BY id;
COMMIT;
-SELECT * FROM people;
+SELECT * FROM people ORDER BY id;
DROP TABLE people;
diff -r 7c67771f47bf -r 442ba34bac81
sql/src/test/BugTracker-2010/Tests/multiple-updates-in-transaction.Bug-2543.stable.out
---
a/sql/src/test/BugTracker-2010/Tests/multiple-updates-in-transaction.Bug-2543.stable.out
Tue Oct 26 17:15:39 2010 +0200
+++
b/sql/src/test/BugTracker-2010/Tests/multiple-updates-in-transaction.Bug-2543.stable.out
Tue Oct 26 23:30:02 2010 +0200
@@ -26,7 +26,7 @@
[ 1 ]
[ 1 ]
[ 1 ]
-#SELECT * FROM people;
+#SELECT * FROM people ORDER BY id;
% sys.people, sys.people # table_name
% id, name # name
% tinyint, varchar # type
@@ -35,24 +35,24 @@
[ 1, "Michael Jordan" ]
[ 2, "Lionel Messi" ]
[ 1 ]
-#SELECT * FROM people;
+#SELECT * FROM people ORDER BY id;
% sys.people, sys.people # table_name
% id, name # name
% tinyint, varchar # type
% 2, 14 # length
+[ -1, "Phil Ivey" ]
[ 1, "Michael Jordan" ]
[ 2, "Lionel Messi" ]
-[ -1, "Phil Ivey" ]
[ 1 ]
-#SELECT * FROM people;
+#SELECT * FROM people ORDER BY id;
% sys.people, sys.people # table_name
% id, name # name
% tinyint, varchar # type
% 2, 14 # length
+[ -2, "Phil Ivey" ]
[ 1, "Michael Jordan" ]
[ 2, "Lionel Messi" ]
-[ -2, "Phil Ivey" ]
-#SELECT * FROM people;
+#SELECT * FROM people ORDER BY id;
% sys.people, sys.people # table_name
% id, name # name
% tinyint, varchar # type
_______________________________________________
Checkin-list mailing list
[email protected]
http://mail.monetdb.org/mailman/listinfo/checkin-list
