Skip to content

[Chore] Improve skipped tests in test config and add verify_fetch_row config#18436

Merged
Mytherin merged 1 commit intoduckdb:v1.3-ossivalisfrom
taniabogatsch:verify-fetch-row
Jul 30, 2025
Merged

[Chore] Improve skipped tests in test config and add verify_fetch_row config#18436
Mytherin merged 1 commit intoduckdb:v1.3-ossivalisfrom
taniabogatsch:verify-fetch-row

Conversation

@taniabogatsch
Copy link
Contributor

New verify_fetch_row.json config:

  "description": "Run on persistent databases as storage with row verification enabled.",
  "initial_db": "{TEST_DIR}/{BASE_TEST_NAME}__test__config__verify_fetch_row.db",
  "on_init": "PRAGMA verify_fetch_row;",
  "skip_compiled": "true",
  "skip_tests": [

Close https://github.com/duckdblabs/duckdb-internal/issues/5207.

New structure of skipped tests:

LogicalType::LIST(
         LogicalType::STRUCT(
{{"reason", LogicalType::VARCHAR}, 
{"paths", LogicalType::LIST(LogicalType::VARCHAR)}})),

Example:

    {
      "reason": "Contains FIRST (non-deterministic).",
      "paths": [
        "test/sql/parallelism/intraquery/test_parallel_nested_aggregates.test"
      ]
    },
    {
      "reason": "FIXME: Unexpected parsed statement verifier failure.",
      "paths": [
        "test/sql/types/decimal/large_decimal_constants.test",
        "test/sql/types/uhugeint/test_uhugeint_conversion.test",
        "test/sql/types/hugeint/test_hugeint_conversion.test"
      ]
    },

There are a bunch of FIXME in the new verify_fetch_row.json - I'll open the respective internal issues once we've merged this PR.

@taniabogatsch
Copy link
Contributor Author

I don't think the LinuxRelease failure is related: https://github.com/duckdb/duckdb/actions/runs/16595451659/job/46940850719?pr=18436#step:3:4040

@Mytherin
Copy link
Collaborator

Looks great, thanks!

@Mytherin Mytherin merged commit 3ac7e19 into duckdb:v1.3-ossivalis Jul 30, 2025
32 of 33 checks passed
@taniabogatsch taniabogatsch deleted the verify-fetch-row branch July 30, 2025 13:14
github-actions bot pushed a commit to duckdb/duckdb-r that referenced this pull request Aug 1, 2025
[Fix] Rework transaction logic in commit, rollback and checkpoint paths (duckdb/duckdb#18474)
[Chore] Improve skipped tests in test config and add verify_fetch_row config (duckdb/duckdb#18436)
github-actions bot added a commit to duckdb/duckdb-r that referenced this pull request Aug 1, 2025
[Fix] Rework transaction logic in commit, rollback and checkpoint paths (duckdb/duckdb#18474)
[Chore] Improve skipped tests in test config and add verify_fetch_row config (duckdb/duckdb#18436)

Co-authored-by: krlmlr <krlmlr@users.noreply.github.com>
Mytherin added a commit that referenced this pull request Aug 6, 2025
Looks like I didn't actually add the `verify_fetch_row.json` config to
`Main.yml` in #18436.
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.

2 participants