cockroachdb / cockroach

CockroachDB — the cloud native, distributed SQL database designed for high availability, effortless scale, and control over data placement.
https://www.cockroachlabs.com
Other
30.07k stars 3.8k forks source link

release-22.1: sql: internal error: comparison overload not found (is, void, unknown) #93710

Closed cockroach-teamcity closed 1 year ago

cockroach-teamcity commented 1 year ago

roachtest.sqlsmith/setup=seed-multi-region/setting=multi-region failed with artifacts on release-22.1 @ 7ce174a7b4295b860d6648a0e05bc77eab27e6ac:

The test failed on branch=release-22.1, cloud=gce:
test artifacts and logs in: /artifacts/sqlsmith/setup=seed-multi-region/setting=multi-region/run_1
    sqlsmith.go:265,sqlsmith.go:324,test_runner.go:883: error: pq: internal error: comparison overload not found (is, void, unknown)
        stmt:
        SELECT
            *
        FROM
            (SELECT COALESCE(NULL::FLOAT4[], NULL::FLOAT4[]) AS col_6905, NULL::VOID AS col_6906) AS tab_3279
        ORDER BY
            col_6905 ASC NULLS FIRST, col_6906 NULLS LAST;
Help

See: [roachtest README](https://github.com/cockroachdb/cockroach/blob/master/pkg/cmd/roachtest/README.md) See: [How To Investigate \(internal\)](https://cockroachlabs.atlassian.net/l/c/SSSBr8c7)

Same failure on other branches

- #90060 roachtest: sqlsmith/setup=seed-multi-region/setting=multi-region failed [C-test-failure O-roachtest O-robot T-sql-queries T-sql-schema branch-release-22.2.0]

/cc @cockroachdb/sql-queries

This test on roachdash | Improve this report!

Jira issue: CRDB-22495

rytaft commented 1 year ago

will be fixed when backport PR #93712 is merged.

rytaft commented 1 year ago

The backport has been merged