AI Demos Research — the structured-intelligence platform. Every verdict on these pages opens to the execution behind it.
Graded 7 October 2026

Can AskYourDatabase add a new constraint without replacing the earlier question?

AskYourDatabase handles this narrowing case: it keeps the earlier question’s date window and adds the new Texas constraint. In the first turn, the app returned 59 orders in a 10-row preview plus a full CSV. In the follow-up, it kept the same window, returned 3 Texas orders, and those three all appear in the first turn’s 59-row CSV.

1 of 1 test case passed

Every test case in this scenario has a result.

Pass rate100%1 of 1 gradable
Coverage1 of 1test case with a result
1PassDid everything it was expected to do.
0FailNo test case failed.
0Not gradableEvery result here could be graded.
0UntestedEvery test case in this scenario has a result.
The pass rate is a summary. The evidence is the test case below: what we sent, what we checked, what the tool returned, and the proof.

The test case

Each test case is judged on its own: Pass, Fail, Not gradable, or Untested. The scenario result above is based on this test case.

Narrow the same question to one regionPassEvidence
What we sent

Input 1: “Show me all orders from the last 90 days, as of September 2, 2026.”

Input 2: “Only the ones shipped to Texas.”

What the tool returned
Text
id,order_number,customer_id,status,category,item_summary,total_amount,currency,city,state,placed_at,shipped_at,delivered_at
60292,ORD-2026-0102,17,delivered,bedding_and_rugs,Linen sheet set, queen — Sage,591.30,USD,Reading,PA,2026-09-01T08:37:21.952Z,2026-09-02T08:37:21.952Z,2026-09-06T08:37:21.952Z
60260,ORD-2026-0101,16,cancelled,bedding_and_rugs,Hand-woven area rug, 8x10 — Walnut,216.00,USD,San Jose,CA,2026-08-30T17:52:21.952Z,null,null
60128,ORD-2026-0100,9,delivered,storage_and_organization,Woven storage baskets, set of 3 — Charcoal,144.00,USD,San Antonio,TX,2026-08-30T11:11:21.952Z,2026-09-01T11:11:21.952Z,2026-09-06T11:11:21.952Z
60074,ORD-2026-0099,6,cancelled,outdoor_and_patio,Adirondack chair — Terracotta,1171.80,USD,Tucson,AZ,2026-08-30T02:24:21.952Z,null,null
41290,ORD-2026-0098,1,delivered,bedding_and_rugs,Cotton waffle comforter, king — Sand,128.00,USD,Denver,CO,2026-08-28T17:15:24.195Z,2026-08-31T17:15:24.195Z,2026-09-04T17:15:24.195Z
60201,ORD-2026-0097,13,delivered,lighting,Linen drum table lamp — Ivory (+1 more),234.50,USD,Portland,OR,2026-08-28T01:44:21.952Z,2026-08-29T01:44:21.952Z,2026-08-31T01:44:21.952Z
60153,ORD-2026-0096,11,delivered,lighting,Linen drum table lamp — Fog Grey,227.70,USD,Phoenix,AZ,2026-08-26T23:19:21.952Z,2026-08-27T23:19:21.952Z,2026-09-02T23:19:21.952Z
60007,ORD-2026-0095,3,delivered,home_decor,Soy candle trio — Ivory (+2 more),284.35,USD,Denver,CO,2026-08-26T12:16:21.952Z,2026-08-27T12:16:21.952Z,2026-08-31T12:16:21.952Z
60100,ORD-2026-0094,8,delivered,kitchen_and_dining,Enamel dutch oven, 6qt — Sand,211.00,USD,Atlanta,GA,2026-08-26T11:57:21.952Z,2026-08-27T11:57:21.952Z,2026-08-31T11:57:21.952Z
60295,ORD-2026-0093,17,delivered,storage_and_organization,Entryway bench with cubbies — Charcoal,150.29,USD,Reading,PA,2026-08-25T18:25:21.952Z,2026-08-26T18:25:21.952Z,2026-08-30T18:25:21.952Z
60178,ORD-2026-0092,12,cancelled,outdoor_and_patio,Outdoor rug, 6x9 — Ivory (+1 more),1281.67,USD,Nashville,TN,2026-08-24T16:33:21.952Z,null,null
60044,ORD-2026-0091,5,delivered,outdoor_and_patio,Patio bistro set, 3-piece — Brass (+1 more),1806.00,USD,Asheville,NC,2026-08-24T15:41:21.952Z,2026-08-26T15:41:21.952Z,2026-09-01T15:41:21.952Z
60255,ORD-2026-0090,16,delivered,outdoor_and_patio,String light set, 48ft — Sand (+2 more),1586.46,USD,San Jose,CA,2026-08-24T14:57:21.952Z,2026-08-26T14:57:21.952Z,2026-08-31T14:57:21.952Z
60140,ORD-2026-0089,10,delivered,bedding_and_rugs,Linen sheet set, queen — Ivory,328.50,USD,Asheville,NC,2026-08-22T02:05:21.952Z,2026-08-24T02:05:21.952Z,2026-08-26T02:05:21.952Z
60049,ORD-2026-0088,5,cancelled,outdoor_and_patio,Outdoor rug, 6x9 — Fog Grey (+1 more),1898.66,USD,Columbus,OH,2026-08-21T13:05:21.952Z,null,null
60099,ORD-2026-0087,8,delivered,home_decor,Soy candle trio — Walnut,69.84,USD,Atlanta,GA,2026-08-20T11:00:21.952Z,2026-08-22T11:00:21.952Z,2026-08-26T11:00:21.952Z
60086,ORD-2026-0086,7,delivered,furniture,Alder bookshelf, 5-tier — Brass (+2 more),1099.30,USD,Minneapolis,MN,2026-08-17T10:19:21.952Z,2026-08-18T10:19:21.952Z,2026-08-21T10:19:21.952Z
60264,ORD-2026-0085,16,delivered,lighting,Ceramic bedside lamp, pair — Ivory,155.99,USD,San Jose,CA,2026-08-17T06:15:21.952Z,2026-08-19T06:15:21.952Z,2026-08-22T06:15:21.952Z
60104,ORD-2026-0084,8,delivered,kitchen_and_dining,Stoneware dinnerware set, 12-piece — Walnut (+2 more),523.50,USD,Ann Arbor,MI,2026-08-11T22:39:21.952Z,2026-08-12T22:39:21.952Z,2026-08-15T22:39:21.952Z
60022,ORD-2026-0083,4,delivered,bedding_and_rugs,Aspen 3-seat sofa — Charcoal (+1 more),745.47,USD,Austin,TX,2026-08-07T16:09:21.952Z,2026-08-08T16:09:21.952Z,2026-08-11T16:09:21.952Z
60043,ORD-2026-0082,5,delivered,home_decor,Brass picture frame, 8x10 — Brass,188.85,USD,Columbus,OH,2026-08-05T23:11:21.952Z,2026-08-06T23:11:21.952Z,2026-08-10T23:11:21.952Z
60073,ORD-2026-0081,6,delivered,lighting,Rattan pendant light — Sage,285.90,USD,Tucson,AZ,2026-08-05T16:25:21.952Z,2026-08-06T16:25:21.952Z,2026-08-08T16:25:21.952Z

The downloaded 59-row CSV for turn 1, showing unique order numbers and the Texas rows.

Copied from Output file (CSV), lines 1–23 · an excerpt

Open the whole CSV file ↗
Expected vs. Found
✓Expected: Returns the subset of t1’s answer, with t1’s other conditions still applied.Found: It returned three Texas orders from the same 90-day window; all three are in the first turn’s 59-row result.
Supporting proof
Proof 1Screenshot
Turn 1 query, SQL window, 59-order answer, and a 10-row preview.
Open original ↗
Proof 2Screenshot
Turn 2 query, SQL with the Texas filter, 3-order answer, and a three-row table.
Open original ↗
Why this result

It kept the full 90-day window from the first turn and added Texas. The three returned orders all appear in the first turn’s 59-row result, and no Texas row was left out.

Also observed in this test case

Window ended at midnight. The first answer’s window ended at midnight on September 2, so an order placed later that day was outside it; the 59-row export does not include ORD-2026-0103.

Texas filter. Texas was matched by the state code TX, and the answer kept the September 2 date.

Unquoted commas. The exported CSV leaves commas inside item summaries unquoted, so some rows need special parsing.

Tested by Ayush Ghosh · evidence dated 6 October 2026

Configuration and setup

How this tool was set up for the run and what the test needed in place. Each row is a fact from the run's records; a fact the records do not hold is left out, not guessed.

Software that produced the output
AskYourDatabase
Build or version
Not exposed by the hosted product
Surface
Web app
Set up before the run
The first answer needed at least one matching order and at least one non-matching order in the region so narrowing could produce a subset.
Tested
6 October 2026 · Ayush Ghosh

How this scenario is graded

How we decide Pass, Fail and Not gradable. The same rules apply to every tool tested on this scenario.

How results are decided

Each test case gets one result per tool: Pass, Fail or Not gradable. A test case we haven't run yet shows Untested. There are no partial results.

The rules
  • Pass: the tool did everything the test expected, and nothing it said contradicts the correct answer.
  • Fail: at least one expected behaviour clearly didn't happen; the test case's result says which one and quotes the tool.
  • Not gradable: our evidence couldn't settle the outcome (for example a record we needed is missing). It is never counted as a fail, and the test case's result says what's missing.

Where this sits in the benchmark

This page is one cell of a larger study: one tool, one scenario. Only this benchmark's frame appears here.

History of this result

What has happened to this result since it was first published. Runs and grades are never overwritten: a retest or a re-grade publishes a new result and keeps the earlier one readable.

from the publication record
7 October 2026First publishedAI Database Agents v1

Act on this result

Nothing filed here edits the run or the grade. A challenge opens a review, and a review can produce a new run or a re-grade — which becomes the current result and leaves this one in the history.

This matches what I see

You run the same kind of test against your own setup and get the same behaviour.

Agree →
This does not match

Yours behaves differently. Tell us what you got, with a screenshot if you have one.

Disagree →
Point out an issue

Something here is wrong — a reference value, a transcription, a grade.

Report an issue →
Request a retest

On a newer build, a larger dataset, or your own setup.

Request a retest →
We have fixed this

Tell us what changed and we schedule a rerun of the failing test case. The old result stays as history.

Vendor notice →
Filed against this evidenceNothing yet. Challenges, counter-evidence and fix notices appear here with their outcome, and stay on the page after they are resolved.
Cite this result
aidemos.com/benchmarks/ai-database-agents/results/askyourdatabase/the-user-narrows-what-they-just-asked · 1 pass · 0 fail · coverage 1/1 · graded 2026-10-07

The same record is available as structured data through the AI Demos MCP server, with the counts, the coverage and every per-test-case reason carried as fields.

Verify the proof files

These files support this result. Open a file to inspect the original evidence.

Proof 1 · Screenshot ↗image/png · 82 KB
Proof 2 · Screenshot ↗image/png · 58 KB
Output file (CSV) ↗text/csv; charset=utf-8 · 10 KB
File fingerprints (SHA-256)

A fingerprint identifies the exact file used for this result.

Proof 1 · Screenshot0ee08be0a6448da787cb4b3c6e1dd151b0ad9300b84097d80e42fb3b72234675
Proof 2 · Screenshot9f1dcf56af8bb124d578ac41946ec26f4f016a2ab12599f6bd81e8008841b8dd
Output file (CSV)59de2dd6b73d212115b162075a99d94e09678c1d38e65c00d4c0eae3548613a0