Update of /cvsroot/monetdb/sql/src/test/mapi/Tests
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv32040/src/test/mapi/Tests
Modified Files:
Tag: SQL_2-24
php_monetdb.stable.out php_monetdb.stable.out.Five
Log Message:
changed handling of declared tables to fix the schema_from_declared_table
bug.
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.8
retrieving revision 1.8.2.1
diff -u -d -r1.8 -r1.8.2.1
--- php_monetdb.stable.out.Five 25 Apr 2008 07:25:31 -0000 1.8
+++ php_monetdb.stable.out.Five 4 Jun 2008 20:19:21 -0000 1.8.2.1
@@ -76,16 +76,16 @@
1106 idxs 1080 0 true 2 0
1111 triggers 1080 0 true 2 0
1122 keycolumns 1080 0 true 2 0
-3794 tables 979 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
-3803 columns 979 SELECT * FROM (SELECT p.* FROM "sys"."_columns" AS p
UNION ALL SELECT t.* FROM "tmp"."_columns" AS t) AS columns; 1 true
0 0
-3822 db_user_info 979 0 true 0 0
-3830 users 979 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
-3834 user_role 979 0 true 0 0
-3837 auths 979 0 true 0 0
-3841 privileges 979 0 true 0 0
-3847 history 1080 0 true 2 0
+3795 tables 979 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
+3804 columns 979 SELECT * FROM (SELECT p.* FROM "sys"."_columns" AS p
UNION ALL SELECT t.* FROM "tmp"."_columns" AS t) AS columns; 1 true
0 0
+3823 db_user_info 979 0 true 0 0
+3831 users 979 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
+3835 user_role 979 0 true 0 0
+3838 auths 979 0 true 0 0
+3842 privileges 979 0 true 0 0
+3848 history 1080 0 true 2 0
-# 09:02:04 >
-# 09:02:04 > Done.
-# 09:02:04 >
+# 20:41:22 >
+# 20:41:22 > Done.
+# 20:41:22 >
U php_monetdb.stable.out
Index: php_monetdb.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/mapi/Tests/php_monetdb.stable.out,v
retrieving revision 1.8
retrieving revision 1.8.2.1
diff -u -d -r1.8 -r1.8.2.1
--- php_monetdb.stable.out 25 Apr 2008 07:32:57 -0000 1.8
+++ php_monetdb.stable.out 4 Jun 2008 20:19:21 -0000 1.8.2.1
@@ -75,16 +75,16 @@
1106 idxs 1080 0 true 2 0
1111 triggers 1080 0 true 2 0
1122 keycolumns 1080 0 true 2 0
-3794 tables 979 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
-3803 columns 979 SELECT * FROM (SELECT p.* FROM "sys"."_columns" AS p
UNION ALL SELECT t.* FROM "tmp"."_columns" AS t) AS columns; 1 true
0 0
-3822 db_users 979 0 true 0 0
-3827 users 979 SELECT "name", "fullname", "default_schema" FROM
"sys"."db_users"; 1 true 0 0
-3831 user_role 979 0 true 0 0
-3834 auths 979 0 true 0 0
-3838 privileges 979 0 true 0 0
-3844 history 1080 0 true 2 0
+3795 tables 979 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
+3804 columns 979 SELECT * FROM (SELECT p.* FROM "sys"."_columns" AS p
UNION ALL SELECT t.* FROM "tmp"."_columns" AS t) AS columns; 1 true
0 0
+3823 db_users 979 0 true 0 0
+3828 users 979 SELECT "name", "fullname", "default_schema" FROM
"sys"."db_users"; 1 true 0 0
+3832 user_role 979 0 true 0 0
+3835 auths 979 0 true 0 0
+3839 privileges 979 0 true 0 0
+3845 history 1080 0 true 2 0
-# 09:28:11 >
-# 09:28:11 > Done.
-# 09:28:11 >
+# 21:45:24 >
+# 21:45:24 > Done.
+# 21:45:24 >
-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
