Update of /cvsroot/monetdb/sql/src/test/bugs/Tests
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv8235
Modified Files:
Tag: SQL_2-18
All
Added Files:
Tag: SQL_2-18
not.sql not.stable.err not.stable.out
Log Message:
add test script for problem with not in selection
Index: All
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/bugs/Tests/All,v
retrieving revision 1.93.2.1
retrieving revision 1.93.2.2
diff -u -d -r1.93.2.1 -r1.93.2.2
--- All 29 Jun 2007 11:18:18 -0000 1.93.2.1
+++ All 18 Aug 2007 12:24:22 -0000 1.93.2.2
@@ -67,3 +67,4 @@
alter_view
simple_view
float2dec
+not
--- NEW FILE: not.stable.out ---
stdout of test 'not` in directory 'src/test/bugs` itself:
# 14:04:18 >
# 14:04:18 > Mtimeout -timeout 180 Mserver
"--config=/scratch/niels/Linux-x86_64/etc/MonetDB.conf" --debug=10 --set
"monet_mod_path=/scratch/niels/Linux-x86_64/lib/MonetDB4:/scratch/niels/Linux-x86_64/lib/MonetDB4/lib:/scratch/niels/Linux-x86_64/lib/MonetDB4/bin"
--set "gdk_dbfarm=/scratch/niels/Linux-x86_64/var/MonetDB4/dbfarm" --set
"sql_logdir=/scratch/niels/Linux-x86_64/var/MonetDB4/sql_logs" --set
"xquery_logdir=/scratch/niels/Linux-x86_64/var/MonetDB4/xquery_logs" --set
mapi_open=true --set xrpc_open=true --set mapi_port=32956 --set xrpc_port=42122
--set monet_prompt= --trace "--dbname=mTests_src_test_bugs" --dbinit="
module(sql_server);" ; echo ; echo Over..
# 14:04:18 >
# MonetDB Server v4.19.0
# based on GDK v1.19.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.19.0 loaded
printf("\nReady.\n");
Ready.
quit();
Over..
# 14:04:18 >
# 14:04:18 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=beo-14 --port=32956
# 14:04:18 >
[ 1 ]
% sys.n # table_name
% alive # name
% boolean # type
% 5 # length
[ false ]
% sys. # table_name
% not_alive # name
% boolean # type
% 5 # length
[ true ]
% sys. # table_name
% not_not_alive # name
% boolean # type
% 5 # length
[ false ]
% sys. # table_name
% not_not_not_alive # name
% boolean # type
% 5 # length
[ true ]
# 14:04:18 >
# 14:04:18 > Done.
# 14:04:18 >
--- NEW FILE: not.stable.err ---
stderr of test 'not` in directory 'src/test/bugs` itself:
# 14:04:18 >
# 14:04:18 > Mtimeout -timeout 180 Mserver
"--config=/scratch/niels/Linux-x86_64/etc/MonetDB.conf" --debug=10 --set
"monet_mod_path=/scratch/niels/Linux-x86_64/lib/MonetDB4:/scratch/niels/Linux-x86_64/lib/MonetDB4/lib:/scratch/niels/Linux-x86_64/lib/MonetDB4/bin"
--set "gdk_dbfarm=/scratch/niels/Linux-x86_64/var/MonetDB4/dbfarm" --set
"sql_logdir=/scratch/niels/Linux-x86_64/var/MonetDB4/sql_logs" --set
"xquery_logdir=/scratch/niels/Linux-x86_64/var/MonetDB4/xquery_logs" --set
mapi_open=true --set xrpc_open=true --set mapi_port=32956 --set xrpc_port=42122
--set monet_prompt= --trace "--dbname=mTests_src_test_bugs" --dbinit="
module(sql_server);" ; echo ; echo Over..
# 14:04:18 >
# 14:04:18 >
# 14:04:18 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=beo-14 --port=32956
# 14:04:18 >
# 14:04:18 >
# 14:04:18 > Done.
# 14:04:18 >
--- NEW FILE: not.sql ---
create table nntest(alive boolean);
insert into nntest(alive) values(False);
select n.alive from nntest n;
select not n.alive from nntest n;
select not not n.alive from nntest n;
select not not not n.alive from nntest n;
drop table nntest;
-------------------------------------------------------------------------
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
