Update of /cvsroot/monetdb/sql/src/test/mapi/Tests
In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv4764/src/test/mapi/Tests
Modified Files:
php_monetdb.stable.out
Log Message:
For avg we now always first change to doubles.
With this we can now rewrite all 'avg's into sum/cnt.
approved slight rounding changes
approved output after changes on the optimizers
approved tests which changed because of number of default functions changed
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.17
retrieving revision 1.18
diff -u -d -r1.17 -r1.18
--- php_monetdb.stable.out 9 Mar 2009 20:38:07 -0000 1.17
+++ php_monetdb.stable.out 4 Jun 2009 20:27:55 -0000 1.18
@@ -76,15 +76,15 @@
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
+4079 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
+4088 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
+4107 db_user_info 1061 0 true 0 0
+4115 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
+4119 user_role 1061 0 true 0 0
+4122 auths 1061 0 true 0 0
+4126 privileges 1061 0 true 0 0
-# 14:31:29 >
-# 14:31:29 > Done.
-# 14:31:29 >
+# 22:01:52 >
+# 22:01:52 > Done.
+# 22:01:52 >
------------------------------------------------------------------------------
OpenSolaris 2009.06 is a cutting edge operating system for enterprises
looking to deploy the next generation of Solaris that includes the latest
innovations from Sun and the OpenSource community. Download a copy and
enjoy capabilities such as Networking, Storage and Virtualization.
Go to: http://p.sf.net/sfu/opensolaris-get
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
