Update of /cvsroot/monetdb/sql/src/test/bugs/Tests
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv24909/src/test/bugs/Tests
Modified Files:
All
Added Files:
ifthenelse_bug.sql ifthenelse_bug.stable.err
ifthenelse_bug.stable.out
Log Message:
propagated changes of Thursday Feb 28 2008
from the SQL_2-22 branch to the development trunk
--- NEW FILE: ifthenelse_bug.sql ---
CREATE TABLE my_table6 (
--
my_id INT,
col1 VARCHAR(10),
col2 VARCHAR(10),
col3 VARCHAR(10)
--
) ;
CREATE TABLE my_table7 (
--
my_id INT,
col1 VARCHAR(10),
col2 VARCHAR(10),
col3 VARCHAR(10)
--
) ;
COPY 9 RECORDS INTO my_table6 FROM STDIN DELIMITERS '|','\n','' ;
10|aa||aaa
20|ab|NULL|aab
30|ac||aac
40|ad||aad
50|ae|NULL|aae
60|af||aaf
70|ag|NULL|aag
80|ah||aah
90|ai|NULL|aai
INSERT INTO my_table7 (
--
my_id,
col1,
col2,
col3
--
)
SELECT
my_id,
NULLIF(TRIM(col1),''),
NULLIF(TRIM(col2),''),
NULLIF(TRIM(col3),'')
FROM
my_table6
;
select * from my_table7;
DROP TABLE my_table6 ;
DROP TABLE my_table7 ;
Index: All
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/bugs/Tests/All,v
retrieving revision 1.109
retrieving revision 1.110
diff -u -d -r1.109 -r1.110
--- All 28 Feb 2008 15:56:46 -0000 1.109
+++ All 28 Feb 2008 20:04:14 -0000 1.110
@@ -84,3 +84,4 @@
select_not_equal
case_substring
zero_or_one_bug
+ifthenelse_bug
--- NEW FILE: ifthenelse_bug.stable.out ---
stdout of test 'ifthenelse_bug` in directory 'src/test/bugs` itself:
# 18:01:55 >
# 18:01:55 > 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=32100 --set
xrpc_port=49570 --set monet_prompt= --trace "--dbname=mTests_src_test_bugs"
--set mal_listing=0 "--dbinit= include sql;" ; echo ; echo Over..
# 18:01:55 >
# MonetDB server v5.4.0, based on kernel v1.22.0
# Serving database 'mTests_src_test_bugs'
# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically linked
# Copyright (c) 1993-2008 CWI, all rights reserved
# Visit http://monetdb.cwi.nl/ for further information
# Listening for connection requests on mapi:monetdb://koala.ins.cwi.nl:32100/
# MonetDB/SQL module v2.22.0 loaded
Ready.
#function user.main():void;
# clients.quit();
#end main;
Over..
# 18:01:55 >
# 18:01:55 > mclient -lsql -umonetdb -Pmonetdb --host=koala --port=32100
# 18:01:55 >
[ 9 ]
[ 9 ]
% sys.my_table7, sys.my_table7, sys.my_table7, sys.my_table7 #
table_name
% my_id, col1, col2, col3 # name
% int, varchar, varchar, varchar # type
% 2, 2, 1, 3 # length
[ 10, "aa", NULL, "aaa" ]
[ 20, "ab", NULL, "aab" ]
[ 30, "ac", NULL, "aac" ]
[ 40, "ad", NULL, "aad" ]
[ 50, "ae", NULL, "aae" ]
[ 60, "af", NULL, "aaf" ]
[ 70, "ag", NULL, "aag" ]
[ 80, "ah", NULL, "aah" ]
[ 90, "ai", NULL, "aai" ]
# 18:01:55 >
# 18:01:55 > Done.
# 18:01:55 >
--- NEW FILE: ifthenelse_bug.stable.err ---
stderr of test 'ifthenelse_bug` in directory 'src/test/bugs` itself:
# 18:01:55 >
# 18:01:55 > 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=32100 --set
xrpc_port=49570 --set monet_prompt= --trace "--dbname=mTests_src_test_bugs"
--set mal_listing=0 "--dbinit= include sql;" ; echo ; echo Over..
# 18:01:55 >
#warning: please don't forget to set your vault key!
#(see /ufs/niels/scratch/rc/Linux-x86_64/etc/monetdb5.conf)
# 18:01:55 >
# 18:01:55 > mclient -lsql -umonetdb -Pmonetdb --host=koala --port=32100
# 18:01:55 >
# 18:01:55 >
# 18:01:55 > Done.
# 18:01:55 >
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
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
