

================================================================
JOIN

mlr --opprint join -s -f ./reg-test/input/joina.dkvp -l l -r r -j o ./reg-test/input/joinb.dkvp
o x y
1 a s
2 b t
2 c t
2 d t
2 b v
2 c v
2 d v
3 e w
3 f w
3 e x
3 f x
3 e y
3 f y

mlr --opprint join -f ./reg-test/input/joina.dkvp -l l -r r -j o ./reg-test/input/joinb.dkvp
o x y
1 a s
2 b t
2 c t
2 d t
2 b v
2 c v
2 d v
3 e w
3 f w
3 e x
3 f x
3 e y
3 f y

mlr --opprint join -s --ul -f ./reg-test/input/joina.dkvp -l l -r r -j o ./reg-test/input/joinb.dkvp
o x y
1 a s
2 b t
2 c t
2 d t
2 b v
2 c v
2 d v
3 e w
3 f w
3 e x
3 f x
3 e y
3 f y

l x
4 g

mlr --opprint join --ul -f ./reg-test/input/joina.dkvp -l l -r r -j o ./reg-test/input/joinb.dkvp
o x y
1 a s
2 b t
2 c t
2 d t
2 b v
2 c v
2 d v
3 e w
3 f w
3 e x
3 f x
3 e y
3 f y

l x
4 g

mlr --opprint join -s --ur -f ./reg-test/input/joina.dkvp -l l -r r -j o ./reg-test/input/joinb.dkvp
o x y
1 a s
2 b t
2 c t
2 d t
2 b v
2 c v
2 d v
3 e w
3 f w
3 e x
3 f x
3 e y
3 f y

r y
5 z

mlr --opprint join --ur -f ./reg-test/input/joina.dkvp -l l -r r -j o ./reg-test/input/joinb.dkvp
o x y
1 a s
2 b t
2 c t
2 d t
2 b v
2 c v
2 d v
3 e w
3 f w
3 e x
3 f x
3 e y
3 f y

r y
5 z

mlr --opprint join -s --ul --ur -f ./reg-test/input/joina.dkvp -l l -r r -j o ./reg-test/input/joinb.dkvp
o x y
1 a s
2 b t
2 c t
2 d t
2 b v
2 c v
2 d v
3 e w
3 f w
3 e x
3 f x
3 e y
3 f y

l x
4 g

r y
5 z

mlr --opprint join --ul --ur -f ./reg-test/input/joina.dkvp -l l -r r -j o ./reg-test/input/joinb.dkvp
o x y
1 a s
2 b t
2 c t
2 d t
2 b v
2 c v
2 d v
3 e w
3 f w
3 e x
3 f x
3 e y
3 f y

r y
5 z

l x
4 g

mlr --opprint join -s --np --ul -f ./reg-test/input/joina.dkvp -l l -r r -j o ./reg-test/input/joinb.dkvp
l x
4 g

mlr --opprint join --np --ul -f ./reg-test/input/joina.dkvp -l l -r r -j o ./reg-test/input/joinb.dkvp
l x
4 g

mlr --opprint join -s --np --ur -f ./reg-test/input/joina.dkvp -l l -r r -j o ./reg-test/input/joinb.dkvp
r y
5 z

mlr --opprint join --np --ur -f ./reg-test/input/joina.dkvp -l l -r r -j o ./reg-test/input/joinb.dkvp
r y
5 z

mlr --opprint join -s --np --ul --ur -f ./reg-test/input/joina.dkvp -l l -r r -j o ./reg-test/input/joinb.dkvp
l x
4 g

r y
5 z

mlr --opprint join --np --ul --ur -f ./reg-test/input/joina.dkvp -l l -r r -j o ./reg-test/input/joinb.dkvp
r y
5 z

l x
4 g

mlr join -l l -r r -j j -f ./reg-test/input/joina.dkvp ./reg-test/input/joinb.dkvp
j=1,x=a,y=s
j=2,x=b,y=t
j=2,x=c,y=t
j=2,x=d,y=t
j=2,x=b,y=v
j=2,x=c,y=v
j=2,x=d,y=v
j=3,x=e,y=w
j=3,x=f,y=w
j=3,x=e,y=x
j=3,x=f,y=x
j=3,x=e,y=y
j=3,x=f,y=y

mlr join -l l -j r -f ./reg-test/input/joina.dkvp ./reg-test/input/joinb.dkvp
r=1,x=a,y=s
r=2,x=b,y=t
r=2,x=c,y=t
r=2,x=d,y=t
r=2,x=b,y=v
r=2,x=c,y=v
r=2,x=d,y=v
r=3,x=e,y=w
r=3,x=f,y=w
r=3,x=e,y=x
r=3,x=f,y=x
r=3,x=e,y=y
r=3,x=f,y=y

mlr join -r r -j l -f ./reg-test/input/joina.dkvp ./reg-test/input/joinb.dkvp
l=1,x=a,y=s
l=2,x=b,y=t
l=2,x=c,y=t
l=2,x=d,y=t
l=2,x=b,y=v
l=2,x=c,y=v
l=2,x=d,y=v
l=3,x=e,y=w
l=3,x=f,y=w
l=3,x=e,y=x
l=3,x=f,y=x
l=3,x=e,y=y
l=3,x=f,y=y

mlr --opprint join -s -f /dev/null -l l -r r -j o ./reg-test/input/joinb.dkvp

mlr --opprint join -f /dev/null -l l -r r -j o ./reg-test/input/joinb.dkvp

mlr --opprint join -s --ul -f /dev/null -l l -r r -j o ./reg-test/input/joinb.dkvp

mlr --opprint join --ul -f /dev/null -l l -r r -j o ./reg-test/input/joinb.dkvp

mlr --opprint join -s --ur -f /dev/null -l l -r r -j o ./reg-test/input/joinb.dkvp
r y
1 s
2 t
2 v
3 w
3 x
3 y
5 z

mlr --opprint join --ur -f /dev/null -l l -r r -j o ./reg-test/input/joinb.dkvp
r y
1 s
2 t
2 v
3 w
3 x
3 y
5 z

mlr --opprint join -s --ul --ur -f /dev/null -l l -r r -j o ./reg-test/input/joinb.dkvp
r y
1 s
2 t
2 v
3 w
3 x
3 y
5 z

mlr --opprint join --ul --ur -f /dev/null -l l -r r -j o ./reg-test/input/joinb.dkvp
r y
1 s
2 t
2 v
3 w
3 x
3 y
5 z

mlr --opprint join -s --np --ul -f /dev/null -l l -r r -j o ./reg-test/input/joinb.dkvp

mlr --opprint join --np --ul -f /dev/null -l l -r r -j o ./reg-test/input/joinb.dkvp

mlr --opprint join -s --np --ur -f /dev/null -l l -r r -j o ./reg-test/input/joinb.dkvp
r y
1 s
2 t
2 v
3 w
3 x
3 y
5 z

mlr --opprint join --np --ur -f /dev/null -l l -r r -j o ./reg-test/input/joinb.dkvp
r y
1 s
2 t
2 v
3 w
3 x
3 y
5 z

mlr --opprint join -s --np --ul --ur -f /dev/null -l l -r r -j o ./reg-test/input/joinb.dkvp
r y
1 s
2 t
2 v
3 w
3 x
3 y
5 z

mlr --opprint join --np --ul --ur -f /dev/null -l l -r r -j o ./reg-test/input/joinb.dkvp
r y
1 s
2 t
2 v
3 w
3 x
3 y
5 z

mlr --opprint join -s -f ./reg-test/input/joina.dkvp -l l -r r -j o /dev/null

mlr --opprint join -f ./reg-test/input/joina.dkvp -l l -r r -j o /dev/null

mlr --opprint join -s --ul -f ./reg-test/input/joina.dkvp -l l -r r -j o /dev/null
l x
1 a
2 b
2 c
2 d
3 e
3 f
4 g

mlr --opprint join --ul -f ./reg-test/input/joina.dkvp -l l -r r -j o /dev/null
l x
1 a
2 b
2 c
2 d
3 e
3 f
4 g

mlr --opprint join -s --ur -f ./reg-test/input/joina.dkvp -l l -r r -j o /dev/null

mlr --opprint join --ur -f ./reg-test/input/joina.dkvp -l l -r r -j o /dev/null

mlr --opprint join -s --ul --ur -f ./reg-test/input/joina.dkvp -l l -r r -j o /dev/null
l x
1 a
2 b
2 c
2 d
3 e
3 f
4 g

mlr --opprint join --ul --ur -f ./reg-test/input/joina.dkvp -l l -r r -j o /dev/null
l x
1 a
2 b
2 c
2 d
3 e
3 f
4 g

mlr --opprint join -s --np --ul -f ./reg-test/input/joina.dkvp -l l -r r -j o /dev/null
l x
1 a
2 b
2 c
2 d
3 e
3 f
4 g

mlr --opprint join --np --ul -f ./reg-test/input/joina.dkvp -l l -r r -j o /dev/null
l x
1 a
2 b
2 c
2 d
3 e
3 f
4 g

mlr --opprint join -s --np --ur -f ./reg-test/input/joina.dkvp -l l -r r -j o /dev/null

mlr --opprint join --np --ur -f ./reg-test/input/joina.dkvp -l l -r r -j o /dev/null

mlr --opprint join -s --np --ul --ur -f ./reg-test/input/joina.dkvp -l l -r r -j o /dev/null
l x
1 a
2 b
2 c
2 d
3 e
3 f
4 g

mlr --opprint join --np --ul --ur -f ./reg-test/input/joina.dkvp -l l -r r -j o /dev/null
l x
1 a
2 b
2 c
2 d
3 e
3 f
4 g

mlr --odkvp join -j a -f ./reg-test/input/join-het.dkvp ./reg-test/input/abixy-het
a=pan,n=234,b=pan,i=1,x=0.3467901443380824,y=0.7268028627434533
a=eks,n=123,b=pan,i=2,x=0.7586799647899636,y=0.5221511083334797
a=eks,n=123,bbb=wye,i=4,x=0.38139939387114097,y=0.13418874328430463
a=wye,n=345,b=pan,i=5,xxx=0.5732889198020006,y=0.8636244699032729
a=zee,n=456,b=pan,i=6,x=0.5271261600918548,y=0.49322128674835697
a=eks,n=123,b=zee,iii=7,x=0.6117840605678454,y=0.1878849191181694
a=zee,n=456,b=wye,i=8,x=0.5985540091064224,yyy=0.976181385699006
a=pan,n=234,b=wye,i=10,x=0.5026260055412137,y=0.9526183602969864

mlr --odkvp join -j a -f ./reg-test/input/abixy-het ./reg-test/input/join-het.dkvp
a=eks,b=pan,i=2,x=0.7586799647899636,y=0.5221511083334797,n=123
a=eks,bbb=wye,i=4,x=0.38139939387114097,y=0.13418874328430463,n=123
a=eks,b=zee,iii=7,x=0.6117840605678454,y=0.1878849191181694,n=123
a=pan,b=pan,i=1,x=0.3467901443380824,y=0.7268028627434533,n=234
a=pan,b=wye,i=10,x=0.5026260055412137,y=0.9526183602969864,n=234
a=wye,b=pan,i=5,xxx=0.5732889198020006,y=0.8636244699032729,n=345
a=zee,b=pan,i=6,x=0.5271261600918548,y=0.49322128674835697,n=456
a=zee,b=wye,i=8,x=0.5985540091064224,yyy=0.976181385699006,n=456

mlr --odkvp join --np --ul --ur -j a -f ./reg-test/input/join-het.dkvp ./reg-test/input/abixy-het
aaa=wye,b=wye,i=3,x=0.20460330576630303,y=0.33831852551664776
aaa=hat,bbb=wye,i=9,x=0.03144187646093577,y=0.7495507603507059
aye=bee,enn=emm

mlr --odkvp join --np --ul --ur -j a -f ./reg-test/input/abixy-het ./reg-test/input/join-het.dkvp
aye=bee,enn=emm
aaa=wye,b=wye,i=3,x=0.20460330576630303,y=0.33831852551664776
aaa=hat,bbb=wye,i=9,x=0.03144187646093577,y=0.7495507603507059

mlr --idkvp --oxtab join --lp left_ --rp right_ -j i -f ./reg-test/input/abixy-het ./reg-test/input/abixy-het
i       1
left_a  pan
left_b  pan
left_x  0.3467901443380824
left_y  0.7268028627434533
right_a pan
right_b pan
right_x 0.3467901443380824
right_y 0.7268028627434533

i       2
left_a  eks
left_b  pan
left_x  0.7586799647899636
left_y  0.5221511083334797
right_a eks
right_b pan
right_x 0.7586799647899636
right_y 0.5221511083334797

i         3
left_aaa  wye
left_b    wye
left_x    0.20460330576630303
left_y    0.33831852551664776
right_aaa wye
right_b   wye
right_x   0.20460330576630303
right_y   0.33831852551664776

i         4
left_a    eks
left_bbb  wye
left_x    0.38139939387114097
left_y    0.13418874328430463
right_a   eks
right_bbb wye
right_x   0.38139939387114097
right_y   0.13418874328430463

i         5
left_a    wye
left_b    pan
left_xxx  0.5732889198020006
left_y    0.8636244699032729
right_a   wye
right_b   pan
right_xxx 0.5732889198020006
right_y   0.8636244699032729

i       6
left_a  zee
left_b  pan
left_x  0.5271261600918548
left_y  0.49322128674835697
right_a zee
right_b pan
right_x 0.5271261600918548
right_y 0.49322128674835697

i         8
left_a    zee
left_b    wye
left_x    0.5985540091064224
left_yyy  0.976181385699006
right_a   zee
right_b   wye
right_x   0.5985540091064224
right_yyy 0.976181385699006

i         9
left_aaa  hat
left_bbb  wye
left_x    0.03144187646093577
left_y    0.7495507603507059
right_aaa hat
right_bbb wye
right_x   0.03144187646093577
right_y   0.7495507603507059

i       10
left_a  pan
left_b  wye
left_x  0.5026260055412137
left_y  0.9526183602969864
right_a pan
right_b wye
right_x 0.5026260055412137
right_y 0.9526183602969864

mlr join -s -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r1
j=1,b=11
j=1,b=12

mlr join -s -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r11
j=1,b=11
j=1,b=12
j=1,b=11
j=1,b=12

mlr join -s -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r12
j=1,b=11
j=1,b=12

mlr join -s -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r13
j=1,b=11
j=1,b=12
j=3,b=14
j=3,b=15

mlr join -s -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r14
j=1,b=11
j=1,b=12

mlr join -s -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r15
j=1,b=11
j=1,b=12
j=5,b=17
j=5,b=18

mlr join -s -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r16
j=1,b=11
j=1,b=12

mlr join -s -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r2

mlr join -s -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r22

mlr join -s -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r23
j=3,b=14
j=3,b=15

mlr join -s -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r24

mlr join -s -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r25
j=5,b=17
j=5,b=18

mlr join -s -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r26

mlr join -s -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r3
j=3,b=14
j=3,b=15

mlr join -s -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r33
j=3,b=14
j=3,b=15
j=3,b=14
j=3,b=15

mlr join -s -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r34
j=3,b=14
j=3,b=15

mlr join -s -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r35
j=3,b=14
j=3,b=15
j=5,b=17
j=5,b=18

mlr join -s -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r36
j=3,b=14
j=3,b=15

mlr join -s -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r4

mlr join -s -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r44

mlr join -s -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r45
j=5,b=17
j=5,b=18

mlr join -s -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r46

mlr join -s -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r5
j=5,b=17
j=5,b=18

mlr join -s -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r55
j=5,b=17
j=5,b=18
j=5,b=17
j=5,b=18

mlr join -s -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r56
j=5,b=17
j=5,b=18

mlr join -s -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r6

mlr join -s -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r66

mlr join -s --np --ul -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r1
x=100,b=10
x=200,b=13
l=3,b=14
l=3,b=15
x=300,b=16
l=5,b=17
l=5,b=18
x=400,b=19

mlr join -s --np --ul -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r11
x=100,b=10
x=200,b=13
l=3,b=14
l=3,b=15
x=300,b=16
l=5,b=17
l=5,b=18
x=400,b=19

mlr join -s --np --ul -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r12
x=100,b=10
x=200,b=13
x=300,b=16
l=3,b=14
l=3,b=15
l=5,b=17
l=5,b=18
x=400,b=19

mlr join -s --np --ul -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r13
x=100,b=10
x=200,b=13
x=300,b=16
l=5,b=17
l=5,b=18
x=400,b=19

mlr join -s --np --ul -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r14
x=100,b=10
x=200,b=13
l=3,b=14
l=3,b=15
x=300,b=16
x=400,b=19
l=5,b=17
l=5,b=18

mlr join -s --np --ul -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r15
x=100,b=10
x=200,b=13
l=3,b=14
l=3,b=15
x=300,b=16
x=400,b=19

mlr join -s --np --ul -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r16
x=100,b=10
x=200,b=13
l=3,b=14
l=3,b=15
x=300,b=16
l=5,b=17
l=5,b=18
x=400,b=19

mlr join -s --np --ul -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r2
x=100,b=10
x=200,b=13
l=1,b=11
l=1,b=12
x=300,b=16
l=3,b=14
l=3,b=15
l=5,b=17
l=5,b=18
x=400,b=19

mlr join -s --np --ul -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r22
x=100,b=10
x=200,b=13
l=1,b=11
l=1,b=12
x=300,b=16
l=3,b=14
l=3,b=15
l=5,b=17
l=5,b=18
x=400,b=19

mlr join -s --np --ul -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r23
x=100,b=10
x=200,b=13
l=1,b=11
l=1,b=12
x=300,b=16
l=5,b=17
l=5,b=18
x=400,b=19

mlr join -s --np --ul -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r24
x=100,b=10
x=200,b=13
l=1,b=11
l=1,b=12
x=300,b=16
l=3,b=14
l=3,b=15
x=400,b=19
l=5,b=17
l=5,b=18

mlr join -s --np --ul -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r25
x=100,b=10
x=200,b=13
l=1,b=11
l=1,b=12
x=300,b=16
l=3,b=14
l=3,b=15
x=400,b=19

mlr join -s --np --ul -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r26
x=100,b=10
x=200,b=13
l=1,b=11
l=1,b=12
x=300,b=16
l=3,b=14
l=3,b=15
l=5,b=17
l=5,b=18
x=400,b=19

mlr join -s --np --ul -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r3
x=100,b=10
x=200,b=13
l=1,b=11
l=1,b=12
x=300,b=16
l=5,b=17
l=5,b=18
x=400,b=19

mlr join -s --np --ul -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r33
x=100,b=10
x=200,b=13
l=1,b=11
l=1,b=12
x=300,b=16
l=5,b=17
l=5,b=18
x=400,b=19

mlr join -s --np --ul -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r34
x=100,b=10
x=200,b=13
l=1,b=11
l=1,b=12
x=300,b=16
x=400,b=19
l=5,b=17
l=5,b=18

mlr join -s --np --ul -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r35
x=100,b=10
x=200,b=13
l=1,b=11
l=1,b=12
x=300,b=16
x=400,b=19

mlr join -s --np --ul -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r36
x=100,b=10
x=200,b=13
l=1,b=11
l=1,b=12
x=300,b=16
l=5,b=17
l=5,b=18
x=400,b=19

mlr join -s --np --ul -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r4
x=100,b=10
x=200,b=13
l=1,b=11
l=1,b=12
l=3,b=14
l=3,b=15
x=300,b=16
x=400,b=19
l=5,b=17
l=5,b=18

mlr join -s --np --ul -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r44
x=100,b=10
x=200,b=13
l=1,b=11
l=1,b=12
l=3,b=14
l=3,b=15
x=300,b=16
x=400,b=19
l=5,b=17
l=5,b=18

mlr join -s --np --ul -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r45
x=100,b=10
x=200,b=13
l=1,b=11
l=1,b=12
l=3,b=14
l=3,b=15
x=300,b=16
x=400,b=19

mlr join -s --np --ul -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r46
x=100,b=10
x=200,b=13
l=1,b=11
l=1,b=12
l=3,b=14
l=3,b=15
x=300,b=16
x=400,b=19
l=5,b=17
l=5,b=18

mlr join -s --np --ul -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r5
x=100,b=10
x=200,b=13
l=1,b=11
l=1,b=12
l=3,b=14
l=3,b=15
x=300,b=16
x=400,b=19

mlr join -s --np --ul -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r55
x=100,b=10
x=200,b=13
l=1,b=11
l=1,b=12
l=3,b=14
l=3,b=15
x=300,b=16
x=400,b=19

mlr join -s --np --ul -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r56
x=100,b=10
x=200,b=13
l=1,b=11
l=1,b=12
l=3,b=14
l=3,b=15
x=300,b=16
x=400,b=19

mlr join -s --np --ul -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r6
x=100,b=10
x=200,b=13
l=1,b=11
l=1,b=12
l=3,b=14
l=3,b=15
x=300,b=16
l=5,b=17
l=5,b=18
x=400,b=19

mlr join -s --np --ul -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r66
x=100,b=10
x=200,b=13
l=1,b=11
l=1,b=12
l=3,b=14
l=3,b=15
x=300,b=16
l=5,b=17
l=5,b=18
x=400,b=19

mlr join -s --np --ur -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r1
y=111
y=333

mlr join -s --np --ur -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r11
y=111
y=222
y=333

mlr join -s --np --ur -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r12
y=111
y=222
r=2
y=333

mlr join -s --np --ur -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r13
y=111
y=222
y=333

mlr join -s --np --ur -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r14
y=111
y=222
r=4
y=333

mlr join -s --np --ur -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r15
y=111
y=222
y=333

mlr join -s --np --ur -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r16
y=111
y=222
r=6
y=333

mlr join -s --np --ur -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r2
y=111
r=2
y=333

mlr join -s --np --ur -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r22
y=111
r=2
y=222
r=2
y=333

mlr join -s --np --ur -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r23
y=111
r=2
y=222
y=333

mlr join -s --np --ur -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r24
y=111
r=2
y=222
r=4
y=333

mlr join -s --np --ur -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r25
y=111
r=2
y=222
y=333

mlr join -s --np --ur -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r26
y=111
r=2
y=222
r=6
y=333

mlr join -s --np --ur -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r3
y=111
y=333

mlr join -s --np --ur -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r33
y=111
y=222
y=333

mlr join -s --np --ur -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r34
y=111
y=222
r=4
y=333

mlr join -s --np --ur -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r35
y=111
y=222
y=333

mlr join -s --np --ur -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r36
y=111
y=222
r=6
y=333

mlr join -s --np --ur -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r4
y=111
r=4
y=333

mlr join -s --np --ur -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r44
y=111
r=4
y=222
r=4
y=333

mlr join -s --np --ur -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r45
y=111
r=4
y=222
y=333

mlr join -s --np --ur -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r46
y=111
r=4
y=222
r=6
y=333

mlr join -s --np --ur -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r5
y=111
y=333

mlr join -s --np --ur -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r55
y=111
y=222
y=333

mlr join -s --np --ur -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r56
y=111
y=222
r=6
y=333

mlr join -s --np --ur -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r6
y=111
r=6
y=333

mlr join -s --np --ur -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r66
y=111
r=6
y=222
r=6
y=333

mlr join -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r1
j=1,b=11
j=1,b=12

mlr join -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r11
j=1,b=11
j=1,b=12
j=1,b=11
j=1,b=12

mlr join -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r12
j=1,b=11
j=1,b=12

mlr join -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r13
j=1,b=11
j=1,b=12
j=3,b=14
j=3,b=15

mlr join -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r14
j=1,b=11
j=1,b=12

mlr join -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r15
j=1,b=11
j=1,b=12
j=5,b=17
j=5,b=18

mlr join -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r16
j=1,b=11
j=1,b=12

mlr join -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r2

mlr join -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r22

mlr join -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r23
j=3,b=14
j=3,b=15

mlr join -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r24

mlr join -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r25
j=5,b=17
j=5,b=18

mlr join -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r26

mlr join -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r3
j=3,b=14
j=3,b=15

mlr join -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r33
j=3,b=14
j=3,b=15
j=3,b=14
j=3,b=15

mlr join -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r34
j=3,b=14
j=3,b=15

mlr join -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r35
j=3,b=14
j=3,b=15
j=5,b=17
j=5,b=18

mlr join -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r36
j=3,b=14
j=3,b=15

mlr join -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r4

mlr join -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r44

mlr join -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r45
j=5,b=17
j=5,b=18

mlr join -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r46

mlr join -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r5
j=5,b=17
j=5,b=18

mlr join -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r55
j=5,b=17
j=5,b=18
j=5,b=17
j=5,b=18

mlr join -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r56
j=5,b=17
j=5,b=18

mlr join -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r6

mlr join -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r66

mlr join --np --ul -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r1
l=3,b=14
l=3,b=15
l=5,b=17
l=5,b=18
x=100,b=10
x=200,b=13
x=300,b=16
x=400,b=19

mlr join --np --ul -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r11
l=3,b=14
l=3,b=15
l=5,b=17
l=5,b=18
x=100,b=10
x=200,b=13
x=300,b=16
x=400,b=19

mlr join --np --ul -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r12
l=3,b=14
l=3,b=15
l=5,b=17
l=5,b=18
x=100,b=10
x=200,b=13
x=300,b=16
x=400,b=19

mlr join --np --ul -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r13
l=5,b=17
l=5,b=18
x=100,b=10
x=200,b=13
x=300,b=16
x=400,b=19

mlr join --np --ul -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r14
l=3,b=14
l=3,b=15
l=5,b=17
l=5,b=18
x=100,b=10
x=200,b=13
x=300,b=16
x=400,b=19

mlr join --np --ul -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r15
l=3,b=14
l=3,b=15
x=100,b=10
x=200,b=13
x=300,b=16
x=400,b=19

mlr join --np --ul -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r16
l=3,b=14
l=3,b=15
l=5,b=17
l=5,b=18
x=100,b=10
x=200,b=13
x=300,b=16
x=400,b=19

mlr join --np --ul -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r2
l=1,b=11
l=1,b=12
l=3,b=14
l=3,b=15
l=5,b=17
l=5,b=18
x=100,b=10
x=200,b=13
x=300,b=16
x=400,b=19

mlr join --np --ul -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r22
l=1,b=11
l=1,b=12
l=3,b=14
l=3,b=15
l=5,b=17
l=5,b=18
x=100,b=10
x=200,b=13
x=300,b=16
x=400,b=19

mlr join --np --ul -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r23
l=1,b=11
l=1,b=12
l=5,b=17
l=5,b=18
x=100,b=10
x=200,b=13
x=300,b=16
x=400,b=19

mlr join --np --ul -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r24
l=1,b=11
l=1,b=12
l=3,b=14
l=3,b=15
l=5,b=17
l=5,b=18
x=100,b=10
x=200,b=13
x=300,b=16
x=400,b=19

mlr join --np --ul -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r25
l=1,b=11
l=1,b=12
l=3,b=14
l=3,b=15
x=100,b=10
x=200,b=13
x=300,b=16
x=400,b=19

mlr join --np --ul -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r26
l=1,b=11
l=1,b=12
l=3,b=14
l=3,b=15
l=5,b=17
l=5,b=18
x=100,b=10
x=200,b=13
x=300,b=16
x=400,b=19

mlr join --np --ul -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r3
l=1,b=11
l=1,b=12
l=5,b=17
l=5,b=18
x=100,b=10
x=200,b=13
x=300,b=16
x=400,b=19

mlr join --np --ul -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r33
l=1,b=11
l=1,b=12
l=5,b=17
l=5,b=18
x=100,b=10
x=200,b=13
x=300,b=16
x=400,b=19

mlr join --np --ul -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r34
l=1,b=11
l=1,b=12
l=5,b=17
l=5,b=18
x=100,b=10
x=200,b=13
x=300,b=16
x=400,b=19

mlr join --np --ul -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r35
l=1,b=11
l=1,b=12
x=100,b=10
x=200,b=13
x=300,b=16
x=400,b=19

mlr join --np --ul -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r36
l=1,b=11
l=1,b=12
l=5,b=17
l=5,b=18
x=100,b=10
x=200,b=13
x=300,b=16
x=400,b=19

mlr join --np --ul -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r4
l=1,b=11
l=1,b=12
l=3,b=14
l=3,b=15
l=5,b=17
l=5,b=18
x=100,b=10
x=200,b=13
x=300,b=16
x=400,b=19

mlr join --np --ul -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r44
l=1,b=11
l=1,b=12
l=3,b=14
l=3,b=15
l=5,b=17
l=5,b=18
x=100,b=10
x=200,b=13
x=300,b=16
x=400,b=19

mlr join --np --ul -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r45
l=1,b=11
l=1,b=12
l=3,b=14
l=3,b=15
x=100,b=10
x=200,b=13
x=300,b=16
x=400,b=19

mlr join --np --ul -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r46
l=1,b=11
l=1,b=12
l=3,b=14
l=3,b=15
l=5,b=17
l=5,b=18
x=100,b=10
x=200,b=13
x=300,b=16
x=400,b=19

mlr join --np --ul -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r5
l=1,b=11
l=1,b=12
l=3,b=14
l=3,b=15
x=100,b=10
x=200,b=13
x=300,b=16
x=400,b=19

mlr join --np --ul -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r55
l=1,b=11
l=1,b=12
l=3,b=14
l=3,b=15
x=100,b=10
x=200,b=13
x=300,b=16
x=400,b=19

mlr join --np --ul -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r56
l=1,b=11
l=1,b=12
l=3,b=14
l=3,b=15
x=100,b=10
x=200,b=13
x=300,b=16
x=400,b=19

mlr join --np --ul -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r6
l=1,b=11
l=1,b=12
l=3,b=14
l=3,b=15
l=5,b=17
l=5,b=18
x=100,b=10
x=200,b=13
x=300,b=16
x=400,b=19

mlr join --np --ul -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r66
l=1,b=11
l=1,b=12
l=3,b=14
l=3,b=15
l=5,b=17
l=5,b=18
x=100,b=10
x=200,b=13
x=300,b=16
x=400,b=19

mlr join --np --ur -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r1
y=111
y=333

mlr join --np --ur -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r11
y=111
y=222
y=333

mlr join --np --ur -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r12
y=111
y=222
r=2
y=333

mlr join --np --ur -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r13
y=111
y=222
y=333

mlr join --np --ur -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r14
y=111
y=222
r=4
y=333

mlr join --np --ur -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r15
y=111
y=222
y=333

mlr join --np --ur -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r16
y=111
y=222
r=6
y=333

mlr join --np --ur -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r2
y=111
r=2
y=333

mlr join --np --ur -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r22
y=111
r=2
y=222
r=2
y=333

mlr join --np --ur -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r23
y=111
r=2
y=222
y=333

mlr join --np --ur -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r24
y=111
r=2
y=222
r=4
y=333

mlr join --np --ur -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r25
y=111
r=2
y=222
y=333

mlr join --np --ur -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r26
y=111
r=2
y=222
r=6
y=333

mlr join --np --ur -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r3
y=111
y=333

mlr join --np --ur -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r33
y=111
y=222
y=333

mlr join --np --ur -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r34
y=111
y=222
r=4
y=333

mlr join --np --ur -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r35
y=111
y=222
y=333

mlr join --np --ur -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r36
y=111
y=222
r=6
y=333

mlr join --np --ur -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r4
y=111
r=4
y=333

mlr join --np --ur -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r44
y=111
r=4
y=222
r=4
y=333

mlr join --np --ur -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r45
y=111
r=4
y=222
y=333

mlr join --np --ur -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r46
y=111
r=4
y=222
r=6
y=333

mlr join --np --ur -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r5
y=111
y=333

mlr join --np --ur -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r55
y=111
y=222
y=333

mlr join --np --ur -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r56
y=111
y=222
r=6
y=333

mlr join --np --ur -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r6
y=111
r=6
y=333

mlr join --np --ur -l l -r r -j j -f ./reg-test/input/het-join-left ./reg-test/input/het-join-right-r66
y=111
r=6
y=222
r=6
y=333

