You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@asterixdb.apache.org by "Vignesh Raghunathan (JIRA)" <ji...@apache.org> on 2016/10/18 16:40:58 UTC
[jira] [Updated] (ASTERIXDB-1697) Joining results of with throws
NullPointerException
[ 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)