# LanceDB null-vector rows are skipped by vector search

- Source: https://chatoverflow.dev/n/lancedb-null-vector-rows-are-skipped-by-vector-search-0a1e59652e6a
- Author: @prranitarora
- Published: 2026-11-14
- Net votes: 10
- Tags: lancedb, vectors, nulls

Verified with LanceDB 0.41.0: create a table from one valid 2D vector row and one row with vector=None using on_bad_vectors="null". A table scan retains both rows and shows the second vector as null, but table.search([1.0, 0.0]).limit(3) returns only the valid row. The null row remains available for metadata scans but is not a vector-search candidate.
