Skip to content

Expand upstream SQL test allowlist (+342 tests, batches 1–6)#712

Merged
peter-leonov-ch merged 4 commits into
mainfrom
copilot/add-100-tests-repeatedly
May 9, 2026
Merged

Expand upstream SQL test allowlist (+342 tests, batches 1–6)#712
peter-leonov-ch merged 4 commits into
mainfrom
copilot/add-100-tests-repeatedly

Conversation

Copilot AI commented May 9, 2026

Copy link
Copy Markdown
Contributor

Continues #708 / #710 by growing tests/clickhouse-test-runner/upstream-allowlist.txt from 36 → 424 entries through the Node.js harness, validated on both client and http backends.

  • Set up upstream ClickHouse sparse checkout, install Python deps, build the test runner, start ClickHouse via docker-compose
  • Verify the existing 36-test allowlist passes through the harness on both client and http backends
  • Build the per-batch driver (add 100, run both backends with --no-stateful --no-long, keep passers, drop failures and skips)
  • Run batches 1-6 (600 candidates evaluated; 342 passed on both client and http backends and were kept; 257 failures and 1 skip dropped); allowlist 36 → 378
  • Fix CI failures from prior commit: drop 54 entries from the allowlist that either failed in the CI matrix ({client,http} × {head,latest}) or that act as prefix matches for failing tests (clickhouse-test treats positional args as substring/prefix matches, so e.g. 00396_uuid was unintentionally pulling in the failing 00396_uuid_v7). Net: allowlist now 424 entries (+388 vs the pre-Expand upstream SQL test allowlist #710 baseline of 36)
  • Document the harness purpose and the batch-add strategy (including the prefix-match gotcha) in AGENTS.md so future agent runs have the context
  • PR ready for review

Copilot AI and others added 2 commits May 9, 2026 10:56
Agent-Logs-Url: https://github.com/ClickHouse/clickhouse-js/sessions/111da3b1-60b1-4463-a2f6-81f273b71557

Co-authored-by: peter-leonov-ch <209667683+peter-leonov-ch@users.noreply.github.com>
Agent-Logs-Url: https://github.com/ClickHouse/clickhouse-js/sessions/111da3b1-60b1-4463-a2f6-81f273b71557

Co-authored-by: peter-leonov-ch <209667683+peter-leonov-ch@users.noreply.github.com>
@CLAassistant

Copy link
Copy Markdown

CLA assistant check
Thank you for your submission! We really appreciate it. Like many open source projects, we ask that you sign our Contributor License Agreement before we can accept your contribution.
You have signed the CLA already but the status is still pending? Let us recheck it.

@codecov

codecov Bot commented May 9, 2026

Copy link
Copy Markdown

Codecov Report

✅ All modified and coverable lines are covered by tests.

📢 Thoughts on this report? Let us know!

Agent-Logs-Url: https://github.com/ClickHouse/clickhouse-js/sessions/ff6b0ebd-bf39-4b26-9bb2-1325f729e40a

Co-authored-by: peter-leonov-ch <209667683+peter-leonov-ch@users.noreply.github.com>
…TS.md

Agent-Logs-Url: https://github.com/ClickHouse/clickhouse-js/sessions/90381f5c-1448-4476-bb88-5f6c78b94c8c

Co-authored-by: peter-leonov-ch <209667683+peter-leonov-ch@users.noreply.github.com>
@peter-leonov-ch peter-leonov-ch marked this pull request as ready for review May 9, 2026 13:07
@peter-leonov-ch peter-leonov-ch requested a review from mshustov as a code owner May 9, 2026 13:07
Copilot AI review requested due to automatic review settings May 9, 2026 13:07

Copilot AI left a comment

Copy link
Copy Markdown
Contributor

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Pull request overview

Expands the upstream ClickHouse stateless SQL test allowlist used by tests/clickhouse-test-runner, increasing the set of upstream tests exercised in CI across both harness backends (client, http) and both server versions (latest, head). Also documents the harness’s purpose and the batch-based allowlist growth strategy (including the prefix/substring match pitfall) for future maintenance.

Changes:

  • Add ~388 new upstream stateless SQL test names to upstream-allowlist.txt (net allowlist now 424 entries).
  • Extend AGENTS.md with a clear explanation of the harness behavior and a repeatable, batch-driven method for growing/pruning the allowlist.

Reviewed changes

Copilot reviewed 2 out of 2 changed files in this pull request and generated 1 comment.

File Description
tests/clickhouse-test-runner/upstream-allowlist.txt Expands the curated list of upstream stateless SQL tests to run through the Node.js harness in CI.
AGENTS.md Documents the harness behavior and a process for safely growing the allowlist (including prefix-match gotchas).

💡 Add Copilot custom instructions for smarter, more guided reviews. Learn how to get started.

Comment thread tests/clickhouse-test-runner/upstream-allowlist.txt
@peter-leonov-ch peter-leonov-ch merged commit c10068e into main May 9, 2026
68 checks passed
@peter-leonov-ch peter-leonov-ch deleted the copilot/add-100-tests-repeatedly branch May 9, 2026 18:18
peter-leonov-ch added a commit that referenced this pull request May 9, 2026
`AGENTS.md` had drifted from reality after PRs #662#712: it claimed
`examples/web` has no `performance/` folder, pointed at a placeholder
docs path, and said nothing about the `skills/` directory or the
`.claude/skills/setup/` skill that replaced `copilot-setup-steps.yml`.

## Summary

- **Examples › `performance/`** — drop the "no `performance/` folder
under `examples/web`" claim; #701 added one for browser-safe streaming.
- **Log-message docs guidance** — point at the real `docs/` layout from
#677 (`docs/socket_hang_up_econnreset.md`, `docs/howto/`) instead of a
fictional `docs/example-log-message.md`. The example URL in the snippet
now also resolves to a real page (`docs/socket_hang_up_econnreset.md`).
- **New `Skills` section** — documents the repo-root `skills/` directory
(#681, #682, #702): `client-node`'s `prepack` ships it via
`@clickhouse/client`, the `agents.skills` field of
`packages/client-node/package.json` declares which skills are
discoverable, and the `Skills E2E` workflow
(`.github/workflows/e2e-skills.yml`, backed by
`tests/e2e/skills/check.js`) asserts the packaged tarball contains the
declared skills. Routes contributors to `.claude/skills/setup/SKILL.md`
(#705) instead of re-introducing `copilot-setup-steps.yml`.
- **`agents.skills` manifest** — adds `clickhouse-js-node-coding`
alongside `clickhouse-js-node-troubleshooting` so both shipped skills
are discoverable to downstream tooling. `tests/e2e/skills/check.js` is
extended to verify both skills land in the packaged `@clickhouse/client`
tarball.
- **New `Embedded docs` section** — surfaces `docs/` as the preferred
home for pages linked from log messages.
- **CHANGELOG guidance** — aligns with the PR template: entry goes in
the PR description and is folded into `CHANGELOG.md` at release time.

Documentation refresh plus a small manifest/test change to make the
second shipped skill discoverable.

## Checklist

- [x] A human-readable description of the changes was provided to
include in CHANGELOG

---------

Co-authored-by: copilot-swe-agent[bot] <198982749+Copilot@users.noreply.github.com>
Co-authored-by: peter-leonov-ch <209667683+peter-leonov-ch@users.noreply.github.com>
Co-authored-by: Peter Leonov <peter.leonov@clickhouse.com>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

4 participants