Update of /cvsroot/monetdb/sql/src/test/BugTracker-2010/Tests
In directory sfp-cvsdas-1.v30.ch3.sourceforge.com:/tmp/cvs-serv3276
Added Files:
Tag: Feb2010
All corrupted_values_after_updates.SF-2938065.sql
corrupted_values_after_updates.SF-2938065.stable.err
corrupted_values_after_updates.SF-2938065.stable.out
Log Message:
added test for bug showing problems with varheap
--- NEW FILE: corrupted_values_after_updates.SF-2938065.stable.err ---
stderr of test 'corrupted_values_after_updates.SF-2938065` in directory
'src/test/BugTracker-2010` itself:
# 16:27:38 >
# 16:27:38 > mserver5
"--config=/ufs/niels/scratch/rc/Linux-x86_64/etc/monetdb5.conf" --debug=10
--set gdk_nr_threads=0 --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 mapi_open=true --set xrpc_open=true --set mapi_port=33614 --set
xrpc_port=46367 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker-2010" --set mal_listing=0 "--dbinit=
include sql;" ; echo ; echo Over..
# 16:27:38 >
# builtin opt gdk_arch = 64bitx86_64-unknown-linux-gnu
# builtin opt gdk_version = 1.36.0
# 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_alloc_map = yes
# 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
# 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 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/MonetDB/merovingian.log
# config opt mero_errlog = ${prefix}/var/log/MonetDB/merovingian.log
# config opt mero_pidfile = ${prefix}/var/run/MonetDB/merovingian.pid
# config opt mero_controlport = 50001
# config opt mal_init = ${exec_prefix}/lib/MonetDB5/mal_init.mal
# config opt mal_listing = 2
# config opt mapi_port = 50000
# config opt mapi_autosense = false
# config opt mapi_open = false
# config opt sql_optimizer = mitosis_pipe
# config opt default_pipe =
inline,remap,evaluate,costModel,coercions,emptySet,aliases,mergetable,deadcode,constants,commonTerms,joinPath,deadcode,reduce,garbageCollector,dataflow,history,multiplex
# config opt replication_pipe =
inline,remap,evaluate,costModel,coercions,emptySet,aliases,mergetable,deadcode,constants,commonTerms,joinPath,deadcode,reduce,garbageCollector,dataflow,history,replication,multiplex
# config opt accumulator_pipe =
inline,remap,evaluate,costModel,coercions,emptySet,aliases,mergetable,deadcode,constants,commonTerms,joinPath,deadcode,reduce,accumulators,garbageCollector,dataflow,history,multiplex
# config opt recycler_pipe =
inline,remap,evaluate,costModel,coercions,emptySet,aliases,deadcode,constants,commonTerms,joinPath,deadcode,recycle,reduce,garbageCollector,dataflow,history,multiplex
# config opt cracker_pipe =
inline,remap,evaluate,costModel,coercions,emptySet,aliases,selcrack,deadcode,constants,commonTerms,joinPath,deadcode,reduce,garbageCollector,dataflow,history,multiplex
# config opt sidcrack_pipe =
inline,remap,evaluate,costModel,coercions,emptySet,aliases,sidcrack,deadcode,constants,commonTerms,joinPath,deadcode,reduce,garbageCollector,dataflow,history,multiplex
# config opt datacell_pipe =
inline,remap,evaluate,costModel,coercions,emptySet,aliases,deadcode,constants,commonTerms,joinPath,datacell,deadcode,reduce,garbageCollector,dataflow,history,multiplex
# config opt octopus_pipe =
inline,remap,evaluate,costModel,coercions,emptySet,aliases,mitosis,mergetable,deadcode,constants,commonTerms,joinPath,octopus,deadcode,reduce,garbageCollector,dataflow,history,multiplex
# config opt mitosis_pipe =
inline,remap,evaluate,costModel,coercions,emptySet,aliases,mitosis,mergetable,deadcode,commonTerms,joinPath,reorder,deadcode,reduce,garbageCollector,dataflow,history,multiplex
# config opt datacyclotron_pipe =
inline,remap,evaluate,costModel,coercions,emptySet,aliases,datacyclotron,mergetable,deadcode,constants,commonTerms,joinPath,reorder,deadcode,reduce,garbageCollector,dataflow,history,replication,multiplex
# config opt derive_pipe =
inline,remap,evaluate,costModel,coercions,emptySet,aliases,mergetable,deadcode,constants,commonTerms,derivePath,joinPath,deadcode,reduce,garbageCollector,dataflow,history,multiplex
# config opt dictionary_pipe =
inline,remap,dictionary,evaluate,costModel,coercions,emptySet,aliases,mergetable,deadcode,constants,commonTerms,joinPath,deadcode,reduce,garbageCollector,dataflow,history,multiplex
# cmdline opt config = /ufs/niels/scratch/rc/Linux-x86_64/etc/monetdb5.conf
# cmdline opt gdk_nr_threads = 0
# 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 mapi_open = true
# cmdline opt xrpc_open = true
# cmdline opt mapi_port = 33614
# cmdline opt xrpc_port = 46367
# cmdline opt monet_prompt =
# cmdline opt gdk_dbname = mTests_src_test_BugTracker-2010
# cmdline opt mal_listing = 0
#warning: please don't forget to set your vault key!
#(see /ufs/niels/scratch/rc/Linux-x86_64/etc/monetdb5.conf)
# 16:27:38 >
# 16:27:38 > mclient -lsql -i --host=alf --port=33614
# 16:27:38 >
# 16:27:39 >
# 16:27:39 > Done.
# 16:27:39 >
--- NEW FILE: corrupted_values_after_updates.SF-2938065.stable.out ---
stdout of test 'corrupted_values_after_updates.SF-2938065` in directory
'src/test/BugTracker-2010` itself:
# 16:27:38 >
# 16:27:38 > mserver5
"--config=/ufs/niels/scratch/rc/Linux-x86_64/etc/monetdb5.conf" --debug=10
--set gdk_nr_threads=0 --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 mapi_open=true --set xrpc_open=true --set mapi_port=33614 --set
xrpc_port=46367 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker-2010" --set mal_listing=0 "--dbinit=
include sql;" ; echo ; echo Over..
# 16:27:38 >
# MonetDB server v5.18.0, based on kernel v1.36.0
# Serving database 'mTests_src_test_BugTracker-2010', using 4 threads
# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically linked
# Found 7.754 GiB available main-memory.
# Copyright (c) 1993-July 2008 CWI.
# Copyright (c) August 2008-2010 MonetDB B.V., all rights reserved
# Visit http://monetdb.cwi.nl/ for further information
# Listening for connection requests on mapi:monetdb://alf.ins.cwi.nl:33614/
# MonetDB/SQL module v2.36.0 loaded
Ready.
#function user.main():void;
# clients.quit();
#end main;
Over..
# 16:27:38 >
# 16:27:38 > mclient -lsql -i --host=alf --port=33614
# 16:27:38 >
[ 1 ]
[ 1 ]
[ 1 ]
[ 1 ]
[ 1 ]
[ 1 ]
[ 0 ]
[ 1 ]
[ 1 ]
[ 1 ]
% sys.base, sys.base, sys.base # table_name
% value, name, state # name
% varchar, varchar, int # type
% 8, 6, 2 # length
[ "modified", "token1", -1 ]
# 16:27:39 >
# 16:27:39 > Done.
# 16:27:39 >
--- NEW FILE: All ---
corrupted_values_after_updates.SF-2938065
--- NEW FILE: corrupted_values_after_updates.SF-2938065.sql ---
CREATE TABLE change (
new_value VARCHAR(32),
old_value VARCHAR(32),
name VARCHAR(32),
PRIMARY KEY (name,old_value)
);
CREATE TABLE base (
value VARCHAR(32),
name VARCHAR(32),
state INTEGER DEFAULT 0,
PRIMARY KEY (name)
);
CREATE TABLE edit (
value VARCHAR(32),
name VARCHAR(32),
state INTEGER DEFAULT 0,
PRIMARY KEY (name)
);
INSERT
INTO base (name,value)
SELECT 'token1','initial';
INSERT
INTO edit (value,name,state)
SELECT value,name,-1
FROM base
WHERE state=0;
DELETE
FROM base
WHERE EXISTS (
SELECT true
FROM edit
WHERE base.name=edit.name
)
;
INSERT
INTO base (value,name,state)
SELECT value,name,state
FROM edit;
DELETE
FROM edit;
INSERT
INTO change (new_value,old_value,name)
SELECT 'modified','initial','token1';
INSERT
INTO edit (value,name,state)
SELECT max(
new_value
),base.name,0
FROM base,change
WHERE base.name=change.name
AND base.value=old_value
AND NOT new_value='modified'
GROUP BY base.name,state;
INSERT
INTO edit (value,name,state)
SELECT max(
new_value
),base.name,state
FROM base,change
WHERE base.name=change.name
AND base.value=old_value
AND new_value='modified'
GROUP BY base.name,state;
DELETE
FROM base
WHERE EXISTS (
SELECT true
FROM edit
WHERE base.name=edit.name
)
;
INSERT
INTO base (value,name,state)
SELECT value,name,state
FROM edit;
SELECT *
FROM base;
------------------------------------------------------------------------------
Throughout its 18-year history, RSA Conference consistently attracts the
world's best and brightest in the field, creating opportunities for Conference
attendees to learn about information security's most important issues through
interactions with peers, luminaries and emerging and established companies.
http://p.sf.net/sfu/rsaconf-dev2dev
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
