Statistics about stderr of test 'singlekeyconstraint` in directory 'sql/test/mergetables`:
         16 lines,       121 words,       764 chars   in lines not matching '^$|^(\| |)#|^=`
=        16 lines,       121 words,       764 chars   in lines not matching '^$|^(\| |)#`
#        32 lines,       174 words,      1230 chars   in all lines

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


# 23:58:40 >  
# 23:58:40 >  "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-31288" "--port=38209"
# 23:58:40 >  

#~ MAPI  = (monetdb) /var/tmp/mtest-31288/.s.monetdb.38209
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-31288/.s.monetdb.38209
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-31288/.s.monetdb.38209
QUERY = INSERT INTO part2 VALUES(2.0, 0.0, 1.0);
ERROR = !INSERT INTO: PRIMARY KEY constraint 'part2.part2_x_pkey' violated
CODE  = 40002
#~ MAPI  = (monetdb) /var/tmp/mtest-31288/.s.monetdb.38209
QUERY = INSERT INTO part1 VALUES(0.0, 0.0, 2.0);
ERROR = !INSERT INTO: PRIMARY KEY constraint 'part1.part1_x_pkey' violated
CODE  = 40002
#~ MAPI  = (monetdb) /var/tmp/mtest-31288/.s.monetdb.38209
QUERY = INSERT INTO complete VALUES(4.0, 0.0, 4.0);
ERROR = !INSERT INTO: cannot insert into merge table 'complete'
CODE  = 42000

# 23:58:40 >  
# 23:58:40 >  "Done."
# 23:58:40 >