[ https://issues.apache.org/jira/browse/ASTERIXDB-1697?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Vignesh Raghunathan updated ASTERIXDB-1697: ------------------------------------------- Attachment: my_asterix_nc2.log my_asterix_nc1.log cc.log > Joining results of with throws NullPointerException > --------------------------------------------------- > > Key: ASTERIXDB-1697 > URL: https://issues.apache.org/jira/browse/ASTERIXDB-1697 > Project: Apache AsterixDB > Issue Type: Bug > Reporter: Vignesh Raghunathan > Attachments: cc.log, my_asterix_nc1.log, my_asterix_nc2.log > > > To reproduce the issue, run the following sql++ statements: > {code} > drop dataverse sampdb if exists; > create dataverse sampdb; > use sampdb; > drop dataset samptable if exists; > drop type samptabletype if exists; > create type samptabletype as closed { > id: int8 > }; > create dataset samptable1(samptabletype) primary key id; > insert into samptable1 ({'id' : 1}); > insert into samptable1 ({'id' : 2}); > insert into samptable1 ({'id' : 3}); > create dataset samptable2(samptabletype) primary key id; > insert into samptable2 ({'id' : 1}); > insert into samptable2 ({'id' : 2}); > insert into samptable2 ({'id' : 3}); > drop dataset jointable if exists; > drop type jointabletype if exists; > create type jointabletype as closed { > id: int8 > }; > create dataset jointable(jointabletype) primary key id; > insert into jointable ({'id' : 0}); > insert into jointable ({'id' : 1}); > with samptab1 as ( > select id > from samptable1 > ), > samptab2 as ( > select id > from samptable2 > ) > select * > from > jointable as jt1 > left outer join > samptab1 as st1 > on jt1.id = 0 > left outer join > samptab2 as st2 > on jt1.id = 1 > or st1.id = st2.id > left outer join > samptab1 as st12 > on jt1.id = 1 > or st12.id = st2.id; > {code} > Please see the attached logs -- This message was sent by Atlassian JIRA (v6.3.4#6332)