Skip to content

LionSQL v0.92.0

Choose a tag to compare

@MaroShim MaroShim released this 09 Nov 01:01
· 415 commits to main since this release

LionSQL v0.92.0 Release Notes (notes/release_notes/RELEASE_NOTES_v0.92.0.md)

  • Initial Date: 2026-11-09
  • Release Version: v0.92.0 (Minor Release)
  • Milestone Theme: Comprehensive 37 P0 Defect Remediations, WiredTiger High-Concurrency Lock Removal (Invariant 10), All-Time High TPC-C Benchmark Surge (+16%~+86%), and Cooldown Architecture

1. Release Highlights

LionSQL v0.92.0 is a landmark milestone release that resolves all 37 critical P0 architectural defects uncovered during our 135-step full-spectrum codebase audit, establishing enterprise mission-critical durability while achieving all-time high benchmark throughput across all 4 tiers simultaneously:

  • 135-Step Audit P0 Remediation: 37 Critical Defects Resolved (Structural Hardening):

    • Storage & Durability: FlatRecord heap offset collision isolation tag (slot[7], P0-01), preservation of row data on ALTER TABLE ADD COLUMN (P0-04), partition key mutex isolation (partMu, P0-05), fail-closed WAL recovery preventing illegal mid-log truncation (P0-03, ADR-027), and atomic segment rotation on WAL archiving (P0-15).
    • Security & RBAC: Eradication of anonymous admin bypass backdoor (P0-06), absolute precedence enforcement for explicit DENY over GRANT (P0-07), atomic persistence of logins and grants to auth.json (P0-09), and mandatory all-caps default password boot banner warning (SEC-BOOT-DEFAULT-PASS-WARN).
    • Replication & CDC: CDC Outbox exponential backoff backpressure on unreachable brokers (P0-08, ADR-026), CDC Lossless Bridge 2-phase streaming handover (P0-10), and fail-closed isolation preventing silent drop on slow replica buffer overflow (P0-34).
    • Execution Engine & Memory Governor: CUBE 12-dimension bounding (P0-11), WindowIterator and MergeJoin 64MB WorkMem real-time budget tracking (P0-12, P0-13), child iterator resource leakage prevention (P0-14), MERGE statement PK direct streaming (P0-18), and fail-closed atomic rollback on DML scan I/O errors (P0-19).
    • Wire Protocols & Sessions: TDS/PGWire 64MB and HTTP Chunked 32MB payload framing limits (P0-27, P0-35), transaction rollback-first session disconnect drain (P0-26), session lock scope shrinking and re-entrant worker guards (P0-30), dynamic RLS AST isolation (P0-31), strict @@TRANCOUNT nested commit enforcement (P0-32), eager LazyTuple materialization before set deduplication (P0-33), and global session panic recovery guards (P0-37).
    • Memory Hygiene: Pointer zeroing and slice capacity bounding in global sync.Pool recyclers (P0-29), eliminating long-lived heap bloat and GC stop-the-world spikes under high-speed concurrency.
  • WiredTiger High-Concurrency Lock Removal & Invariant 10 Permanent Lockdown:

    • Enforced a 4-layer permanent lockdown preventing transaction_sync from appearing in wiredtiger_open configurations ([RULE:WiredTigerHighConcurrency]), eliminating the global C transaction mutex serialization bottleneck.
    • While preserving 100% ACID durability via WiredTiger native group commit and background periodic flushing (1s interval), achieved storage kernel TPC-C 1,184,785 tpmC (+42.1%) and network TDS 255,040 tpmC (+86.4%).
  • All-Time High Benchmark Surges Across All Tiers & 5-Second Cooldown Protocol (scripts/run_all_benchmarks.sh):

    • Tier 1 (cmd/bench): In-Memory OCC 218,282 TPS (+16.1%), WiredTiger 141,472 TPS (+16.6%) (100% ACID verified).
    • Tier 2 (Storage Kernel): In-Memory OCC 1,066,827 tpmC (39,748 TPS), WiredTiger 1,184,785 tpmC (41,905 TPS).
    • Tier 3 (VDBE T-SQL Runtime): In-Memory OCC 723k ~ 759k tpmC (26.9k ~ 28.1k TPS, +25%~+46%), WiredTiger 825k ~ 863k tpmC (28.7k ~ 31.7k TPS, +25%~+39%).
    • Tier 4 (Network Wire): PGWire v3 329k ~ 376k tpmC (11.7k ~ 13.9k TPS), TDS 228k ~ 315k tpmC (8.4k ~ 11.6k TPS).
    • Codified the 5-second cooldown gap protocol (--cooldown=5) in benchmark harnesses to guarantee host kernel TCP TIME_WAIT socket drain and CPU thermal recovery.
  • SSMS Official Integration Guide & Virtual System Views:

    • Published comprehensive Microsoft SQL Server Management Studio (SSMS 19/20) integration guide (guide/SSMS_INTEGRATION_GUIDE.md / Korean).
    • Expanded virtual system views with sys.dm_os_host_info for seamless GUI introspection.

2. Verification & Compliance

  1. 3-Stage Pipeline Verification ([RULE:PipelineVerification]):
    • Official release binaries compiled for macOS (darwin-arm64), Linux (linux-amd64), and Windows (windows-amd64.exe).
    • go test -tags wiredtiger -count=1 -race ./pkg/... 100% PASS across all core packages (0 data races).
  2. ACID Durability & Crash Recovery Oracles:
    • Verified 10-round zero-loss crash recovery (bin/crashtest) under abrupt SIGKILL.
    • 100,000 banking transfer transactions executed with 0 rollbacks and 100% ACID consistency.

Detailed Changelog Delta

Added

  • enforce all-caps default password warning on boot banner last line (SEC-BOOT-DEFAULT-PASS-WARN) (c0913da)
  • persist logins, users, and grants to auth.json atomically across restarts (P0-09) (f10602f)
  • set memory engine as default for Windows platform (ef81b51)

Fixed

  • eliminate anonymous user admin bypass backdoor (P0-06) (df23626)
  • enforce fail-closed checkTableAccess and fix LIKE wildcard precedence (3f140a7)
  • ensure explicit role DENY takes absolute precedence over GRANT (P0-07) (39a6b7e)
  • stall dispatcher on unreachable broker to guarantee zero data loss and FIFO ordering (P0-08, ADR-026) (1df60f2)
  • eliminate historical replay silent drop via lossless bridge streaming (P0-10) (dacd070)
  • isolate SSO tag byte to eliminate flat record heap offset collision (P0-01) (eef5db6)
  • materialize flat record row on snapshot sync to prevent data loss (P0-02) (e5e702c)
  • enforce fail-closed WAL recovery and prevent illegal truncation on I/O error (P0-03) (c847184)
  • preserve existing flat record data on alter table add column (P0-04) (cf4c37a)
  • protect partition key mutations and lookups with partMu to eliminate data races (P0-05) (1c2361b)
  • map DECIMAL, NUMERIC, and MONEY to TypeDecimal with precision and scale (P0-23) (b3c9e7b)
  • decode runes with utf8 in lexer to support multibyte identifiers (P0-24) (ec6d011)
  • prevent nil right-hand expression in BinaryExpr to avoid nil deref panic (P0-25) (871ad94)
  • guard against zero division and NaN cost in unique index calculation (P0-28) (504040f)
  • resolve WAL archiving truncation race condition with atomic rotation (P0-15) (c2f5f4c)
  • resolve batch 3 P0 defects (P0-16, P0-17, P0-20, P0-21, P0-22) (a446235)
  • resolve P0-11 by bounding GROUP BY CUBE to 12 columns to prevent 2^N OOM crash (0fef9b0)
  • resolve P0-12 by enforcing workMem budget in WindowIterator to prevent OOM crash (4838f62)
  • resolve P0-13 by bounding MergeJoin duplicate key buffering with workMem (3d238dc)
  • resolve P0-14 by ensuring child iterator cleanup and zero partial leakage on I/O error (8ee0099)
  • resolve P0-18 by streaming direct PK lookups and bounding full-scan buffer in MERGE (bdcec4a)
  • resolve P0-19 by failing closed on scan I/O error in UPDATE and DELETE (ac3f82d)
  • resolve P0-26 with rollback-first disconnect and deadlock-free drop (e9a7a7e)
  • resolve P0-27 by enforcing bounded payload frame limits on TDS and PGWire (cbab713)
  • resolve P0-29 by zeroing pointers and bounding slice capacity in sync.Pools (64240d6)
  • resolve P0-30 by shrinking session lock scope and guarding reentrant worker slots (7b28ad7)
  • resolve P0-32 by enforcing @@TRANCOUNT semantics and preventing early physical commits (e047525)
  • resolve P0-34 by failing closed on broadcaster buffer overflow to prevent silent drop (cd04bca)
  • resolve P0-35 by enforcing 32MB request body limit on chunked transfer encoding (0b6abab)
  • resolve P0-31 by isolating RLS with AST composition and single-pass param scanning (f174f6b)
  • resolve P0-36 by bounding REST pagination to 100 items and streaming unindexed scans (65d7199)
  • resolve P0-33 by eagerly materializing LazyTuples before set-operation deduplication (829eb78)
  • resolve P0-37 with global session panic recovery and cron isolation guard (41d84ba)
  • evaluate bitshift expressions in integer literal coercion (3277307)
  • enforce 4-layer permanent lockdown preventing wiredtiger transaction_sync regression (2f463d9)
  • align release notes path with notes/release_notes/ directory (1ba5196)
  • compile release binaries even when skip-tests is specified (85500be)

Documentation

  • restore 100-step pre-release audit findings (scopes 001-020) and tracking matrix (08a71ca)
  • remove redundant ARTICLE_ prefix from release gates whitepaper (1ec2084)
  • update project roadmap and phase 7 milestone status (8df199d)
  • complete 135-step dual AI code review across all 13 domains (4fc08cd)
  • rename audit plan to PRE_RELEASE_AUDIT_PLAN.ko.md and sync links (ab0f9cc)
  • add DuckDB integration guide with continuous analytics architecture decision matrix (1e9d7af)
  • reorganize plan into 3-phase pipeline with phase 2 deep core rescan (8f7c0ff)
  • register AUDIT-CORE-DEEP-RESCAN phase 2 task in backlog and dashboard (3999b57)
  • log phase 2 deep core findings for zone 1 storage core (725ec30)
  • log phase 2 deep core findings for zone 2 transaction coordinator (e3b9f8b)
  • log phase 2 deep core findings for zone 3 bytecode compiler and vm (8c59d1f)
  • log phase 2 deep core findings for zone 4 cbo planner and operators (b06580b)
  • complete phase 2 deep core audit for all 5 zones (767a8bc)
  • expand phase 2 deep core audit scope to 7 zones (2e1df45)
  • complete phase 2 deep core audit for all 7 zones (c077513)
  • expand phase 2 deep core audit scope to 12 zones (34bd614)
  • log phase 2 deep core findings for zone 8 sql execution runtime (bf659d4)
  • log phase 2 deep core findings for zone 9 backup and pitr (3bd30bf)
  • log phase 2 deep core findings for zone 10 analytics operators (c0ab8fa)
  • log phase 2 deep core findings for zone 11 in-memory storage remainder (9b7c228)
  • complete phase 2 deep core rescan for all 12 zones with zone 12 findings (5cfeceb)
  • dual-sync sprint tasks with SQLite sprint_tasks db (6aa5d99)
  • regenerate TASKS.md from sprint_tasks DB SSOT (6532f90)
  • finalize triage matrix with 30 P0 defects and launch AUDIT-PATCH-P0 (7a349e3)
  • document transactional outbox sender contract and architecture (ADR-026) (f8003c7)
  • mark Batch 1 of P0 defect patches complete in TASKS.md (0626afc)
  • formalize WAL crash recovery and zero-truncate durability invariant (ADR-027) (4229feb)
  • document engineering insights on AI code generation blindspots vs adversarial audit (528f38e)
  • mark Batch 2 completed in pre-release audit triage (01c5c8a)
  • expand AI audit essay with type system symmetry and set-difference deduction (00ef603)
  • reorder sections in AI audit essay to place P0-23 case study as climax (36c6a21)
  • reorder sections 3.4 and 3.5 in AI audit essay for better narrative flow (2bcbdd7)
  • place Dual AI synergy in 3.4 and P0-23 case study in 3.5 as intended (c746518)
  • expand Section 3.5 with 2-stage compiler pipeline case studies (Lexer P0-24 and Parser P0-23) (d3071d8)
  • add Item 15 on IEEE 754 Zero-Division and NaN poisoning in CBO to PITFALLS_AND_TRICKS.md (7d3541d)
  • catalog and dual-sync P2 deferred backlog (92 cases) and P3 invariants (25 cases) (e733631)
  • update version to v0.91.0 and prioritize Grafana observability in Q11 (d4ca870)
  • complete phase 2 deep core audit for zones 13-15 (REST, Execution, Replication) (7d6e6ff)
  • register P0-31 (RLS injection) and update P1/P2/P3 classification for 206 defects (1988de4)
  • update release horizons for v0.92, v1.0, v1.5 Kitty Engine and v2.0 (a44ca31)
  • sanitize pure-go storage terminology and reaffirm WiredTiger coexistence (a122a6f)
  • expand P0 defect set to 37 items with critical rescan promotions (a46fedb)
  • add SSMS integration guide and host_info sysview support (4f3b964)
  • complete P0 37-defect remediation with comprehensive retrospective and plan notes (b5fcd1f)
  • publish comprehensive 8-theme architecture plans for P0 defects (54c3cbe)
  • prune redundant low-architectural-value plan documents (84be73d)
  • reorganize notes directory into plans, reports, and release_notes folders (fc744d7)
  • restore 4 high-value P0 architecture plan documents to notes/plans (13ed6fb)
  • update benchmark guide and readme to v0.92.0 verified metrics with cooldown architecture and historical archive (06c6842)
  • highlight 37 P0 bug remediations and architectural hardening in postmortem discussion (6cdb02b)
  • complete TUNE-DOC-SYNC-1 benchmark documentation synchronization (d4ed6ed)
  • publish formal release notes for v0.92.0 (6e30ebc)

Changed

  • consolidate sprint CLI to single zero-daemon SQLite backend (e0274c4)