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.99k stars 3.79k forks source link

pkg/ccl/testccl/sqlccl/sqlccl_test: TestExplainGist failed #125722

Closed cockroach-teamcity closed 2 months ago

cockroach-teamcity commented 3 months ago

pkg/ccl/testccl/sqlccl/sqlccl_test.TestExplainGist failed with artifacts on master @ 7426c8ed49d6f78c31f866a5e01ee09cc3b5892a:

github.com/cockroachdb/cockroach/pkg/sql/colflow.(*FlowCoordinator).next(0x4006159700)
    github.com/cockroachdb/cockroach/pkg/sql/colflow/flow_coordinator.go:128 +0x38
github.com/cockroachdb/cockroach/pkg/sql/colflow.(*FlowCoordinator).nextAdapter(...)
    github.com/cockroachdb/cockroach/pkg/sql/colflow/flow_coordinator.go:145
github.com/cockroachdb/cockroach/pkg/sql/colexecerror.CatchVectorizedRuntimeError(0x4004a34980?)
    github.com/cockroachdb/cockroach/pkg/sql/colexecerror/error.go:152 +0x58
github.com/cockroachdb/cockroach/pkg/sql/colflow.(*FlowCoordinator).Next(0x4006159700)
    github.com/cockroachdb/cockroach/pkg/sql/colflow/flow_coordinator.go:150 +0x38
github.com/cockroachdb/cockroach/pkg/sql/execinfra.Run({0x7810070, 0x40091ae6f0}, {0x7840020, 0x4006159700}, {0x77d8108, 0x4009d5bc08})
    github.com/cockroachdb/cockroach/pkg/sql/execinfra/base.go:198 +0x48
github.com/cockroachdb/cockroach/pkg/sql/execinfra.(*ProcessorBaseNoHelper).Run(0x4006159700, {0x7810038?, 0x4009d51e50?}, {0x77d8108, 0x4009d5bc08})
    github.com/cockroachdb/cockroach/pkg/sql/execinfra/processorsbase.go:723 +0x6c
github.com/cockroachdb/cockroach/pkg/sql/flowinfra.(*FlowBase).Run(0x40077a0288, {0x7810038, 0x4009d51e50}, 0x0?)
    github.com/cockroachdb/cockroach/pkg/sql/flowinfra/flow.go:579 +0x180
github.com/cockroachdb/cockroach/pkg/sql/colflow.(*vectorizedFlow).Run(0x788ea80?, {0x7810038?, 0x4009d51e50?}, 0xe0?)
    github.com/cockroachdb/cockroach/pkg/sql/colflow/vectorized_flow.go:305 +0x1d0
github.com/cockroachdb/cockroach/pkg/sql.(*DistSQLPlanner).Run(0x4001860500, {0x7810070, 0x4009903f50}, 0x40047f3d40, 0x4006eddae0, 0x4008e52f80, 0x4009d5bc08, 0x40076e2808, 0x4004a35828)
    github.com/cockroachdb/cockroach/pkg/sql/distsql_running.go:932 +0xa0c
github.com/cockroachdb/cockroach/pkg/sql.(*DistSQLPlanner).planAndRunSubquery(0x4001860500, {0x7810070, 0x4009903f50}, 0x0, {{0x77be160, 0x40057bd3b0}, 0x3, 0x1, 0x0, {{0x7811490, ...}, ...}, ...}, ...)
    github.com/cockroachdb/cockroach/pkg/sql/distsql_running.go:1853 +0x56c
github.com/cockroachdb/cockroach/pkg/sql.(*DistSQLPlanner).PlanAndRunSubqueries(0x4001860500, {0x7810070, 0x4009903f50}, 0x40094939b8, 0x4004a35ae8, {0x4009d51e00, 0x1, 0x1}, 0x4008946c08, 0x4004a35a60, ...)
    github.com/cockroachdb/cockroach/pkg/sql/distsql_running.go:1768 +0x154
github.com/cockroachdb/cockroach/pkg/sql.(*DistSQLPlanner).PlanAndRunAll(0x4001860500, {0x7810070, 0x4009903f50}, 0x4009493eb8, 0x40047f3ba0, 0x40094939b8, 0x4008946c08, 0x40091ae1e0)
    github.com/cockroachdb/cockroach/pkg/sql/distsql_running.go:1689 +0x118
github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execWithDistSQLEngine(0x4009493308, {0x7810070, 0x4009903f50}, 0x40094939b8, 0x3?, {0xffff5195d6e0?, 0x40043ba738?}, 0x1, 0x400708c518, {0x0, ...})
    github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:2419 +0x360
github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).dispatchToExecutionEngine(0x4009493308, {0x7810070, 0x40096ce390}, 0x40094939b8, {0xffff5195d6e0, 0x40043ba738})
    github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:1966 +0xd64
github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execStmtInOpenState(0x4009493308, {0x7810070, 0x40096ce2d0}, {{0x7836560, 0x40057bd900}, {0x0, 0x0, 0x0}, {0x400728c601, 0x594}, ...}, ...)
    github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:1173 +0x3e18
github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execStmt.func1({0x7810070?, 0x40096ce2d0?})
    github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:145 +0x8c
github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execWithProfiling(0x7810070?, {0x7810070?, 0x40096ce2d0?}, {0x7836560?, 0x40057bd900?}, 0x0?, 0x6?)
    github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:3423 +0x25c
github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execStmt(0x4009493308, {0x7810070, 0x40096ce2d0}, {{0x7836560, 0x40057bd900}, {0x0, 0x0, 0x0}, {0x400728c601, 0x594}, ...}, ...)
    github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:144 +0x544
github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execCmd.func1(0x4004a377f8, 0x4004a378a8, 0x4009493308, 0x4004a374d0, 0x4004a37930, 0x4004a37920, 0x4004a37950, 0x4004a37968)
    github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:2312 +0x360
github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execCmd(0x4009493308)
    github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:2317 +0x764
github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).run(0x4009493308, {0x7810070, 0x40094a71a0}, 0x6dcea8?, 0x4006afbc88?, 0x40094de0f0?)
    github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:2234 +0x168
github.com/cockroachdb/cockroach/pkg/sql.(*Server).ServeConn(0x40019f4f80?, {0x7810070?, 0x40094a71a0?}, {0x400469e240?}, 0x2?, 0x40094a7020?)
    github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:963 +0xb4
github.com/cockroachdb/cockroach/pkg/sql/pgwire.(*conn).processCommands(0x40043ba008, {0x7810070, 0x40094a71a0}, {0x0, 0x4, {0x1, {0x5f2b8c8, 0x3}, {0x400877d8c0, 0xf}, ...}, ...}, ...)
    github.com/cockroachdb/cockroach/pkg/sql/pgwire/conn.go:253 +0x344
github.com/cockroachdb/cockroach/pkg/sql/pgwire.(*Server).serveImpl.func4()
    github.com/cockroachdb/cockroach/pkg/sql/pgwire/server.go:1035 +0xcc
created by github.com/cockroachdb/cockroach/pkg/sql/pgwire.(*Server).serveImpl in goroutine 2195
    github.com/cockroachdb/cockroach/pkg/sql/pgwire/server.go:1032 +0x46c
Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

This test on roachdash | Improve this report!

Jira issue: CRDB-39569

yuzefovich commented 3 months ago 
      * ERROR: a SQL panic has occurred while executing the following statement:
      * WITH with_107 (col_1129) AS (SELECT * FROM (VALUES ('010200000002000000E15364697C900042A0B9A7DE21BAEA41E9D1701ED25DD0C18440FADA827FE741':::GEOMETRY), (NULL)) AS tab_798 (col_1129)), with_108 (col_1130) AS (SELECT * FROM (VALUES (public.func_1('BOX(-0.5596217560286105 0.15490656426479232,-0.2935461238263386 1.8165943734794179)', ARRAY[30027, -16403, 24797]::INT2VECTOR, 3978647253)::RECORD), ((1912076288,)), ((1516956368,)), ((-835879205,)), (NULL)) AS tab_799 (col_1130)), with_109 (col_1131) AS (SELECT * FROM (VALUES ((-0.3288376992998558):::FLOAT8), ((-0.16636185560939765):::FLOAT8)) AS tab_800 (col_1131)) SELECT tab_801._date AS col_1133, CASE WHEN (false AND tab_801._bool) THEN '-59 years -4 mons -525 days -00:14:41.029074':::INTERVAL ELSE '32 years 8 mons 222 days 18:45:07.094994':::INTERVAL END AS col_1134, tab_801._jsonb AS col_1135, (-1.845666716481748214E+30):::DECIMAL AS col_1136, tab_801._uuid AS col_1137 FROM defaultdb.public.seed AS tab_801 WHERE tab_801._interval::INTERVAL NOT IN (SELECT tab_802._interval::INTERVAL AS col_1132 FROM defaultdb.public.seed AS tab_802 WHERE false LIMIT 23:::INT8) ORDER BY tab_801._decimal DESC
      *
      *
      * ERROR: a panic has occurred!
      * invalid datum type given: RECORD, expected RECORD
cockroach-teamcity commented 3 months ago

pkg/ccl/testccl/sqlccl/sqlccl_test.TestExplainGist failed on master @ 3afb6935d0ef3de7c0d44cfb3cd54f312752c186:

            _inet = 'c5e2:c1e0:a310:e721:643:4a41:6e52:2584/93':::INET
        FROM
            defaultdb.public.seed AS tab_607
        WHERE
            false
        LIMIT
            10:::INT8;
        SELECT
            '1985-06-14':::DATE AS col_913,
            (('bda:3bff:367f:f552:edb3:212d:a8a4:ac6/8':::INET::INET << tab_608._inet::INET)::BOOL OR false) AS col_914,
            tab_608._enum AS col_915
        FROM
            defaultdb.public.seed@seed__int8__float8__date_idx AS tab_608
        ORDER BY
            tab_608._string NULLS FIRST, tab_608._decimal NULLS LAST, tab_608._string DESC NULLS FIRST
        LIMIT
            1:::INT8;
        SELECT
            NULL AS col_933
        FROM
            defaultdb.public.seed@seed__int8__float8__date_idx AS tab_611,
            defaultdb.public.seed AS tab_612
            JOIN defaultdb.public.seed AS tab_613 ON (tab_612._jsonb) = (tab_613._jsonb)
        WHERE
            true
        LIMIT
            16:::INT8;
        UPDATE
            defaultdb.public.seed AS tab_614
        SET
            _int2 = tab_614._int2, _enum = 'hello':::greeting, _uuid = NULL
        ORDER BY
            tab_614._uuid DESC NULLS LAST, tab_614._enum NULLS LAST
        LIMIT
            3:::INT8;
        DELETE FROM defaultdb.public.seed AS tab_615 LIMIT 26:::INT8;
        ALTER TABLE defaultdb.public.seed
            ADD COLUMN
                col_934
                    BYTES[]
                    DEFAULT (
                        '[-0.05059449,1.4889848e+29,1.7521194e+11,-2.1909734e+16,2.0294575e+27,4.178061e+34,-0.00061084767,1.5994598e+19,-4.015839e+31,1.0153067e-16,-1.1350948e+18,2.5397457e+27,1.8793912e+29,6.257463e-30,-2.1160562,-4.854124e-25,1050.0193,-8.40636e+23,2.9316388e+07,2119.2244,-1.3184736e-06,-3.3530616e-13,3.008979e+27,-9.9434946e+26,-2.2018992e-29,4.6338718e+14,-2.5688033e-07,-1.1149317e-28,0.81565464,-1.9286249e-25,-7.7852815e+21,-1.9766506e-10,0.14265588,8.71929e+17,-2.7255917e-23,3.0433372e+12,1.1984925e+32,-2.9434717e+27,-1.1670306e+13,-1.4309546e-11,1.7116978e+33,-2.5483365e+20,-1.0345905e-18,-2.4532534e+18,-2.5733282e+07,-201.76825,-7.4524475e-20,-2.3444924e-12,1964.964,6.976529e-34,8.565431e+27,5.6618668e-36,3.1489802e-07,2.2389921e+32,1.5801992e+09,-2.7571702e-25,-1.9248519e+25,-1.8537829e-31,1.2306375e-11,-3.6809076e-13,-0.0020817055,0.16990873,-2.6392246e-31,6.466751e-25,-4.1013046e+19,2.1082478e+07,3.4638397e-09,3.3259917e+32,8.5989933e-19,1.7593929e+36,-2.8425138e+38,1.1273173e-07,1.9278376e+38,-1.9412821e+17,1.0374714,-4.663037e-30,2.693602e+20,-3.5164707,2.0662153e-17,113251.13,1.5189413e+38,4.4318101e-38,2.022431e-30,0.050517395,8.478e-37,1.7683505e+23,-4.165854e+13,2.732489e+14,-7.325587e-36,2.2448116e+17,-3.4977617e+21,9.130264e+18,8.7017376e-35,-8.60207e+18,50276.465,-2.9815744e+23,-0.00069128856,-3.271926e-16,-7.098398e+14,-1.1608373e+15,1.961014e+12,4.3845874e+33,-1.7869731e-10,1.9475425e+18,-1.3943909e-12,2.2595153e+12,2.7958784e-36,1.1533389e-36,-1.2130234e-06,1.9711416e-15,5.447838e+30,-3.4079758e-38,-1.9748404e-33,-1.2638011e+35,-1.3243216e+34,-1.1843649e+13,-5.637941e-10,1.49021e+22,-1.2289799e+15,-1.9575336e+11,-1.0968992e-28,-3.8467315e-05,211920.69,1.2294807e-17,6.4545075e+06,4.982344e-14,-7.5804457e-10,6.785792e+36,1.6879333e+18,1.2246843e+32,0.00016464244,2.7335893e+14,-2.6033509e-31,-1.1144732e-27,1.8791571e+35,9.562343e-33,1.3157356e-10,3.0264725e+37,2.2512268e-08,2.5244445e+10,-1.1279916e+17,2.0975213,-7.91849e-17,-4.3177525e+10,4.7174926e-37,3.6946866e-18,-2.026333e+27,3.6372643e-16,1.7361923e+11,1.573155e-09,-4.936279e+15,-589595.56,3.544707e-15,5.422306e+27,-1.3270575e+13,-1.046112e+28,6.28725e-23,8.217887e+19,-4.514497e-39,-6.372066e+23,-7.639512e+28,-1.0659122e-18,1.3963397e-30,1.3179503e+25,6.5144475e+24,-3.7075009e+15,-28074.201,2.7273635e-17,359.57925,2.1621753e-20,-8.345701e+20,-1.3180423e-14,7.530524e-17,3.1233534e+27,9.124585e-36,6.0851074e-37,-1.4531813e-08,1.05980097e+37,13164.618,3.6183975e-33,-1.0303821e+07,4.9667535e+18,5.6265666e-27,1.5577299e-28,1.8163094e+31,5.2155142e-14,2.2847589e-17,3.303259e-07,8.358873e-22,-1.1361692e-10,-2.1897295e+21,-7.627838e-39,-337.73605,8.75374e-06,5.1009563e-34,5.3651077e-27,-5.6104875e-15,-9.174944e+24,-3.9183393e+26,5.6775508e-11,-1.0979178e-36,-1.521942e-08,-1.8685512e-22,4.274537e+24,3.6866934e+09,0.016177183,5.194302e-19,-5.307365e+25,7.918325e+34,6.754819e+21,-6.925983e-25,7.9686313,4.6950544e-38,7.955457e+14,9.369944e+22,646774.06,-1.7064054e+37,4.3010956e+11,-2.8598729e+10,1.4500317e+26,-8.982071e+28,9.721625e-28,9.401669e+19,-1.3758369e+25,-3.5307134e+24,-4.7228047e+11,-1.3555838e-17,1.5330308e+32,-1.3642542,-1.3898202e+19,-0.00020378352,-1.8916708e-36,-3.9861297e-29,49.198643,-3.3163555e-37,1.3911186e+21,1.2700712e-13,-5.2355432e+16,-3067.1665,5.7900147e+25,-2.1862476e-07,7.102847e-38,3.771135e-17,10625.622,35762.375,-2.5833877e-08,3.2086726e+30,-2.6439168e-37,1.6702728e-06,-0.1079411,-6.045514e-24,0.43325746,1.7667013e+09,-3.1854235e+24,451169.5,5.9963225e-32,-4.1412265e+19,4.948104e+25,-1.6699074e-12,-2.613687e+16,-1.18867185e+30,-5.835021e-33,-7.603121e-33,8.259658e-08,-1.1118832e-13,1.1931302e-26,-3.684982e-33,-3.2250476e+17,3.4398024e-28,6.0258678e+19,-3.9942306e-21,-7.1201645e-23,1.1914804e+30,3.3056684e+37,8.402584e+31,2.978562e+12,-1.04167865e+21,-8.788149e+20,3.3102495e-34,1.2688704e+18,-0.011908581,-2.5156846e+34,2.117552e+11,-2.237535e+32,239166.44,-2.773118e-09,-5.3724825e-08,232793.6,-4.1289716e+17,2.1552105e+32,6.5521644e+07,-4.156949e-24,3.970519e+18,-0.00010598302,3.098814e+16,-2.1573737e+26,2.7092612e-25,1.8580318e-13,6.068296e-08,-4.1640624e+08,-4.539418e+21,2.2358061e-24,2.19679e+24,-6.428842e+22,-2.4271308e-23,-2.1271288e+33,1.2751931e+37,0.03573939,-1.3165552e+28,-3.9220192,-11284.309,3.7480899e-35,-146.49388,1.10459405e+18,2.2498353e-20,-8.099803e-30,-9.3843004e+23,-3.6225108e+06,2.151231e+15,-371036.28,-4.5492114e+23,-6.7335286e-08,-1.5343959e+35,-4.932793e-21,1.9298727e-35,-6.693761e+19,3.935547e+13,9.741451e-28,-120.07686,3.145424e+09,1.0396184e+35,-5.8653005e+34,2.2977188e+25,-0.31106246,2.9054622e-30,1.0622424e-21,-1.994174e+26,1.7683473e-13,-6.941236e+29,1.02223245e-17,-6.311441e-15,-1.6894968e-18,7.9480147e-22,8.584993e+12,-204.42073,2.2839927e-29,1.9488932e-29,-4.1003656e-19,-2.335625,-1.4581444e-34,1.2305108e-05,-16645.512,1.1535051e+34,-3.0266168e-14,9.287097e-07,-7.563447e-38,1.6071832e-15,-3.8686795e+27,-1.9598716e+26,8.527951e-13,-4.5983544e-08,1.1400138e-32,1.6355865e-26,4.9326785e+30,8.779688e-36,-1.2197187e-17,1.4742933e+35,8.106499e+33,-7.0287196e-19,-241.27771,-4.2037673e+23,-2.996795e+14,-8.718204e+07,-1.4194029e+38,6.4042176e+35,-9.387804e-15,-2.8187978e+33,1.8856331,2.5983465e-12,4.9425557e-17,7.815632e+12,4.3372296e+07,5.753544e+06,1.9892022e-08,-6.439198,-40957.36,-3.0289956e+09,1.0317352e-11,1.3586583e-06,9.4077344e-30,-1.4504105e+16,2.54983e-38,-1.2904045e+28,1.1550077e-14,2.8589655e+27,3.1917105e-35,-1.3234207e+22,-1.12586794e-10,-0.38221458,2.2277828e-10,3.137163e-17,-189672.72,1.3505199e+12,-3.350461e+13,1.9759789e+22,5.4118884e+21,3.529087e+34,-2.9387581e-34,-1.3210476e-26,1.9760957,2.173598e+15,-5.0851033e+28,-2.180251e-23,7.4515314,19353.393,-2.6125439e-37,0.04637184,1.9560104e+12,7.1204216e-09,-1.99691e+35,-4.718568e+30,1.8060537e-35,-1.4163442e+20,896055.5,-1.3664198e-12,-3.144065e+35,-263.81555,-7.991007e-15,-2.0204735e+34,-5.3612247e+34,4.9564445e+08,-1.872819e+20,-1.746476e+38,-0.00046966982,7.64247e-09,5.123508e+14,1.2397488e-31,1.6786196e+09,1.8135407e+11,-1.1196738e+14,207216.27,-0.26272032,-5.0217956e+07,3.2941808e+35,-4.0966344e-24,-3.7531003e+09,4.7184765e+21,-175.6542,-6.8515e-32,-3.149266e+22,5.4864583e+11,-1.6704699e+31,5.3555222e+08,1.2909342e-08,1.8018337e-30,-2.8951785e+38,3.3736828e+07,2.9726103e-36,-1.3384834e+34,0.7106861,4.0104256e+09,3.1795812e-12,5.4443644e+33,-2.4501767e+30,-2.1279926e+23,6.186668e+07,2.8142752e-19,-29131.45,2.6564949e-37,2.7126832e+18,1.1404965e-22,-1.8793863e-35,-1.1236828e-27,1.3330125e-18,4.3197816e-35,-2.5592266e+19,-2.3684677e-16,-5.1620167e-33,-5.6025064e+23,1.4681189e+07,-0.59777915,1.8097341e+30,3.234874e-33,7.603483e+17,-0.020206282,-3.5154127e-25,1.6019801e-34,1.3896313e-13,-1.7699559e+18,1.908324e+32,-4.879767e-26,4.1254817e-09,1.0703574e+12,-1.4648726e+33,1.5927514e+38,-917.88806,2.3313446e+09,6.8967643e+24,0.021937601,9.093724e+35,-4587.152,4.0006555e+18,2.6063058e+22,-2.5568037,5.960125e-38,2.2789802e+37,6.17431e+13,-5.31293e-07,-1.4003165e-12,-3.6052826e+26,-1.3242328e+23,-1.2484668e+25,7.4544646e+08,1.0470422e+22,-3.968232e+10,-1.910824e-36,-1.5311186e-07,8.256027e+33,1.9889666e-27,6.3268885e+24,5.5109154e+33,-1.30749815e+20,-1.555298e+37,7.32902e-10,7.380203,-8.8414236e-16,3.250976e+17,-8.7201183e+15,2.3846419e+11,-4.4550067e+33,4.9889935e+06,9.9936516e+33,-1.21892955e-17,-3.922599e+23,-4.9532064e-06,4.2151493e-16,1.0064592e+10,1.234954e+33,-1.6296159e-23,89806.64,7.167628e+30,-4.7306546e+17,1.762817e-16,8.597226e-15,2.894317e+12,-5.224892e-27,-1.4109753e-13,0.00010753154,-3.472127e+37,-1.1993722e-09,7.5609586e+12,1.6732387e-34,3.988982e+07,3.109197e+10,-101006.65,-0.12180817,0.000857961,3.1919876e-09,1.5667541e-36,2.651759e-31,-2.0080531e-33,-0.02834813,2.1918535e-18,-0.055387847,-6.0899446e-29,-3.1372627e-24,-1.4170569e+16,-0.305375,1.4364857e+33,1.6329538e+07,1.6660988e+34,-4.79494e+20,-3.0910256e-24,-37.815704,-8.4243754e-38,4.8145084e-23,3.6537786e-09,8.831586e-10,1.6855632e-21,8.016422e-06,0.00023882739,-5.4566565e+34,-8.963174e-26,315172.72,-6.322398e+29,-4.483078e-20,5.997262e+33,-4.1506854e+22,9.343814e+07,2.301888e-31,-2.954412e+34,1.5924669e+32,6.9714305e-21,-1.831399e+34,-9.2552715e-14,7.624372e-31,1.1807716e+30,1.5958524e+19,7.1344e+27,2.3320285e+16,1.2949111e+06,-1.8922066e+12,-4.4143564e+29,-5.9212035e-37,1.6048643e-15,6.540288e-11,8.237505e+19,-3.8171405e+33,5.427084e+14,-1.08336e-17,-6.121581e-13,-2.2707353e-37,-3.7194792e-22,-29112.256,-1.5333871e+35,-31.644745,5.3140507e-08,2.429473e-20,-6.880969e+09,3.248947e-05,3.5907216e-36,1.8865606e+28,-5.116684e-37,5.1805435e-32,2.1730446e-11,1.6927953e+12,-4.034836e-18,1.2033029e+28,-5.9282365e-06,2475.6824,-7.285684e-20,-0.015464774,-5.9542105e+30,-1.8541122e-25,-1.4839195e+28,-502.63138,-1.0122039e-09,1.1636688e+21,0.055859353,-6.220002e+08,-1.2856144e+27,-2.8549999e-30,-4.009319e-24,-8.773277e-27,7.4266406e+08,-2.98586e-11,-2.0180273e-19,2.241811e+15,3.7624663e+31,-0.00081156055,-2.324967e+19,-9.6678466e+14,1.643804e+25,9.1558086e+17,-0.0004992042,5.3825807e+09,1.0008147e+24,1.8975114e-06,8.9004353e-26,1.3175566e+23,2.9122058e-25,-41.747704,0.018470163,-7.397734e-36,-0.008987586,3.023607e-12,-4.682004e-07,-2.5853976e-36,-2.1722064e+23,3.8599593e-10,-6.61818e+19,1.8522248e-07,3.2580655e+10,-7.88162e-20,-73254.01,-2.1563007e-34,9.126806e+12,5.5724387,-8.2120655e-18,2.2667602e-34,-1.3067486e+25,7.830047e+12,6.9180813e+21,-3.5965544e-19,1.0588523e+28,-1.6225282e-22,2.458334e+09,-1.3525099e-36,-3.649604e-35,-1.1477591e-17,1.1158295e-13,-2.8548813e-33,2.4143347e+38,1.5234227e+09,-9.5832536e+24,1.8993146,1.3025523e+10,-1.6857848e-32,22.825302,-1.1409271e-13,9.092877e+20,-9.6168034e-21,-5.3312455e+10,8.337554e-16,5.0192034e-07,1.1133375e+33,1.4108317e+25,-2.1646077e-29,1.0181736e-36,4.7399397e+19,7.8148685e+11,3.259084e+13,-1.8371579e-31,6.697112e+28,2.0959936e-09,2.6121514e+08,9.51197e-37,-7.106067e-28,-67039.98,8.208128e-05,1.6053905e+31,-1.5587908e+29,-0.05496128,1.5767999e-16,-2.6083214e-36,3.0227097e-35,4.484447e+35,3.564947e-09,2.6015328e+06,2.853236e+32,-3.8231056e-07,1.2698235e+32,-1.5970136e-21,-705.04443,8.286764e+22,-2.1376896e+09,1.0658531e+38,3.713195e+34,-16177.131,4.2051266e-13,-6.192628e+32,-9.820968e-39,-8.518241e-29,4.7864597e+26,3.325538e+20,-3.957727e+11,-16083.576,-2.958298e+14,-1.9379226e+21,-148318.98,1.703111e+33,2.9420411e-31,-3.433466e-21,-1.4932296e+29,1.2781744e+07,-3.2280042e+11,-3.9556397e-36,1.5782327e-13,7.481113e+26,-2.7906882e+32,1443.7996,0.20611544,-2.5314825e+32,5.1625575e+36,4.492542e-19,-1.9079776e+32,2.8566473e-36,-2.9860442e+24,8.293911e-12,1.2307156e-14,2.6536423e-10,1.0103496e+20,-0.44321948,-1.6200682e+22,4.5952983,4.8702165e-31,-3.088391e+22,3.0286765e+28,-2.9860437e-37,6.1813867e+15,1.2870576e+24,2.1784224e-14,6.6009864e-09,-7.6330183e+28,-1.8110224e-07,-5.3314406e-12,9.605423e+33,-1.0020912e+21,-5.508922e+33,-1.290628e+18,-2.6181688e-22,105945.37,-7.7160765e-36,8.999801e-16,-416.45148,2.363899e+37,-3.8398182e+31,1.03452415e+34,-7.6554464e-11,2.833721e+29,-7.125692e-38,0.0031882606,-2.3400388e+21,4.7364566e+34,-1.8397719e+36,3.127927e+13,-9.993357e-38,2.8903755e-20,2.620625e+32,-2.3804125e-31,-9.102895e-25,-1.2061322e-36,-10.212865,-6.4878367e+13,5.337825e+31,2.3875715e+23,6.861043e-14,-3.1456803e-12,-7.7142065e+34,-1.4955546e+31,2.606378e-06,2.056973e+10,-4.590261e-38,-1.593285,-2.4290697e+33,6.4207966e+18,-4.038046e-09]':::VECTOR
                    );

    explain_test.go:204: pq: internal error: cannot append FLOAT8 to array containing BYTES: INSERT
        INTO
            defaultdb.public.seed AS tab_617 (_date, _timestamp, _timestamptz, _interval, _decimal, _uuid)
        VALUES
            (NULL, NULL, '1972-08-04 21:57:26.000918+00':::TIMESTAMPTZ, NULL, 1:::DECIMAL, NULL)
    --- FAIL: TestExplainGist/main (11.19s)

Parameters:

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

Same failure on other branches

- #126964 pkg/ccl/testccl/sqlccl/sqlccl_test: TestExplainGist failed [failed to construct index entries during backfill] [C-test-failure O-robot T-sql-foundations branch-release-24.2 release-blocker]

This test on roachdash | Improve this report!

DrewKimball commented 2 months ago

Dupe of #117101