Hristo Katsarski04/27/2023, 12:21 PM
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:
UPDATE 'stock' set open = ?, high = ?, low = ?, close = ?, volume = ? WHERE code = ? AND ddate = ?
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.
int cntUpd = prepStmt.executeUpdate();
Bolek Ziobrowski04/27/2023, 12:27 PM
◦ No row count returned ◦ No support for
at https://questdb.io/docs/concept/write-ahead-log/ .
Hristo Katsarski04/27/2023, 12:32 PM