Update of /cvsroot/monetdb/sql/src/test/BugTracker/Tests
In directory
sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv32749/src/test/BugTracker/Tests
Modified Files:
All
Added Files:
copy_into_crash.SF-1993999.sql
copy_into_crash.SF-1993999.stable.err
copy_into_crash.SF-1993999.stable.out
Log Message:
propagated changes of Tuesday Jun 17 2008
from the SQL_2-24 branch to the development trunk
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2008/06/17 - nielsnes: src/test/bugs/Tests/All,1.112.2.6
src/test/bugs/Tests/reljoin_join2_bug.sql,1.1.2.1
src/test/bugs/Tests/reljoin_join2_bug.stable.err,1.1.2.1
src/test/bugs/Tests/reljoin_join2_bug.stable.out,1.1.2.1
add for bug in handling combinations of joins with different expressions and
transformation into of joins into filters
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2008/06/17 - nielsnes: src/backends/monet4/sql_gencode.mx,1.174.2.3
src/backends/monet5/sql_gencode.mx,1.275.2.3
src/server/bin_optimizer.mx,1.11.2.1 src/server/rel_bin.mx,1.42.2.3
src/server/sql_optimize.mx,1.92.2.1 src/server/sql_rel2bin.mx,1.120.2.1
src/server/sql_select.mx,1.231.2.7
src/server/sql_statement.mx,1.165.2.2
src/server/sql_updates.mx,1.138.2.2
fixed bug in handling combinations of joins where some joins needed to be
changed into filters (selects/semijoins).
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2008/06/17 - sjoerd: NT/MonetDB4-SQL/MonetDB4-SQL-Installer.vdproj,1.11.2.5
NT/MonetDB5-SQL/MonetDB5-SQL-Installer.vdproj,1.19.2.5
Updated version number.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2008/06/17 - nielsnes: src/server/rel_select.mx,1.75.2.2
fixed bug in recusive views
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2008/06/17 - sjoerd: NT/MonetDB4-SQL64/MonetDB4-SQL-Installer.vdproj,1.6.2.6
NT/MonetDB5-SQL64/MonetDB5-SQL-Installer.vdproj,1.9.2.5
Updated version numbers.
Removed JDBC jars.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2008/06/17 - nielsnes: src/test/BugTracker/Tests/All,1.93.2.12
src/test/BugTracker/Tests/copy_into_crash.SF-1993999.sql,1.1.2.1
src/test/BugTracker/Tests/copy_into_crash.SF-1993999.stable.err,1.1.2.1
src/test/BugTracker/Tests/copy_into_crash.SF-1993999.stable.out,1.1.2.1
added test for (non existing) bug
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
--- NEW FILE: copy_into_crash.SF-1993999.stable.err ---
stderr of test 'copy_into_crash.SF-1993999` in directory 'src/test/BugTracker`
itself:
# 11:28:57 >
# 11:28:57 > 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=36663 --set
xrpc_port=47072 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker" --set sql_debug=16384 --set
xquery_backend=algebra --set mal_listing=0 "--dbinit= include sql;" ; echo ;
echo Over..
# 11:28:57 >
# builtin opt gdk_arch = 64bitx86_64-unknown-linux-gnu
# builtin opt gdk_version = 1.24.0
# builtin opt monet_pid = 30882
# 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 = 36663
# cmdline opt xrpc_port = 47072
# cmdline opt monet_prompt =
# cmdline opt gdk_dbname = mTests_src_test_BugTracker
# cmdline opt sql_debug = 16384
# cmdline opt xquery_backend = algebra
# 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)
# 11:28:57 >
# 11:28:57 > mclient -lsql -umonetdb -Pmonetdb --host=alf --port=36663 -G
# 11:28:57 >
# 11:28:57 >
# 11:28:57 > Done.
# 11:28:57 >
--- NEW FILE: copy_into_crash.SF-1993999.stable.out ---
stdout of test 'copy_into_crash.SF-1993999` in directory 'src/test/BugTracker`
itself:
# 11:28:57 >
# 11:28:57 > 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=36663 --set
xrpc_port=47072 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker" --set sql_debug=16384 --set
xquery_backend=algebra --set mal_listing=0 "--dbinit= include sql;" ; echo ;
echo Over..
# 11:28:57 >
# 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:36663/
# MonetDB/SQL module v2.24.0 loaded
Ready.
# falling back to direct mode
# falling back to direct mode
# falling back to direct mode
#function user.main():void;
# clients.quit();
#end main;
Over..
# 11:28:57 >
# 11:28:57 > mclient -lsql -umonetdb -Pmonetdb --host=alf --port=36663 -G
# 11:28:57 >
[ 1 ]
# 11:28:57 >
# 11:28:57 > Done.
# 11:28:57 >
Index: All
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/BugTracker/Tests/All,v
retrieving revision 1.99
retrieving revision 1.100
diff -u -d -r1.99 -r1.100
--- All 16 Jun 2008 09:23:27 -0000 1.99
+++ All 17 Jun 2008 10:35:13 -0000 1.100
@@ -130,3 +130,4 @@
schema_from_declared_table.SF-1983341
proc_insert_into.SF-1958572
nested_views_algebra_version.SF-1993765
+copy_into_crash.SF-1993999
--- NEW FILE: copy_into_crash.SF-1993999.sql ---
CREATE TABLE PlateX(
plateID bigint NOT NULL,
spRerun int NOT NULL,
mjd int NOT NULL,
plate smallint NOT NULL,
tile smallint NOT NULL,
mapMjd int NOT NULL,
nExp smallint NOT NULL,
tai real NOT NULL,
raBoresight float NOT NULL,
decBoresight float NOT NULL,
taiHMS varchar(64) NOT NULL,
expTime real NOT NULL,
expTimeB1 real NOT NULL,
expTimeB2 real NOT NULL,
expTimeR1 real NOT NULL,
expTimeR2 real NOT NULL,
helioRV real NOT NULL,
ra real NOT NULL,
"dec" real NOT NULL,
cx float NOT NULL,
cy float NOT NULL,
cz float NOT NULL,
htmID bigint NOT NULL,
sn1_0 real NOT NULL,
sn1_1 real NOT NULL,
sn1_2 real NOT NULL,
sn2_0 real NOT NULL,
sn2_1 real NOT NULL,
sn2_2 real NOT NULL,
dateObs varchar(12) NOT NULL,
timeSys varchar(8) NOT NULL,
quality varchar(12) NOT NULL,
name varchar(32) NOT NULL,
program varchar(16) NOT NULL,
version varchar(64) NOT NULL,
observer varchar(64) NOT NULL,
camVer varchar(64) NOT NULL,
spec2DVer varchar(64) NOT NULL,
utilsVer varchar(64) NOT NULL,
spec1DVer varchar(64) NOT NULL,
readVer varchar(64) NOT NULL,
combVer varchar(64) NOT NULL,
extinction_u real NOT NULL,
extinction_g real NOT NULL,
extinction_r real NOT NULL,
extinction_i real NOT NULL,
extinction_z real NOT NULL,
rOffset1 real NOT NULL,
rSigma1 real NOT NULL,
grOff1 real NOT NULL,
grSigma1 real NOT NULL,
rOffset2 real NOT NULL,
rSigma2 real NOT NULL,
grOff2 real NOT NULL,
grSigma2 real NOT NULL,
sfd_used tinyint NOT NULL,
xygrSig1 real NOT NULL,
xygrSig2 real NOT NULL,
mpgrSig1 real NOT NULL,
mpgrSig2 real NOT NULL,
mpgrOff1 real NOT NULL,
mpgrOff2 real NOT NULL,
isPrimary tinyint NOT NULL,
cartridgeID smallint NOT NULL,
plateVersion varchar(32) NOT NULL,
haMin real NOT NULL,
haMax real NOT NULL,
mjdDesign int NOT NULL,
theta real NOT NULL,
fscanVersion varchar(32) NOT NULL,
fmapVersion varchar(32) NOT NULL,
fscanMode varchar(32) NOT NULL,
fscanSpeed int NOT NULL,
programType int NOT NULL,
programName varchar(32) NOT NULL,
loadVersion int NOT NULL,
expID blob NULL,
CONSTRAINT pk_PlateX_plateID PRIMARY KEY
(
plateID
)
);
COPY 1 RECORDS INTO PlateX from STDIN USING DELIMITERS '\t', '\n';
238071330002436096 25 52381 845 616 5237901 12
4.5257452E+9 188.11953 4.9431539999999998 07:03:56.30 3124.0
3.0 3.0 3.0 3.0 10.410612 188.1192 4.9424138
-0.98629544768999999 -0.14070785053962101 8.6154458169632603E-2
14906400923706 19.139601 18.403 15.7439 20.577999 20.612301
17.4648 2000-09-01 tai excellent 0845-52379-01 binning
1 1 v3_74_0 harvanek SPEC1 v4_7 v5_3_3 v5_2_0
v5_10_4 v5_3_3 v5_3_2 0.1138 8.3800003E-2
6.0699999E-2 4.6100002E-2 3.2699998E-2 -9999.0 -9999.0 -9999.0 -9999.0
-9999.0 -9999.0 -9999.0 -9999.0 0 -9999.0 -9999.0 -9999.0 -9999.0 -9999.0
-9999.0 1 6 v3_6 6.0 6.0 52336 0.0 0 v4_1_0
extreme 500 0 chunk32 28
4664C8005664D8004664CC005664D8004664D0005664D800580000005664D800580000005664D800580000005664D800578000005664D800578000005664D800578000005664D800584000005664D800584000005664D800584000005664D800
drop table PlateX;
-------------------------------------------------------------------------
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
