lvector_sync_delete

Signature:

CREATE PROCEDURE lvector_sync_delete(table_name LVARCHAR, id BIGINT);

Purpose: Deletes the corresponding row from the lvector backing table.

Example:

BEGIN WORK;
EXECUTE PROCEDURE lvector_sync_delete('docs_demo', 1);
COMMIT WORK;

Note: If Informix IDs and LanceDB IDs do not match, delete sync may not remove the expected row. Large delete flushes are now batched into 1000-ID LanceDB calls to avoid OOM kills observed during 10K/20K delete tests.