Update of /cvsroot/monetdb/sql/src/test/BugTracker-2009/Tests
In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv21982
Modified Files:
Tag: Aug2009
All
Added Files:
Tag: Aug2009
updating_non-loaded_columns.SF-2864313.data
updating_non-loaded_columns.SF-2864313_KO-1.sql.in
updating_non-loaded_columns.SF-2864313_KO-1.stable.err
updating_non-loaded_columns.SF-2864313_KO-1.stable.out
updating_non-loaded_columns.SF-2864313_KO-2.sql.in
updating_non-loaded_columns.SF-2864313_KO-2.stable.err
updating_non-loaded_columns.SF-2864313_KO-2.stable.out
updating_non-loaded_columns.SF-2864313_KO-3.sql.in
updating_non-loaded_columns.SF-2864313_KO-3.stable.err
updating_non-loaded_columns.SF-2864313_KO-3.stable.out
updating_non-loaded_columns.SF-2864313_OK-0.sql.in
updating_non-loaded_columns.SF-2864313_OK-0.stable.err
updating_non-loaded_columns.SF-2864313_OK-0.stable.out
updating_non-loaded_columns.SF-2864313_OK-4.sql.in
updating_non-loaded_columns.SF-2864313_OK-4.stable.err
updating_non-loaded_columns.SF-2864313_OK-4.stable.out
Log Message:
added test for
ID: 2864313 "SQL: Update changes all columns with same type and default"
https://sourceforge.net/tracker/?func=detail&aid=2864313&group_id=56967&atid=482468
--- NEW FILE: updating_non-loaded_columns.SF-2864313_KO-2.sql.in ---
CREATE TABLE "t0" (
"d0" double
);
CREATE TABLE "t1" (
"d1" double,
"v1" varchar(255) default '',
"v2" varchar(255) default ''
);
COPY 1025 RECORDS INTO t0 FROM
'$TSTSRCDIR/updating_non-loaded_columns.SF-2864313.data' USING DELIMITERS
'\t';
select count(*) from t0;
INSERT INTO t1 (d1) SELECT d0 FROM t0;
select count(*) from t1;
select d1, v2, v1 from t1 limit 1;
Update t1 Set v2 = 'AA';
select d1, v2, v1 from t1 limit 1;
Update t1 Set d1 = -1.2;
select d1, v2, v1 from t1 limit 1;
Update t1 Set v1 = 'BB';
select d1, v2, v1 from t1 limit 1;
drop table t1;
drop table t0;
--- NEW FILE: updating_non-loaded_columns.SF-2864313_KO-2.stable.out ---
stdout of test 'updating_non-loaded_columns.SF-2864313_KO-2` in directory
'src/test/BugTracker-2009` itself:
# 15:32:36 >
# 15:32:36 > mserver5
"--config=/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/etc/monetdb5.conf"
--debug=10 --set gdk_nr_threads=0 --set
"monet_mod_path=/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB5:/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB5/lib:/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB5/bin"
--set
"gdk_dbfarm=/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/var/MonetDB5/dbfarm"
--set mapi_open=true --set xrpc_open=true --set mapi_port=38343 --set
xrpc_port=40609 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker-2009" --set mal_listing=0 "--dbinit=
include sql;" ; echo ; echo Over..
# 15:32:36 >
# MonetDB server v5.14.1, based on kernel v1.32.1
# Serving database 'mTests_src_test_BugTracker-2009', using 4 threads
# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically linked
# Copyright (c) 1993-July 2008 CWI.
# Copyright (c) August 2008-2009 MonetDB B.V., all rights reserved
# Visit http://monetdb.cwi.nl/ for further information
# Listening for connection requests on mapi:monetdb://rig.ins.cwi.nl:38343/
# MonetDB/SQL module v2.32.1 loaded
Ready.
#function user.main():void;
# clients.quit();
#end main;
Over..
# 15:32:36 >
# 15:32:36 > mclient -lsql -umonetdb -Pmonetdb --host=rig --port=38343
# 15:32:36 >
[ 1025 ]
% sys.t0 # table_name
% L1 # name
% wrd # type
% 4 # length
[ 1025 ]
[ 1025 ]
% sys.t1 # table_name
% L2 # name
% wrd # type
% 4 # length
[ 1025 ]
% sys.t1, sys.t1, sys.t1 # table_name
% d1, v2, v1 # name
% double, varchar, varchar # type
% 22, 0, 0 # length
[ 0, NULL, NULL ]
[ 1025 ]
% sys.t1, sys.t1, sys.t1 # table_name
% d1, v2, v1 # name
% double, varchar, varchar # type
% 22, 2, 0 # length
[ 0, "AA", NULL ]
[ 1025 ]
% sys.t1, sys.t1, sys.t1 # table_name
% d1, v2, v1 # name
% double, varchar, varchar # type
% 22, 2, 0 # length
[ -1.2, "AA", NULL ]
[ 1025 ]
% sys.t1, sys.t1, sys.t1 # table_name
% d1, v2, v1 # name
% double, varchar, varchar # type
% 22, 2, 2 # length
[ -1.2, "AA", "BB" ]
# 15:32:36 >
# 15:32:36 > Done.
# 15:32:36 >
--- NEW FILE: updating_non-loaded_columns.SF-2864313_OK-4.stable.err ---
stderr of test 'updating_non-loaded_columns.SF-2864313_OK-4` in directory
'src/test/BugTracker-2009` itself:
# 15:32:36 >
# 15:32:36 > mserver5
"--config=/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/etc/monetdb5.conf"
--debug=10 --set gdk_nr_threads=0 --set
"monet_mod_path=/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB5:/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB5/lib:/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB5/bin"
--set
"gdk_dbfarm=/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/var/MonetDB5/dbfarm"
--set mapi_open=true --set xrpc_open=true --set mapi_port=38343 --set
xrpc_port=40609 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker-2009" --set mal_listing=0 "--dbinit=
include sql;" ; echo ; echo Over..
# 15:32:36 >
# builtin opt gdk_arch = 64bitx86_64-unknown-linux-gnu
# builtin opt gdk_version = 1.32.0
# builtin opt prefix =
/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert
# 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}/lib64/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/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert
# config opt config = ${prefix}/etc/monetdb5.conf
# config opt prefix =
/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert
# 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}/lib64/MonetDB5:${exec_prefix}/lib64/MonetDB5/lib:${exec_prefix}/lib64/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 mal_init = ${exec_prefix}/lib64/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 =
inline,remap,evaluate,costModel,coercions,emptySet,aliases,mergetable,deadcode,constants,commonTerms,joinPath,deadcode,reduce,garbageCollector,dataflow,history,multiplex
# cmdline opt config =
/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/etc/monetdb5.conf
# cmdline opt gdk_nr_threads = 0
# cmdline opt monet_mod_path =
/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB5:/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB5/lib:/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB5/bin
# cmdline opt gdk_dbfarm =
/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/var/MonetDB5/dbfarm
# cmdline opt mapi_open = true
# cmdline opt xrpc_open = true
# cmdline opt mapi_port = 38343
# cmdline opt xrpc_port = 40609
# cmdline opt monet_prompt =
# cmdline opt gdk_dbname = mTests_src_test_BugTracker-2009
# cmdline opt mal_listing = 0
#warning: please don't forget to set your vault key!
#(see
/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/etc/monetdb5.conf)
# 15:32:36 >
# 15:32:36 > mclient -lsql -umonetdb -Pmonetdb --host=rig --port=38343
# 15:32:36 >
# 15:32:36 >
# 15:32:36 > Done.
# 15:32:36 >
--- NEW FILE: updating_non-loaded_columns.SF-2864313_KO-1.stable.err ---
stderr of test 'updating_non-loaded_columns.SF-2864313_KO-1` in directory
'src/test/BugTracker-2009` itself:
# 15:32:36 >
# 15:32:36 > mserver5
"--config=/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/etc/monetdb5.conf"
--debug=10 --set gdk_nr_threads=0 --set
"monet_mod_path=/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB5:/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB5/lib:/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB5/bin"
--set
"gdk_dbfarm=/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/var/MonetDB5/dbfarm"
--set mapi_open=true --set xrpc_open=true --set mapi_port=38343 --set
xrpc_port=40609 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker-2009" --set mal_listing=0 "--dbinit=
include sql;" ; echo ; echo Over..
# 15:32:36 >
# builtin opt gdk_arch = 64bitx86_64-unknown-linux-gnu
# builtin opt gdk_version = 1.32.0
# builtin opt prefix =
/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert
# 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}/lib64/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/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert
# config opt config = ${prefix}/etc/monetdb5.conf
# config opt prefix =
/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert
# 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}/lib64/MonetDB5:${exec_prefix}/lib64/MonetDB5/lib:${exec_prefix}/lib64/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 mal_init = ${exec_prefix}/lib64/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 =
inline,remap,evaluate,costModel,coercions,emptySet,aliases,mergetable,deadcode,constants,commonTerms,joinPath,deadcode,reduce,garbageCollector,dataflow,history,multiplex
# cmdline opt config =
/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/etc/monetdb5.conf
# cmdline opt gdk_nr_threads = 0
# cmdline opt monet_mod_path =
/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB5:/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB5/lib:/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB5/bin
# cmdline opt gdk_dbfarm =
/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/var/MonetDB5/dbfarm
# cmdline opt mapi_open = true
# cmdline opt xrpc_open = true
# cmdline opt mapi_port = 38343
# cmdline opt xrpc_port = 40609
# cmdline opt monet_prompt =
# cmdline opt gdk_dbname = mTests_src_test_BugTracker-2009
# cmdline opt mal_listing = 0
#warning: please don't forget to set your vault key!
#(see
/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/etc/monetdb5.conf)
# 15:32:36 >
# 15:32:36 > mclient -lsql -umonetdb -Pmonetdb --host=rig --port=38343
# 15:32:36 >
# 15:32:36 >
# 15:32:36 > Done.
# 15:32:36 >
--- NEW FILE: updating_non-loaded_columns.SF-2864313_OK-0.sql.in ---
CREATE TABLE "t0" (
"d0" double
);
CREATE TABLE "t1" (
"d1" double,
"v1" varchar(255),
"v2" varchar(255)
);
COPY 1024 RECORDS INTO t0 FROM
'$TSTSRCDIR/updating_non-loaded_columns.SF-2864313.data' USING DELIMITERS
'\t';
select count(*) from t0;
INSERT INTO t1 (d1) SELECT d0 FROM t0;
select count(*) from t1;
select d1, v2, v1 from t1 limit 1;
Update t1 Set v2 = 'AA';
select d1, v2, v1 from t1 limit 1;
Update t1 Set d1 = -1.2;
select d1, v2, v1 from t1 limit 1;
Update t1 Set v1 = 'BB';
select d1, v2, v1 from t1 limit 1;
drop table t1;
drop table t0;
--- NEW FILE: updating_non-loaded_columns.SF-2864313_KO-3.sql.in ---
CREATE TABLE "t0" (
"d0" double
);
CREATE TABLE "t1" (
"d1" double,
"v1" varchar(255) default 'x',
"v2" varchar(255) default 'x'
);
COPY 1025 RECORDS INTO t0 FROM
'$TSTSRCDIR/updating_non-loaded_columns.SF-2864313.data' USING DELIMITERS
'\t';
select count(*) from t0;
INSERT INTO t1 (d1) SELECT d0 FROM t0;
select count(*) from t1;
select d1, v2, v1 from t1 limit 1;
Update t1 Set v2 = 'AA';
select d1, v2, v1 from t1 limit 1;
Update t1 Set d1 = -1.2;
select d1, v2, v1 from t1 limit 1;
Update t1 Set v1 = 'BB';
select d1, v2, v1 from t1 limit 1;
drop table t1;
drop table t0;
--- NEW FILE: updating_non-loaded_columns.SF-2864313_KO-3.stable.out ---
stdout of test 'updating_non-loaded_columns.SF-2864313_KO-3` in directory
'src/test/BugTracker-2009` itself:
# 15:32:36 >
# 15:32:36 > mserver5
"--config=/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/etc/monetdb5.conf"
--debug=10 --set gdk_nr_threads=0 --set
"monet_mod_path=/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB5:/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB5/lib:/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB5/bin"
--set
"gdk_dbfarm=/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/var/MonetDB5/dbfarm"
--set mapi_open=true --set xrpc_open=true --set mapi_port=38343 --set
xrpc_port=40609 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker-2009" --set mal_listing=0 "--dbinit=
include sql;" ; echo ; echo Over..
# 15:32:36 >
# MonetDB server v5.14.1, based on kernel v1.32.1
# Serving database 'mTests_src_test_BugTracker-2009', using 4 threads
# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically linked
# Copyright (c) 1993-July 2008 CWI.
# Copyright (c) August 2008-2009 MonetDB B.V., all rights reserved
# Visit http://monetdb.cwi.nl/ for further information
# Listening for connection requests on mapi:monetdb://rig.ins.cwi.nl:38343/
# MonetDB/SQL module v2.32.1 loaded
Ready.
#function user.main():void;
# clients.quit();
#end main;
Over..
# 15:32:36 >
# 15:32:36 > mclient -lsql -umonetdb -Pmonetdb --host=rig --port=38343
# 15:32:36 >
[ 1025 ]
% sys.t0 # table_name
% L1 # name
% wrd # type
% 4 # length
[ 1025 ]
[ 1025 ]
% sys.t1 # table_name
% L2 # name
% wrd # type
% 4 # length
[ 1025 ]
% sys.t1, sys.t1, sys.t1 # table_name
% d1, v2, v1 # name
% double, varchar, varchar # type
% 22, 0, 0 # length
[ 0, NULL, NULL ]
[ 1025 ]
% sys.t1, sys.t1, sys.t1 # table_name
% d1, v2, v1 # name
% double, varchar, varchar # type
% 22, 2, 0 # length
[ 0, "AA", NULL ]
[ 1025 ]
% sys.t1, sys.t1, sys.t1 # table_name
% d1, v2, v1 # name
% double, varchar, varchar # type
% 22, 2, 0 # length
[ -1.2, "AA", NULL ]
[ 1025 ]
% sys.t1, sys.t1, sys.t1 # table_name
% d1, v2, v1 # name
% double, varchar, varchar # type
% 22, 2, 2 # length
[ -1.2, "AA", "BB" ]
# 15:32:36 >
# 15:32:36 > Done.
# 15:32:36 >
--- NEW FILE: updating_non-loaded_columns.SF-2864313.data ---
0.0000000000
0.0000000000
0.0000000000
0.0000000000
0.0000000000
0.0000000000
0.0000000000
0.0000000000
0.0000000000
0.0000000000
0.0000000000
0.0000000000
0.0000000000
0.0000000000
0.0000000000
0.0000000000
0.0000000000
0.0000000000
0.0000000000
[...986 lines suppressed...]
0.0000000000
0.0000000000
0.0000000000
0.0000000000
0.0000000000
0.0000000000
0.0000000000
0.0000000000
0.0000000000
0.0000000000
0.0000000000
0.0000000000
0.0000000000
0.0000000000
0.0000000000
0.0000000000
0.0000000000
0.0000000000
0.0000000000
0.0000000000
--- NEW FILE: updating_non-loaded_columns.SF-2864313_KO-1.sql.in ---
CREATE TABLE "t0" (
"d0" double
);
CREATE TABLE "t1" (
"d1" double,
"v1" varchar(255),
"v2" varchar(255)
);
COPY 1025 RECORDS INTO t0 FROM
'$TSTSRCDIR/updating_non-loaded_columns.SF-2864313.data' USING DELIMITERS
'\t';
select count(*) from t0;
INSERT INTO t1 (d1) SELECT d0 FROM t0;
select count(*) from t1;
select d1, v2, v1 from t1 limit 1;
Update t1 Set v2 = 'AA';
select d1, v2, v1 from t1 limit 1;
Update t1 Set d1 = -1.2;
select d1, v2, v1 from t1 limit 1;
Update t1 Set v1 = 'BB';
select d1, v2, v1 from t1 limit 1;
drop table t1;
drop table t0;
--- NEW FILE: updating_non-loaded_columns.SF-2864313_KO-3.stable.err ---
stderr of test 'updating_non-loaded_columns.SF-2864313_KO-3` in directory
'src/test/BugTracker-2009` itself:
# 15:32:36 >
# 15:32:36 > mserver5
"--config=/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/etc/monetdb5.conf"
--debug=10 --set gdk_nr_threads=0 --set
"monet_mod_path=/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB5:/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB5/lib:/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB5/bin"
--set
"gdk_dbfarm=/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/var/MonetDB5/dbfarm"
--set mapi_open=true --set xrpc_open=true --set mapi_port=38343 --set
xrpc_port=40609 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker-2009" --set mal_listing=0 "--dbinit=
include sql;" ; echo ; echo Over..
# 15:32:36 >
# builtin opt gdk_arch = 64bitx86_64-unknown-linux-gnu
# builtin opt gdk_version = 1.32.0
# builtin opt prefix =
/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert
# 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}/lib64/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/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert
# config opt config = ${prefix}/etc/monetdb5.conf
# config opt prefix =
/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert
# 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}/lib64/MonetDB5:${exec_prefix}/lib64/MonetDB5/lib:${exec_prefix}/lib64/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 mal_init = ${exec_prefix}/lib64/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 =
inline,remap,evaluate,costModel,coercions,emptySet,aliases,mergetable,deadcode,constants,commonTerms,joinPath,deadcode,reduce,garbageCollector,dataflow,history,multiplex
# cmdline opt config =
/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/etc/monetdb5.conf
# cmdline opt gdk_nr_threads = 0
# cmdline opt monet_mod_path =
/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB5:/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB5/lib:/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB5/bin
# cmdline opt gdk_dbfarm =
/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/var/MonetDB5/dbfarm
# cmdline opt mapi_open = true
# cmdline opt xrpc_open = true
# cmdline opt mapi_port = 38343
# cmdline opt xrpc_port = 40609
# cmdline opt monet_prompt =
# cmdline opt gdk_dbname = mTests_src_test_BugTracker-2009
# cmdline opt mal_listing = 0
#warning: please don't forget to set your vault key!
#(see
/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/etc/monetdb5.conf)
# 15:32:36 >
# 15:32:36 > mclient -lsql -umonetdb -Pmonetdb --host=rig --port=38343
# 15:32:36 >
# 15:32:36 >
# 15:32:36 > Done.
# 15:32:36 >
--- NEW FILE: updating_non-loaded_columns.SF-2864313_OK-0.stable.err ---
stderr of test 'updating_non-loaded_columns.SF-2864313_OK-0` in directory
'src/test/BugTracker-2009` itself:
# 15:32:36 >
# 15:32:36 > mserver5
"--config=/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/etc/monetdb5.conf"
--debug=10 --set gdk_nr_threads=0 --set
"monet_mod_path=/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB5:/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB5/lib:/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB5/bin"
--set
"gdk_dbfarm=/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/var/MonetDB5/dbfarm"
--set mapi_open=true --set xrpc_open=true --set mapi_port=38343 --set
xrpc_port=40609 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker-2009" --set mal_listing=0 "--dbinit=
include sql;" ; echo ; echo Over..
# 15:32:36 >
# builtin opt gdk_arch = 64bitx86_64-unknown-linux-gnu
# builtin opt gdk_version = 1.32.0
# builtin opt prefix =
/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert
# 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}/lib64/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/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert
# config opt config = ${prefix}/etc/monetdb5.conf
# config opt prefix =
/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert
# 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}/lib64/MonetDB5:${exec_prefix}/lib64/MonetDB5/lib:${exec_prefix}/lib64/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 mal_init = ${exec_prefix}/lib64/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 =
inline,remap,evaluate,costModel,coercions,emptySet,aliases,mergetable,deadcode,constants,commonTerms,joinPath,deadcode,reduce,garbageCollector,dataflow,history,multiplex
# cmdline opt config =
/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/etc/monetdb5.conf
# cmdline opt gdk_nr_threads = 0
# cmdline opt monet_mod_path =
/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB5:/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB5/lib:/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB5/bin
# cmdline opt gdk_dbfarm =
/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/var/MonetDB5/dbfarm
# cmdline opt mapi_open = true
# cmdline opt xrpc_open = true
# cmdline opt mapi_port = 38343
# cmdline opt xrpc_port = 40609
# cmdline opt monet_prompt =
# cmdline opt gdk_dbname = mTests_src_test_BugTracker-2009
# cmdline opt mal_listing = 0
#warning: please don't forget to set your vault key!
#(see
/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/etc/monetdb5.conf)
# 15:32:36 >
# 15:32:36 > mclient -lsql -umonetdb -Pmonetdb --host=rig --port=38343
# 15:32:36 >
# 15:32:36 >
# 15:32:36 > Done.
# 15:32:36 >
U All
Index: All
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/BugTracker-2009/Tests/All,v
retrieving revision 1.37.2.25
retrieving revision 1.37.2.26
diff -u -d -r1.37.2.25 -r1.37.2.26
--- All 21 Sep 2009 21:12:01 -0000 1.37.2.25
+++ All 22 Sep 2009 13:45:07 -0000 1.37.2.26
@@ -94,6 +94,11 @@
double_count_limit_bug.SF-2862146
create_on_ro_db_crash.SF-2830238
old_views_incorrectly_reused.SF-2863804
+updating_non-loaded_columns.SF-2864313_OK-0
+updating_non-loaded_columns.SF-2864313_KO-1
+updating_non-loaded_columns.SF-2864313_KO-2
+updating_non-loaded_columns.SF-2864313_KO-3
+updating_non-loaded_columns.SF-2864313_OK-4
#
# The following test currently crashes and this fact (or its remains) might
# harm sub-sequent tests; hence, this test should be last in this directory.
--- NEW FILE: updating_non-loaded_columns.SF-2864313_OK-0.stable.out ---
stdout of test 'updating_non-loaded_columns.SF-2864313_OK-0` in directory
'src/test/BugTracker-2009` itself:
# 15:32:36 >
# 15:32:36 > mserver5
"--config=/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/etc/monetdb5.conf"
--debug=10 --set gdk_nr_threads=0 --set
"monet_mod_path=/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB5:/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB5/lib:/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB5/bin"
--set
"gdk_dbfarm=/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/var/MonetDB5/dbfarm"
--set mapi_open=true --set xrpc_open=true --set mapi_port=38343 --set
xrpc_port=40609 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker-2009" --set mal_listing=0 "--dbinit=
include sql;" ; echo ; echo Over..
# 15:32:36 >
# MonetDB server v5.14.1, based on kernel v1.32.1
# Serving database 'mTests_src_test_BugTracker-2009', using 4 threads
# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically linked
# Copyright (c) 1993-July 2008 CWI.
# Copyright (c) August 2008-2009 MonetDB B.V., all rights reserved
# Visit http://monetdb.cwi.nl/ for further information
# Listening for connection requests on mapi:monetdb://rig.ins.cwi.nl:38343/
# MonetDB/SQL module v2.32.1 loaded
Ready.
#function user.main():void;
# clients.quit();
#end main;
Over..
# 15:32:36 >
# 15:32:36 > mclient -lsql -umonetdb -Pmonetdb --host=rig --port=38343
# 15:32:36 >
[ 1024 ]
% sys.t0 # table_name
% L1 # name
% wrd # type
% 4 # length
[ 1024 ]
[ 1024 ]
% sys.t1 # table_name
% L2 # name
% wrd # type
% 4 # length
[ 1024 ]
% sys.t1, sys.t1, sys.t1 # table_name
% d1, v2, v1 # name
% double, varchar, varchar # type
% 22, 0, 0 # length
[ 0, NULL, NULL ]
[ 1024 ]
% sys.t1, sys.t1, sys.t1 # table_name
% d1, v2, v1 # name
% double, varchar, varchar # type
% 22, 2, 0 # length
[ 0, "AA", NULL ]
[ 1024 ]
% sys.t1, sys.t1, sys.t1 # table_name
% d1, v2, v1 # name
% double, varchar, varchar # type
% 22, 2, 0 # length
[ -1.2, "AA", NULL ]
[ 1024 ]
% sys.t1, sys.t1, sys.t1 # table_name
% d1, v2, v1 # name
% double, varchar, varchar # type
% 22, 2, 2 # length
[ -1.2, "AA", "BB" ]
# 15:32:36 >
# 15:32:36 > Done.
# 15:32:36 >
--- NEW FILE: updating_non-loaded_columns.SF-2864313_KO-1.stable.out ---
stdout of test 'updating_non-loaded_columns.SF-2864313_KO-1` in directory
'src/test/BugTracker-2009` itself:
# 15:32:36 >
# 15:32:36 > mserver5
"--config=/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/etc/monetdb5.conf"
--debug=10 --set gdk_nr_threads=0 --set
"monet_mod_path=/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB5:/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB5/lib:/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB5/bin"
--set
"gdk_dbfarm=/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/var/MonetDB5/dbfarm"
--set mapi_open=true --set xrpc_open=true --set mapi_port=38343 --set
xrpc_port=40609 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker-2009" --set mal_listing=0 "--dbinit=
include sql;" ; echo ; echo Over..
# 15:32:36 >
# MonetDB server v5.14.1, based on kernel v1.32.1
# Serving database 'mTests_src_test_BugTracker-2009', using 4 threads
# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically linked
# Copyright (c) 1993-July 2008 CWI.
# Copyright (c) August 2008-2009 MonetDB B.V., all rights reserved
# Visit http://monetdb.cwi.nl/ for further information
# Listening for connection requests on mapi:monetdb://rig.ins.cwi.nl:38343/
# MonetDB/SQL module v2.32.1 loaded
Ready.
#function user.main():void;
# clients.quit();
#end main;
Over..
# 15:32:36 >
# 15:32:36 > mclient -lsql -umonetdb -Pmonetdb --host=rig --port=38343
# 15:32:36 >
[ 1025 ]
% sys.t0 # table_name
% L1 # name
% wrd # type
% 4 # length
[ 1025 ]
[ 1025 ]
% sys.t1 # table_name
% L2 # name
% wrd # type
% 4 # length
[ 1025 ]
% sys.t1, sys.t1, sys.t1 # table_name
% d1, v2, v1 # name
% double, varchar, varchar # type
% 22, 0, 0 # length
[ 0, NULL, NULL ]
[ 1025 ]
% sys.t1, sys.t1, sys.t1 # table_name
% d1, v2, v1 # name
% double, varchar, varchar # type
% 22, 2, 0 # length
[ 0, "AA", NULL ]
[ 1025 ]
% sys.t1, sys.t1, sys.t1 # table_name
% d1, v2, v1 # name
% double, varchar, varchar # type
% 22, 2, 0 # length
[ -1.2, "AA", NULL ]
[ 1025 ]
% sys.t1, sys.t1, sys.t1 # table_name
% d1, v2, v1 # name
% double, varchar, varchar # type
% 22, 2, 2 # length
[ -1.2, "AA", "BB" ]
# 15:32:36 >
# 15:32:36 > Done.
# 15:32:36 >
--- NEW FILE: updating_non-loaded_columns.SF-2864313_OK-4.stable.out ---
stdout of test 'updating_non-loaded_columns.SF-2864313_OK-4` in directory
'src/test/BugTracker-2009` itself:
# 15:32:36 >
# 15:32:36 > mserver5
"--config=/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/etc/monetdb5.conf"
--debug=10 --set gdk_nr_threads=0 --set
"monet_mod_path=/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB5:/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB5/lib:/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB5/bin"
--set
"gdk_dbfarm=/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/var/MonetDB5/dbfarm"
--set mapi_open=true --set xrpc_open=true --set mapi_port=38343 --set
xrpc_port=40609 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker-2009" --set mal_listing=0 "--dbinit=
include sql;" ; echo ; echo Over..
# 15:32:36 >
# MonetDB server v5.14.1, based on kernel v1.32.1
# Serving database 'mTests_src_test_BugTracker-2009', using 4 threads
# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically linked
# Copyright (c) 1993-July 2008 CWI.
# Copyright (c) August 2008-2009 MonetDB B.V., all rights reserved
# Visit http://monetdb.cwi.nl/ for further information
# Listening for connection requests on mapi:monetdb://rig.ins.cwi.nl:38343/
# MonetDB/SQL module v2.32.1 loaded
Ready.
#function user.main():void;
# clients.quit();
#end main;
Over..
# 15:32:36 >
# 15:32:36 > mclient -lsql -umonetdb -Pmonetdb --host=rig --port=38343
# 15:32:36 >
[ 1025 ]
% sys.t0 # table_name
% L1 # name
% wrd # type
% 4 # length
[ 1025 ]
[ 1025 ]
% sys.t1 # table_name
% L2 # name
% wrd # type
% 4 # length
[ 1025 ]
% sys.t1, sys.t1, sys.t1 # table_name
% d1, v2, v1 # name
% double, varchar, varchar # type
% 22, 1, 1 # length
[ 0, "y", "x" ]
[ 1025 ]
% sys.t1, sys.t1, sys.t1 # table_name
% d1, v2, v1 # name
% double, varchar, varchar # type
% 22, 2, 1 # length
[ 0, "AA", "x" ]
[ 1025 ]
% sys.t1, sys.t1, sys.t1 # table_name
% d1, v2, v1 # name
% double, varchar, varchar # type
% 22, 2, 1 # length
[ -1.2, "AA", "x" ]
[ 1025 ]
% sys.t1, sys.t1, sys.t1 # table_name
% d1, v2, v1 # name
% double, varchar, varchar # type
% 22, 2, 2 # length
[ -1.2, "AA", "BB" ]
# 15:32:36 >
# 15:32:36 > Done.
# 15:32:36 >
--- NEW FILE: updating_non-loaded_columns.SF-2864313_OK-4.sql.in ---
CREATE TABLE "t0" (
"d0" double
);
CREATE TABLE "t1" (
"d1" double,
"v1" varchar(255) default 'x',
"v2" varchar(255) default 'y'
);
COPY 1025 RECORDS INTO t0 FROM
'$TSTSRCDIR/updating_non-loaded_columns.SF-2864313.data' USING DELIMITERS
'\t';
select count(*) from t0;
INSERT INTO t1 (d1) SELECT d0 FROM t0;
select count(*) from t1;
select d1, v2, v1 from t1 limit 1;
Update t1 Set v2 = 'AA';
select d1, v2, v1 from t1 limit 1;
Update t1 Set d1 = -1.2;
select d1, v2, v1 from t1 limit 1;
Update t1 Set v1 = 'BB';
select d1, v2, v1 from t1 limit 1;
drop table t1;
drop table t0;
--- NEW FILE: updating_non-loaded_columns.SF-2864313_KO-2.stable.err ---
stderr of test 'updating_non-loaded_columns.SF-2864313_KO-2` in directory
'src/test/BugTracker-2009` itself:
# 15:32:36 >
# 15:32:36 > mserver5
"--config=/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/etc/monetdb5.conf"
--debug=10 --set gdk_nr_threads=0 --set
"monet_mod_path=/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB5:/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB5/lib:/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB5/bin"
--set
"gdk_dbfarm=/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/var/MonetDB5/dbfarm"
--set mapi_open=true --set xrpc_open=true --set mapi_port=38343 --set
xrpc_port=40609 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker-2009" --set mal_listing=0 "--dbinit=
include sql;" ; echo ; echo Over..
# 15:32:36 >
# builtin opt gdk_arch = 64bitx86_64-unknown-linux-gnu
# builtin opt gdk_version = 1.32.0
# builtin opt prefix =
/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert
# 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}/lib64/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/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert
# config opt config = ${prefix}/etc/monetdb5.conf
# config opt prefix =
/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert
# 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}/lib64/MonetDB5:${exec_prefix}/lib64/MonetDB5/lib:${exec_prefix}/lib64/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 mal_init = ${exec_prefix}/lib64/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 =
inline,remap,evaluate,costModel,coercions,emptySet,aliases,mergetable,deadcode,constants,commonTerms,joinPath,deadcode,reduce,garbageCollector,dataflow,history,multiplex
# cmdline opt config =
/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/etc/monetdb5.conf
# cmdline opt gdk_nr_threads = 0
# cmdline opt monet_mod_path =
/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB5:/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB5/lib:/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB5/bin
# cmdline opt gdk_dbfarm =
/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/var/MonetDB5/dbfarm
# cmdline opt mapi_open = true
# cmdline opt xrpc_open = true
# cmdline opt mapi_port = 38343
# cmdline opt xrpc_port = 40609
# cmdline opt monet_prompt =
# cmdline opt gdk_dbname = mTests_src_test_BugTracker-2009
# cmdline opt mal_listing = 0
#warning: please don't forget to set your vault key!
#(see
/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/etc/monetdb5.conf)
# 15:32:36 >
# 15:32:36 > mclient -lsql -umonetdb -Pmonetdb --host=rig --port=38343
# 15:32:36 >
# 15:32:36 >
# 15:32:36 > Done.
# 15:32:36 >
------------------------------------------------------------------------------
Come build with us! The BlackBerry® Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9-12, 2009. Register now!
http://p.sf.net/sfu/devconf
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
