Skip to content

feat: select, insert, update and json Schemas per table #196

feat: select, insert, update and json Schemas per table

feat: select, insert, update and json Schemas per table #196

Triggered via pull request November 2, 2026 15:32
Status Failure
Total duration 2m 37s
Artifacts –

ci.yml

on: pull_request
Matrix: release-checks
Fit to window
Zoom out
Zoom in

Annotations

3 errors and 2 notices
Builder / ClickHouse 26.2.19.43
Process completed with exit code 1.
tests/fuzz/queries.fuzz.test.ts > generated fixture queries > generated fixtures: query results agree (clickhouse-join-nulls): tests/fuzz/harness.ts#L155
Error: [fuzz] generated fixtures: query results agree (clickhouse-join-nulls) failed after 72 runs (18 shrinks) replay: FUZZ_SEED=1231362704 FUZZ_PATH=75:0:0:0:1:1:1:1:2:2:2:2:2:0:0:0:0:0:0 bun run fuzz -t 'generated fixtures: query results agree \(clickhouse-join-nulls\)' --- input (shrunk) {"fixture":{"orders":[],"customers":[]},"plan":{"orgId":"org_2","join":undefined,"where":[{"k":"tenant","side":"orders"}],"shape":{"k":"rows","select":[["id",{"k":"col","col":"Id"}],["e0",{"k":"arith","op":"add","l":{"k":"arith","op":"add","l":{"k":"arith","op":"add","l":{"k":"col","col":"Id"},"r":{"k":"num","v":0}},"r":{"k":"arith","op":"mod","l":{"k":"col","col":"Id"},"r":{"k":"col","col":"Id"}}},"r":-1}]],"distinct":false,"orderBy":[],"limit":undefined,"offset":undefined},"wrap":false,"crossTenant":false}} --- error expected 'DatabaseError' to be 'Rows' // Object.is equality --- sql WITH orders AS ( SELECT CAST('' AS String) AS "OrgId", CAST(0 AS UInt32) AS "Id", CAST('' AS String) AS "Customer", CAST(0 AS Int64) AS "Amount", CAST('' AS String) AS "Status", CAST(NULL AS Nullable(String)) AS "Note", CAST('2026-01-01 00:00:00.000' AS DateTime64(3, 'UTC')) AS "Created" WHERE 1 = 0 ), customers AS ( SELECT CAST('' AS String) AS "OrgId", CAST('' AS String) AS "Name", CAST('' AS String) AS "Tier" WHERE 1 = 0 ) SELECT orders.Id AS id, orders.Id + 0 + (orders.Id % orders.Id) + -1 AS e0 FROM orders WHERE orders.OrgId = 'org_2' --- parameters [] --- tenantScope single-tenant --- outcome {"_tag":"DatabaseError","message":"Code: 153. DB::Exception: Division by zero. (ILLEGAL_DIVISION) (version 26.2.19.43 (official build))"} --- expected [] --- pin it: add the input above to tests/fuzz/regressions.ts under a key matching "generated fixtures: query results agree (clickhouse-join-nulls)" ❯ property tests/fuzz/harness.ts:155:8
tests/fuzz/queries.fuzz.test.ts > generated fixture queries > generated fixtures: union results agree (clickhouse): tests/fuzz/harness.ts#L155
Error: [fuzz] generated fixtures: union results agree (clickhouse) failed after 13 runs (47 shrinks) replay: FUZZ_SEED=1895785494 FUZZ_PATH=14:0:8:0:1:1:1:1:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0 bun run fuzz -t 'generated fixtures: union results agree \(clickhouse\)' --- input (shrunk) {"fixture":{"orders":[],"customers":[]},"plan":{"orgId":"org_3","branches":[{"orgId":"org_3","join":undefined,"where":[],"shape":{"k":"rows","select":[["id",{"k":"col","col":"Id"}],["e0",{"k":"col","col":"Note"}],["e1",{"k":"coalesce","e":{"k":"col","col":"Note"},"fallback":{"k":"col","col":"OrgId"}}],["e2",{"k":"arith","op":"mod","l":{"k":"num","v":0},"r":{"k":"col","col":"Id"}}]],"distinct":false,"orderBy":[],"limit":undefined,"offset":undefined},"wrap":false,"crossTenant":false},{"orgId":"org_3","join":undefined,"where":[{"k":"cmp","op":"eq","l":{"k":"arith","op":"add","l":{"k":"col","col":"Id"},"r":-1},"r":{"k":"param","kind":"int","v":0}}],"shape":{"k":"rows","select":[["id",{"k":"col","col":"Id"}],["e0",{"k":"col","col":"Note"}],["e1",{"k":"col","col":"OrgId"}],["e2",{"k":"arith","op":"add","l":{"k":"col","col":"Id"},"r":{"k":"num","v":0}}]],"distinct":false,"orderBy":[],"limit":undefined,"offset":undefined},"wrap":false,"crossTenant":false},{"orgId":"org_3","join":undefined,"where":[{"k":"and","style":"method","cs":[{"k":"and","style":"method","cs":[{"k":"const","v":false},{"k":"cmp","op":"eq","l":{"k":"num","v":0},"r":{"k":"expr","e":{"k":"col","col":"Id"}}}]},{"k":"cmp","op":"eq","l":{"k":"num","v":0},"r":{"k":"param","kind":"int","v":0}}]}],"shape":{"k":"rows","select":[["id",{"k":"col","col":"Id"}],["e0",{"k":"col","col":"Note"}],["e1",{"k":"col","col":"OrgId"}],["e2",{"k":"col","col":"Id"}]],"distinct":false,"orderBy":[],"limit":undefined,"offset":undefined},"wrap":false,"crossTenant":false}],"crossTenant":false,"orderBy":[["e2","asc"],["id","asc"],["e1","asc"],["e0","asc"]],"limit":undefined,"offset":undefined}} --- error expected 'DatabaseError' to be 'Rows' // Object.is equality --- sql SELECT * FROM ( WITH orders AS ( SELECT CAST('' AS String) AS "OrgId", CAST(0 AS UInt32) AS "Id", CAST('' AS String) AS "Customer", CAST(0 AS Int64) AS "Amount", CAST('' AS String) AS "Status", CAST(NULL AS Nullable(String)) AS "Note", CAST('2026-01-01 00:00:00.000' AS DateTime64(3, 'UTC')) AS "Created" WHERE 1 = 0 ), customers AS ( SELECT CAST('' AS String) AS "OrgId", CAST('' AS String) AS "Name", CAST('' AS String) AS "Tier" WHERE 1 = 0 ) SELECT orders.Id AS id, orders.Note AS e0, coalesce(orders.Note, orders.OrgId) AS e1, 0 % orders.Id AS e2 FROM orders UNION ALL WITH orders AS ( SELECT CAST('' AS String) AS "OrgId", CAST(0 AS UInt32) AS "Id", CAST('' AS String) AS "Customer", CAST(0 AS Int64) AS "Amount", CAST('' AS String) AS "Status", CAST(NULL AS Nullable(String)) AS "Note", CAST('2026-01-01 00:00:00.000' AS DateTime64(3, 'UTC')) AS "Created" WHERE 1 = 0 ), customers AS ( SELECT CAST('' AS String) AS "OrgId", CAST('' AS String) AS "Name", CAST('' AS String) AS "Tier" WHERE 1 = 0 ) SELECT orders.Id AS id, orders.Note AS e0, orders.OrgId AS e1, orders.Id + 0 AS e2 FROM orders WHERE orders.Id + -1 = 0 UNION ALL WITH orders AS ( SELECT CAST('' AS String) AS "OrgId", CAST(0 AS UInt32) AS "Id", CAST('' AS String) AS "Customer", CAST(0 AS Int64) AS "Amount", CAST('' AS String) AS "Status", CAST(NULL AS Nullable(String)) AS "Note", CAST('2026-01-01 00:00:00.000' AS DateTime64(3, 'UTC')) AS "Created" WHERE 1 = 0 ), customers AS ( SELECT CAST('' AS String) AS "OrgId", CAST('' AS String) AS "Name", CAST('' AS String) AS "Tier" WHERE 1 = 0 ) SELECT orders.Id AS id, orders.Note AS e0, orders.OrgId AS e1, orders.Id AS e2 FROM orders WHERE ((1 = 0 AND 0 = orders.Id) AND 0 = 0) ) ORDER BY CAST(e2 AS Nullable(Float64)) ASC, accurateCastOrNull(e2, 'Int128') ASC, id ASC, e1 ASC, e0 ASC --- parameters [] --- tenantScope cross-tenant --- outcome {"_tag":"Da
Builder / ClickHouse 26.2.19.43
"The ubuntu-latest label will migrate to Ubuntu 26 beginning October 19, 2026. For more information, see https://github.com/actions/runner-images/issues/14748"
Builder / ClickHouse 26.8.2.7
"The ubuntu-latest label will migrate to Ubuntu 26 beginning October 19, 2026. For more information, see https://github.com/actions/runner-images/issues/14748"