gold
SELECT name FROM scores ORDER BY score DESC LIMIT 1- score
- descending
sha256:f56de6cca7885057277d932c18dde41bdd72a8c72537dfa5221b885956dc35d8
The question
Who holds the highest score?
the hint the set supplies: the highest score refers to MAX(score)
This question was audited without a prediction beside it, so there is nothing to compare the gold with. The probes below read the gold alone.
The statements
The results
gold, 1 row
from evidence-gold.json, 1 row
| nameTEXT |
|---|
| ash |
The probes
A smell is a mechanical reason to read this gold statement again. It is a heuristic: it does not state that the statement is wrong, and a maintainer decides.
ordering-over-numeric-text not applicable
this statement orders by a text column holding only numbers, and ordering it as a number gives a different answer, so the gold may be sorting 9.5 above 10
no ORDER BY key resolves to a text column
what it measured
{
"heuristic": true,
"reason": "no ORDER BY key resolves to a text column",
"keys": [
{
"key": "score",
"column": "scores.score",
"declared_type": "INTEGER",
"not_applicable": "the column is not declared as text"
}
]
}arbitrary-cut fired
this statement cuts its result at a LIMIT that does not decide which rows come back, so a different but equally correct statement can return other rows and score zero
from smells.json, 3 rows
| ash | 99 |
| bram | 99 |
| cleo | 99 |
what it measured
{
"heuristic": true,
"cut": 1,
"offset": 0,
"distinct_kept": false,
"unbounded_sql": "SELECT name, score AS attestql_ordering_key_0 FROM scores ORDER BY score DESC",
"unbounded_rows": 6,
"projected_columns": [
"name"
],
"ordering_key_columns": [
"attestql_ordering_key_0"
],
"ordering_keys": [
{
"key": "score",
"direction": "desc",
"nulls": "last",
"nulls_first_in_effect": false,
"returned_rows_null_in_this_key": 0,
"fires": false
}
],
"tied_at_the_cut": {
"positions": [
0,
1,
2
],
"tied_rows": 3,
"distinct_projected_answers": 3,
"rows": [
[
{
"type": "str",
"value": "ash"
}
],
[
{
"type": "str",
"value": "bram"
}
],
[
{
"type": "str",
"value": "cleo"
}
]
]
},
"case": "tie-at-the-cut"
}not-a-function-of-the-data fired
rerun over the same rows in another physical order this statement gives another answer, so its result depends on how the rows are stored and not only on the data
from smells.json, 1 row
| bram |
what it measured
{
"heuristic": true,
"rule": "R-ORD",
"baseline_result_hash": "sha256:f56de6cca7885057277d932c18dde41bdd72a8c72537dfa5221b885956dc35d8",
"baseline_result": {
"columns": [
{
"name": "name",
"declared_type": "TEXT"
}
],
"row_count": 1,
"truncated": false,
"rows_shown": 1,
"rows": [
[
{
"type": "str",
"value": "ash"
}
]
],
"result_hash": "sha256:f56de6cca7885057277d932c18dde41bdd72a8c72537dfa5221b885956dc35d8"
},
"planner_statistics": {},
"shuffle": {
"seed": "1",
"row_limit": 300000,
"tables": [
"scores"
],
"tables_not_shuffled": [],
"tables_skipped_for_size": {},
"tables_not_reached_by_a_copy": {
"main.y": "the statement names this table's schema, and a name that states its schema is read from that schema whatever TEMP holds, so the rerun reads this table and not a copy of it"
}
},
"shuffled_copies": {
"run": true,
"verdict": "not_equal",
"differs": true,
"result_hash": "sha256:79ded4083fac54ef16e9fa13d6119a401b789326fdd793fa07c5d5d3b7c2ff13",
"result": {
"columns": [
{
"name": "name",
"declared_type": "TEXT"
}
],
"row_count": 1,
"truncated": false,
"rows_shown": 1,
"rows": [
[
{
"type": "str",
"value": "bram"
}
]
],
"result_hash": "sha256:79ded4083fac54ef16e9fa13d6119a401b789326fdd793fa07c5d5d3b7c2ff13"
}
},
"plan_variant": {
"run": false,
"reason": "the plan variant was not asked for"
}
}duplicate-full-row not applicable
this statement returns the same whole row more than once and never says DISTINCT, so a statement answering the same question once per row disagrees on multiplicity alone
what it measured
{
"heuristic": true,
"rows": 1,
"distinct_rows": 1,
"repeated_rows": 0,
"largest_repeat": 1,
"result_bounded": false,
"distinct_stated": false,
"set_operation": false,
"not_applicable": "a result of fewer than two rows has nothing to repeat"
}The evidence records
gold: evidence-gold.json
SELECT name FROM scores ORDER BY score DESC LIMIT 1- statement read from
- demo/questions.json
- digest
- sha256:7ad58addc070b425cabfc9d67bbd9c95840253160cf3b73d672e9aeb4897f5ff
- origin
- the run was told none
result_hash sha256:f56de6cca7885057277d932c18dde41bdd72a8c72537dfa5221b885956dc35d8 recomputed from this JSON: match
record_hash sha256:e26a1872a0e20ad164d64e9982462cb1f4e2b40e388e7540b129d929aee73266 recomputed from this JSON: match
the result this record holds, 1 row
from evidence-gold.json, 1 row
| nameTEXT |
|---|
| ash |
what ran, and where
- run
- audit-51d01b27-ac4f-4d61-8f83-49bf3e375f0b
- executed at
- 2026-09-15T03:02:15.681664+00:00
- data as of
- 2026-09-15T03:02:15.661770+00:00
- backend at checkout
- SQLite 3.53.1 | file=/tmp/attestql-site-sandbox/demo/fixture.sqlite | size=69632
- backend that answered
- SQLite 3.53.1 | file=/tmp/attestql-site-sandbox/demo/fixture.sqlite | size=69632
- database role
- file
- replay rule
- R-ORD
- question set version
- sha256:7ad58addc070b425cabfc9d67bbd9c95840253160cf3b73d672e9aeb4897f5ff
- validator
- audit:sqlglot-sqlite-parse
- checks run
- parses_as_exactly_one_statement, the_one_statement_is_a_select, no_placeholder_without_a_bound_parameter
- statement timeout
- 30000 ms
- rows
- 1 row
the session it ran under
- engine
- sqlite
- time_zone
- not stated by this engine
- date_style
- not stated by this engine
- interval_style
- not stated by this engine
- extra_float_digits
- not stated by this engine
- database_collation
- not stated by this engine
- work_mem
- not stated by this engine
- hash_mem_multiplier
- not stated by this engine
recorded beside them
- sqlite_version
- 3.53.1
- encoding
- UTF-8
- reverse_unordered_selects
- 0
- query_only
- 1
- journal_mode
- delete
- data_version
- 1
- automatic_index
- 1
- compile_options
- ATOMIC_INTRINSICS=1,COMPILER=clang-22.1.3,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_DBSTAT_VTAB,ENABLE_FTS3,ENABLE_FTS3_PARENTHESIS,ENABLE_FTS4,ENABLE_FTS5,ENABLE_GEOPOLY,ENABLE_MATH_FUNCTIONS,ENABLE_PERCENTILE,ENABLE_RTREE,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=32766,MAX_VDBE_OP=250000000,MAX_WORKER_THREADS=8,MUTEX_PTHREADS,SYSTEM_MALLOC,TEMP_STORE=1,THREADSAFE=1
- collation_list
- RTRIM,NOCASE,BINARY
- case_sensitive_like
- 0
the rendering and the data
- version
- attestql/audit/4
- numeric_scale
- 6
- timestamp_format
- %Y-%m-%dT%H:%M:%S.%fZ
- timezone
- UTC
- null_rendering
- NULL
- encoding
- utf-8
- schema digest
- sha256:e4354ead6a2289b8c76e7795b0838826fbe93f799799ce632c3799ead4e830e1
- source file sha256
- rows in main.scores
- 6
Running these again
gold
re-run this statement read-only against SQLite 3.53.1 | file=/tmp/attestql-site-sandbox/demo/fixture.sqlite | size=69632 under the session settings and over the data this record's fixture digest names, and compare the two results under R-ORD
This question's run
- run
- audit-51d01b27-ac4f-4d61-8f83-49bf3e375f0b
- server
- SQLite 3.53.1 | file=/tmp/attestql-site-sandbox/demo/fixture.sqlite | size=69632
- question set
- questions
- replay rule
- R-ORD
The JSON this page was rendered from
- evidence-gold.json the gold's evidence record
- smells.json attestql/audit/smells/2