Update of /cvsroot/monetdb/sql/src/test/mapi/Tests
In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv15984/src/test/mapi/Tests
Modified Files:
php_monetdb.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 php_monetdb.stable.out.Five
Index: php_monetdb.stable.out.Five
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/mapi/Tests/php_monetdb.stable.out.Five,v
retrieving revision 1.13
retrieving revision 1.14
diff -u -d -r1.13 -r1.14
--- php_monetdb.stable.out.Five 7 Sep 2008 20:31:42 -0000 1.13
+++ php_monetdb.stable.out.Five 28 Oct 2008 20:05:05 -0000 1.14
@@ -57,35 +57,35 @@
privileges
history
id name schema_id query type system commit_action
temporary
-1060 schemas 1059 0 true 0 0
-1065 types 1059 0 true 0 0
-1074 functions 1059 0 true 0 0
-1083 args 1059 0 true 0 0
-1091 sequences 1059 0 true 0 0
-1101 dependencies 1059 0 true 0 0
-1105 connections 1059 0 true 0 0
-1114 _tables 1059 0 true 0 0
-1122 _columns 1059 0 true 0 0
-1132 keys 1059 0 true 0 0
-1139 idxs 1059 0 true 0 0
-1144 triggers 1059 0 true 0 0
-1155 keycolumns 1059 0 true 0 0
-1161 _tables 1160 0 true 2 0
-1169 _columns 1160 0 true 2 0
-1179 keys 1160 0 true 2 0
-1186 idxs 1160 0 true 2 0
-1191 triggers 1160 0 true 2 0
-1202 keycolumns 1160 0 true 2 0
-4095 tables 1059 SELECT * FROM (SELECT p.*, 0 AS "temporary" FROM
"sys"."_tables" AS p UNION ALL SELECT t.*, 1 AS "temporary" FROM
"tmp"."_tables" AS t) AS tables where tables.type < 2; 1 true 0
0
-4104 columns 1059 SELECT * FROM (SELECT p.* FROM "sys"."_columns" AS p
UNION ALL SELECT t.* FROM "tmp"."_columns" AS t) AS columns; 1 true
0 0
-4123 db_user_info 1059 0 true 0 0
-4131 users 1059 SELECT u."name" AS "name", ui."fullname",
ui."default_schema" FROM db_users() AS u LEFT JOIN "sys"."db_user_info" AS ui
ON u."name" = ui."name" ; 1 true 0 0
-4135 user_role 1059 0 true 0 0
-4138 auths 1059 0 true 0 0
-4142 privileges 1059 0 true 0 0
-4148 history 1160 0 true 2 0
+1062 schemas 1061 0 true 0 0
+1067 types 1061 0 true 0 0
+1076 functions 1061 0 true 0 0
+1085 args 1061 0 true 0 0
+1093 sequences 1061 0 true 0 0
+1103 dependencies 1061 0 true 0 0
+1107 connections 1061 0 true 0 0
+1116 _tables 1061 0 true 0 0
+1124 _columns 1061 0 true 0 0
+1134 keys 1061 0 true 0 0
+1141 idxs 1061 0 true 0 0
+1146 triggers 1061 0 true 0 0
+1157 keycolumns 1061 0 true 0 0
+1163 _tables 1162 0 true 2 0
+1171 _columns 1162 0 true 2 0
+1181 keys 1162 0 true 2 0
+1188 idxs 1162 0 true 2 0
+1193 triggers 1162 0 true 2 0
+1204 keycolumns 1162 0 true 2 0
+4101 tables 1061 SELECT * FROM (SELECT p.*, 0 AS "temporary" FROM
"sys"."_tables" AS p UNION ALL SELECT t.*, 1 AS "temporary" FROM
"tmp"."_tables" AS t) AS tables where tables.type < 2; 1 true 0
0
+4110 columns 1061 SELECT * FROM (SELECT p.* FROM "sys"."_columns" AS p
UNION ALL SELECT t.* FROM "tmp"."_columns" AS t) AS columns; 1 true
0 0
+4129 db_user_info 1061 0 true 0 0
+4137 users 1061 SELECT u."name" AS "name", ui."fullname",
ui."default_schema" FROM db_users() AS u LEFT JOIN "sys"."db_user_info" AS ui
ON u."name" = ui."name" ; 1 true 0 0
+4141 user_role 1061 0 true 0 0
+4144 auths 1061 0 true 0 0
+4148 privileges 1061 0 true 0 0
+4154 history 1162 0 true 2 0
-# 21:40:03 >
-# 21:40:03 > Done.
-# 21:40:03 >
+# 20:13:35 >
+# 20:13:35 > Done.
+# 20:13:35 >
-------------------------------------------------------------------------
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
