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 '^$|^(\| |)#`
#        37 lines,       199 words,      1613 chars   in all lines

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


# 23:54:47 >  
# 23:54:47 >  "mserver5" "--debug=0" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=31896" "--set" "mapi_usock=/var/tmp/mtest-24026/.s.monetdb.31896" "--forcemito" "--set" "gdk_vm_maxsize=8589934592" "--dbpath=/export/scratch1/home/monet/testing/0b8bcdf65189-4-1-3/tests/sql/dbfarm/mTests_sql_test_mergetables" "--set" "embedded_c=true"
# 23:54:47 >  


# 23:54:47 >  
# 23:54:47 >  "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-24026" "--port=31896"
# 23:54:47 >  

#~ MAPI  = (monetdb) /var/tmp/mtest-24026/.s.monetdb.31896
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-24026/.s.monetdb.31896
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-24026/.s.monetdb.31896
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-24026/.s.monetdb.31896
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-24026/.s.monetdb.31896
QUERY = INSERT INTO complete VALUES(4.0, 0.0, 4.0);
ERROR = !INSERT INTO: cannot insert into merge table 'complete'
CODE  = 42000

# 23:54:47 >  
# 23:54:47 >  "Done."
# 23:54:47 >