Issues

• SQL conversions run twice when upsert updates an existing row

  simonw/sqlite-utils#946 · Filter by author sanidhyasaluja opened on Nov 14, 2026

• transform(not_null={"col": False}) adds NOT NULL to a nullable column

  simonw/sqlite-utils#944 · Filter by author abhishekcpp007 opened on Nov 14, 2026

• search_sql() exhausts iterator columns before building the outer projection

  simonw/sqlite-utils#942 · Filter by author pengpengyi92 opened on Nov 13, 2026

• JSON with a UTF-8 BOM is misdetected as CSV by sqlite-utils memory

  simonw/sqlite-utils#940 · Filter by author Mint0424 opened on Nov 13, 2026

• Database accepts internally-created autocommit connections without validation

  simonw/sqlite-utils#939 · Filter by author soarkit opened on Nov 12, 2026
  1

• Empty --truncate imports leave existing rows in place

  simonw/sqlite-utils#935 · Filter by author peterolkhov opened on Nov 10, 2026

• create_index exhausts iterator columns while deriving the index name

  simonw/sqlite-utils#933 · Filter by author IlyaKhalafi opened on Nov 8, 2026

• FTS detection treats table names as LIKE patterns

  simonw/sqlite-utils#930 · Filter by author IlyaKhalafi opened on Nov 6, 2026

• Contributing docs: local test runs silently skip SpatiaLite and ext.c tests, and the setup steps assume SSH and uv

  simonw/sqlite-utils#928 · Filter by author lucasrodr1010 opened on Nov 6, 2026

• FTS4 triggers fail when indexed rows are updated or deleted

  simonw/sqlite-utils#922 · Filter by author Muguett-DBY opened on Oct 29, 2026

• Tests use CliRunner.isolated_filesystem(), which is deprecated and will be removed in Click 9.0

  simonw/sqlite-utils#916 · Filter by author ahsanhoq04 opened on Oct 25, 2026

• lookup() treats ordinary and partial indexes as unique lookup constraints

  simonw/sqlite-utils#914 · Filter by author workstonedai-collab opened on Oct 24, 2026

• Avoid quadratic suffix scans when deduplicating query column names

  simonw/sqlite-utils#912 · Filter by author workstonedai-collab opened on Oct 24, 2026

• Repeated Table.convert() runs an earlier callable with the same name

  simonw/sqlite-utils#910 · Filter by author PDGGK opened on Oct 20, 2026

• rows_from_file() splits a single-column CSV file on a letter, or raises csv.Error

  simonw/sqlite-utils#907 · Filter by author L4XB opened on Oct 17, 2026

• enable_fts() exhausts iterator columns before populating the index

  simonw/sqlite-utils#902 · Filter by author er-s-an opened on Oct 11, 2026

• Contributor docs build command omits the docs dependency group

  simonw/sqlite-utils#900 · Filter by author himanshu748 opened on Oct 11, 2026

• CSV/TSV reading silently drops carriage returns inside quoted fields

  simonw/sqlite-utils#895 · Filter by author feiiiiii5 opened on Oct 3, 2026

• rows_from_file() ignores ignore_extras= and extras_key= for anything that isn't Format.CSV

  simonw/sqlite-utils#892 · Filter by author feiiiiii5 opened on Sep 30, 2026

• insert --csv drops values past the header, rows_from_file raises for the same input

  simonw/sqlite-utils#890 · Filter by author feiiiiii5 opened on Sep 28, 2026

• analyze_column() mis-handles columns containing nulls

  simonw/sqlite-utils#887 · Filter by author feiiiiii5 opened on Sep 28, 2026

• insert_all() silently corrupts text values after the first batch (e.g. "007" -> 7)

  simonw/sqlite-utils#885 · Filter by author Soheib68 opened on Sep 27, 2026

• upsert() raises NOT NULL for an omitted column on an existing row (4.2.1)

  simonw/sqlite-utils#878 · Filter by author glaziermag opened on Sep 24, 2026

• Raw numpy scalar values get silently stored as corrupted BLOBs instead of being converted

  simonw/sqlite-utils#876 · Filter by author aayushgupta7725 opened on Sep 23, 2026

• upsert_all() writes NULL to omitted columns in mixed-field batches

  simonw/sqlite-utils#873 · Filter by author glaziermag opened on Sep 22, 2026