Changeset: f6bfa6df48ad for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=f6bfa6df48ad
Modified Files:
sql/test/BugTracker-2011/Tests/exists-select.Bug-2933.sql
sql/test/BugTracker-2011/Tests/exists-select.Bug-2933.stable.out
Branch: Dec2011
Log Message:
added test for Bug 2959
diffs (61 lines):
diff --git a/sql/test/BugTracker-2011/Tests/exists-select.Bug-2933.sql
b/sql/test/BugTracker-2011/Tests/exists-select.Bug-2933.sql
--- a/sql/test/BugTracker-2011/Tests/exists-select.Bug-2933.sql
+++ b/sql/test/BugTracker-2011/Tests/exists-select.Bug-2933.sql
@@ -27,3 +27,7 @@ WHERE
ancestor.pre < _rank2.pre AND _rank2.pre < ancestor.post);
DROP TABLE _rank2933;
+
+
+SELECT 123 AS dummy1 FROM tables n WHERE EXISTS ( SELECT 456 AS dummy2 FROM
+ (SELECT * FROM columns) nnn WHERE n.id > 0 );
diff --git a/sql/test/BugTracker-2011/Tests/exists-select.Bug-2933.stable.out
b/sql/test/BugTracker-2011/Tests/exists-select.Bug-2933.stable.out
--- a/sql/test/BugTracker-2011/Tests/exists-select.Bug-2933.stable.out
+++ b/sql/test/BugTracker-2011/Tests/exists-select.Bug-2933.stable.out
@@ -83,6 +83,46 @@ Ready.
% 1 # length
[ 2 ]
#DROP TABLE _rank2933;
+#SELECT 123 AS dummy1 FROM tables n WHERE EXISTS ( SELECT 456 AS dummy2 FROM
+# (SELECT * FROM columns) nnn WHERE n.id > 0 );
+% . # table_name
+% dummy1 # name
+% tinyint # type
+% 3 # length
+[ 123 ]
+[ 123 ]
+[ 123 ]
+[ 123 ]
+[ 123 ]
+[ 123 ]
+[ 123 ]
+[ 123 ]
+[ 123 ]
+[ 123 ]
+[ 123 ]
+[ 123 ]
+[ 123 ]
+[ 123 ]
+[ 123 ]
+[ 123 ]
+[ 123 ]
+[ 123 ]
+[ 123 ]
+[ 123 ]
+[ 123 ]
+[ 123 ]
+[ 123 ]
+[ 123 ]
+[ 123 ]
+[ 123 ]
+[ 123 ]
+[ 123 ]
+[ 123 ]
+[ 123 ]
+[ 123 ]
+[ 123 ]
+[ 123 ]
+[ 123 ]
# 17:14:07 >
# 17:14:07 > "Done."
_______________________________________________
Checkin-list mailing list
[email protected]
http://mail.monetdb.org/mailman/listinfo/checkin-list
