Changeset: e5135a5c5889 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=e5135a5c5889
Modified Files:
Branch: default
Log Message:
Merge with Oct2010 branch.
diffs (62 lines):
diff -r c2513f93a1e0 -r e5135a5c5889
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 22:41:55 2010 +0200
+++
b/sql/src/test/BugTracker-2010/Tests/multiple-updates-in-transaction.Bug-2543.sql
Tue Oct 26 23:30:35 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 c2513f93a1e0 -r e5135a5c5889
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 22:41:55 2010 +0200
+++
b/sql/src/test/BugTracker-2010/Tests/multiple-updates-in-transaction.Bug-2543.stable.out
Tue Oct 26 23:30:35 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
Checkin-list@monetdb.org
http://mail.monetdb.org/mailman/listinfo/checkin-list
