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

Does BlazeSQL give a summary and detail together?

BlazeSQL failed to give the overall figure together with the breakdown. It first asked which dimension to use, then showed category-level query, results, highlights, and CSV export, but none stated the month total.

1 of 1 test case failed

Every test case in this scenario has a result.

Pass rate0%0 of 1 gradable
Coverage1 of 1test case with a result
0PassNo test case passed.
1FailMissed at least one thing it was expected to do; the reason and proof are with each test case below.
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.

Headline figure plus its breakdownFailEvidence
What we sent

Input 1: “As of September 2, 2026, how did our revenue do last month, and what drove it”

Input 2: “Product category”

What the tool returned

Response 1 replies to Input 1.

Response 2 replies to Input 2.

Response to input 1 What dimension would you like to see the revenue breakdown by? · Product category · Individual product · Customer segment (e.g. members vs non-members) · All of the above Response to input 2 Here are the key highlights for August 2026 revenue 👇 · Storage & Organization topped revenue at $3,775 across 8 orders — the highest volume category · Outdoor & Patio came in 2nd at $3,446 with just 3 orders — driven by a very high AOV of $1,149 · Lighting was close behind at $3,323 across 5 orders · Furniture and Bedding & Rugs were the weakest performers, each under $1,250 · Would you like to dig deeper into any specific category, or compare this to a prior month?

Transcribed from Proof 1 · Screenshot

Transcribed from Proof 2 · Screenshot

Output file (CSV)
CSV export: seven category rows with no total line
CSV7 rows · 4 columns
categoryorder_counttotal_revenueavg_order_value
storage_and_organization83775.44471.93
outdoor_and_patio33446.141148.71
lighting53323.41664.68
home_decor73096.4442.34
kitchen_and_dining21656.05828.03
furniture21244.35622.18
bedding_and_rugs51203.23240.65
Open the CSV file ↗
Expected vs. Found
✗Expected: Show the overall figure and a breakdown in fitting forms.Found: It showed category-level detail but never the overall figure; the first reply was only a dimension prompt.
Supporting proof
Proof 1Screenshot
Chat capture: a dimension prompt instead of a revenue answer
Open original ↗
Proof 2Screenshot
Chat capture: category breakdown reply with query and highlights
Open original ↗
Why this result

It had to show a month total and a breakdown. The second reply showed only category-level detail, and the first reply was just a dimension prompt, so the combined answer never appeared.

Also observed in this test case

Prompt only. The first reply was only a dimension-choice prompt, so no revenue figure appeared yet.

Derived total. The export's seven category totals add up to $17,745.02.

Tested by Ayush Ghosh · evidence dated 21 September 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
BlazeSQL
Build or version
1.8.93
Surface
Web app
Set up before the run
A changing measure and one segment responsible for most of the movement had to be present.
Tested
21 September 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
14 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/blazesql/the-answer-needs-a-summary-and-its-detail-together · 0 pass · 1 fail · coverage 1/1 · graded 2026-10-13

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 · 38 KB
Proof 2 · Screenshot ↗image/png · 123 KB
Output file (CSV) ↗text/csv; charset=utf-8 · 0 KB
File fingerprints (SHA-256)

A fingerprint identifies the exact file used for this result.

Proof 1 · Screenshotf993c84d35a63944190a5687cff240213ef3aa6abb7dcbd6f9bee98a5e649b6e
Proof 2 · Screenshotf32d542c2cbb41c7ddbc87d3ba79d0ba1d8b077b25dc82b9da5b1878de37c78d
Output file (CSV)8de3efb210e53afb65afe4d16776fc9226772f0162bd1985561b9ec8591700ef