Avinash Sajjanshetty 112c72bb8e bugfix: RANDOM ROWID should be respected in VACUUM and bulk insert ops (#1048) ...

* Add regression tests for random rowid bugs

Tests added for:

1. VACUUM does not respect RANDOM ROWID - https://github.com/tursodatabase/libsql/issues/929
2. Bulk insert into a fresh table does not respect RANDOM ROWID - https://github.com/tursodatabase/libsql/issues/1046

In both cases, the table should end up random rowids, but they seem to have sequential ones.

* bugfix: pass `regNextRowid` to `OP_NewRowid` call in `xferOptimization`

The register `regNextRowid` contains the `LIBSQL_RANDOM_ROWID_MARKER` value
which tells the VDBE to use a random value for row ids. The method `xferOptimization`
is used in `VACUUM` and bulk insert routines where data from one table is
inserted in another. Since the data is inserted in a loop, it checks for
max rowid once and then keeps inserting it serially. Hence we pass the marker
in each call, so that random id is generated.

2024-02-19 16:58:50 +00:00

..

src

bugfix: RANDOM ROWID should be respected in VACUUM and bulk insert ops (#1048)

2024-02-19 16:58:50 +00:00

Cargo.toml

bugfix: reset modifications of sqlite3_vtab (#1027)

2024-02-15 18:18:30 +00:00