Update of /cvsroot/monetdb/sql/src/test/BugTracker/Tests
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv30525
Modified Files:
Tag: SQL_2-24
All
Added Files:
Tag: SQL_2-24
proc_insert_into.SF-1958572.sql
proc_insert_into.SF-1958572.stable.err
proc_insert_into.SF-1958572.stable.out
Log Message:
test for procedure insert_into bug
U All
Index: All
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/BugTracker/Tests/All,v
retrieving revision 1.93.2.8
retrieving revision 1.93.2.9
diff -u -d -r1.93.2.8 -r1.93.2.9
--- All 3 Jun 2008 11:50:19 -0000 1.93.2.8
+++ All 4 Jun 2008 20:16:57 -0000 1.93.2.9
@@ -128,3 +128,4 @@
set_a_new_user_password.SF-1844050
select_crashes_in_the_optimization.SF-1848553
schema_from_declared_table.SF-1983341
+proc_insert_into.SF-1958572
--- NEW FILE: proc_insert_into.SF-1958572.sql ---
create sequence "ff" as integer start with 1;
CREATE TABLE t1(timeid INT DEFAULT NEXT VALUE FOR "ff" PRIMARY KEY, a INT, b
INT, c INT, d INT, e INT, f VARCHAR(20), g VARCHAR(20), h INT, i VARCHAR(10), j
VARCHAR(10), k VARCHAR(10), l INT, m INT, n VARCHAR(10), o VARCHAR(10), p
VARCHAR(10), q VARCHAR(15), r INT);
insert into t1(a, b, c, d, e, f, g, h, i, j, k, l, m, n, o, p, q, r) values(1,
1, 1, 1, 1, 'first row', 'first row',1, 'first row', 'first row', 'first
row',1,1, 'first row', 'first row', 'first row', 'first row', 1);
select * from t1;
insert into t1(a, b, c, d, e, f, g, h) select a, b, c, d, e, f, g, h from t1
where timeid = 1;
select * from t1;
create procedure tt()
begin
insert into t1(a, b, c, d, e, f, g, h) select a, b, c, d, e, f, g, h
from t1 where timeid = 1;
end;
call tt();
call tt();
call tt();
call tt();
select * from t1;
select count(*) from t1;
select timeid from t1;
select * from t1;
drop procedure tt;
drop table t1;
drop sequence ff;
--- NEW FILE: proc_insert_into.SF-1958572.stable.err ---
stderr of test 'proc_insert_into.SF-1958572` in directory 'src/test/BugTracker`
itself:
# 22:15:00 >
# 22:15:00 > 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=31825 --set
xrpc_port=47897 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker" --set mal_listing=0 "--dbinit= include
sql;" ; echo ; echo Over..
# 22:15:00 >
# builtin opt gdk_arch = 64bitx86_64-unknown-linux-gnu
# builtin opt gdk_version = 1.24.0
# builtin opt monet_pid = 1742
# builtin opt prefix = /ufs/niels/scratch/rc/Linux-x86_64
# builtin opt exec_prefix = ${prefix}
# builtin opt gdk_dbname = tst
# builtin opt gdk_dbfarm = ${prefix}/var/MonetDB
# builtin opt gdk_debug = 8
# builtin opt gdk_mem_bigsize = 262144
# builtin opt gdk_alloc_map = yes
# builtin opt gdk_mem_pagebits = 14
# builtin opt gdk_vmtrim = yes
# builtin opt monet_admin = adm
# builtin opt monet_prompt = >
# builtin opt monet_welcome = yes
# builtin opt monet_mod_path =
${exec_prefix}/lib/MonetDB:${exec_prefix}/lib/bin
# builtin opt monet_daemon = yes
# builtin opt host = localhost
# builtin opt mapi_port = 50000
# builtin opt mapi_noheaders = no
# builtin opt mapi_debug = 0
# builtin opt mapi_clients = 2
# builtin opt sql_debug = 0
# builtin opt sql_logdir = ${prefix}/var/MonetDB/sql_logs
# builtin opt xquery_logdir = ${prefix}/var/MonetDB/xquery_logs
# builtin opt standoff_ns = http://monetdb.cwi.nl/standoff
# builtin opt standoff_start = start
# builtin opt standoff_end = end
# config opt prefix = /ufs/niels/scratch/rc/Linux-x86_64
# config opt config = ${prefix}/etc/monetdb5.conf
# config opt prefix = /ufs/niels/scratch/rc/Linux-x86_64
# config opt exec_prefix = ${prefix}
# config opt gdk_dbfarm = ${prefix}/var/MonetDB5/dbfarm
# config opt gdk_dbname = demo
# config opt gdk_alloc_map = no
# config opt gdk_embedded = no
# config opt gdk_debug = 0
# config opt monet_mod_path =
${exec_prefix}/lib/MonetDB5:${exec_prefix}/lib/MonetDB5/lib:${exec_prefix}/lib/MonetDB5/bin
# config opt monet_daemon = no
# config opt monet_welcome = yes
# config opt mero_msglog = ${prefix}/var/log/merovingian.log
# config opt mero_errlog = ${prefix}/var/log/merovingian.log
# config opt mero_timeinterval = 600
# config opt mero_pidfile = ${prefix}/var/run/merovingian.pid
# config opt mero_exittimeout = 7
# config opt mero_doproxy = yes
# config opt mero_discoveryttl = 600
# config opt mal_init = ${exec_prefix}/lib/MonetDB5/mal_init.mal
# config opt mal_listing = 15
# config opt checkpoint_dir = ${prefix}/var/MonetDB5/chkpnt
# config opt mapi_port = 50000
# config opt mapi_open = false
# config opt sql_debug = 0
# config opt sql_logdir = ${prefix}/var/MonetDB5/sql_logs
# config opt sql_init = ${exec_prefix}/lib/MonetDB5/sql_init.sql
# cmdline opt config = /ufs/niels/scratch/rc/Linux-x86_64/etc/monetdb5.conf
# cmdline opt 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
# cmdline opt gdk_dbfarm =
/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB5/dbfarm
# cmdline opt sql_logdir =
/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB5/sql_logs
# cmdline opt mapi_open = true
# cmdline opt xrpc_open = true
# cmdline opt mapi_port = 31825
# cmdline opt xrpc_port = 47897
# cmdline opt monet_prompt =
# cmdline opt gdk_dbname = mTests_src_test_BugTracker
# cmdline opt mal_listing = 0
# cmdline opt gdk_debug = 10
#warning: please don't forget to set your vault key!
#(see /ufs/niels/scratch/rc/Linux-x86_64/etc/monetdb5.conf)
# 22:15:00 >
# 22:15:00 > mclient -lsql -umonetdb -Pmonetdb --host=alf --port=31825
# 22:15:00 >
# 22:15:00 >
# 22:15:00 > Done.
# 22:15:00 >
--- NEW FILE: proc_insert_into.SF-1958572.stable.out ---
stdout of test 'proc_insert_into.SF-1958572` in directory 'src/test/BugTracker`
itself:
# 22:15:00 >
# 22:15:00 > 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=31825 --set
xrpc_port=47897 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker" --set mal_listing=0 "--dbinit= include
sql;" ; echo ; echo Over..
# 22:15:00 >
# MonetDB server v5.6.0, based on kernel v1.24.0
# Serving database 'mTests_src_test_BugTracker'
# 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://alf.ins.cwi.nl:31825/
# MonetDB/SQL module v2.24.0 loaded
Ready.
#function user.main():void;
# clients.quit();
#end main;
Over..
# 22:15:00 >
# 22:15:00 > mclient -lsql -umonetdb -Pmonetdb --host=alf --port=31825
# 22:15:00 >
[ 1 ]
% sys.t1, sys.t1, sys.t1, sys.t1, sys.t1, sys.t1, sys.t1, sys.t1, sys.t1,
sys.t1, sys.t1, sys.t1, sys.t1, sys.t1, sys.t1, sys.t1, sys.t1, sys.t1, sys.t1
# table_name
% timeid, a, b, c, d, e, f, g, h,
i, j, k, l, m, n, o, p, q, r # name
% int, int, int, int, int, int, varchar, varchar,
int, varchar, varchar, varchar, int, int,
varchar, varchar, varchar, varchar, int # type
% 1, 1, 1, 1, 1, 1, 9, 9, 1, 9,
9, 9, 1, 1, 9, 9, 9, 9, 1 # length
[ 1, 1, 1, 1, 1, 1, "first row", "first row",
1, "first row", "first row", "first row", 1, 1, "first
row", "first row", "first row", "first row", 1 ]
[ 1 ]
% sys.t1, sys.t1, sys.t1, sys.t1, sys.t1, sys.t1, sys.t1, sys.t1, sys.t1,
sys.t1, sys.t1, sys.t1, sys.t1, sys.t1, sys.t1, sys.t1, sys.t1, sys.t1, sys.t1
# table_name
% timeid, a, b, c, d, e, f, g, h,
i, j, k, l, m, n, o, p, q, r # name
% int, int, int, int, int, int, varchar, varchar,
int, varchar, varchar, varchar, int, int,
varchar, varchar, varchar, varchar, int # type
% 1, 1, 1, 1, 1, 1, 9, 9, 1, 9,
9, 9, 1, 1, 9, 9, 9, 9, 1 # length
[ 1, 1, 1, 1, 1, 1, "first row", "first row",
1, "first row", "first row", "first row", 1, 1, "first
row", "first row", "first row", "first row", 1 ]
[ 2, 1, 1, 1, 1, 1, "first row", "first row",
1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL ]
[ 1 ]
[ 1 ]
[ 1 ]
[ 1 ]
% sys.t1, sys.t1, sys.t1, sys.t1, sys.t1, sys.t1, sys.t1, sys.t1, sys.t1,
sys.t1, sys.t1, sys.t1, sys.t1, sys.t1, sys.t1, sys.t1, sys.t1, sys.t1, sys.t1
# table_name
% timeid, a, b, c, d, e, f, g, h,
i, j, k, l, m, n, o, p, q, r # name
% int, int, int, int, int, int, varchar, varchar,
int, varchar, varchar, varchar, int, int,
varchar, varchar, varchar, varchar, int # type
% 1, 1, 1, 1, 1, 1, 9, 9, 1, 9,
9, 9, 1, 1, 9, 9, 9, 9, 1 # length
[ 1, 1, 1, 1, 1, 1, "first row", "first row",
1, "first row", "first row", "first row", 1, 1, "first
row", "first row", "first row", "first row", 1 ]
[ 2, 1, 1, 1, 1, 1, "first row", "first row",
1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL ]
[ 3, 1, 1, 1, 1, 1, "first row", "first row",
1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL ]
[ 4, 1, 1, 1, 1, 1, "first row", "first row",
1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL ]
[ 5, 1, 1, 1, 1, 1, "first row", "first row",
1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL ]
[ 6, 1, 1, 1, 1, 1, "first row", "first row",
1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL ]
% sys. # table_name
% count_ # name
% int # type
% 1 # length
[ 6 ]
% sys.t1 # table_name
% timeid # name
% int # type
% 1 # length
[ 1 ]
[ 2 ]
[ 3 ]
[ 4 ]
[ 5 ]
[ 6 ]
% sys.t1, sys.t1, sys.t1, sys.t1, sys.t1, sys.t1, sys.t1, sys.t1, sys.t1,
sys.t1, sys.t1, sys.t1, sys.t1, sys.t1, sys.t1, sys.t1, sys.t1, sys.t1, sys.t1
# table_name
% timeid, a, b, c, d, e, f, g, h,
i, j, k, l, m, n, o, p, q, r # name
% int, int, int, int, int, int, varchar, varchar,
int, varchar, varchar, varchar, int, int,
varchar, varchar, varchar, varchar, int # type
% 1, 1, 1, 1, 1, 1, 9, 9, 1, 9,
9, 9, 1, 1, 9, 9, 9, 9, 1 # length
[ 1, 1, 1, 1, 1, 1, "first row", "first row",
1, "first row", "first row", "first row", 1, 1, "first
row", "first row", "first row", "first row", 1 ]
[ 2, 1, 1, 1, 1, 1, "first row", "first row",
1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL ]
[ 3, 1, 1, 1, 1, 1, "first row", "first row",
1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL ]
[ 4, 1, 1, 1, 1, 1, "first row", "first row",
1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL ]
[ 5, 1, 1, 1, 1, 1, "first row", "first row",
1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL ]
[ 6, 1, 1, 1, 1, 1, "first row", "first row",
1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL ]
# 22:15:00 >
# 22:15:00 > Done.
# 22:15:00 >
-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
