Statistics about stderr of test 'singlekeyconstraint` in directory 'sql/test/mergetables`:
         19 lines,       141 words,       904 chars   in lines not matching '^$|^(\| |)#|^=`
=        19 lines,       141 words,       904 chars   in lines not matching '^$|^(\| |)#`
#        41 lines,       227 words,      1813 chars   in all lines

stderr 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 >  


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

#~ MAPI  = (monetdb) /var/tmp/mtest-8346/.s.monetdb.36761
QUERY = ALTER TABLE complete ADD TABLE part1;
ERROR = !ALTER MERGE TABLE: to be added table index doesn't match MERGE TABLE definition
CODE  = 3F000
#~ MAPI  = (monetdb) /var/tmp/mtest-8346/.s.monetdb.36761
QUERY = ALTER TABLE complete ADD TABLE part2;
ERROR = !ALTER MERGE TABLE: to be added table index doesn't match MERGE TABLE definition
CODE  = 3F000
#~ MAPI  = (monetdb) /var/tmp/mtest-8346/.s.monetdb.36761
QUERY = INSERT INTO part2 VALUES(2.0, 0.0, 1.0);
ERROR = !INSERT INTO: PRIMARY KEY constraint 'part2.part2_x_pkey' violated
CODE  = M0M29
#~ MAPI  = (monetdb) /var/tmp/mtest-8346/.s.monetdb.36761
QUERY = INSERT INTO part1 VALUES(0.0, 0.0, 2.0);
ERROR = !INSERT INTO: PRIMARY KEY constraint 'part1.part1_x_pkey' violated
CODE  = M0M29
#~ MAPI  = (monetdb) /var/tmp/mtest-8346/.s.monetdb.36761
QUERY = INSERT INTO part2 VALUES(0.0, 0.0, 3.0);
ERROR = !INSERT INTO: PRIMARY KEY constraint 'complete.complete_x_pkey' violated
CODE  = M0M29
#~ MAPI  = (monetdb) /var/tmp/mtest-8346/.s.monetdb.36761
QUERY = INSERT INTO complete VALUES(4.0, 0.0, 4.0);
ERROR = !INSERT INTO: cannot insert into merge table 'complete'
CODE  = 42000

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