[
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)
