compare_query_results
Compare two read-only SQL query results to verify exact match, including result shape, duplicates, and required order, capturing both results in one snapshot.
Instructions
Compare two read-only query results in one snapshot. The result is proven only when the complete bounded results, duplicates, shape, and required order match.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| baseline_sql | Yes | Baseline read-only SQL. | |
| candidate_sql | Yes | Candidate read-only SQL. | |
| compare_order | No | ||
| database_name | No | ||
| parameter_case | No | Required for parameterized SQL: one named case with exact values and declared SQL types for every parameter. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||