search

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
29.9k stars 3.78k forks source link

roachtest: sqlsmith/setup=seed/setting=no-ddl failed #45431

Closed cockroach-teamcity closed 4 years ago

cockroach-teamcity commented 4 years ago

(roachtest).sqlsmith/setup=seed/setting=no-ddl failed on master@8b5adba703fae9b6961623f65b685d93b0fe0290:

                                                                    'd036de86-a881-409a-ba68-b073f74667c8':::UUID
                                                                ),
                                                                (
                                                                    '29 years 11 mons 389 days 10:04:04.297665':::INTERVAL,
                                                                    '2a66d763-6d14-4990-aa27-94fbe67aba07':::UUID
                                                                )
                                                        )
                                                            AS tab_1121 (col_3023, col_3024)
                                                ),
                                            with_372 (col_3025)
                                                AS (
                                                    SELECT
                                                        *
                                                    FROM
                                                        (
                                                            VALUES
                                                                ('1988-07-24':::DATE),
                                                                ('1988-01-30':::DATE),
                                                                ('1983-09-13':::DATE)
                                                        )
                                                            AS tab_1122 (col_3025)
                                                )
                                        SELECT
                                            NULL AS col_3026
                                        FROM
                                            with_371 AS cte_ref_90, with_372 AS cte_ref_91
                                        WHERE
                                            true
                                        GROUP BY
                                            cte_ref_90.col_3023, cte_ref_90.col_3024, cte_ref_91.col_3025
                                        ORDER BY
                                            cte_ref_91.col_3025, cte_ref_90.col_3024 ASC
                                        LIMIT
                                            1:::INT8
                                    )
                                ),
                                ((-2080523139):::INT8, (-20586):::INT8)
                        )
                            AS tab_1123 (col_3027, col_3028)
                )
        SELECT
            757628778:::INT8 AS col_3029, NULL AS col_3030
        FROM
            with_373 AS cte_ref_92
        WHERE
            true
        ORDER BY
            cte_ref_92.col_3028 ASC, cte_ref_92.col_3027, cte_ref_92.col_3028 DESC
        LIMIT
            82:::INT8;
More

Artifacts: [/sqlsmith/setup=seed/setting=no-ddl](https://teamcity.cockroachdb.com/viewLog.html?buildId=1766891&tab=artifacts#/sqlsmith/setup=seed/setting=no-ddl) [See this test on roachdash](https://roachdash.crdb.dev/?filter=status%3Aopen+t%3A.%2Asqlsmith%2Fsetup%3Dseed%2Fsetting%3Dno-ddl.%2A&sort=title&restgroup=false&display=lastcommented+project) powered by [pkg/cmd/internal/issues](https://github.com/cockroachdb/cockroach/tree/master/pkg/cmd/internal/issues)

yuzefovich commented 4 years ago 
WITH
    with_373 (col_3027, col_3028)
        AS (
            SELECT
                *
            FROM
                (
                    VALUES
                        (
                            970117041:::INT8,
                            (
                                WITH
                                    with_370 (col_3022)
                                        AS (
                                            SELECT
                                                *
                                            FROM
                                                (
                                                    VALUES
                                                        (
                                                            ARRAY[
                                                                '106.40.89.69/12':::INET,
                                                                '251.249.251.199/19':::INET,
                                                                'ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff':::INET
                                                            ]
                                                        ),
                                                        (NULL),
                                                        (
                                                            ARRAY[
                                                                '4695:6ec8:448a:d7de:9be3:58eb:cc63:2163/36':::INET,
                                                                '9c32:f9cd:a72e:2d88:6b06:14d:5c42:7380/85':::INET,
                                                                '43.7.57.5/19':::INET,
                                                                '225.202.165.180/12':::INET
                                                            ]
                                                        ),
                                                        (
                                                            ARRAY[
                                                                '58ec:c67:f98f:ff8e:556:4f1c:ddb4:f024/77':::INET,
                                                                '2c7e:a7b9:53c5:cc06:2a5:66a1:5865:e54f/10':::INET,
                                                                '2ddc:3269:a6d4:3a5a:46da:fc56:3e61:67e3/52':::INET,
                                                                '139.38.45.199/26':::INET,
                                                                'ed9a:c21e:66c8:47dd:4f4b:4467:5718:42d6/72':::INET,
                                                                'f5f8:d0b5:ac8a:ef12:32ba:6d6a:b973:8370/83':::INET
                                                            ]
                                                        ),
                                                        (
                                                            ARRAY[
                                                                '3539:8c7:b3bd:9d91:fe92:e6db:b4d4:c071/75':::INET,
                                                                'ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff':::INET,
                                                                '118.254.61.232/19':::INET,
                                                                'c775:79a5:b9b3:fb28:8797:3a4f:97b:1d11/101':::INET,
                                                                '190.230.196.249/8':::INET,
                                                                '170.22.237.245/14':::INET,
                                                                '196.186.172.200/31':::INET
                                                            ]
                                                        ),
                                                        (
                                                            ARRAY[
                                                                '180.20.185.19/22':::INET,
                                                                '8e0:3c9:6e69:5b37:f1fa:ca32:8258:cf42/39':::INET,
                                                                'bb04:c811:544c:c378:4e8b:bf1:587d:d79b/99':::INET
                                                            ]
                                                        )
                                                )
                                                    AS tab_1120 (col_3022)
                                        ),
                                    with_371 (col_3023, col_3024)
                                        AS (
                                            SELECT
                                                *
                                            FROM
                                                (
                                                    VALUES
                                                        (
                                                            age(
                                                                '0001-01-01 00:00:00+00:00':::TIMESTAMPTZ::TIMESTAMPTZ,
                                                                '1970-01-06 10:58:56.000944+00:00':::TIMESTAMPTZ::TIMESTAMPTZ
                                                            )::INTERVAL,
                                                            '55f02bbc-5a6d-436b-8471-587601ce68ea':::UUID
                                                        ),
                                                        (
                                                            NULL,
                                                            'f60b4b6b-166e-40f0-ae65-b6e722a598ce':::UUID
                                                        ),
                                                        (
                                                            '75 years 5 mons 796 days 05:29:54.609723':::INTERVAL,
                                                            'd2abb251-8116-4541-be8c-f06e5dbd4982':::UUID
                                                        ),
                                                        (
                                                            '17 years 5 mons 876 days 08:19:09.454287':::INTERVAL,
                                                            '512f9af5-c179-4095-89c7-2e6878c614cf':::UUID
                                                        ),
                                                        (
                                                            '25 years 10 mons 517 days 23:29:23.944543':::INTERVAL,
                                                            'd036de86-a881-409a-ba68-b073f74667c8':::UUID
                                                        ),
                                                        (
                                                            '29 years 11 mons 389 days 10:04:04.297665':::INTERVAL,
                                                            '2a66d763-6d14-4990-aa27-94fbe67aba07':::UUID
                                                        )
                                                )
                                                    AS tab_1121 (col_3023, col_3024)
                                        ),
                                    with_372 (col_3025)
                                        AS (
                                            SELECT
                                                *
                                            FROM
                                                (
                                                    VALUES
                                                        ('1988-07-24':::DATE),
                                                        ('1988-01-30':::DATE),
                                                        ('1983-09-13':::DATE)
                                                )
                                                    AS tab_1122 (col_3025)
                                        )
                                SELECT
                                    NULL AS col_3026
                                FROM
                                    with_371 AS cte_ref_90,
                                    with_372 AS cte_ref_91
                                WHERE
                                    true
                                GROUP BY
                                    cte_ref_90.col_3023,
                                    cte_ref_90.col_3024,
                                    cte_ref_91.col_3025
                                ORDER BY
                                    cte_ref_91.col_3025,
                                    cte_ref_90.col_3024 ASC
                                LIMIT
                                    1:::INT8
                            )
                        ),
                        ((-2080523139):::INT8, (-20586):::INT8)
                )
                    AS tab_1123 (col_3027, col_3028)
        )
SELECT
    757628778:::INT8 AS col_3029, NULL AS col_3030
FROM
    with_373 AS cte_ref_92
WHERE
    true
ORDER BY
    cte_ref_92.col_3028 ASC,
    cte_ref_92.col_3027,
    cte_ref_92.col_3028 DESC
LIMIT
    82:::INT8;
ERROR: internal error: negative limit hint
SQLSTATE: XX000
DETAIL: stack trace:
github.com/cockroachdb/cockroach/pkg/sql/opt/xform/physical_props.go:130: BuildChildPhysicalProps()
github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:491: optimizeGroupMember()
github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:439: optimizeGroup()
github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:239: optimizeExpr()
github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:494: optimizeGroupMember()
github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:439: optimizeGroup()
github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:239: optimizeExpr()
github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:494: optimizeGroupMember()
github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:439: optimizeGroup()
github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:239: optimizeExpr()
github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:524: optimizeScalarExpr()
rytaft commented 4 years ago

Duplicate of #44128