Does AskYourDatabase handle a user's synonym when stored values use different wording?
AskYourDatabase returned 14 gift-card orders for a request about gift vouchers. The table matched the reference answer's $16,806.08 total and status breakdown.
1 of 1 test case passed
Every test case in this scenario has a result.
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.
Category asked by the user's synonymPassEvidence
“Show me all orders paid with a gift voucher.”
Here are all orders paid with a gift card (14 total):
| Order # | Customer ID | Status | Total | Placed At | Items |
|---|---|---|---|---|---|
| ORD-2026-0278 | 16 | placed | $245.25 | 2026-10-05 | Under-bed storage bins, pair - Walnut |
| ORD-2026-0252 | 7 | packed | $1,661.97 | 2026-10-04 | Entryway bench with cubbies - Brass (+1 more) |
| ORD-2026-0246 | 8 | packed | $2,157.57 | 2026-10-03 | Rattan pendant light - Ivory (+2 more) |
| ORD-2026-0228 | 14 | cancelled | $1,302.00 | 2026-10-02 | Adirondack chair - Fog Grey |
| ORD-2026-0194 | 11 | shipped | $521.99 | 2026-09-28 | String light set, 48ft - Ivory |
| ORD-2026-0186 | 17 | shipped | $823.50 | 2026-09-27 | Aspen 3-seat sofa - Walnut |
| ORD-2026-0165 | 11 | delivered | $2,597.97 | 2026-09-22 | Kestrel accent chair - Ivory (+1 more) |
| ORD-2026-0163 | 13 | delivered | $268.00 | 2026-09-22 | Velvet throw pillow, pair - Charcoal |
| ORD-2026-0139 | 5 | delivered | $2,018.86 | 2026-09-20 | Fairview bed frame, queen - Sage (+2 more) |
| ORD-2026-0091 | 5 | delivered | $1,806.00 | 2026-08-24 | Patio bistro set, 3-piece - Brass (+1 more) |
| ORD-2026-0066 | 7 | delivered | $776.78 | 2026-07-24 | Woven storage baskets, set of 3 - Sage (+2 more) |
| ORD-2026-0045 | 14 | delivered | $274.50 | 2026-06-20 | Aspen 3-seat sofa - Sand |
| ORD-2026-0001 | 11 | delivered | $1,738.69 | 2026-01-10 | Fairview bed frame, queen - Fog Grey (+1 more) |
| ORD-2025-0020 | 12 | cancelled | $613.00 | 2025-12-29 | Woven storage baskets, set of 3 - Walnut (+1 more) |
Two of these orders were later cancelled (ORD-2026-0228 and ORD-2025-0020). You can view the full results here
Show the reply as returned (Markdown)
Here are all orders paid with a gift card (14 total): | Order # | Customer ID | Status | Total | Placed At | Items | |---|---|---|---|---|---| | ORD-2026-0278 | 16 | placed | $245.25 | 2026-10-05 | Under-bed storage bins, pair - Walnut | | ORD-2026-0252 | 7 | packed | $1,661.97 | 2026-10-04 | Entryway bench with cubbies - Brass (+1 more) | | ORD-2026-0246 | 8 | packed | $2,157.57 | 2026-10-03 | Rattan pendant light - Ivory (+2 more) | | ORD-2026-0228 | 14 | cancelled | $1,302.00 | 2026-10-02 | Adirondack chair - Fog Grey | | ORD-2026-0194 | 11 | shipped | $521.99 | 2026-09-28 | String light set, 48ft - Ivory | | ORD-2026-0186 | 17 | shipped | $823.50 | 2026-09-27 | Aspen 3-seat sofa - Walnut | | ORD-2026-0165 | 11 | delivered | $2,597.97 | 2026-09-22 | Kestrel accent chair - Ivory (+1 more) | | ORD-2026-0163 | 13 | delivered | $268.00 | 2026-09-22 | Velvet throw pillow, pair - Charcoal | | ORD-2026-0139 | 5 | delivered | $2,018.86 | 2026-09-20 | Fairview bed frame, queen - Sage (+2 more) | | ORD-2026-0091 | 5 | delivered | $1,806.00 | 2026-08-24 | Patio bistro set, 3-piece - Brass (+1 more) | | ORD-2026-0066 | 7 | delivered | $776.78 | 2026-07-24 | Woven storage baskets, set of 3 - Sage (+2 more) | | ORD-2026-0045 | 14 | delivered | $274.50 | 2026-06-20 | Aspen 3-seat sofa - Sand | | ORD-2026-0001 | 11 | delivered | $1,738.69 | 2026-01-10 | Fairview bed frame, queen - Fog Grey (+1 more) | | ORD-2025-0020 | 12 | cancelled | $613.00 | 2025-12-29 | Woven storage baskets, set of 3 - Walnut (+1 more) | Two of these orders were later cancelled (ORD-2026-0228 and ORD-2025-0020). You can view the full results here
Transcribed from Proof 2 · Screenshot
Every message the tool sent, in order (3)
- Lookup status
I'll look up orders paid with a gift card.
- SQL query · not part of the answer
SELECT id, order_number, customer_id, status, total_amount, currency, payment_method, placed_at, item_summary FROM orders WHERE payment_method = 'gift_card' ORDER BY placed_at DESC;
- Gift-card orders
The final response, printed above.
| ✓ | Expected: Return the matching orders rather than present an empty result.Found: It returned 14 matching orders whose amounts sum to $16,806.08, equal to the reference total of $16,806.08. |
It is a Pass, not an empty-result failure: the product bridged the user's wording to the stored value and returned 14 rows. The recorded reference query on the same database gives 14 orders totaling $16,806.08 (7 delivered, 2 cancelled, 2 shipped, 2 packed, 1 placed), and the returned table matches those figures.
Unexplained wording change. The reply uses gift card throughout without explaining that it treats gift voucher as equivalent. The displayed query makes the substitution visible.
Cancellation note, no combined amount. The closing note identifies the two orders that were later cancelled; the answer gives no combined amount for the gift-card orders.
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.
How this scenario is graded
How we decide Pass, Fail and Not gradable. The same rules apply to every tool tested on this scenario.
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.
- 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.
| Level | Name | Scope |
|---|---|---|
| Benchmark | AI Database Agents → | 28 scenarios · 11 tools |
| Capability | Question Answering → | |
| Scenario | The user's wording doesn't match how the values are stored → | |
| Tool | AskYourDatabase → |
Global scenario definition → · Global capability definition → · AskYourDatabase product page →
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.
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.
You run the same kind of test against your own setup and get the same behaviour.
Agree →Yours behaves differently. Tell us what you got, with a screenshot if you have one.
Disagree →Something here is wrong — a reference value, a transcription, a grade.
Report an issue →Tell us what changed and we schedule a rerun of the failing test case. The old result stays as history.
Vendor notice →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.
File fingerprints (SHA-256)
A fingerprint identifies the exact file used for this result.