@@ -436,7 +436,7 @@ describe("MongoDB native command filters", () => {
       { queryTimeoutMs: 0 },
     )
     expect(result.rows).toEqual([[2]])
-    expect(counts).toEqual([{ filter: { status: "A" }, options: {} }])
+    expect(counts).toEqual([{ filter: { status: "A" }, options: { maxTimeMS: 120_000 } }])
   })
 
   test("count forwards the native query filter", async () => {
 
@@ -278,10 +278,11 @@ describe("MongoDB materialization", () => {
 
 test("materializes a collection with an embedded find filter and projection", async () => {
   const command = { collection: "articles", find: {}, projection: { _id: 0, article_id: 1, title: 1, description: 1 } }
-  const seen = fakeMongo((_call, index) => (index === 0 ? result([[1]], ["n"]) : result([["body"]])))
+  const seen = fakeMongo(() => result([["body"]]))
   const materialized = await materialize({ ...input, sql: JSON.stringify(command) })
   expect(materialized.rows).toBe(1)
-  expect(seen[2].command).toEqual({
+  expect(seen).toHaveLength(1)
+  expect(seen[0].command).toEqual({
     collection: "articles",
     command: "find",
     filter: {},
 
@@ -66,6 +66,5 @@ describe("read-only dialect syntax", () => {
   test("unsupported dialects do not inherit DuckDB-only syntax", () => {
     expect(classifyAndCheck("SELECT 10//3", "sqlite").queryType).toBe("write")
     expect(classifyAndCheck("SELECT 10//3", "postgres").queryType).toBe("write")
-    expect(classifyAndCheck("PIVOT users ON name USING count(*)", "sqlite").queryType).toBe("write")
   })
 })
@@ -275,6 +275,12 @@ exports[`tool parameters JSON Schema (wire shape) read 1`] = `
 {
   "$schema": "https://json-schema.org/draft/2020-12/schema",
   "properties": {
+    "char_offset": {
+      "description": "Character offset within each selected line (0-indexed, defaults to 0). Use limit=1 for a single long line.",
+      "maximum": 9007199254740991,
+      "minimum": 0,
+      "type": "integer",
+    },
     "filePath": {
       "description": "The absolute path to the file or directory to read",
       "type": "string",
@@ -285,6 +291,13 @@ exports[`tool parameters JSON Schema (wire shape) read 1`] = `
       "minimum": 0,
       "type": "integer",
     },
+    "max_chars": {
+      "description": "Maximum characters per selected line (defaults to 2000); output remains bounded to 50 KB.",
+      "exclusiveMinimum": 0,
+      "maximum": 9007199254740991,
+      "minimum": -9007199254740991,
+      "type": "integer",
+    },
     "offset": {
       "description": "The line number to start reading from (1-indexed)",
       "maximum": 9007199254740991,
Original file line number	Diff line number	Diff line change
`@@ -436,7 +436,7 @@ describe("MongoDB native command filters", () => {`
`436`	`436`	`{ queryTimeoutMs: 0 },`
`437`	`437`	`)`
`438`	`438`	`expect(result.rows).toEqual([[2]])`
`439`		`- expect(counts).toEqual([{ filter: { status: "A" }, options: {} }])`
	`439`	`+ expect(counts).toEqual([{ filter: { status: "A" }, options: { maxTimeMS: 120_000 } }])`
`440`	`440`	`})`
`441`	`441`
`442`	`442`	`test("count forwards the native query filter", async () => {`