Update of /cvsroot/monetdb/sql/src/test/mapi/Tests
In directory
sfp-cvsdas-1.v30.ch3.sourceforge.com:/tmp/cvs-serv1972/src/test/mapi/Tests
Modified Files:
php_monetdb.stable.out
Log Message:
A sequence of group new and derives is now closed with a group.done (does
the last step ie a group.new or derive).
This makes the code in merge table a bit cleaner (more could be done later)
sql.bind and append/update/delete now have an extra (first) argument,
making them safe to use in the dataflow (ie solved using variable dependencies)
(BREAKS octopus !)
Implemented read only tables. Use
ALTER TABLE x SET READ ONLY;
(cannot be reverted currently)
fixed bug in limit/offset handling, now we have 64 bit wrd instead of int.
The new read only required schema changes, ie backup/restore your db.
We therefor claimed some more oid's for internal functions.
Index: php_monetdb.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/mapi/Tests/php_monetdb.stable.out,v
retrieving revision 1.19
retrieving revision 1.20
diff -u -d -r1.19 -r1.20
--- php_monetdb.stable.out 2 Aug 2009 20:23:51 -0000 1.19
+++ php_monetdb.stable.out 27 Feb 2010 19:28:48 -0000 1.20
@@ -56,35 +56,35 @@
user_role
auths
privileges
-id name schema_id query type system commit_action
temporary
-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
-4120 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
-4129 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
-4148 db_user_info 1061 0 true 0 0
-4156 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
-4160 user_role 1061 0 true 0 0
-4163 auths 1061 0 true 0 0
-4167 privileges 1061 0 true 0 0
+id name schema_id query type system commit_action
readonly temporary
+2001 schemas 2000 0 true 0 false 0
+2006 types 2000 0 true 0 false 0
+2015 functions 2000 0 true 0 false 0
+2024 args 2000 0 true 0 false 0
+2032 sequences 2000 0 true 0 false 0
+2042 dependencies 2000 0 true 0 false 0
+2046 connections 2000 0 true 0 false 0
+2055 _tables 2000 0 true 0 false 0
+2064 _columns 2000 0 true 0 false 0
+2075 keys 2000 0 true 0 false 0
+2082 idxs 2000 0 true 0 false 0
+2087 triggers 2000 0 true 0 false 0
+2098 keycolumns 2000 0 true 0 false 0
+2104 _tables 2103 0 true 2 false 0
+2113 _columns 2103 0 true 2 false 0
+2124 keys 2103 0 true 2 false 0
+2131 idxs 2103 0 true 2 false 0
+2136 triggers 2103 0 true 2 false 0
+2147 keycolumns 2103 0 true 2 false 0
+5063 tables 2000 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
false 0
+5073 columns 2000 SELECT * FROM (SELECT p.* FROM "sys"."_columns" AS p
UNION ALL SELECT t.* FROM "tmp"."_columns" AS t) AS columns; 1 true
0 false 0
+5093 db_user_info 2000 0 true 0 false 0
+5101 users 2000 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 false 0
+5105 user_role 2000 0 true 0 false 0
+5108 auths 2000 0 true 0 false 0
+5112 privileges 2000 0 true 0 false 0
-# 22:19:38 >
-# 22:19:38 > Done.
-# 22:19:38 >
+# 19:43:27 >
+# 19:43:27 > Done.
+# 19:43:27 >
------------------------------------------------------------------------------
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
