changedInput schema / properties / preview / description
Previous value: -"Requested inline rows, 0–1000000. Values above row_limit are clamped to row_limit with disclosure. Omit to return every row up to row_limit; the serialized byte ceiling may withhold whole rows or metadata, preserving the result as lossless chunks."New value: +"Rows returned inline; 0 returns only the columns and counts. Default 25; a larger value returns at most 1500, or row_limit when lower, and says so."
removedInput schema / properties / preview / maximum
Removed value: -1000000
addedInput schema / properties / preview / multipleOf
Added value: +1
changedInput schema / properties / row_limit / description
Previous value: -"Most rows the query materializes (1–10000, default 1000). When more match, row_count_capped is true; use register_as to keep the full result."New value: +"Most rows the query materializes. Default 1000; a larger value materializes at most 10000 and says so. When more rows match, row_count_capped is true; use register_as to keep the full result."
removedInput schema / properties / row_limit / maximum
Removed value: -10000
addedInput schema / properties / row_limit / multipleOf
Added value: +1
changedOutput schema / properties / error / properties / data / properties / reason / description
Previous value: -"Machine-readable failure mode. Declared by this tool: `result_storage_unavailable`: The lossless result snapshot cannot be retained within the staging budget or storage fails. `canvas_unavailable`: Dataframes are turned off in this deployment, or the SQL engine behind them could not load. `missing_table`: A df_<id> the SQL names is not staged: it never existed, its TTL expired, or it was evicted to make room for newer dataframes. `invalid_sql`: A statement starting with SELECT, WITH, or FROM does not parse, or the SELECT fails to prepare: an unknown column, table, or function, or an invalid expression. `sql_execution_error`: The SELECT prepared but failed on the data it read: a cast or conversion that does not fit, an out-of-range value, or invalid input to a function. `register_as_clash`: The register_as name is already a staged dataframe. `register_as_too_large`: The register_as result alone holds more rows than the 1,000,000-row staging budget, so it was not saved. `non_select_statement`: The statement is not a read-only SELECT: an INSERT, UPDATE, DDL, PRAGMA, or other write the engine refuses, or SQL that fails to parse and does not start with SELECT, WITH, or FROM (such as a misspelled SELEC). `multi_statement`: The SQL holds more than one statement. `denied_function`: The SQL calls a denied external-data or introspection function, uses query_table, or passes query() anything other than a single SQL string literal. `plan_operator_not_allowed`: The query plan uses an operator outside the read-only allowlist, such as the range() or generate_series() table functions. `system_catalog_access`: The SQL references a system catalog (information_schema, pg_catalog, sqlite_master, duckdb_*). Other values are possible when a failure originates below the handler."New value: +"Machine-readable failure mode. Declared by this tool: `canvas_unavailable`: Dataframes are turned off in this deployment, or the SQL engine behind them could not load. `missing_table`: A df_<id> the SQL names is not staged: it never existed, its TTL expired, or it was evicted to make room for newer dataframes. `invalid_sql`: A statement starting with SELECT, WITH, or FROM does not parse, or the SELECT fails to prepare: an unknown column, table, or function, or an invalid expression. `sql_execution_error`: The SELECT prepared but failed on the data it read: a cast or conversion that does not fit, an out-of-range value, or invalid input to a function. `register_as_clash`: The register_as name is already a staged dataframe. `register_as_too_large`: The register_as result alone holds more rows than the 1,000,000-row staging budget, so it was not saved. `non_select_statement`: The statement is not a read-only SELECT: an INSERT, UPDATE, DDL, PRAGMA, or other write the engine refuses, or SQL that fails to parse and does not start with SELECT, WITH, or FROM (such as a misspelled SELEC). `multi_statement`: The SQL holds more than one statement. `denied_function`: The SQL calls a denied external-data or introspection function, uses query_table, or passes query() anything other than a single SQL string literal. `plan_operator_not_allowed`: The query plan uses an operator outside the read-only allowlist, such as the range() or generate_series() table functions. `system_catalog_access`: The SQL references a system catalog (information_schema, pg_catalog, sqlite_master, duckdb_*). Other values are possible when a failure originates below the handler."
changedOutput schema / properties / error / properties / data / properties / reason / examples
Previous value: -[
- "result_storage_unavailable",
- "canvas_unavailable",
- "missing_table",
- "invalid_sql",
- "sql_execution_error",
- "register_as_clash",
- "register_as_too_large",
- "non_select_statement",
- "multi_statement",
- "denied_function",
- "plan_operator_not_allowed",
- "system_catalog_access"
-]New value: +[
+ "canvas_unavailable",
+ "missing_table",
+ "invalid_sql",
+ "sql_execution_error",
+ "register_as_clash",
+ "register_as_too_large",
+ "non_select_statement",
+ "multi_statement",
+ "denied_function",
+ "plan_operator_not_allowed",
+ "system_catalog_access"
+]
changedOutput schema / properties / incomplete_sources / description
Previous value: -"Original incomplete upstream dataframe handles; retained through saved descendants. If metadata_withheld is true, consult the result snapshot for the full list."New value: +"Original incomplete upstream dataframe handles; retained through saved descendants."
removedOutput schema / properties / metadata_withheld
Removed value: -{
- "description": "True when oversized column names or incomplete-source metadata are withheld inline and retained in result_chunks.",
- "type": "boolean"
-}
changedOutput schema / properties / notice / description
Previous value: -"Guidance when the query returned no rows or rows were withheld."New value: +"Guidance for this result: a clamped count, an incomplete source, an empty result, or rows withheld by preview or row_limit."
removedOutput schema / properties / result_chunks
Removed value: -{
- "additionalProperties": false,
- "description": "Lossless materialized result snapshot when the byte ceiling withholds rows or metadata.",
- "properties": {
- "chunk_count": {
- "description": "Chunks numbered from zero, with at most 6144 source bytes each.",
- "maximum": 9007199254740991,
- "minimum": -9007199254740991,
- "type": "integer"
- },
- "encoding": {
- "const": "base64-json-utf8",
- "description": "Decode each base64 chunk, concatenate bytes in index order, then decode UTF-8 and JSON.",
- "type": "string"
- },
- "expires_at": {
- "description": "ISO 8601 expiry of the chunk dataframe.",
- "type": "string"
- },
- "name": {
- "description": "Tenant-scoped dataframe holding chunk_index and base64 chunk columns.",
- "type": "string"
- }
- },
- "required": [
- "name",
- "encoding",
- "chunk_count",
- "expires_at"
- ],
- "type": "object"
-}
changedOutput schema / properties / row_count / description
Previous value: -"Rows the query produced, up to row_limit. When row_count_capped is true this is the cap, not the full size."New value: +"Rows the query produced, up to row_limit; with register_as, every row of the saved result. When row_count_capped is true this is the cap, not the full size."
changedOutput schema / properties / rows / description
Previous value: -"Result rows, one object per row keyed by column name, bounded by preview and row_limit. BIGINT values (SUM, COUNT) arrive as strings."New value: +"The first preview rows of the result, one object per row keyed by column name. BIGINT values (SUM, COUNT) arrive as strings."
changedOutput schema / properties / truncated / description
Previous value: -"True when rows were withheld by a cap."New value: +"True when preview or row_limit withheld rows."