Why does setting multiple fields in an UPDATE-SET statement for ONE QLDB document, return a list of the same document IDs?

0

When I run an UPDATE-SET statement against one of my documents in QLDB using this statement:

UPDATE Documents SET author = 'jkrowling', channel = 'dstv' WHERE docIdExt = 'newDocId'

The return value is a list of document IDs that were modified:

[
  {
    "documentId": "3Ax2GOnKEC82Qp5fwgPEBS"
  },
  {
    "documentId": "3Ax2GOnKEC82Qp5fwgPEBS"
  }
]

Why do I get a list of the same document IDs even if only one document was modified? I have noticed that the amount of IDs I get back is also directly related with the amount of SET elements in my query.

Expectation

Only to get a list of unique document IDs that were modified.

Result

Got a list duplicate document IDs that were modified.

asked a month ago86 views
No Answers

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions