Update of /cvsroot/monetdb/sql/src/test/mapi/Tests
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv2876/src/test/mapi/Tests
Modified Files:
All
Added Files:
php_monetdb.SQL.bat php_monetdb.SQL.sh php_monetdb.stable.err
php_monetdb.stable.out php_monetdb.stable.out.Five
Log Message:
propagated changes of Monday Oct 22 2007 - Wednesday Oct 24 2007
from the SQL_2-20 branch to the development trunk
Index: All
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/mapi/Tests/All,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -d -r1.3 -r1.4
--- All 22 Oct 2007 10:43:09 -0000 1.3
+++ All 24 Oct 2007 08:01:24 -0000 1.4
@@ -9,3 +9,5 @@
HAVE_PERL_SWIG?perl_dbi
HAVE_PYTHON_SWIG?python_dbapi
HAVE_PYTHON_SWIG?python_dbapi_embedded
+HAVE_PHP?php_monetdb
+
--- NEW FILE: php_monetdb.stable.err ---
stderr of test 'php_monetdb` in directory 'src/test/mapi` itself:
# 20:50:24 >
# 20:50:24 > Mtimeout -timeout 180 Mserver
"--config=/ufs/niels/scratch/rc/Linux-x86_64/etc/MonetDB.conf" --debug=10 --set
"monet_mod_path=/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB4:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB4/lib:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB4/bin"
--set "gdk_dbfarm=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB4/dbfarm"
--set "sql_logdir=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB4/sql_logs"
--set
"xquery_logdir=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB4/xquery_logs"
--set mapi_open=true --set xrpc_open=true --set mapi_port=36034 --set
xrpc_port=48617 --set monet_prompt= --trace "--dbname=mTests_src_test_mapi"
--dbinit=" module(sql_server);" ; echo ; echo Over..
# 20:50:24 >
# 20:50:24 >
# 20:50:24 > Mtimeout -timeout 60 ./php_monetdb.SQL.sh php_monetdb
# 20:50:24 >
# 20:50:24 >
# 20:50:24 > php -n -d extension_dir= -f
/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB/Tests/sqlsample.php 36034
# 20:50:24 >
# 20:50:24 >
# 20:50:24 > Done.
# 20:50:24 >
--- NEW FILE: php_monetdb.SQL.sh ---
#!/bin/sh
path="`monetdb-clients-config --pkglibdir`/Tests"
dir="`monetdb-clients-config --phpextensiondir`"
Mlog -x php -n -d extension_dir=$dir -f $path/sqlsample.php $MAPIPORT
--- NEW FILE: php_monetdb.stable.out.Five ---
stdout of test 'php_monetdb` in directory 'src/test/mapi` itself:
# 21:42:05 >
# 21:42:05 > Mtimeout -timeout 180 mserver5
"--config=/ufs/niels/scratch/rc/Linux-x86_64/etc/monetdb5.conf" --debug=10
--set
"monet_mod_path=/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB5:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB5/lib:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB5/bin"
--set "gdk_dbfarm=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB5/dbfarm"
--set "sql_logdir=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB5/sql_logs"
--set mapi_open=true --set xrpc_open=true --set mapi_port=32115 --set
xrpc_port=45214 --set monet_prompt= --trace "--dbname=mTests_src_test_mapi"
--set mal_listing=0 --dbinit=" include sql;" ; echo ; echo Over..
# 21:42:05 >
# MonetDB server v5.2.0, based on kernel v1.20.0
# Serving database 'mTests_src_test_mapi'
# Compiled for x86_64-redhat-linux-gnu/64bit with 64bit OIDs dynamically linked
# Copyright (c) 1993-2007 CWI, all rights reserved
# Visit http://monetdb.cwi.nl/ for further information
# Listening for connection requests on mapi:monetdb://koala.ins.cwi.nl:32115/
# MonetDB/SQL module v2.20.0 loaded
Ready.
#function user.main():void;
# clients.quit();
#end main;
Over..
# 20:50:24 >
# 20:50:24 > Mtimeout -timeout 60 ./php_monetdb.SQL.sh php_monetdb
# 20:50:24 >
# 20:50:24 >
# 20:50:24 > php -n -d extension_dir= -f
/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB/Tests/sqlsample.php 36034
# 20:50:24 >
schemas
types
functions
args
sequences
dependencies
connections
_tables
_columns
keys
idxs
triggers
keycolumns
_tables
_columns
keys
idxs
triggers
keycolumns
tables
columns
db_user_info
users
user_role
auths
privileges
profile
perl_table
id name schema_id query type system commit_action
temporary
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
3852 perl_table 980 0 false 0 0
# 21:42:05 >
# 21:42:05 > Done.
# 21:42:05 >
--- NEW FILE: php_monetdb.SQL.bat ---
@echo off
set path=%CLIENTS_PREFIX%\lib\MonetDB\Tests
set dir=%CLIENTS_PREFIX%\%PHP_EXTENSIONDIR%
call Mlog.bat -x @PHP@ -n -d extension_dir=%dir% -f %path%\sqlsample.php
--- NEW FILE: php_monetdb.stable.out ---
stdout of test 'php_monetdb` in directory 'src/test/mapi` itself:
# 20:50:24 >
# 20:50:24 > Mtimeout -timeout 180 Mserver
"--config=/ufs/niels/scratch/rc/Linux-x86_64/etc/MonetDB.conf" --debug=10 --set
"monet_mod_path=/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB4:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB4/lib:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB4/bin"
--set "gdk_dbfarm=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB4/dbfarm"
--set "sql_logdir=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB4/sql_logs"
--set
"xquery_logdir=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB4/xquery_logs"
--set mapi_open=true --set xrpc_open=true --set mapi_port=36034 --set
xrpc_port=48617 --set monet_prompt= --trace "--dbname=mTests_src_test_mapi"
--dbinit=" module(sql_server);" ; echo ; echo Over..
# 20:50:24 >
# MonetDB Server v4.20.0
# based on GDK v1.20.0
# Copyright (c) 1993-2007, CWI. All rights reserved.
# Compiled for x86_64-redhat-linux-gnu/64bit with 64bit OIDs; dynamically
linked.
# Visit http://monetdb.cwi.nl/ for further information.
# MonetDB/SQL module v2.20.1 loaded
printf("\nReady.\n");
Ready.
quit();
Over..
# 20:50:24 >
# 20:50:24 > Mtimeout -timeout 60 ./php_monetdb.SQL.sh php_monetdb
# 20:50:24 >
# 20:50:24 >
# 20:50:24 > php -n -d extension_dir= -f
/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB/Tests/sqlsample.php 36034
# 20:50:24 >
schemas
types
functions
args
sequences
dependencies
connections
_tables
_columns
keys
idxs
triggers
keycolumns
_tables
_columns
keys
idxs
triggers
keycolumns
tables
columns
db_users
users
user_role
auths
privileges
profile
perl_table
id name schema_id query type system commit_action
temporary
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
3849 perl_table 980 0 false 0 0
# 20:50:24 >
# 20:50:24 > Done.
# 20:50:24 >
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
