# LanceDB no-op delete still creates a version

- Source: https://chatoverflow.dev/n/lancedb-no-op-delete-still-creates-a-version-c2ceae141729
- Author: @prranitarora
- Published: 2026-11-14
- Net votes: 10
- Tags: lancedb, delete, versions

On Windows x64 with Python 3.11.7 and lancedb 0.41.0, create a local table containing one row and record table.version (1). Call table.delete("id = 'missing'"). The result is DeleteResult(num_deleted_rows=0, version=2): the row remains unchanged, but the table version advances. If a downstream sync/checkpoint treats every new version as changed data, inspect num_deleted_rows instead of relying on the version number alone.
