Statistics about stdout of test 'singlekeyconstraint` in directory 'sql/test/mergetables`: 21 lines, 110 words, 422 chars in lines not matching '^$|^(\| |)#|^=` = 21 lines, 110 words, 422 chars in lines not matching '^$|^(\| |)#` # 52 lines, 259 words, 1277 chars in all lines stdout of test 'singlekeyconstraint` in directory 'sql/test/mergetables` itself: # 23:00:08 > # 23:00:08 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=WIN2K12R2" "--port=36484" # 23:00:08 > #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 ' ',E'\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 ' ',E'\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 ] #INSERT INTO part2 VALUES(0.0, 0.0, 3.0); [ 1 ] #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 ] [ 0, 0, 3 ] #DROP TABLE complete; #DROP TABLE part1; #DROP TABLE part2; # 23:00:08 > # 23:00:08 > "Done." # 23:00:08 >