"""New editorial fixture, 2026-10-10. Synthetic data only.
Run: python3 example-check.py
This is not the unavailable original Deep Research harness or a production test.
"""
import sqlite3

db = sqlite3.connect(':memory:')
db.executescript('''
CREATE TABLE orders(id TEXT PRIMARY KEY, amount INTEGER NOT NULL);
CREATE TABLE items(order_id TEXT NOT NULL);
INSERT INTO orders VALUES ('A',100),('B',200);
INSERT INTO items VALUES ('A'),('A'),('B');
''')
def scalar(query):
    return db.execute(query).fetchone()[0]

wrong = scalar('SELECT SUM(amount) FROM orders JOIN items ON id=order_id')
correct = scalar('SELECT SUM(amount) FROM orders')
assert wrong == 400 and correct == 300
print(f'Join fan-out: incorrect={wrong}, expected={correct}')

# SUM(DISTINCT amount) silently merges distinct equal-valued orders.
db.execute("UPDATE orders SET amount=100 WHERE id='B'")
distinct = scalar('SELECT SUM(DISTINCT amount) FROM orders JOIN items ON id=order_id')
correct_equal = scalar('SELECT SUM(amount) FROM orders')
assert distinct == 100 and correct_equal == 200
print(f'Equal order amounts: DISTINCT={distinct}, expected={correct_equal}')
print('Passed these two synthetic cases only. Review your own metric and exceptions.')