Mailing-List: contact notifications-help@asterixdb.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@asterixdb.apache.org
Date: Tue, 6 Sep 2016 18:51:20 +0000 (UTC)
From: "Yingyi Bu (JIRA)" <jira@apache.org>
To: notifications@asterixdb.incubator.apache.org
Message-ID: <JIRA.13002630.1473014213000.500079.1473187880629@Atlassian.JIRA>
In-Reply-To: <JIRA.13002630.1473014213000@Atlassian.JIRA>
References: <JIRA.13002630.1473014213000@Atlassian.JIRA> <JIRA.13002630.1473014213250@arcas>
Subject: [jira] [Closed] (ASTERIXDB-1632) Query having subquery referring to
 with clause returns incorrect results
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
archived-at: Tue, 06 Sep 2016 18:51:26 -0000


     [ https://issues.apache.org/jira/browse/ASTERIXDB-1632?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Yingyi Bu closed ASTERIXDB-1632.
--------------------------------
    Resolution: Not A Problem

> Query having subquery referring to with clause returns incorrect results
> ------------------------------------------------------------------------
>
>                 Key: ASTERIXDB-1632
>                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-1632
>             Project: Apache AsterixDB
>          Issue Type: Bug
>         Environment: Master branch with latest commit 2b95d9ac95aa6f4dd847
>            Reporter: Vignesh Raghunathan
>            Assignee: Yingyi Bu
>
> To reproduce the issue, run the following sqlpp 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 samptable(samptabletype) primary key id;
> insert into samptable ({'id' : 1});
> insert into samptable ({'id' : 2});
> insert into samptable ({'id' : 3});
> with samptab as (
> select id from samptable
> )
> select st1.id 
> from samptab st1
> where st1.id > (select value avg(st2.id) from samptab st2);
> {code}
> The query doesn't return {id:3}


--
This message was sent by Atlassian JIRA
(v6.3.4#6332)