UPSERT only a single document

SQL++
2

Hi @deamontg, which version are you using? UPDATE works as expected.

select meta().id, * from default use keys "k_blr" ;
[
  {
    "default": {
      "country": "India",
      "faa": "BLR",
    },
    "id": "k_blr"
  }
]

update default use keys "k_blr" set faa = "blr2", name = "Bangalore" returning *;
[
  {
    "default": {
      "country": "India",
      "faa": "blr2",
      "name": "Bangalore"
    }
  }
]
2 Likes