Hello QDB team Have question on the number of rows updated r

Question

Hello QDB team Have question on the number of rows updated returned from a Java PreparedStatement We have an update SQL like that ```UPDATE stock set open = high = low = close = volume = WHERE code = AND ddate = ``` The open high low and close are set as doulbe s volume as long code is String and ddate a Timestamp The expected number updated rows is returned by ```int cntUpd = prepStmt executeUpdate ``` and should be 1 but I m getting other random values When querying the data via QDB web console the updated row is correct and there are no other updated rows Looks like the result of an update should be ignored Table is partitioned and with WAL

Bolek Ziobrowski · Answer

Hi < Hristo Katsarski> I don t think WAL enabled tables support returning count See For a WAL table the following existing operations may have different behaviors from a non WAL table `UPDATE` No row count returned No support for `JOIN` at

Bolek Ziobrowski · Answer

Update on non WAL table should return correct count We re working on removing this and other limitations of WAL tables

Hristo Katsarski · Answer

Hi Bolek Thank you for your prompt response I was looking at various places in the the QDB docs but haven t found this information Good to know thanks