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

Does FutureSmart Database Agent keep a report meaningful when rerun after the data has changed?

FutureSmart Database Agent did not demonstrate that a report rerun after data changes preserved the same relative window. It returned 57 for the preceding 30 days as of September 2, 2026, and the visible answer surface showed no save/report control or refreshed report to compare after new rows were added.

1 of 1 test case failed

Every test case in this scenario has a result.

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

Saved report re-run after new rowsFailEvidence
What we sent

“Show me the number of orders placed in the last 30 days, as of September 2, 2026.”

What the tool returned

Orders Placed in the Last 30 Days As of September 2, 2026, the total number of orders placed in the preceding 30-day period is 57. COUNT 57

Transcribed from tc55-orders-last-30-days-result-detail

Expected vs. Found
What this scenario evaluates

These are scenario-level criteria. Each test case's Expected and Found are listed separately.

  • Whether the rerun preserves the original question rather than becoming a different report.
  • Whether the refreshed result is recomputed against the changed data state.
  • Whether the answer still means the same thing as the saved report, not a frozen past result.
How this scenario is judged →
✗Found: No refreshed result is shown; the visible query still returns 57 for the same relative 30-day window.
Supporting proof
Proof 1Screenshot
Full-window answer screen showing the relative 30-day count of 57 and the visible SQL.
Open original ↗
Why this result

The product shows the same relative 30-day query returning 57, but no save or report control is visible. With no saved report shown, a refreshed result after added rows cannot be verified.

Also observed on this row

Relative window kept in SQL. The SQL keeps the period relative by using the September 2, 2026 anchor minus INTERVAL '30 days' rather than hard-coded dates.

Tested by Ayush Ghosh · evidence dated 8 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
FutureSmart Database Agent
Surface
answer surface
Set up before the run
The database had to accept new rows after a report was saved, and the report had to use a relative time window rather than fixed dates so later rows could change the answer. The saved report was then rerun after adding those rows.
Tested
By 8 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 row says which 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 row 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
3 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/futuresmart-ai-database-agent/relative-date-report · 0 pass · 1 fail · coverage 1/1 · graded 2026-09-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.

Same content as Proof 1 ↗image/png · 32 KB
Proof 1 · Screenshot ↗image/png · 178 KB
File fingerprints (SHA-256)

A fingerprint identifies the exact file used for this result.

Same content as Proof 17c21df1387a34475513a781bf664fe317698a3ff402cf64f8c600d591b51be8d
Proof 1 · Screenshotb34c4b7862cb4f5198330ce513ae80bb568b5274cedb1a83ea459b6601eff147