[jira] [Updated] (ASTERIXDB-3627) Primary key missing from result

["Peeyush Gupta (Jira)" <ji...@apache.org>]

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

Peeyush Gupta updated ASTERIXDB-3627:
-------------------------------------
    Description: 
Some queries on collections created without type specification are missing primary keys from the output.
Steps to reproduce the issue
{code:java}
CREATE COLLECTION test PRIMARY KEY (id:String) 
UPSERT INTO test {"id":"1", "name":"abc"} 
SELECT [a] as b FROM test a{code}
The output of the query only contains name and does not contain id field

  was:
Some queries on collections created without type specification are missing primary keys from the output.
Steps to reproduce the issue
{{}}
{code:java}
CREATE COLLECTION test PRIMARY KEY (id:String) 
UPSERT INTO test {"id":"1", "name":"abc"} 
SELECT [a] as b FROM test a{code}
{{}}
The output of the query only contains name and does not contain id field


> Primary key missing from result
> -------------------------------
>
>                 Key: ASTERIXDB-3627
>                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-3627
>             Project: Apache AsterixDB
>          Issue Type: Bug
>          Components: OTH - Other
>            Reporter: Peeyush Gupta
>            Priority: Major
>
> Some queries on collections created without type specification are missing primary keys from the output.
> Steps to reproduce the issue
> {code:java}
> CREATE COLLECTION test PRIMARY KEY (id:String) 
> UPSERT INTO test {"id":"1", "name":"abc"} 
> SELECT [a] as b FROM test a{code}
> The output of the query only contains name and does not contain id field



--
This message was sent by Atlassian Jira
(v8.20.10#820010)