The whole of this run is a release asset
This site holds 4 of the 6 question directories this run wrote; the archive holds every one:
- archive
- bird-dev-sqlite-dev-20251106.tar.gz
- size
- 375,933 bytes
- sha256
- 4f83fa6296273278933f9f1b7d726f813ac35f73a03e4aa15dce6ec7db0700bc
What it counted
| what | how many |
|---|---|
| questions audited | 89 |
| GOLD-ONLY | 89 |
| probes fired | 10 |
the probes
| probe | fired on |
|---|---|
| ordering-over-numeric-text | 0 |
| arbitrary-cut | 5 |
| not-a-function-of-the-data | 5 |
| float-aggregate-order | 0 |
| direction-against-question | 0 |
What the run was made of
- run
- audit-cf217358-b543-48ea-95b9-81bb7a1f9fdc
- summary format
- attestql/audit/summary/2
- question file
- data/questions/dev_20251106-00000-of-00001.json sha256:ffd8018378ddb1a8794753e0a31cfc81862ff7318a5184c22f3dc4ce03a03feb | https://huggingface.co/datasets/birdsql/bird_sql_dev_20251106/resolve/3c11fb193e5439b338e23677fa0aae11e8b85db9/data/dev_20251106-00000-of-00001.json (commit 3c11fb19, downloaded 2026-09-07), 2026-01-18T08:51:02Z
- questions in the file
- 1534
- data file
- data/dev/dev_databases/california_schools/california_schools.sqlite sha256:986817d793479801ed55133e55aa27e335422c0cd3866b54a3d6317b7c5f09c1 | dev.zip (sha256 cdd6d19faeb45a23970b98d3ef6c40a87987c95459c2cf12076897a60cf5a630), member dev_20240627/dev_databases.zip, dev_databases, california_schools/california_schools.sqlite, 2024-06-14
- server
- SQLite 3.53.4 | file=/private/tmp/attestql-runs/data/dev/dev_databases/california_schools/california_schools.sqlite | size=11116544
- database role
- file
- engine
- sqlite
- parser
- validator audit:sqlglot-sqlite-parse, sqlglot 30.18.0, dialect sqlite
- serialization
- attestql/audit/2
- statement timeout
- 30 s
- fixture digest depth
- counts
- schema digest
- sha256:0906a33c0fa9248160fb7cc746501120c03ae1250fe39bda04cf8640bdbbd18d
- data as of
- 2026-09-08T05:05:54.087132+00:00 the instant the run started
- shuffled copies
- prepared
- shuffle seed
- 1
- experimental probe
- off
The session the run was made in
what the engine reported, 9 settings
- sqlite_version
- 3.53.4
- encoding
- UTF-8
- reverse_unordered_selects
- 0
- query_only
- 1
- journal_mode
- delete
- data_version
- 1
- compile_options
- ATOMIC_INTRINSICS=1,COMPILER=clang-21.0.0,DEFAULT_AUTOVACUUM,DEFAULT_CACHE_SIZE=-2000,DEFAULT_FILE_FORMAT=4,DEFAULT_JOURNAL_SIZE_LIMIT=-1,DEFAULT_MMAP_SIZE=0,DEFAULT_PAGE_SIZE=4096,DEFAULT_PCACHE_INITSZ=20,DEFAULT_RECURSIVE_TRIGGERS,DEFAULT_SECTOR_SIZE=4096,DEFAULT_SYNCHRONOUS=2,DEFAULT_WAL_AUTOCHECKPOINT=1000,DEFAULT_WAL_SYNCHRONOUS=2,DEFAULT_WORKER_THREADS=0,DIRECT_OVERFLOW_READ,ENABLE_API_ARMOR,ENABLE_COLUMN_METADATA,ENABLE_DBSTAT_VTAB,ENABLE_FTS3,ENABLE_FTS3_PARENTHESIS,ENABLE_FTS5,ENABLE_GEOPOLY,ENABLE_MATH_FUNCTIONS,ENABLE_MEMORY_MANAGEMENT,ENABLE_PERCENTILE,ENABLE_PREUPDATE_HOOK,ENABLE_RTREE,ENABLE_SESSION,ENABLE_STAT4,ENABLE_UNLOCK_NOTIFY,MALLOC_SOFT_LIMIT=1024,MAX_ATTACHED=10,MAX_COLUMN=2000,MAX_COMPOUND_SELECT=500,MAX_DEFAULT_PAGE_SIZE=8192,MAX_EXPR_DEPTH=1000,MAX_FUNCTION_ARG=1000,MAX_LENGTH=1000000000,MAX_LIKE_PATTERN_LENGTH=50000,MAX_MMAP_SIZE=0x7fff0000,MAX_PAGE_COUNT=0xfffffffe,MAX_PAGE_SIZE=65536,MAX_SQL_LENGTH=1000000000,MAX_TRIGGER_DEPTH=1000,MAX_VARIABLE_NUMBER=250000,MAX_VDBE_OP=250000000,MAX_WORKER_THREADS=8,MUTEX_PTHREADS,SYSTEM_MALLOC,TEMP_STORE=1,THREADSAFE=1,USE_URI
- collation_list
- RTRIM,NOCASE,BINARY
- case_sensitive_like
- 0
The questions
| question | rule | verdict | class | probes | what was asked |
|---|---|---|---|---|---|
| q30 | R-ORD | GOLD-ONLY | arbitrary-cut | Which cities have the top 5 lowest enrollment number for students in grades 1 through 12? | |
| q57 | R-ORD | GOLD-ONLY | arbitrary-cut not-a-function-of-the-data | What is the phone number and extension number for the school that had the 333rd highest average writing score? | |
| q81 | R-ORD | GOLD-ONLY | arbitrary-cut not-a-function-of-the-data | In which city can you find the school in the state of California with the lowest latitude coordinates and what is its lowest grade? Indicate the school name. | |
| q82 | R-ORD | GOLD-ONLY | arbitrary-cut not-a-function-of-the-data | What is the grade span offered in the school with the highest longitude? |
A question whose statement could not be run wrote no directory, so it is a row here and has no page: the summary holds the side that stopped, the step it stopped at and the engine's own message.
The same index, restricted
Each of these is a page of its own, so a filtered view has an address a reader can send. Nothing here is done by a script or by a query string.
The JSON this page was rendered from
- summary.json attestql/audit/summary/2