Update of /cvsroot/monetdb/sql/src/test/Tests
In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv15984/src/test/Tests
Modified Files:
coalesce.stable.err.Five rank.stable.out.Five
Log Message:
added support for sql/xml namespaces
fixed bug in algebra version for handling exist/not exists in exists/not exists
with correlation
added optimizer steps for algebra version to rewrite semi/anti joins followed
by joins on the same (referenced) relation into a single semijoin
push selects through semi/anti joins
approved tests
U rank.stable.out.Five
Index: rank.stable.out.Five
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Tests/rank.stable.out.Five,v
retrieving revision 1.7
retrieving revision 1.8
diff -u -d -r1.7 -r1.8
--- rank.stable.out.Five 7 Sep 2008 20:31:39 -0000 1.7
+++ rank.stable.out.Five 28 Oct 2008 20:05:04 -0000 1.8
@@ -65,116 +65,116 @@
% foo, schema_id # name
% int, int # type
% 2, 4 # length
-[ 1, 1059 ]
-[ 2, 1059 ]
-[ 3, 1059 ]
-[ 4, 1059 ]
-[ 5, 1059 ]
-[ 6, 1059 ]
-[ 7, 1059 ]
-[ 8, 1059 ]
-[ 9, 1059 ]
-[ 10, 1059 ]
-[ 11, 1059 ]
-[ 12, 1059 ]
-[ 13, 1059 ]
-[ 1, 1160 ]
-[ 2, 1160 ]
-[ 3, 1160 ]
-[ 4, 1160 ]
-[ 5, 1160 ]
-[ 6, 1160 ]
-[ 14, 1059 ]
-[ 15, 1059 ]
-[ 16, 1059 ]
-[ 17, 1059 ]
-[ 18, 1059 ]
-[ 19, 1059 ]
-[ 20, 1059 ]
-[ 7, 1160 ]
-[ 21, 1059 ]
-[ 22, 1059 ]
-[ 23, 1059 ]
-[ 24, 1059 ]
-[ 25, 1059 ]
-[ 26, 1059 ]
-[ 27, 1059 ]
+[ 1, 1061 ]
+[ 2, 1061 ]
+[ 3, 1061 ]
+[ 4, 1061 ]
+[ 5, 1061 ]
+[ 6, 1061 ]
+[ 7, 1061 ]
+[ 8, 1061 ]
+[ 9, 1061 ]
+[ 10, 1061 ]
+[ 11, 1061 ]
+[ 12, 1061 ]
+[ 13, 1061 ]
+[ 1, 1162 ]
+[ 2, 1162 ]
+[ 3, 1162 ]
+[ 4, 1162 ]
+[ 5, 1162 ]
+[ 6, 1162 ]
+[ 14, 1061 ]
+[ 15, 1061 ]
+[ 16, 1061 ]
+[ 17, 1061 ]
+[ 18, 1061 ]
+[ 19, 1061 ]
+[ 20, 1061 ]
+[ 7, 1162 ]
+[ 21, 1061 ]
+[ 22, 1061 ]
+[ 23, 1061 ]
+[ 24, 1061 ]
+[ 25, 1061 ]
+[ 26, 1061 ]
+[ 27, 1061 ]
% ., sys.tables # table_name
% foo, schema_id # name
% int, int # type
% 2, 4 # length
-[ 1, 1059 ]
-[ 2, 1059 ]
-[ 3, 1059 ]
-[ 4, 1059 ]
-[ 5, 1059 ]
-[ 6, 1059 ]
-[ 7, 1059 ]
-[ 8, 1059 ]
-[ 9, 1059 ]
-[ 10, 1059 ]
-[ 11, 1059 ]
-[ 12, 1059 ]
-[ 13, 1059 ]
-[ 1, 1160 ]
-[ 2, 1160 ]
-[ 3, 1160 ]
-[ 4, 1160 ]
-[ 5, 1160 ]
-[ 6, 1160 ]
-[ 14, 1059 ]
-[ 15, 1059 ]
-[ 16, 1059 ]
-[ 17, 1059 ]
-[ 18, 1059 ]
-[ 19, 1059 ]
-[ 20, 1059 ]
-[ 7, 1160 ]
-[ 21, 1059 ]
-[ 22, 1059 ]
-[ 23, 1059 ]
-[ 24, 1059 ]
-[ 25, 1059 ]
-[ 26, 1059 ]
-[ 27, 1059 ]
+[ 1, 1061 ]
+[ 2, 1061 ]
+[ 3, 1061 ]
+[ 4, 1061 ]
+[ 5, 1061 ]
+[ 6, 1061 ]
+[ 7, 1061 ]
+[ 8, 1061 ]
+[ 9, 1061 ]
+[ 10, 1061 ]
+[ 11, 1061 ]
+[ 12, 1061 ]
+[ 13, 1061 ]
+[ 1, 1162 ]
+[ 2, 1162 ]
+[ 3, 1162 ]
+[ 4, 1162 ]
+[ 5, 1162 ]
+[ 6, 1162 ]
+[ 14, 1061 ]
+[ 15, 1061 ]
+[ 16, 1061 ]
+[ 17, 1061 ]
+[ 18, 1061 ]
+[ 19, 1061 ]
+[ 20, 1061 ]
+[ 7, 1162 ]
+[ 21, 1061 ]
+[ 22, 1061 ]
+[ 23, 1061 ]
+[ 24, 1061 ]
+[ 25, 1061 ]
+[ 26, 1061 ]
+[ 27, 1061 ]
% ., sys.tables # table_name
% foo, schema_id # name
% int, int # type
% 2, 4 # length
-[ 1, 1059 ]
-[ 2, 1059 ]
-[ 3, 1059 ]
-[ 4, 1059 ]
-[ 5, 1059 ]
-[ 6, 1059 ]
-[ 7, 1059 ]
-[ 8, 1059 ]
-[ 9, 1059 ]
-[ 10, 1059 ]
-[ 11, 1059 ]
-[ 12, 1059 ]
-[ 13, 1059 ]
-[ 14, 1059 ]
-[ 15, 1059 ]
-[ 16, 1059 ]
-[ 17, 1059 ]
-[ 18, 1059 ]
-[ 19, 1059 ]
-[ 20, 1059 ]
-[ 21, 1059 ]
-[ 22, 1059 ]
-[ 23, 1059 ]
-[ 24, 1059 ]
-[ 25, 1059 ]
-[ 26, 1059 ]
-[ 27, 1059 ]
-[ 28, 1160 ]
-[ 29, 1160 ]
-[ 30, 1160 ]
-[ 31, 1160 ]
-[ 32, 1160 ]
-[ 33, 1160 ]
-[ 34, 1160 ]
+[ 1, 1061 ]
+[ 2, 1061 ]
+[ 3, 1061 ]
+[ 4, 1061 ]
+[ 5, 1061 ]
+[ 6, 1061 ]
+[ 7, 1061 ]
+[ 8, 1061 ]
+[ 9, 1061 ]
+[ 10, 1061 ]
+[ 11, 1061 ]
+[ 12, 1061 ]
+[ 13, 1061 ]
+[ 14, 1061 ]
+[ 15, 1061 ]
+[ 16, 1061 ]
+[ 17, 1061 ]
+[ 18, 1061 ]
+[ 19, 1061 ]
+[ 20, 1061 ]
+[ 21, 1061 ]
+[ 22, 1061 ]
+[ 23, 1061 ]
+[ 24, 1061 ]
+[ 25, 1061 ]
+[ 26, 1061 ]
+[ 27, 1061 ]
+[ 28, 1162 ]
+[ 29, 1162 ]
+[ 30, 1162 ]
+[ 31, 1162 ]
+[ 32, 1162 ]
+[ 33, 1162 ]
+[ 34, 1162 ]
% sys. # table_name
% foo # name
% int # type
@@ -217,116 +217,116 @@
% foo, schema_id # name
% int, int # type
% 1, 4 # length
-[ 1, 1059 ]
-[ 1, 1059 ]
-[ 1, 1059 ]
-[ 1, 1059 ]
-[ 1, 1059 ]
-[ 1, 1059 ]
-[ 1, 1059 ]
-[ 1, 1059 ]
-[ 1, 1059 ]
-[ 1, 1059 ]
-[ 1, 1059 ]
-[ 1, 1059 ]
-[ 1, 1059 ]
-[ 1, 1059 ]
-[ 1, 1059 ]
-[ 1, 1059 ]
-[ 1, 1059 ]
-[ 1, 1059 ]
-[ 1, 1059 ]
-[ 1, 1059 ]
-[ 1, 1059 ]
-[ 1, 1059 ]
-[ 1, 1059 ]
-[ 1, 1059 ]
-[ 1, 1059 ]
-[ 1, 1059 ]
-[ 1, 1059 ]
-[ 1, 1160 ]
-[ 1, 1160 ]
-[ 1, 1160 ]
-[ 1, 1160 ]
-[ 1, 1160 ]
-[ 1, 1160 ]
-[ 1, 1160 ]
+[ 1, 1061 ]
+[ 1, 1061 ]
+[ 1, 1061 ]
+[ 1, 1061 ]
+[ 1, 1061 ]
+[ 1, 1061 ]
+[ 1, 1061 ]
+[ 1, 1061 ]
+[ 1, 1061 ]
+[ 1, 1061 ]
+[ 1, 1061 ]
+[ 1, 1061 ]
+[ 1, 1061 ]
+[ 1, 1061 ]
+[ 1, 1061 ]
+[ 1, 1061 ]
+[ 1, 1061 ]
+[ 1, 1061 ]
+[ 1, 1061 ]
+[ 1, 1061 ]
+[ 1, 1061 ]
+[ 1, 1061 ]
+[ 1, 1061 ]
+[ 1, 1061 ]
+[ 1, 1061 ]
+[ 1, 1061 ]
+[ 1, 1061 ]
+[ 1, 1162 ]
+[ 1, 1162 ]
+[ 1, 1162 ]
+[ 1, 1162 ]
+[ 1, 1162 ]
+[ 1, 1162 ]
+[ 1, 1162 ]
% ., sys.tables # table_name
% foo, schema_id # name
% int, int # type
% 1, 4 # length
-[ 1, 1059 ]
-[ 1, 1059 ]
-[ 1, 1059 ]
-[ 1, 1059 ]
-[ 1, 1059 ]
-[ 1, 1059 ]
-[ 1, 1059 ]
-[ 1, 1059 ]
-[ 1, 1059 ]
-[ 1, 1059 ]
-[ 1, 1059 ]
-[ 1, 1059 ]
-[ 1, 1059 ]
-[ 1, 1059 ]
-[ 1, 1059 ]
-[ 1, 1059 ]
-[ 1, 1059 ]
-[ 1, 1059 ]
-[ 1, 1059 ]
-[ 1, 1059 ]
-[ 1, 1059 ]
-[ 1, 1059 ]
-[ 1, 1059 ]
-[ 1, 1059 ]
-[ 1, 1059 ]
-[ 1, 1059 ]
-[ 1, 1059 ]
-[ 1, 1160 ]
-[ 1, 1160 ]
-[ 1, 1160 ]
-[ 1, 1160 ]
-[ 1, 1160 ]
-[ 1, 1160 ]
-[ 1, 1160 ]
+[ 1, 1061 ]
+[ 1, 1061 ]
+[ 1, 1061 ]
+[ 1, 1061 ]
+[ 1, 1061 ]
+[ 1, 1061 ]
+[ 1, 1061 ]
+[ 1, 1061 ]
+[ 1, 1061 ]
+[ 1, 1061 ]
+[ 1, 1061 ]
+[ 1, 1061 ]
+[ 1, 1061 ]
+[ 1, 1061 ]
+[ 1, 1061 ]
+[ 1, 1061 ]
+[ 1, 1061 ]
+[ 1, 1061 ]
+[ 1, 1061 ]
+[ 1, 1061 ]
+[ 1, 1061 ]
+[ 1, 1061 ]
+[ 1, 1061 ]
+[ 1, 1061 ]
+[ 1, 1061 ]
+[ 1, 1061 ]
+[ 1, 1061 ]
+[ 1, 1162 ]
+[ 1, 1162 ]
+[ 1, 1162 ]
+[ 1, 1162 ]
+[ 1, 1162 ]
+[ 1, 1162 ]
+[ 1, 1162 ]
% ., sys.tables # table_name
% foo, schema_id # name
% int, int # type
% 2, 4 # length
-[ 1, 1059 ]
-[ 1, 1059 ]
-[ 1, 1059 ]
-[ 1, 1059 ]
-[ 1, 1059 ]
-[ 1, 1059 ]
-[ 1, 1059 ]
-[ 1, 1059 ]
-[ 1, 1059 ]
-[ 1, 1059 ]
-[ 1, 1059 ]
-[ 1, 1059 ]
-[ 1, 1059 ]
-[ 1, 1059 ]
-[ 1, 1059 ]
-[ 1, 1059 ]
-[ 1, 1059 ]
-[ 1, 1059 ]
-[ 1, 1059 ]
-[ 1, 1059 ]
-[ 1, 1059 ]
-[ 1, 1059 ]
-[ 1, 1059 ]
-[ 1, 1059 ]
-[ 1, 1059 ]
-[ 1, 1059 ]
-[ 1, 1059 ]
-[ 28, 1160 ]
-[ 28, 1160 ]
-[ 28, 1160 ]
-[ 28, 1160 ]
-[ 28, 1160 ]
-[ 28, 1160 ]
-[ 28, 1160 ]
+[ 1, 1061 ]
+[ 1, 1061 ]
+[ 1, 1061 ]
+[ 1, 1061 ]
+[ 1, 1061 ]
+[ 1, 1061 ]
+[ 1, 1061 ]
+[ 1, 1061 ]
+[ 1, 1061 ]
+[ 1, 1061 ]
+[ 1, 1061 ]
+[ 1, 1061 ]
+[ 1, 1061 ]
+[ 1, 1061 ]
+[ 1, 1061 ]
+[ 1, 1061 ]
+[ 1, 1061 ]
+[ 1, 1061 ]
+[ 1, 1061 ]
+[ 1, 1061 ]
+[ 1, 1061 ]
+[ 1, 1061 ]
+[ 1, 1061 ]
+[ 1, 1061 ]
+[ 1, 1061 ]
+[ 1, 1061 ]
+[ 1, 1061 ]
+[ 28, 1162 ]
+[ 28, 1162 ]
+[ 28, 1162 ]
+[ 28, 1162 ]
+[ 28, 1162 ]
+[ 28, 1162 ]
+[ 28, 1162 ]
% sys., sys.columns, sys.columns # table_name
% foo, name, type # name
% int, varchar, varchar # type
U coalesce.stable.err.Five
Index: coalesce.stable.err.Five
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Tests/coalesce.stable.err.Five,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -d -r1.1 -r1.2
--- coalesce.stable.err.Five 3 Jan 2008 11:45:21 -0000 1.1
+++ coalesce.stable.err.Five 28 Oct 2008 20:05:04 -0000 1.2
@@ -12,12 +12,12 @@
# 14:16:39 > mclient -lsql -umonetdb -Pmonetdb --host=amelia --port=36320
# 14:16:39 >
-MAPI = [EMAIL PROTECTED]:31459
+MAPI = [EMAIL PROTECTED]:35914
QUERY = select id, coalesce(age,'age unknown') from test;
ERROR = !SQLException:int:conversion of string 'age unknown' failed
-MAPI = [EMAIL PROTECTED]:31459
+MAPI = [EMAIL PROTECTED]:35914
QUERY = select id, coalesce(name, age, 'unknown') from test;
-ERROR = !SQLException:int:conversion of string 'a' failed
+ERROR = !SQLException:int:conversion of string 'unknown' failed
# 16:39:45 >
# 16:39:45 > Done.
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
