Testdrive (before Kafka source versioning) (#2) failed, main history:

Unknown error in primary-key-optimizations.td:

primary-key-optimizations.td:210:1: non-matching rows: expected:
[["Explained Query:\n  Return\n    Union\n      Get l0\n      Map (0)\n        Union\n          Negate\n            Project ()\n              Get l0\n          Constant\n            - ()\n  With\n    cte l0 =\n      Reduce aggregates=[count(distinct #0)]\n        Project (#0)\n          ReadIndex on=t1 t1_primary_idx=[*** full scan ***]\n\nUsed Indexes:\n  - t1_primary_idx (*** full scan ***)\n\nTarget cluster: quickstart\n"]]
got:
[["Explained Query:\n  With\n    cte l0 =\n      Reduce aggregates=[count(distinct #0)]\n        Project (#0)\n          ReadIndex on=t1 t1_primary_idx=[*** full scan ***]\n  Return\n    Union\n      Get l0\n      Map (0)\n        Union\n          Negate\n            Project ()\n              Get l0\n          Constant\n            - ()\n\nUsed Indexes:\n  - t1_primary_idx (*** full scan ***)\n\nTarget cluster: quickstart\n"]]
got raw rows:
[["Explained Query:\n  With\n    cte l0 =\n      Reduce aggregates=[count(distinct #0)]\n        Project (#0)\n          ReadIndex on=t1 t1_primary_idx=[*** full scan ***]\n  Return\n    Union\n      Get l0\n      Map (0)\n        Union\n          Negate\n            Project ()\n              Get l0\n          Constant\n            - ()\n\nUsed Indexes:\n  - materialize.public.t1_primary_idx (*** full scan ***)\n\nTarget cluster: quickstart\n"]]
Poor diff:
- "Explained Query:\n  Return\n    Union\n      Get l0\n      Map (0)\n        Union\n          Negate\n            Project ()\n              Get l0\n          Constant\n            - ()\n  With\n    cte l0 =\n      Reduce aggregates=[count(distinct #0)]\n        Project (#0)\n          ReadIndex on=t1 t1_primary_idx=[*** full scan ***]\n\nUsed Indexes:\n  - t1_primary_idx (*** full scan ***)\n\nTarget cluster: quickstart\n"
+ "Explained Query:\n  With\n    cte l0 =\n      Reduce aggregates=[count(distinct #0)]\n        Project (#0)\n          ReadIndex on=t1 t1_primary_idx=[*** full scan ***]\n  Return\n    Union\n      Get l0\n      Map (0)\n        Union\n          Negate\n            Project ()\n              Get l0\n          Constant\n            - ()\n\nUsed Indexes:\n  - t1_primary_idx (*** full scan ***)\n\nTarget cluster: quickstart\n"

     |
  12 | $ postgres-execute c ... [rest of line truncated for security]
  46 |     URL '${testdrive ... [rest of line truncated for security]
 209 | 
 210 | ? EXPLAIN WITH(no notices) SELECT COUNT(DISTINCT key1) FROM t1;
     | ^

Unknown error in source-linear-operators.td:

source-linear-operators.td:190:1: non-matching rows: expected:
[["Explained Query:\n  Return\n    Project (#2)\n      Join on=(#0 = #1) type=differential\n        ArrangeBy keys=[[#0]]\n          Project (#0)\n            Get l0\n        ArrangeBy keys=[[#0]]\n          Project (#0, #2)\n            Get l0\n  With\n    cte l0 =\n      Filter (#0) IS NOT NULL\n        ReadStorage materialize.public.data\n\nSource materialize.public.data\n  filter=((#0) IS NOT NULL)\n\nTarget cluster: quickstart\n"]]
got:
[["Explained Query:\n  With\n    cte l0 =\n      Filter (#0) IS NOT NULL\n        ReadStorage materialize.public.data\n  Return\n    Project (#2)\n      Join on=(#0 = #1) type=differential\n        ArrangeBy keys=[[#0]]\n          Project (#0)\n            Get l0\n        ArrangeBy keys=[[#0]]\n          Project (#0, #2)\n            Get l0\n\nSource materialize.public.data\n  filter=((#0) IS NOT NULL)\n\nTarget cluster: quickstart\n"]]
Poor diff:
- "Explained Query:\n  Return\n    Project (#2)\n      Join on=(#0 = #1) type=differential\n        ArrangeBy keys=[[#0]]\n          Project (#0)\n            Get l0\n        ArrangeBy keys=[[#0]]\n          Project (#0, #2)\n            Get l0\n  With\n    cte l0 =\n      Filter (#0) IS NOT NULL\n        ReadStorage materialize.public.data\n\nSource materialize.public.data\n  filter=((#0) IS NOT NULL)\n\nTarget cluster: quickstart\n"
+ "Explained Query:\n  With\n    cte l0 =\n      Filter (#0) IS NOT NULL\n        ReadStorage materialize.public.data\n  Return\n    Project (#2)\n      Join on=(#0 = #1) type=differential\n        ArrangeBy keys=[[#0]]\n          Project (#0)\n            Get l0\n        ArrangeBy keys=[[#0]]\n          Project (#0, #2)\n            Get l0\n\nSource materialize.public.data\n  filter=((#0) IS NOT NULL)\n\nTarget cluster: quickstart\n"

     |
 189 | 
 190 | ? EXPLAIN SELECT * FROM v;
     | ^

Unknown error in workflow-default:

Docker compose failed: docker compose -f/dev/fd/4 --project-directory /var/lib/buildkite-agent/builds/hetzner-aarch64-8cpu-16gb-9053a6da/materialize/nightly/test/testdrive-old-kafka-src-syntax run -eCLUSTER_REPLICA_SIZES testdrive --junit-report=junit_testdrive-old-kafka-src-syntax_019468b9-2e50-4e65-8fc3-96a76041dba3.xml --var=default-replica-size=4-4 --var=default-storage-size=4-1 *.td

Container testdrive-old-kafka-src-syntax-minio-1  Running
Container testdrive-old-kafka-src-syntax-fivetran-destination-1  Running
importer.proto:2:1: warning: Import empty.proto is unused.
^^^ +++
importer.proto:2:1: warning: Import empty.proto is unused.
^^^ +++
+++ !!! Error Report
2 errors were encountered during execution
files involved: primary-key-optimizations.td source-linear-operators.td

Test details & reproducer

Testdrive is the basic framework and language for defining product tests under the expected-result/actual-result (aka golden testing) paradigm. A query is retried until it produces the desired result.

bin/mzcompose --find testdrive-old-kafka-src-syntax run default

Nightly

Scheduled build