[jira] [Created] (ASTERIXDB-1598) Grouping by columns with same name throws error

[Vignesh Raghunathan (JIRA)]

Vignesh Raghunathan created ASTERIXDB-1598:
----------------------------------------------

             Summary: Grouping by columns with same name throws error
                 Key: ASTERIXDB-1598
                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-1598
             Project: Apache AsterixDB
          Issue Type: Bug
         Environment: Master branch with latest commit 
0339b475f323e6e2777dbcb13ee2
            Reporter: Vignesh Raghunathan


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 samptabletype1 as closed {
  id: int64
};

create type samptabletype2 as closed {
  id: int64
};

create dataset samptable1(samptabletype1) primary key id;
create dataset samptable2(samptabletype2) primary key id;

select *
from samptable1  s1, samptable2 s2
group by s1.id, s2.id;
{code}

Result:

{code}
Error: Duplicate alias definitions: id
{code}



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