The whole of this run is a release asset
This site holds 4 of the 5 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 | 191 |
| GOLD-ONLY | 190 |
| ERROR | 1 |
| probes fired | 6 |
the probes
| probe | fired on |
|---|---|
| ordering-over-numeric-text | 1 |
| arbitrary-cut | 1 |
| not-a-function-of-the-data | 4 |
| float-aggregate-order | 0 |
| direction-against-question | 0 |
What the run was made of
- run
- audit-dab499aa-0142-4d84-a27a-cf354e9e38e3
- 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/card_games/card_games.sqlite sha256:c98bdb57fe7474da798b407785544b9af0daaad5d61fd21e2a73309493bc1227 | dev.zip (sha256 cdd6d19faeb45a23970b98d3ef6c40a87987c95459c2cf12076897a60cf5a630), member dev_20240627/dev_databases.zip, dev_databases, card_games/card_games.sqlite, 2024-06-14
- server
- SQLite 3.53.4 | file=/private/tmp/attestql-runs/data/dev/dev_databases/card_games/card_games.sqlite | size=261820416
- 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:0654f2e002e823f47f4f1299e259b9557e98f1e388ac16be7a3fa11284be1030
- data as of
- 2026-09-08T05:11:02.685988+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
- wal
- data_version
- 3
- 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
What the run states about itself
- stopped by the statement timeout, gold
- 518 the run's bound was 30 s
The questions
| question | rule | verdict | class | probes | what was asked |
|---|---|---|---|---|---|
| q392 | R-ORD | GOLD-ONLY | arbitrary-cut not-a-function-of-the-data | Pick 3 cards with rarity of uncommon, list down name these cards according to ascending order of it's ruling date. | |
| q423 | R-ORD | GOLD-ONLY | ordering-over-numeric-text | Please provide the ids of top three powerful pairs of Kingdom Foil and Kingdom Cards sorted by Kingdom Foil id in alphabetical order. | |
| q484 | R-ORD | GOLD-ONLY | not-a-function-of-the-data | Please list the Italian names of the cards in the set Coldsnap with the highest converted mana cost. | |
| q523 | R-ORD | GOLD-ONLY | not-a-function-of-the-data | What is the annual average number of sets that were released between 1/1/2012 to 12/31/2015? Indicate the common langugage of the card. | |
| q518 | ERROR | gold: execute: execute: the statement ran past its 30s timeout |
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