Build tested: 1.4.0-1

[dlee@master centos7]$ cat gitversionInfo.txt
server commit:
67452bc
engine commit:
4d2a159

Autopilot test case: features.outerJoin

This test works in 1.2.4-1

script: 02_twoTables.sql

ColumnStore returned:

572 select r.* from region r where exists (select null from nation n where n.n_regionkey = r.r_regionkey) order by 1, 2, 3
573 --------------
574
575 r_regionkey r_name r_comment
576 0 AFRICA lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to
577 1 row in set

596 select r.* from region r where not exists (select null from nation n where n.n_regionkey = r.r_regionkey and n.n_nationkey < 4) order by 1, 2, 3
597 --------------
598
599 r_regionkey r_name r_comment
600 0 AFRICA lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to
601 1 row in set

Reference

572 select r.* from region r where exists (select null from nation n where n.n_regionkey = r.r_regionkey) order by 1, 2, 3
573 --------------
574
575 r_regionkey r_name r_comment
576 0 AFRICA lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to
577 1 AMERICA hs use ironic, even requests. s
578 2 ASIA ges. thinly even pinto beans ca
579 3 EUROPE ly final courts cajole furiously final excuse
580 4 MIDDLE EAST uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl
581 5 rows in set

604 select r.* from region r where not exists (select null from nation n where n.n_regionkey = r.r_regionkey and n.n_nationkey < 4) order by 1, 2, 3
605 --------------
606
607 r_regionkey r_name r_comment
608 NULL AMERICA hs use ironic, even requests. s
609 NULL ASIA ges. thinly even pinto beans ca
610 -2 ASIA ges. thinly even pinto beans ca
611 -1 AMERICA hs use ironic, even requests. s
612 2 ASIA ges. thinly even pinto beans ca
613 3 EUROPE ly final courts cajole furiously final excuse
614 4 MIDDLE EAST uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl
615 7 rows in set
616
617 Bye