The whole of this run is a release asset
This site holds 7 of the 7 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 | 174 |
| GOLD-ONLY | 174 |
| probes fired | 7 |
the probes
| probe | fired on |
|---|---|
| ordering-over-numeric-text | 2 |
| arbitrary-cut | 3 |
| not-a-function-of-the-data | 2 |
| float-aggregate-order | 0 |
| direction-against-question | 0 |
What the run was made of
- run
- audit-12a6eeae-04a4-45ea-866b-f75095ba654b
- 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/formula_1/formula_1.sqlite sha256:17185981cd747f6cdc374cb02a6096db3130e6ec2ddc582fe1686a28fb4c4c8a | dev.zip (sha256 cdd6d19faeb45a23970b98d3ef6c40a87987c95459c2cf12076897a60cf5a630), member dev_20240627/dev_databases.zip, dev_databases, formula_1/formula_1.sqlite, 2024-06-14
- server
- SQLite 3.53.4 | file=/private/tmp/attestql-runs/data/dev/dev_databases/formula_1/formula_1.sqlite | size=22360064
- 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:ebbf75002e22243ac49c5a2445ec90cc64863fb33473b2bec8cd22238acff523
- data as of
- 2026-09-08T04:57:31.494463+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 |
|---|---|---|---|---|---|
| q847 | R-ORD | GOLD-ONLY | arbitrary-cut | What is the surname of the driver with the best lap time in race number 19 in the second qualifying period? | |
| q879 | R-ORD | GOLD-ONLY | ordering-over-numeric-text | For the driver who set the fastest lap speed, what is his nationality? | |
| q893 | R-ORD | GOLD-ONLY | not-a-function-of-the-data | Name the top 3 drivers and the points they scored in the 2017 Chinese Grand Prix. | |
| q906 | R-ORD | GOLD-ONLY | arbitrary-cut | Which was Lewis Hamilton first race? What was his points recorded for his first race event? | |
| q927 | R-ORD | GOLD-ONLY | ordering-over-numeric-text | Which driver created the fastest lap speed in a Formula_1 race? Please give both his forename and surname. | |
| q1002 | R-ORD | GOLD-ONLY | arbitrary-cut | As of the present, what is the full name of the youngest racer? Indicate her nationality and the name of the race to which he/she first joined. | |
| q1004 | R-ORD | GOLD-ONLY | not-a-function-of-the-data | How many wins was achieved by the oldest racer? Indicate his/her full name. |
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