# 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 EXEC -1 1 -2 1 -t: -o 1.5,2.5,1.6,2.6 -e bozo a.dat b.dat 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 EXEC -j1 1 -j2 2 -o 1.1 -t $'\342\202\254' a.dat b.dat 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 EXEC -j1 1 -j2 2 -o 1.1 -t $'\xa1\xf7' a.dat b.dat INPUT a.dat $'\x66\x31\xa1\xf7\x66\x32' INPUT b.dat $'\x74\x32\xa1\xf7\x66\x31' OUTPUT - 'f1'
