Repository navigation
feat: select, insert, update and json Schemas per table #196
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"
|