# regression tests for the join utilitiy
TEST 01 'one field'
EXEC f1 f1
INPUT f1 $'100214179\n101425403\n1023323808'
INPUT f2 $'100214179 aaa\n101425403 bbb\n1023323808 ccc'
OUTPUT - $'100214179\n101425403\n1023323808'
EXEC f1 f2
OUTPUT - $'100214179 aaa\n101425403 bbb\n1023323808 ccc'
EXEC f2 f1
OUTPUT - $'100214179 aaa\n101425403 bbb\n1023323808 ccc'
EXEC f2 f2
OUTPUT - $'100214179 aaa aaa\n101425403 bbb bbb\n1023323808 ccc ccc'
TEST 02 'two fields'
EXEC f1 f2
INPUT f1 $'a b\na c\na d\nb x\nc y\nd z'
INPUT f2 $'a i\nb j\nc k\nd l'
OUTPUT - $'a b i\na c i\na d i\nb x j\nc y k\nd z l'
TEST 03 'field exercises'
EXEC -t'|' -e NAV -1 2 -2 2 -o 1.1 1.2 2.1 f1 f2
INPUT f1 $'205|AL\n501|AR\n602|AZ\n209|CA\n213|CA\n310|CA\n408|CA\n415|CA\n510|CA\n619|CA'
INPUT f2 $'4|AL\n5|AR\n7|AZ\n1|CA\n7|CO\n3|CT\n6|DC\n6|DE\n4|FL\n4|GA'
OUTPUT - $'205|AL|4\n501|AR|5\n602|AZ|7\n209|CA|1\n213|CA|1\n310|CA|1\n408|CA|1\n415|CA|1\n510|CA|1\n619|CA|1'
EXEC -t'|' -e NAV -j 2 -o 1.1 1.2 2.1 f1 f2
EXEC -t'|' -e NAV -j1 2 -j2 2 -o 1.1 1.2 2.1 f1 f2
EXEC -t'|' -e NAV -1 2 -2 2 -o 1.1 1.2 2.1 f1 f2
EXEC -t'|' -a1 -e NAV -1 2 -2 2 -o 1.1 1.2 2.1 f1 f2
OUTPUT - $'205|AL|4\n501|AR|5\n602|AZ|7\n209|CA|1\n213|CA|1\n310|CA|1\n408|CA|1\n415|CA|1\n510|CA|1\n619|CA|1'
EXEC -t'|' -a1 -e NAV -j 2 -o 1.1 1.2 2.1 f1 f2
EXEC -t'|' -v1 -e NAV -1 2 -2 2 -o 1.1 1.2 2.1 f1 f2
OUTPUT -
EXEC -t'|' -v1 -e NAV -j 2 -o 1.1 1.2 2.1 f1 f2
EXEC -t'|' -a1 -e NAV -1 2 -2 2 -o 1.1 1.2 2.1 f1 f2
INPUT f1 $'205|AL\n501|AR\n602|AZ\n209|CA\n213|CA\n310|CA\n408|CA\n415|CA\n510|CA\n619|CA\n908|NJ'
OUTPUT - $'205|AL|4\n501|AR|5\n602|AZ|7\n209|CA|1\n213|CA|1\n310|CA|1\n408|CA|1\n415|CA|1\n510|CA|1\n619|CA|1\n908|NJ|NAV'
EXEC -t'|' -a1 -e NAV -j 2 -o 1.1 1.2 2.1 f1 f2
EXEC -t'|' -v1 -e NAV -1 2 -2 2 -o 1.1 1.2 2.1 f1 f2
OUTPUT - $'908|NJ|NAV'
EXEC -t'|' -v1 -e NAV -j 2 -o 1.1 1.2 2.1 f1 f2
EXEC -t '|' -1 2 -2 2 f1 f2
INPUT f1 $'1||4\n2|x|5\n3|y|6'
INPUT f2 $'a||d\nb|x|e\nc|y|f'
OUTPUT - $'|1|4|a|d\nx|2|5|b|e\ny|3|6|c|f'
EXEC -t '|' -1 2 -2 2 f1 f2
INPUT f1 $'1|w|4\n2|x|5\n3|y|6'
INPUT f2 $'a|w|d\nb|x|e\nc|y|f'
OUTPUT - $'w|1|4|a|d\nx|2|5|b|e\ny|3|6|c|f'
TEST 04 'phoney stuff'
EXEC -t: -e 9999999 -j 1 -o 1.1 2.1 1.5 2.5 f1 f2
INPUT f1 $'201:1087959:317956:214759:1620674\n202:198698:113245:55505:367448\n203:370611:391058:73131:834800\n205:825456:253691:53214:1132361\n206:804098:425758:109197:1339053\n207:475252:127876:29837:632965\n208:304855:172322:31832:509009\n209:706486:233530:44440:984456\n210:732423:272243:87315:1091981\n212:614509:313916:134331:1062756'
INPUT f2 $'201:1101647:330947:212248:1644842\n202:202179:116338:55635:374152\n203:369618:392862:74562:837042\n205:832559:251988:55911:1140458\n206:810752:428137:111784:1350673\n207:478707:126589:30118:635414\n208:307105:173927:31891:512923\n209:708069:230231:45308:983608\n210:734879:270042:97955:1102876\n212:616079:315262:135458:1066799'
OUTPUT - $'201:201:1620674:1644842\n202:202:367448:374152\n203:203:834800:837042\n205:205:1132361:1140458\n206:206:1339053:1350673\n207:207:632965:635414\n208:208:509009:512923\n209:209:984456:983608\n210:210:1091981:1102876\n212:212:1062756:1066799'
EXEC -t: -a2 -e 9999999 -j 1 -o 1.1 2.1 1.5 2.5 f1 f2
OUTPUT - $'201:201:1620674:1644842\n202:202:367448:374152\n203:203:834800:837042\n205:205:1132361:1140458\n206:206:1339053:1350673\n207:207:632965:635414\n208:208:509009:512923\n209:209:984456:983608\n210:210:1091981:1102876\n212:212:1062756:1066799'
EXEC -t: -a2 -e 9999999 -j 1 -o 1.1 2.1 1.5 2.5 f1 f2
INPUT f2 $'201:1101647:330947:212248:1644842\n202:202179:116338:55635:374152\n203:369618:392862:74562:837042\n205:832559:251988:55911:1140458\n206:810752:428137:111784:1350673\n207:478707:126589:30118:635414\n208:307105:173927:31891:512923\n209:708069:230231:45308:983608\n210:734879:270042:97955:1102876\n212:616079:315262:135458:1066799\n908:614509:313916:134331:1062756'
OUTPUT - $'201:201:1620674:1644842\n202:202:367448:374152\n203:203:834800:837042\n205:205:1132361:1140458\n206:206:1339053:1350673\n207:207:632965:635414\n208:208:509009:512923\n209:209:984456:983608\n210:210:1091981:1102876\n212:212:1062756:1066799\n9999999:908:9999999:1062756'
EXEC -t: -a1 -e 9999999 -j 1 -o 1.1 2.1 1.5 2.5 f1 f2
OUTPUT - $'201:201:1620674:1644842\n202:202:367448:374152\n203:203:834800:837042\n205:205:1132361:1140458\n206:206:1339053:1350673\n207:207:632965:635414\n208:208:509009:512923\n209:209:984456:983608\n210:210:1091981:1102876\n212:212:1062756:1066799'
EXEC -a1 -j 1 -t"|" f1 f2
INPUT f1 $'2012000008|940214|Y|950814||||F|||32|12|638|941|KO|P\n2012000013|941201|Y|941128||R||O||N|41|12|137|9|RT|C\n2012000036|970528|Y|970616||||O|||10|10|220|148|CH|A\n2012000038|940914|Y|940912|||||||43|12|0|10|CN|N\n2012000050|940721|Y|960326||R||||N|25|12|975|116|MX|M\n2012000055|910520|Y|970627||O|||||10|10|880|432|JP|P\n2012000066|940302|Y|940225|||||||50|12|222|54|BA|C\n2012000068|940413|Y|940409|||||||48|12|0|37|AG|A\n2012000077|940330|Y|970829|||||||8|8|125|57|GY|A\n2012000079|941009|Y|951129||O||O|||29|12|1553|1753|EG|E'
INPUT f2 $'2012000008|970619|17CPE\n2012000079|970121|17CPE\n2012000079|980227|17CPR\n2012000079|980320|OCVO4\n2012000100|951117|17CPE\n2012000153|970801|OCVO4\n2012000208|980117|17CPE\n2012000208|980118|17CPR\n2012000291|970606|17CPE\n2012000342|971114|17CPE'
OUTPUT - $'2012000008|940214|Y|950814||||F|||32|12|638|941|KO|P|970619|17CPE\n2012000013|941201|Y|941128||R||O||N|41|12|137|9|RT|C\n2012000036|970528|Y|970616||||O|||10|10|220|148|CH|A\n2012000038|940914|Y|940912|||||||43|12|0|10|CN|N\n2012000050|940721|Y|960326||R||||N|25|12|975|116|MX|M\n2012000055|910520|Y|970627||O|||||10|10|880|432|JP|P\n2012000066|940302|Y|940225|||||||50|12|222|54|BA|C\n2012000068|940413|Y|940409|||||||48|12|0|37|AG|A\n2012000077|940330|Y|970829|||||||8|8|125|57|GY|A\n2012000079|941009|Y|951129||O||O|||29|12|1553|1753|EG|E|970121|17CPE\n2012000079|941009|Y|951129||O||O|||29|12|1553|1753|EG|E|980227|17CPR\n2012000079|941009|Y|951129||O||O|||29|12|1553|1753|EG|E|980320|OCVO4'
TEST 05 'dup join field in f1'
EXEC -t: -e 9999999 -j 1 -o 1.1 2.1 1.5 2.5 f1 f2
INPUT f1 $'201:1087959:317956:214759:1620674\n201:198698:113245:55505:2367448\n202:198698:113245:55505:367448\n203:370611:391058:73131:834800\n205:825456:253691:53214:1132361\n206:804098:425758:109197:1339053\n207:475252:127876:29837:632965\n208:304855:172322:31832:509009\n209:706486:233530:44440:984456\n210:732423:272243:87315:1091981\n212:614509:313916:134331:1062756'
INPUT f2 $'201:1101647:330947:212248:1644842\n202:202179:116338:55635:374152\n203:369618:392862:74562:837042\n205:832559:251988:55911:1140458\n206:810752:428137:111784:1350673\n207:478707:126589:30118:635414\n208:307105:173927:31891:512923\n209:708069:230231:45308:983608\n210:734879:270042:97955:1102876\n212:616079:315262:135458:1066799'
OUTPUT - $'201:201:1620674:1644842\n201:201:2367448:1644842\n202:202:367448:374152\n203:203:834800:837042\n205:205:1132361:1140458\n206:206:1339053:1350673\n207:207:632965:635414\n208:208:509009:512923\n209:209:984456:983608\n210:210:1091981:1102876\n212:212:1062756:1066799'
EXEC -t: -a2 -e 9999999 -j 1 -o 1.1 2.1 1.5 2.5 f1 f2
OUTPUT - $'201:201:1620674:1644842\n201:201:2367448:1644842\n202:202:367448:374152\n203:203:834800:837042\n205:205:1132361:1140458\n206:206:1339053:1350673\n207:207:632965:635414\n208:208:509009:512923\n209:209:984456:983608\n210:210:1091981:1102876\n212:212:1062756:1066799'
EXEC -t: -a2 -e 9999999 -j 1 -o 1.1 2.1 1.5 2.5 f1 f2
INPUT f2 $'201:1101647:330947:212248:1644842\n202:202179:116338:55635:374152\n203:369618:392862:74562:837042\n205:832559:251988:55911:1140458\n206:810752:428137:111784:1350673\n207:478707:126589:30118:635414\n208:307105:173927:31891:512923\n209:708069:230231:45308:983608\n210:734879:270042:97955:1102876\n212:616079:315262:135458:1066799\n908:614509:313916:134331:1062756'
OUTPUT - $'201:201:1620674:1644842\n201:201:2367448:1644842\n202:202:367448:374152\n203:203:834800:837042\n205:205:1132361:1140458\n206:206:1339053:1350673\n207:207:632965:635414\n208:208:509009:512923\n209:209:984456:983608\n210:210:1091981:1102876\n212:212:1062756:1066799\n9999999:908:9999999:1062756'
EXEC -t: -a1 -e 9999999 -j 1 -o 1.1 2.1 1.5 2.5 f1 f2
OUTPUT - $'201:201:1620674:1644842\n201:201:2367448:1644842\n202:202:367448:374152\n203:203:834800:837042\n205:205:1132361:1140458\n206:206:1339053:1350673\n207:207:632965:635414\n208:208:509009:512923\n209:209:984456:983608\n210:210:1091981:1102876\n212:212:1062756:1066799'
TEST 06 'dup join field in f2'
EXEC -t: -e 9999999 -j 1 -o 1.1 2.1 1.5 2.5 f1 f2
INPUT f1 $'201:1087959:317956:214759:1620674\n202:198698:113245:55505:367448\n203:370611:391058:73131:834800\n205:825456:253691:53214:1132361\n206:804098:425758:109197:1339053\n207:475252:127876:29837:632965\n208:304855:172322:31832:509009\n209:706486:233530:44440:984456\n210:732423:272243:87315:1091981\n212:614509:313916:134331:1062756'
INPUT f2 $'201:1101647:330947:212248:1644842\n201:1478707:126589:30118:635414\n202:202179:116338:55635:374152\n203:369618:392862:74562:837042\n205:832559:251988:55911:1140458\n206:810752:428137:111784:1350673\n207:478707:126589:30118:635414\n208:307105:173927:31891:512923\n209:708069:230231:45308:983608\n210:734879:270042:97955:1102876\n212:616079:315262:135458:1066799'
OUTPUT - $'201:201:1620674:1644842\n201:201:1620674:635414\n202:202:367448:374152\n203:203:834800:837042\n205:205:1132361:1140458\n206:206:1339053:1350673\n207:207:632965:635414\n208:208:509009:512923\n209:209:984456:983608\n210:210:1091981:1102876\n212:212:1062756:1066799'
EXEC -t: -a2 -e 9999999 -j 1 -o 1.1 2.1 1.5 2.5 f1 f2
OUTPUT - $'201:201:1620674:1644842\n201:201:1620674:635414\n202:202:367448:374152\n203:203:834800:837042\n205:205:1132361:1140458\n206:206:1339053:1350673\n207:207:632965:635414\n208:208:509009:512923\n209:209:984456:983608\n210:210:1091981:1102876\n212:212:1062756:1066799'
EXEC -t: -a2 -e 9999999 -j 1 -o 1.1 2.1 1.5 2.5 f1 f2
INPUT f2 $'201:1101647:330947:212248:1644842\n201:1478707:126589:30118:635414\n202:202179:116338:55635:374152\n203:369618:392862:74562:837042\n205:832559:251988:55911:1140458\n206:810752:428137:111784:1350673\n207:478707:126589:30118:635414\n208:307105:173927:31891:512923\n209:708069:230231:45308:983608\n210:734879:270042:97955:1102876\n212:616079:315262:135458:1066799\n908:614509:313916:134331:1062756'
OUTPUT - $'201:201:1620674:1644842\n201:201:1620674:635414\n202:202:367448:374152\n203:203:834800:837042\n205:205:1132361:1140458\n206:206:1339053:1350673\n207:207:632965:635414\n208:208:509009:512923\n209:209:984456:983608\n210:210:1091981:1102876\n212:212:1062756:1066799\n9999999:908:9999999:1062756'
EXEC -t: -a1 -e 9999999 -j 1 -o 1.1 2.1 1.5 2.5 f1 f2
OUTPUT - $'201:201:1620674:1644842\n201:201:1620674:635414\n202:202:367448:374152\n203:203:834800:837042\n205:205:1132361:1140458\n206:206:1339053:1350673\n207:207:632965:635414\n208:208:509009:512923\n209:209:984456:983608\n210:210:1091981:1102876\n212:212:1062756:1066799'
TEST 07 'common fields'
EXEC -a 1 -a 2 -e fff f1 f2
INPUT f1 $'000 1\n111 1\n222 1\n333 1'
INPUT f2 $'000 1\n222 1\n333 1\n444 1'
OUTPUT - $'000 1 1\n111 1\n222 1 1\n333 1 1\n444 1'
EXEC -a 1 -a 2 -e fff f2 f1
OUTPUT - $'000 1 1\n111 1\n222 1 1\n333 1 1\n444 1'
EXEC -a 1 -a 2 -e fff f1 f2
INPUT f1 $'111 1\n222 1\n333 1'
INPUT f2 $'222 1\n333 1\n444 1'
OUTPUT - $'111 1\n222 1 1\n333 1 1\n444 1'
EXEC -a 1 -a 2 f1 f2
EXEC -a 1 f1 f2
OUTPUT - $'111 1\n222 1 1\n333 1 1'
EXEC f1 f2
OUTPUT - $'222 1 1\n333 1 1'
EXEC -a 1 -a 2 -e fff f2 f1
OUTPUT - $'111 1\n222 1 1\n333 1 1\n444 1'
EXEC -a 1 -a 2 f2 f1
EXEC -a 2 f2 f1
OUTPUT - $'111 1\n222 1 1\n333 1 1'
EXEC -a 1 f2 f1
OUTPUT - $'222 1 1\n333 1 1\n444 1'
EXEC f2 f1
OUTPUT - $'222 1 1\n333 1 1'
EXEC -a 1 -a 2 -e fff f1 f2
INPUT f1 $'111 a\n222 b\n333 c'
INPUT f2 $'222 B\n333 C\n444 D'
OUTPUT - $'111 a\n222 b B\n333 c C\n444 D'
EXEC -a 1 -a 2 -e fff f1 f2
OUTPUT - $'111 a\n222 b B\n333 c C\n444 D'
TEST 08 'no common fields'
EXEC -v 1 -v 2 -e fff f1 f2
INPUT f1 $'000 1\n111 1\n222 1\n333 1'
INPUT f2 $'000 1\n222 1\n333 1\n444 1'
OUTPUT - $'111 1\n444 1'
EXEC -v 1 -v 2 -e fff f2 f1
EXEC -v 1 -v 2 -e fff f1 f2
INPUT f1 $'111 1\n222 1\n333 1'
INPUT f2 $'222 1\n333 1\n444 1'
EXEC -v 1 -v 2 f1 f2
EXEC -v 1 f1 f2
OUTPUT - $'111 1'
EXEC f1 f2
OUTPUT - $'222 1 1\n333 1 1'
EXEC -v 1 -v 2 -e fff f2 f1
OUTPUT - $'111 1\n444 1'
EXEC -v 1 -v 2 f2 f1
EXEC -v 2 f2 f1
OUTPUT - $'111 1'
EXEC -v 1 f2 f1
OUTPUT - $'444 1'
EXEC f2 f1
OUTPUT - $'222 1 1\n333 1 1'
EXEC -v 1 -v 2 -e fff f1 f2
INPUT f1 $'111 a\n222 b\n333 c'
INPUT f2 $'222 B\n333 C\n444 D'
OUTPUT - $'111 a\n444 D'
EXEC -v 1 -v 2 -e fff f1 f2
EXEC -t: -v 2 -1 1 -2 1 f1 f2
INPUT f1 $'AAAA:BBBB:1:2:CCCC:DDDD'
INPUT f2 $'AAAA:BBBB:CCCC:DDDD:bbbb\nAAAA:BBBB:CCCC:DDDD:cccc'
OUTPUT -
EXEC -t: -11 -21 f1 f2
INPUT f1 $'A\nB\nC'
INPUT f2 $'A:F2KEYA\nB:F2KEYB\nC:F2KEYC'
SAME OUTPUT f2
EXEC -t: -11 -21 f1 f2
INPUT f1 $'A\nC\nZ'
OUTPUT - $'A:F2KEYA\nC:F2KEYC'
EXEC -v1 -t: -11 -21 f1 f2
OUTPUT - $'Z'
EXEC -v2 -t: -11 -21 f1 f2
OUTPUT - $'B:F2KEYB'
EXEC -v1 -v2 -t: -11 -21 f1 f2
OUTPUT - $'B:F2KEYB\nZ'
TEST 09 'boundary conditions'
EXEC -1 2 -2 1 -o 1.1,2.2 f1 f2
INPUT f1 $'903672 486\n806565 536\n806754 536\n806988 536\n915043 540\n915220 540\n915966 961\n915985 961'
INPUT f2 $'540 3000\n542 4000\n664 5000\n961 6000'
OUTPUT - $'915043 3000\n915220 3000\n915966 6000\n915985 6000'
EXEC -a1 -1 2 -2 1 -o 1.1,2.2 f1 f2
OUTPUT - $'903672 \n806565 \n806754 \n806988 \n915043 3000\n915220 3000\n915966 6000\n915985 6000'
EXEC -a2 -1 2 -2 1 -o 1.1,2.2 f1 f2
OUTPUT - $'915043 3000\n915220 3000\n 4000\n 5000\n915966 6000\n915985 6000'
EXEC -a1 -a2 -1 2 -2 1 -o 1.1,2.2 f1 f2
OUTPUT - $'903672 \n806565 \n806754 \n806988 \n915043 3000\n915220 3000\n 4000\n 5000\n915966 6000\n915985 6000'
EXEC -v1 -1 2 -2 1 -o 1.1,2.2 f1 f2
OUTPUT - $'903672 \n806565 \n806754 \n806988 '
EXEC -v2 -1 2 -2 1 -o 1.1,2.2 f1 f2
OUTPUT - $' 4000\n 5000'
EXEC -v1 -v2 -1 2 -2 1 -o 1.1,2.2 f1 f2
OUTPUT - $'903672 \n806565 \n806754 \n806988 \n 4000\n 5000'
EXEC -a1 -v1 -1 2 -2 1 -o 1.1,2.2 f1 f2
OUTPUT - $'903672 \n806565 \n806754 \n806988 '
EXEC -a1 -v2 -1 2 -2 1 -o 1.1,2.2 f1 f2
OUTPUT - $'903672 \n806565 \n806754 \n806988 \n 4000\n 5000'
EXEC -v1 -a2 -1 2 -2 1 -o 1.1,2.2 f1 f2
OUTPUT - $'903672 \n806565 \n806754 \n806988 \n 4000\n 5000'
EXEC -v2 -a2 -1 2 -2 1 -o 1.1,2.2 f1 f2
OUTPUT - $' 4000\n 5000'
TEST 10 'more ggs/psm bugs -- thanks guys'
EXEC -t: -a 1 -a 2 f1 f2
INPUT f1 $'AGAIN:D981001:47\nAGAINST:D981001:101\nAGREED:D981001:67:72\nAHAS:D981001:5'
INPUT f2 $'AGAIN:D981002:15:58\nAGO:D981002:31\nAL/TUC:D981002:2:3:4:5:6\nALL:D981002:16:58:74:84'
OUTPUT - $'AGAIN:D981001:47:D981002:15:58\nAGAINST:D981001:101\nAGO:D981002:31\nAGREED:D981001:67:72\nAHAS:D981001:5\nAL/TUC:D981002:2:3:4:5:6\nALL:D981002:16:58:74:84'
EXEC -a2 f1 f2
INPUT f1 $'9112170179\n9112170180\n9112170181\n9112170182'
INPUT f2 $'9112161885\n9112170180\n9112170180\n9112170421\n9112170464'
OUTPUT - $'9112161885\n9112170180\n9112170180\n9112170421\n9112170464'
SET pipe-input
TEST 11 'pipe on 1 or 2'
EXEC f1 -
INPUT - $'9112161885\n9112170180\n9112170180\n9112170421\n9112170464'
INPUT f1 $'9112170179\n9112170180\n9112170181\n9112170182'
OUTPUT - $'9112170180\n9112170180'
EXEC - f1
EXEC f2 -
INPUT - $'9112170179\n9112170180\n9112170181\n9112170182'
INPUT f2 $'9112161885\n9112170180\n9112170180\n9112170421\n9112170464'
EXEC - f2
SET nopipe-input
TEST 12 'gnu join tests'
EXEC -a1 f1 f2
INPUT f1 $'a 1'
INPUT f2 $'b'
OUTPUT - $'a 1'
EXEC -a2 f1 f2
INPUT f1 $'a 1'
INPUT f2 $'b'
OUTPUT - $'b'
EXEC -a1 -a2 f1 f2
INPUT f1 $'a 1'
INPUT f2 $'b'
OUTPUT - $'a 1\nb'
EXEC -a1 f1 f2
INPUT f1 $'a 1\nb'
INPUT f2 $'b'
OUTPUT - $'a 1\nb'
EXEC -a2 f1 f2
INPUT f1 $'a 1\nb'
INPUT f2 $'b'
OUTPUT - $'b'
EXEC -a2 f1 f2
INPUT f1 $'b'
INPUT f2 $'a\nb'
OUTPUT - $'a\nb'
TEST 13 '-a -e'
EXEC -a1 -e . f1 f2
INPUT f1 $'a\nb\nc'
INPUT f2 $'a x y\nb\nc'
OUTPUT - $'a x y\nb\nc'
EXEC -a1 -e . -o 2.1,2.2,2.3 f1 f2
INPUT f1 $'a\nb\nc'
INPUT f2 $'a x y\nb\nc'
OUTPUT - $'a x y\nb . .\nc . .'
EXEC -a1 -e . -o 2.1,2.2,2.3 f1 f2
INPUT f1 $'a\nb\nc\nd'
INPUT f2 $'a x y\nb\nc'
OUTPUT - $'a x y\nb . .\nc . .\n. . .'
TEST 14 '-t'
EXEC -t: f1 f2
INPUT f1 $'a:1\nb:1'
INPUT f2 $'a:2:\nb:2:'
OUTPUT - $'a:1:2:\nb:1:2:'
TEST 15 '-v'
EXEC -v 1 f1 f2
INPUT f1 $'a 1'
INPUT f2 $'b'
OUTPUT - $'a 1'
EXEC -v 2 f1 f2
INPUT f1 $'a 1'
INPUT f2 $'b'
OUTPUT - $'b'
EXEC -v 1 f1 f2
INPUT f1 $'a 1\nb'
INPUT f2 $'b'
OUTPUT - $'a 1'
EXEC -v 2 f1 f2
INPUT f1 $'a 1\nb'
INPUT f2 $'b'
OUTPUT -
EXEC -v 2 f1 f2
INPUT f1 $'b'
INPUT f2 $'a 1\nb'
OUTPUT - $'a 1'
TEST 16 '-a -e -o'
EXEC -a1 -e - -o 1.1 2.2 f1 f2
INPUT f1 $'a 1\nb 2'
INPUT f2 $'a 11\nb'
OUTPUT - $'a 11\nb \-'
EXEC -a1 -e - -o 1.1 2.2 f1 f2
INPUT f1 $'apr 15\naug 20\ndec 18\nfeb 05'
INPUT f2 $'apr 06\naug 14\ndate\nfeb 15'
OUTPUT - $'apr 06\naug 14\ndec \-\nfeb 15'
EXEC -a1 -e - -o 1.1 2.2 f1 f2
INPUT f1 $'aug 20\ndec 18'
INPUT f2 $'aug 14\ndate\nfeb 15'
OUTPUT - $'aug 14\ndec \-'
EXEC -a1 -e - -o 1.1 2.2 f1 f2
INPUT f1 $'dec 18'
INPUT f2
OUTPUT - $'dec \-'
EXEC -a2 -e - -o 1.1 2.2 f1 f2
INPUT f1 $'apr 15\naug 20\ndec 18\nfeb 05'
INPUT f2 $'apr 06\naug 14\ndate\nfeb 15'
OUTPUT - $'apr 06\naug 14\n\- \-\nfeb 15'
EXEC -a2 -e - -o 2.2 1.1 f1 f2
INPUT f1 $'apr 15\naug 20\ndec 18\nfeb 05'
INPUT f2 $'apr 06\naug 14\ndate\nfeb 15'
OUTPUT - $'06 apr\n14 aug\n\- \-\n15 feb'
EXEC -a1 -e - -o 2.2 1.1 f1 f2
INPUT f1 $'apr 15\naug 20\ndec 18\nfeb 05'
INPUT f2 $'apr 06\naug 14\ndate\nfeb 15'
OUTPUT - $'06 apr\n14 aug\n\- dec\n15 feb'
EXEC -a1 -e - -o 2.2 1.1 f1 f2
INPUT f1 $'apr 15\naug 20\ndec 18\nfeb 05'
INPUT f2 $'apr 06\naug 14\ndate'
OUTPUT - $'06 apr\n14 aug\n\- dec\n\- feb'
EXEC -a1 -e - -o 1.1 2.2 f1 f2
INPUT f1 $'apr 15\naug 20\ndec 18\nfeb 05'
INPUT f2 $'apr 06\naug 14\ndate'
OUTPUT - $'apr 06\naug 14\ndec \-\nfeb \-'
EXEC -a2 -e - -o 2.2 1.1 f1 f2
INPUT f1 $'apr 15\naug 20\ndec 18\nfeb 05'
INPUT f2 $'apr 06\naug 14\ndate'
OUTPUT - $'06 apr\n14 aug\n\- \-'
EXEC -a2 -e - -o 2.2 1.1 f1 f2
INPUT f1 $'apr 15\naug 20\ndec 18\nfeb 05'
INPUT f2 $'apr 06\naug 14\ndate'
OUTPUT - $'06 apr\n14 aug\n\- \-'
EXEC -a1 -e - -o 2.2 1.1 f1 f2
INPUT f1 $'apr 15\naug 20\ndec 18'
INPUT f2 $'apr 06\naug 14\ndate\nfeb 15'
OUTPUT - $'06 apr\n14 aug\n\- dec'
EXEC -a2 -e - -o 2.2 1.1 f1 f2
INPUT f1 $'apr 15\naug 20\ndec 18'
INPUT f2 $'apr 06\naug 14\ndate\nfeb 15'
OUTPUT - $'06 apr\n14 aug\n\- \-\n15 \-'
TEST 17 '-e'
EXEC -e - f1 f2
INPUT f1 $'a 1\nb 2\nd 4'
INPUT f2 $'a 21\nb 22\nc 23\nf 26'
OUTPUT - $'a 1 21\nb 2 22'
EXEC -a1 -e - f1 f2
INPUT f1 $'a 1\nb 2\nd 4'
INPUT f2 $'a 21\nb 22\nc 23\nf 26'
OUTPUT - $'a 1 21\nb 2 22\nd 4'
EXEC -a1 -e - f1 f2
INPUT f1 $'a 21\nb 22\nc 23\nf 26'
INPUT f2 $'a 1\nb 2\nd 4'
OUTPUT - $'a 21 1\nb 22 2\nc 23\nf 26'
TEST 18 '-a -e -o'
EXEC -a1 -e . -o 2.7 f1 f2
INPUT f1 $'a\nb\nc'
INPUT f2 $'a x y\nb\nc'
OUTPUT - $'.\n.\n.'
EXEC -a1 -e . -o 0,1.2 f1 f2
INPUT f1 $'a\nb\nc\nd G'
INPUT f2 $'a x y\nb\nc\ne'
OUTPUT - $'a .\nb .\nc .\nd G'
EXEC -a1 -a2 -e . -o 0,1.2 f1 f2
INPUT f1 $'a\nb\nc\nd G'
INPUT f2 $'a x y\nb\nc\ne'
OUTPUT - $'a .\nb .\nc .\nd G\ne .'
TEST 19 'empty field deref'
EXEC -o 1.1 2.1 1.2 2.2 2.3 f1 f1
INPUT f1 $'U+0750'
OUTPUT - $'U+0750 U+0750 '
TEST 20 'nuttin'
EXEC f1 f2
INPUT f1 $' a 1\nb 2'
INPUT f2 $' a Y\nb Z'
OUTPUT - $'a 1 Y\nb 2 Z'
TEST 21 '-v1 vs. -v2 inconsistencies'
EXEC -11 -21 -v2 f1 f2
INPUT f1 $'a\nb\nc'
INPUT f2 $'a 1\nb 2\nb 3\nc 4'
OUTPUT -
EXEC -11 -21 -v1 f2 f1
TEST 22 VSC#8
INPUT a.dat $'three:this:is:line:three:file2\ntwo:this:is:line:two:file2'
INPUT b.dat $'four:this:is:line:four:file3\nthree:this:is:line:three::file3'
OUTPUT - $'three:three:file2:bozo'
TEST 23 'multibyte C.UTF-8'
EXPORT LC_CTYPE=C.UTF-8
INPUT a.dat $'f1\342\202\254f2'
INPUT b.dat $'t2\342\202\254f1'
OUTPUT - 'f1'
TEST 24 'multibyte euc'
EXPORT LC_CTYPE=ja_JP.eucJP
INPUT a.dat $'\x66\x31\xa1\xf7\x66\x32'
INPUT b.dat $'\x74\x32\xa1\xf7\x66\x31'
OUTPUT - 'f1'