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 '^$|^(\| |)#`
#        42 lines,       247 words,      2198 chars   in all lines

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


# 19:32:55 >  
# 19:32:55 >  "mserver5" "--debug=0" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=39706" "--set" "mapi_usock=/var/tmp/mtest-17913/.s.monetdb.39706" "--forcemito" "--set" "gdk_vm_maxsize=8589934592" "--dbpath=/export/scratch1/home/monet/testing/d2a25d02ca50-5-1-1/tests/sql/dbfarm/mTests_sql_test_mergetables" "--set" "embedded_c=true"
# 19:32:55 >  

#client2:!ERROR:SQLException:sql.rel_check_tables:3F000!ALTER MERGE TABLE: to be added table index doesn't match MERGE TABLE definition
#client2:!ERROR:SQLException:sql.rel_check_tables:3F000!ALTER MERGE TABLE: to be added table index doesn't match MERGE TABLE definition
#client2:!ERROR:SQLException:assert:M0M29!INSERT INTO: PRIMARY KEY constraint 'part2.part2_x_pkey' violated
#client2:!ERROR:SQLException:assert:M0M29!INSERT INTO: PRIMARY KEY constraint 'part1.part1_x_pkey' violated
#client2:!ERROR:ParseException:SQLparser:42000!INSERT INTO: cannot insert into merge table 'complete'

# 19:32:55 >  
# 19:32:55 >  "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-17913" "--port=39706"
# 19:32:55 >  

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

# 19:32:56 >  
# 19:32:56 >  "Done."
# 19:32:56 >