Update of /cvsroot/monetdb/sql/src/test/BugTracker/Tests
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv7044

Modified Files:
      Tag: SQL_2-20
        All 
Added Files:
      Tag: SQL_2-20
        jdbc_no_debug.SF-1739356-data.sql 
        jdbc_no_debug.SF-1739356.SQL.sh 
        jdbc_no_debug.SF-1739356.stable.err 
        jdbc_no_debug.SF-1739356.stable.out 
Log Message:
test for the jdbc debug,trace  profile problem


--- NEW FILE: jdbc_no_debug.SF-1739356.stable.out ---
stdout of test 'jdbc_no_debug.SF-1739356` in directory 'src/test/BugTracker` 
itself:


# 09:34:52 >  
# 09:34:52 >  Mtimeout -timeout 300  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=30711 --set 
xrpc_port=46004 --set monet_prompt= --trace 
"--dbname=mTests_src_test_BugTracker" --dbinit=" module(sql_server);" ; echo ; 
echo Over..
# 09:34:52 >  

!WARNING: GDKlockHome: ignoring empty or invalid .gdk_lock.
!WARNING: BBPdir: initializing BBP.
# 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.0 loaded

printf("\nReady.\n");

Ready.
quit();

Over..

# 09:34:52 >  
# 09:34:52 >  Mtimeout -timeout 180 ./jdbc_no_debug.SF-1739356.SQL.sh 
jdbc_no_debug.SF-1739356 
# 09:34:52 >  


# 09:34:52 >  
# 09:34:52 >  Mtimeout -timeout 60 mjclient -h koala -p 30711 -d 
mTests_src_test_BugTracker -f 
../../../../../../../../scratch1/niels/rc/sql/src/test/BugTracker/Tests/jdbc_no_debug.SF-1739356-data.sql
# 09:34:52 >  

+--------+
| count_ |
+========+
|     27 |
+--------+
1 row


# 09:34:53 >  
# 09:34:53 >  Done.
# 09:34:53 >  


Index: All
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/BugTracker/Tests/All,v
retrieving revision 1.63.2.2
retrieving revision 1.63.2.3
diff -u -d -r1.63.2.2 -r1.63.2.3
--- All 2 Oct 2007 13:57:25 -0000       1.63.2.2
+++ All 3 Oct 2007 07:36:24 -0000       1.63.2.3
@@ -80,3 +80,4 @@
 limit_timestampz.SF-1774217
 convert_dec2varchar.SF-1774312
 convert_dec2varchar_crash.SF-1775550
+jdbc_no_debug.SF-1739356

--- NEW FILE: jdbc_no_debug.SF-1739356.stable.err ---
stderr of test 'jdbc_no_debug.SF-1739356` in directory 'src/test/BugTracker` 
itself:


# 09:34:52 >  
# 09:34:52 >  Mtimeout -timeout 300  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=30711 --set 
xrpc_port=46004 --set monet_prompt= --trace 
"--dbname=mTests_src_test_BugTracker" --dbinit=" module(sql_server);" ; echo ; 
echo Over..
# 09:34:52 >  


# 09:34:52 >  
# 09:34:52 >  Mtimeout -timeout 180 ./jdbc_no_debug.SF-1739356.SQL.sh 
jdbc_no_debug.SF-1739356 
# 09:34:52 >  


# 09:34:52 >  
# 09:34:52 >  Mtimeout -timeout 60 mjclient -h koala -p 30711 -d 
mTests_src_test_BugTracker -f 
../../../../../../../../scratch1/niels/rc/sql/src/test/BugTracker/Tests/jdbc_no_debug.SF-1739356-data.sql
# 09:34:52 >  

Error on line 1: We only support debugging SQL in interactive mode in: "debug"
Error on line 2: We do not support tracing SQL in interactive mode in: "trace"

# 09:34:53 >  
# 09:34:53 >  Done.
# 09:34:53 >  


--- NEW FILE: jdbc_no_debug.SF-1739356.SQL.sh ---
#!/bin/bash

cat << EOF > .monetdb
user=monetdb
password=monetdb
EOF

LANG="en_US.UTF-8"
export LANG

Mlog   "$MTIMEOUT mjclient -h $HOST -p $MAPIPORT -d ${TSTDB} -f 
$RELSRCDIR/jdbc_no_debug.SF-1739356-data.sql"
        $MTIMEOUT mjclient -h $HOST -p $MAPIPORT -d ${TSTDB} -f 
$RELSRCDIR/jdbc_no_debug.SF-1739356-data.sql 

rm -f .monetdb

--- NEW FILE: jdbc_no_debug.SF-1739356-data.sql ---
debug select count(*) from tables;
trace select count(*) from tables;

-- next is allowed as it doesn't change the output of the statement
profile select count(*) from tables;


-------------------------------------------------------------------------
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

Reply via email to