You are viewing a plain text version of this content. The canonical link for it is here.

Posted to notifications@asterixdb.apache.org by "Peeyush Gupta (Jira)" <ji...@apache.org> on 2025/07/10 17:29:00 UTC

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

Peeyush Gupta created ASTERIXDB-3627:
----------------------------------------

             Summary: 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


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)