Update of /cvsroot/monetdb/sql/src/test/mapi/Tests
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv11808/src/test/mapi/Tests
Modified Files:
php_monetdb.stable.out php_monetdb.stable.out.Five
Log Message:
fixes use of txtsim functions
added more optimized versions of cast of mtime types (from string)
added more optimized verion of str to string convert
added use (first steps) of rangejoin
approved tests which changed by this (rangejoin addition)
Index: php_monetdb.stable.out.Five
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/mapi/Tests/php_monetdb.stable.out.Five,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -d -r1.4 -r1.5
--- php_monetdb.stable.out.Five 18 Dec 2007 10:49:15 -0000 1.4
+++ php_monetdb.stable.out.Five 21 Dec 2007 17:02:28 -0000 1.5
@@ -57,35 +57,35 @@
privileges
profile
id name schema_id query type system commit_action
temporary
-957 schemas 956 0 true 0 0
-962 types 956 0 true 0 0
-971 functions 956 0 true 0 0
-980 args 956 0 true 0 0
-988 sequences 956 0 true 0 0
-998 dependencies 956 0 true 0 0
-1002 connections 956 0 true 0 0
-1011 _tables 956 0 true 0 0
-1019 _columns 956 0 true 0 0
-1029 keys 956 0 true 0 0
-1036 idxs 956 0 true 0 0
-1041 triggers 956 0 true 0 0
-1052 keycolumns 956 0 true 0 0
-1058 _tables 1057 0 true 2 0
-1066 _columns 1057 0 true 2 0
-1076 keys 1057 0 true 2 0
-1083 idxs 1057 0 true 2 0
-1088 triggers 1057 0 true 2 0
-1099 keycolumns 1057 0 true 2 0
-3692 tables 956 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
-3701 columns 956 SELECT * FROM (SELECT p.* FROM "sys"."_columns" AS p
UNION ALL SELECT t.* FROM "tmp"."_columns" AS t) AS columns; 1 true
0 0
-3720 db_user_info 956 0 true 0 0
-3728 users 956 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
-3732 user_role 956 0 true 0 0
-3735 auths 956 0 true 0 0
-3739 privileges 956 0 true 0 0
-3745 profile 1057 0 true 2 0
+981 schemas 980 0 true 0 0
+986 types 980 0 true 0 0
+995 functions 980 0 true 0 0
+1004 args 980 0 true 0 0
+1012 sequences 980 0 true 0 0
+1022 dependencies 980 0 true 0 0
+1026 connections 980 0 true 0 0
+1035 _tables 980 0 true 0 0
+1043 _columns 980 0 true 0 0
+1053 keys 980 0 true 0 0
+1060 idxs 980 0 true 0 0
+1065 triggers 980 0 true 0 0
+1076 keycolumns 980 0 true 0 0
+1082 _tables 1081 0 true 2 0
+1090 _columns 1081 0 true 2 0
+1100 keys 1081 0 true 2 0
+1107 idxs 1081 0 true 2 0
+1112 triggers 1081 0 true 2 0
+1123 keycolumns 1081 0 true 2 0
+3791 tables 980 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
+3800 columns 980 SELECT * FROM (SELECT p.* FROM "sys"."_columns" AS p
UNION ALL SELECT t.* FROM "tmp"."_columns" AS t) AS columns; 1 true
0 0
+3819 db_user_info 980 0 true 0 0
+3827 users 980 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
+3831 user_role 980 0 true 0 0
+3834 auths 980 0 true 0 0
+3838 privileges 980 0 true 0 0
+3844 profile 1081 0 true 2 0
-# 17:32:05 >
-# 17:32:05 > Done.
-# 17:32:05 >
+# 16:54:20 >
+# 16:54:20 > Done.
+# 16:54:20 >
Index: php_monetdb.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/mapi/Tests/php_monetdb.stable.out,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -d -r1.4 -r1.5
--- php_monetdb.stable.out 18 Dec 2007 10:49:15 -0000 1.4
+++ php_monetdb.stable.out 21 Dec 2007 17:02:28 -0000 1.5
@@ -56,35 +56,35 @@
privileges
profile
id name schema_id query type system commit_action
temporary
-957 schemas 956 0 true 0 0
-962 types 956 0 true 0 0
-971 functions 956 0 true 0 0
-980 args 956 0 true 0 0
-988 sequences 956 0 true 0 0
-998 dependencies 956 0 true 0 0
-1002 connections 956 0 true 0 0
-1011 _tables 956 0 true 0 0
-1019 _columns 956 0 true 0 0
-1029 keys 956 0 true 0 0
-1036 idxs 956 0 true 0 0
-1041 triggers 956 0 true 0 0
-1052 keycolumns 956 0 true 0 0
-1058 _tables 1057 0 true 2 0
-1066 _columns 1057 0 true 2 0
-1076 keys 1057 0 true 2 0
-1083 idxs 1057 0 true 2 0
-1088 triggers 1057 0 true 2 0
-1099 keycolumns 1057 0 true 2 0
-3692 tables 956 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
-3701 columns 956 SELECT * FROM (SELECT p.* FROM "sys"."_columns" AS p
UNION ALL SELECT t.* FROM "tmp"."_columns" AS t) AS columns; 1 true
0 0
-3720 db_users 956 0 true 0 0
-3725 users 956 SELECT "name", "fullname", "default_schema" FROM
"sys"."db_users"; 1 true 0 0
-3729 user_role 956 0 true 0 0
-3732 auths 956 0 true 0 0
-3736 privileges 956 0 true 0 0
-3742 profile 1057 0 true 2 0
+981 schemas 980 0 true 0 0
+986 types 980 0 true 0 0
+995 functions 980 0 true 0 0
+1004 args 980 0 true 0 0
+1012 sequences 980 0 true 0 0
+1022 dependencies 980 0 true 0 0
+1026 connections 980 0 true 0 0
+1035 _tables 980 0 true 0 0
+1043 _columns 980 0 true 0 0
+1053 keys 980 0 true 0 0
+1060 idxs 980 0 true 0 0
+1065 triggers 980 0 true 0 0
+1076 keycolumns 980 0 true 0 0
+1082 _tables 1081 0 true 2 0
+1090 _columns 1081 0 true 2 0
+1100 keys 1081 0 true 2 0
+1107 idxs 1081 0 true 2 0
+1112 triggers 1081 0 true 2 0
+1123 keycolumns 1081 0 true 2 0
+3791 tables 980 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
+3800 columns 980 SELECT * FROM (SELECT p.* FROM "sys"."_columns" AS p
UNION ALL SELECT t.* FROM "tmp"."_columns" AS t) AS columns; 1 true
0 0
+3819 db_users 980 0 true 0 0
+3824 users 980 SELECT "name", "fullname", "default_schema" FROM
"sys"."db_users"; 1 true 0 0
+3828 user_role 980 0 true 0 0
+3831 auths 980 0 true 0 0
+3835 privileges 980 0 true 0 0
+3841 profile 1081 0 true 2 0
-# 17:23:03 >
-# 17:23:03 > Done.
-# 17:23:03 >
+# 16:41:02 >
+# 16:41:02 > Done.
+# 16:41:02 >
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
