search

ydb-platform / ydb-embedded-ui

MIT License
23 stars 5 forks source link

update via dataquery doesn't change values #844

Open antonkovalenko opened 1 month ago

antonkovalenko commented 1 month ago

Problem

Update table query doesn't change values in a table though operation is marked as success. Affects main and 24-1

Steps to reproduce

  1. select a row in any table by primary key value
  2. run update query that changes any non-pk field's value
  3. select this row by primary key

Expected Result

Value of an updated column was changed

Actual result

After second select you can see the initial value as is update was not applied

artemmufazalov commented 1 month ago

UPDATE with execute-data and execute-query (yql and pg syntax) doesn't work (only execute-script works)

There is no error, response looks similar to execute-script.

Not a frontend issue

antonkovalenko commented 1 month ago

@StekPerepolnen take a look please

StekPerepolnen commented 1 month ago

https://github.com/ydb-platform/ydb/pull/5013

antonkovalenko commented 1 month ago

please don't forget to merge into 24-1

StekPerepolnen commented 1 month ago

https://github.com/ydb-platform/ydb/pull/5081