Statistics about stdout of test 'singlekeyconstraint` in directory 'sql/test/mergetables`:
         19 lines,       102 words,       406 chars   in lines not matching '^$|^(\| |)#|^=`
=        19 lines,       102 words,       406 chars   in lines not matching '^$|^(\| |)#`
#       107 lines,       559 words,      3737 chars   in all lines

stdout of test 'singlekeyconstraint` in directory 'sql/test/mergetables` itself:


# 17:07:09 >  
# 17:07:09 >  "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=33620" "--set" "mapi_usock=/var/tmp/mtest-21328/.s.monetdb.33620" "--set" "monet_prompt=" "--forcemito" "--set" "mal_listing=2" "--dbpath=/ufs/manegold/_/Monet/HG/Jul2015/prefix/_/var/MonetDB/mTests_sql_test_mergetables" "--set" "mal_listing=0" "--set" "embedded_r=yes"
# 17:07:09 >  

# MonetDB 5 server v11.21.6
# This is an unreleased version
# Serving database 'mTests_sql_test_mergetables', using 8 threads
# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs and 128bit integers dynamically linked
# Found 15.590 GiB available main-memory.
# Copyright (c) 1993-July 2008 CWI.
# Copyright (c) August 2008-2015 MonetDB B.V., all rights reserved
# Visit http://www.monetdb.org/ for further information
# Listening for connection requests on mapi:monetdb://rome.ins.cwi.nl:33620/
# Listening for UNIX domain connection requests on mapi:monetdb:///var/tmp/mtest-21328/.s.monetdb.33620
# MonetDB/GIS module loaded
# Start processing logs sql/sql_logs version 52200
# Finished processing logs sql/sql_logs
# MonetDB/SQL module loaded
# MonetDB/R   module loaded

# SQL catalog created, loading sql scripts once
# loading sql script: 09_like.sql
# loading sql script: 10_math.sql
# loading sql script: 11_times.sql
# loading sql script: 12_url.sql
# loading sql script: 13_date.sql
# loading sql script: 14_inet.sql
# loading sql script: 15_querylog.sql
# loading sql script: 16_tracelog.sql
# loading sql script: 17_temporal.sql
# loading sql script: 20_vacuum.sql
# loading sql script: 21_dependency_functions.sql
# loading sql script: 22_clients.sql
# loading sql script: 23_skyserver.sql
# loading sql script: 24_zorder.sql
# loading sql script: 25_debug.sql
# loading sql script: 26_sysmon.sql
# loading sql script: 27_rejects.sql
# loading sql script: 39_analytics.sql
# loading sql script: 39_analytics_hge.sql
# loading sql script: 40_geom.sql
# loading sql script: 40_json.sql
# loading sql script: 40_json_hge.sql
# loading sql script: 41_md5sum.sql
# loading sql script: 45_uuid.sql
# loading sql script: 46_gsl.sql
# loading sql script: 51_sys_schema_extension.sql
# loading sql script: 72_fits.sql
# loading sql script: 74_netcdf.sql
# loading sql script: 75_storagemodel.sql
# loading sql script: 80_statistics.sql
# loading sql script: 80_udf.sql
# loading sql script: 80_udf_hge.sql
# loading sql script: 85_bam.sql
# loading sql script: 90_generator.sql
# loading sql script: 90_generator_hge.sql
# loading sql script: 99_system.sql

# 17:07:09 >  
# 17:07:09 >  "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-21328" "--port=33620"
# 17:07:09 >  

#CREATE TABLE part1 ( x double, y double, z double);
#ALTER TABLE part1 ADD PRIMARY KEY (x);
#COPY 2 RECORDS INTO part1 FROM stdin USING DELIMITERS ' ','\n';
#0.0 0.0 0.0
#1.0 0.0 0.0 
[ 2     ]
#CREATE TABLE part2 ( x double, y double, z double);
#ALTER TABLE part2 ADD PRIMARY KEY (x);
#COPY 2 RECORDS INTO part2 FROM stdin USING DELIMITERS ' ','\n';
#2.0 0.0 0.0
#3.0 0.0 0.0 
[ 2     ]
#CREATE MERGE TABLE complete ( x double, y double, z double);
#ALTER TABLE complete ADD PRIMARY KEY (x);
#ALTER TABLE complete ADD TABLE part1;
#ALTER TABLE complete ADD TABLE part2;
#SELECT * FROM COMPLETE;
% .complete,    .complete,      .complete # table_name
% x,    y,      z # name
% double,       double, double # type
% 24,   24,     24 # length
[ 0,    0,      0       ]
[ 1,    0,      0       ]
[ 2,    0,      0       ]
[ 3,    0,      0       ]
#SELECT * FROM complete;
% .complete,    .complete,      .complete # table_name
% x,    y,      z # name
% double,       double, double # type
% 24,   24,     24 # length
[ 0,    0,      0       ]
[ 1,    0,      0       ]
[ 2,    0,      0       ]
[ 3,    0,      0       ]
#DROP TABLE complete;
#DROP TABLE part1;
#DROP TABLE part2;

# 17:07:09 >  
# 17:07:09 >  "Done."
# 17:07:09 >