Skip to content

0.9.0 — SQL correctness, VB6 data access, and schema impact

Choose a tag to compare

@sfy257000 sfy257000 released this 10 Nov 03:40
· 10 commits to main since this release
120529c

This release fixes missing and incorrect SQL data-access answers, adds conservative VB6 SQL support, and makes schema changes visible without mixing them with row writes.

python -m pip install --upgrade local-codebase-indexer
local-codebase-indexer demo

SQL correctness

  • Resolve UPDATE/DELETE aliases named a, an, or the; support parameterized TOP and UPDATE table hints.
  • Preserve bracketed/double-quoted names, spaces, escaped delimiters, quoted dots, and linked-server qualifiers.
  • Recognize legacy NOLOCK table hints and comma sources following JOIN predicates.
  • Exclude cursor FETCH and scalar TRIM operands from table reads; mask nested block comments correctly.
  • Analyze literal SQL inside OPENQUERY as uncertain, preserving the need to verify remote execution.
  • Attribute constant C# SQL to each executing method, without sharing same-named constants across unrelated classes.

Legacy sources and schema impact

  • BOM-tagged UTF-16/UTF-32 work in indexing, source context, and diagnostics. Actual binary files no longer remain permanently pending as new files.
  • VB6 .frm, .bas, and .cls SQL strings have enclosing method owners. Complete SQL at known ADO/DAO receivers can be confirmed as a static call site; unknown receivers and incomplete expressions remain probable/uncertain. VB6 symbols do not become SQL functions or C# call targets.
  • Table/index DDL appears under schema_changes with confidence filtering and pagination. Git impact includes file-level SQL, before/after evidence, and correct GO batch boundaries.
  • Explicit negations in .ai_context/ignore can include source kept under bin/packages/build/dist. VCS and index-state directories remain excluded.

Maintenance and compatibility

  • Fix first-run Windows lock-file contention and serialize index ignore-file creation.

  • Preserve the seven MCP tools, CLI commands, and public imports while separating relation, context, and rendering code from the query facade.

  • Resolve the existing 32 mypy errors and add Ruff/mypy CI and release checks.

  • Test Linux and Windows on Python 3.10, 3.12, and 3.13.

  • Use pyproject.toml as the dependency source and AGENTS.md as the canonical assistant instructions.

Upgrade note: index format 9 triggers one full rebuild on the first update after upgrading. Subsequent updates remain incremental. Restart existing MCP server processes after upgrading to load the new parser. VB6 support is static string analysis, and schema tracking does not prove migration safety or resolve every runtime SQL pattern.

Validation

147 tests, including 38 new regression cases; installed-wheel demo and Unicode/VB6 smoke checks; extracted source-distribution tests; Ruff/mypy; package/version/checksum validation; and official MCP manifest validation. The three search benchmark Recall@5 results remain approximately 0.92 / 0.91 / 0.62.

See the support and upgrade notes and changelog.