sql: TestExplainRedact failed

[cockroach-teamcity]

sql.TestExplainRedact failed with artifacts on release-23.1.17-rc @ d50ccb5a52cdf5a1f41cbb2fa61ef971c65e1346:

            defaultdb.public.seed@seed__int8__float8__date_idx AS "%vtab18"
            JOIN defaultdb.public.seed AS "tab%0319"
                JOIN defaultdb.public.seed AS "
taB}20" ON ("tab%0319"._int8) = ("
taB}20"._int8) ON
                    ("%vtab18"._float4) = ("
taB}20"._float8)
        WHERE
            "%vtab18"._bool
        ORDER BY
            "%vtab18"._int2 NULLS LAST, "%vtab18"._date NULLS FIRST
        LIMIT
            16:::INT8
    explain_test_util.go:39: WITH
            with9 ("co  l39", col40)
                AS (
                    SELECT
                        *
                    FROM
                        (
                            VALUES
                                (
                                    CASE
                                    WHEN (e'pterodactylj7\x18!!\x13h':::STRING::STRING % NULL::STRING)::BOOL THEN 3275:::INT8
                                    ELSE 0:::INT8
                                    END,
                                    ARRAY[(-128):::INT8]
                                ),
                                ((-12021):::INT8, ARRAY[(-25699):::INT8,7249:::INT8,1:::INT8,(-255):::INT8]),
                                (int2('80 years 2 mons 303 days 17:45:00.078716':::INTERVAL::INTERVAL)::INT2, NULL)
                        )
                            AS "Ta\\uA7B7b21" ("co  l39", col40)
                )
        SELECT
            count(*) AS col41
        FROM
            defaultdb.public.seed@seed__int8__float8__date_idx AS "ta?b22"
        GROUP BY
            "ta?b22"._int8
        HAVING
            bool_and(NULL::BOOL)::BOOL
        ORDER BY
            "ta?b22"._int8 DESC NULLS FIRST, "ta?b22"._int8 ASC, "ta?b22"._int8 ASC NULLS LAST
        LIMIT
            13:::INT8
=== CONT  TestExplainRedact
    explain_test.go:557: -- test log scope end --
    explain_test.go:557: Leaked goroutine: goroutine 1020287 [select]:
        github.com/cockroachdb/pebble/vfs.(*diskHealthCheckingFile).startTicker.func1()
            github.com/cockroachdb/pebble/vfs/external/com_github_cockroachdb_pebble/vfs/disk_health.go:172 +0xdc
        created by github.com/cockroachdb/pebble/vfs.(*diskHealthCheckingFile).startTicker
            github.com/cockroachdb/pebble/vfs/external/com_github_cockroachdb_pebble/vfs/disk_health.go:167 +0x5d
--- FAIL: TestExplainRedact (75.25s)

Parameters:

• TAGS=bazel,gss
  Help

See also: How To Investigate a Go Test Failure (internal)

/cc @cockroachdb/sql-queries

This test on roachdash | Improve this report!

Jira issue: CRDB-36754

[yuzefovich]

120060 is not present on this branch. Unactionable.