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.

demandé il y a 2 mois91 vues
Aucune réponse

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Instructions pour répondre aux questions