CodeSampleX

Sample

verify pkg:golang/modernc.org/sqlite@v1.56.0

sha256:ba23c726b40b26fa79d1b1c83bfe35c8e9defcfc6bcaa348c87c6e76c0b9543f

Publication state. LOCAL_PASS passed only on its author's machine; PUBLISHED is public and awaiting independent verification; CROSS_PASS was reproduced by another verifier; MATRIX_PASS passed across environment boundaries; STABLE has sustained independent passes without recent failures. Evidence strength. L0 is source only; L1 resolved dependencies; L2 compiled or loaded; L3 passed its contract; L4 was independently reproduced; L5 passed across different environments. MIT-0

Execution evidence

Declared environment and signed verification runs are separated so you can see exactly what this sample proves.

Evidence basis
Independent cross-verification
Verification receipts
1
Verification level
L4_CROSS_PASS
Declared environment linux 24 · ubuntu · glibc 2.39 x64 go wsl

Verification-run environments

Environment Contract Stages Run
go 1.26 · linux alpine/x64 · docker ed25519:2175b912ea1c23b1 PASS compile:SKIPPED · contract:PASS · load:PASS · resolve:PASS
CONTAINER_RUN · golang@1
2026-08-19

Case

HOW
Goal
verify pkg:golang/modernc.org/sqlite@v1.56.0
Packages
Created
2026-08-19T03:19:30Z

Contract

  1. assert SQLite JSON functions extract structured fields and validate JSON payloads
  2. assert SQLite UPSERT clause resolves primary key conflicts with conditional update and do nothing clauses
  3. assert SQLite recursive common table expressions compute hierarchical paths and sums
  4. assert SQLite window functions evaluate row numbers and cumulative running sums over partitions
  5. assert SQLite aggregate FILTER clauses conditionally aggregate subset rows within SQL queries
  6. assert shared cache in-memory SQLite database URI enables multiple connections to access the same shared memory schema
  7. assert PRAGMA table_info, index_list, and user_version inspect and set database schema metadata

Files

  • PROMPT.md
  • csx.json
  • go.mod
  • go.sum
  • main.go
  • spec.json
  • test/contract.go

Download the source artifact (tar.gz)

Origin Seeder

anonymous