the run

audit-856da5a8-6a71-40a2-b306-8cbcd21e9060 exit status 1

The whole of this run is a release asset

This site holds 1 of the 8 question directories this run wrote; the archive holds every one:

archive
minidev-sqlite-mistralai-mixtral-8x7b-instru-4.tar.gz
size
1,075,349 bytes
sha256
7f34c38f4a2fbc7c9cfd7720ee1dcc8af8c27748e47e2bdd6ebe556f7e3703ea

What it counted

whathow many
questions audited48
EQUAL12
ERROR28
NOT_EQUAL8
probes fired0
the verdicts of run audit-856da5a8-6a71-40a2-b306-8cbcd21e9060, from summary.json12 EQUAL28 ERROR1 multiplicity7 NOT_EQUAL
Of the questions this run audited: 12 EQUAL, 28 ERROR, 1 multiplicity, 7 NOT_EQUAL

the probes

probefired on
ordering-over-numeric-text0
arbitrary-cut0
not-a-function-of-the-data0
float-aggregate-order0
direction-against-question0
how many golds each probe fired on, of 48, from summary.json0 ordering-over-numeric-text0 arbitrary-cut0 not-a-function-of-the-data0 float-aggregate-order0 direction-against-question
Of 48 golds this run read, the probes fired on: none.

credited by BIRD's own check and NOT_EQUAL here

whathow many
credited by BIRD and NOT_EQUAL here1
multiplicity1
type0
order0
truncation0
other0
the test-suite check answered 10
the test-suite check answered 01

What the run was made of

run
audit-856da5a8-6a71-40a2-b306-8cbcd21e9060
summary format
attestql/audit/summary/2
question file
data/questions/mini_dev_sqlite.json sha256:4ba5fa8de55856222f484d380d2ba872b380bf79d825de70478e2120cb0fc43b | https://bird-bench.oss-cn-beijing.aliyuncs.com/minidev.zip (sha256 cc48ba16838204e4e214512030cb572eeb5f7bcdd999bae4b9b6ff12ec13b92f, downloaded 2026-09-07), member minidev/MINIDEV/mini_dev_sqlite.json, 2024-06-19
questions in the file
500
prediction file
data/preds-sqlite/predict_mini_dev_mistralai-mixtral-8x7b-instru-4_sqlite.json sha256:53cdf9142e3f2e49941eb7b50ebbea90361b2c5b46de37d5ba1c244187d643a2 | https://raw.githubusercontent.com/bird-bench/mini_dev/b3d4bcbbae9a96934ad812551eb400c7a3b23c12/llm/exp_result/sql_output_kg/predict_mini_dev_mistralai-mixtral-8x7b-instru-4_sqlite.json, 2024-06-19
statements read
500
keyed by
position
data file
data/minidev/dev_databases/student_club/student_club.sqlite sha256:eb89bcfe97eefa386a27904ec5aa15159811a7eac894ec659a36e48fa9f76b77 | minidev.zip (sha256 cc48ba16838204e4e214512030cb572eeb5f7bcdd999bae4b9b6ff12ec13b92f), member minidev/MINIDEV/dev_databases, student_club/student_club.sqlite, 2024-06-13
server
SQLite 3.53.4 | file=/private/tmp/attestql-runs/data/minidev/dev_databases/student_club/student_club.sqlite | size=2641920
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:64709a2781d4c388f2169ca190cab020ca6914e9e9af8101899b2f8f3746abf4
data as of
2026-09-08T05:04:59.467125+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

What the run states about itself

ids the question file states twice
137, 138
prediction positions not compared
487, 488

The questions

question rule verdict class probes what was asked
q1435 R-SET NOT_EQUAL multiplicity List the names of closed event as "game" that was closed from 3/15/2019 to 3/20/2020.
q1317 ERROR prediction: statement: the text does not parse: Error tokenizing '= 'Women\'s Soccer' AND m.t_shirt_size = 'Medium''
q1323 ERROR prediction: statement: 2 statements in one text; an audit runs one
q1334 ERROR prediction: statement: the text does not parse: Invalid expression / Unexpected token. Line 1, Col: 13. SELECT first\_name, last\_name FROM member WHERE zip IN ( SELECT zip\_code FROM zip\_code WHERE state = 'Illinois
q1339 ERROR prediction: statement: the text does not parse: Invalid expression / Unexpected token. Line 6, Col: 12. budget ON link_to_budget = budget_id JOIN event ON budget.link_to_event = event.event_id WHERE first\_name = 'Elijah' AND last\_name = 'Allen' AND (month(expense\_date) = 9 OR month(expense\_date) = 10
q1346 ERROR prediction: statement: the text does not parse: Invalid expression / Unexpected token. Line 3, Col: 19. SELECT member.phone FROM member WHERE member.first\_name = 'Carlo' AND member.last\_name = 'Jacobs';
q1356 ERROR prediction: execute: execute: no such column: department
q1357 ERROR prediction: statement: the text does not parse: Invalid expression / Unexpected token. Line 1, Col: 12. SELECT date\_received FROM member JOIN income ON member.member\_id = income.link\_to\_member WHERE first\_name =
q1359 ERROR prediction: statement: 2 statements in one text; an audit runs one
q1361 ERROR prediction: statement: the text does not parse: Invalid expression / Unexpected token. Line 1, Col: 29. SELECT SUM(e1.cost) as total\_cost FROM expense e1 JOIN budget b1 ON e1.link\_to\_budget = b1.budget\_id WHERE e1.expense\_descri
q1371 ERROR prediction: statement: the text does not parse: Error tokenizing 'ent_id WHERE event.event_name = 'Women\'s Soccer''
q1375 ERROR prediction: statement: the text does not parse: Invalid expression / Unexpected token. Line 1, Col: 13. SELECT first\_name || ' ' || last\_name AS full\_name FROM member WHERE link\_to\_major IN ( SELECT major\_id FRO
q1376 ERROR prediction: statement: the text does not parse: Invalid expression / Unexpected token. Line 1, Col: 15. SELECT e.event\_name, MAX(b.spent/b.amount) as spend\_to\_budget\_ratio FROM event as e JOIN budget as b ON e.event
q1378 ERROR prediction: statement: the text does not parse: Invalid expression / Unexpected token. Line 1, Col: 31. SELECT MAX(b.spent) as highest\_budget\_spend FROM budget b JOIN event e ON b.link\_to\_event = e.event\_id;
q1381 ERROR prediction: statement: the text does not parse: Invalid expression / Unexpected token. Line 1, Col: 13. SELECT first\_name || ' ' || last\_name AS name FROM member JOIN attendance ON member.member\_id = attendance.lin
q1387 ERROR prediction: statement: the text does not parse: Invalid expression / Unexpected token. Line 1, Col: 15. SELECT m.first\_name, m.last\_name FROM member m JOIN budget b ON m.member\_id = b.link\_to\_member JOIN event e ON
q1389 ERROR prediction: statement: the text does not parse: Invalid expression / Unexpected token. Line 6, Col: 21. ROM expense e JOIN budget b ON e.link_to_budget = b.budget_id GROUP BY e.link_to_event; This query calculates the minimum cost for each event by joining the expense and budget tables, then grouping by the even
q1390 ERROR prediction: statement: 2 statements in one text; an audit runs one
q1392 ERROR prediction: statement: the text does not parse: Invalid expression / Unexpected token. Line 1, Col: 34. SELECT source, MAX(amount) as max\_amount FROM income WHERE date\_received BETWEEN '2019-09-01' AND '2019-09-30' GROUP BY source;
q1399 ERROR prediction: statement: the text does not parse: Error tokenizing ''Mclean' AND event.event_name = 'Women\'s Soccer''
q1401 ERROR prediction: execute: execute: no such column: link_to_event
q1403 ERROR prediction: statement: the text does not parse: Invalid expression / Unexpected token. Line 1, Col: 15. SELECT e.event\_name FROM event e JOIN budget b ON e.event\_id = b.link\_to\_event JOIN attendance a ON e.event\_id
q1405 ERROR prediction: statement: the text does not parse: Invalid expression / Unexpected token. Line 1, Col: 39. SELECT category, SUM(amount) as amount\_budgeted FROM budget JOIN event ON budget.link\_to\_event = event.event\_id WHERE event.event\_name
q1410 ERROR prediction: statement: the text does not parse: Invalid expression / Unexpected token. Line 1, Col: 20. SELECT member.first\_name || ' ' || member.last\_name AS full\_name, SUM(expense.cost) AS total\_cost FROM member JOIN e
q1426 ERROR prediction: statement: the text does not parse: Invalid expression / Unexpected token. Line 1, Col: 12. SELECT last\_name, major\_name, department, college FROM member JOIN major ON member.link\_to\_major = major.maj
q1432 ERROR prediction: statement: the text does not parse: Invalid expression / Unexpected token. Line 6, Col: 14. ncome.link_to_member WHERE member.t_shirt_size = 'Medium' AND member.position = 'Member'; This SQL query calculates the percentage of the amount 50 received by the members with t-shirt size of medium in t
q1457 ERROR prediction: statement: the text does not parse: Invalid expression / Unexpected token. Line 1, Col: 13. SELECT first\_name, last\_name, phone FROM member JOIN ( SELECT link\_to\_member FROM expense JOIN ( SELECT AVG(c
q1460 ERROR prediction: statement: the text does not parse: Invalid expression / Unexpected token. Line 1, Col: 20. SELECT member.first\_name || ' ' || member.last\_name AS full\_name, expense.cost FROM member JOIN expense ON member.mem
q1464 ERROR prediction: execute: execute: incomplete input

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