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.

質問済み 2ヶ月前91ビュー
回答なし

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

質問に答えるためのガイドライン

関連するコンテンツ