Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

sql/tests: TestRandomSyntaxSQLSmith failed #115065

Closed
cockroach-teamcity opened this issue Nov 25, 2023 · 4 comments
Closed

sql/tests: TestRandomSyntaxSQLSmith failed #115065

cockroach-teamcity opened this issue Nov 25, 2023 · 4 comments
Labels
branch-release-22.2 Used to mark GA and release blockers, technical advisories, and bugs for 22.2 C-test-failure Broken test (automatically or manually discovered). O-robot Originated from a bot. T-sql-queries SQL Queries Team
Milestone

Comments

@cockroach-teamcity
Copy link
Member

cockroach-teamcity commented Nov 25, 2023

sql/tests.TestRandomSyntaxSQLSmith failed with artifacts on release-22.2 @ ecba7438f05c3d88d1136c42550bf9ea69257689:

Random syntax error:

    rsg_test.go:854: Crash detected: server panic: statement exec timeout

Query:

        WITH
        	with_10686 (col_61618)
        		AS (
        			SELECT
        				*
        			FROM
        				(VALUES (4.562164793166841738E+19:::DECIMAL), (2.104659822630884391E+36:::DECIMAL))
        					AS tab_26455 (col_61618)
        		),
        	with_10687 (col_61619) AS (SELECT * FROM (VALUES (NULL)) AS tab_26456 (col_61619)),
        	with_10688 (col_61620, col_61621)
        		AS (
        			SELECT
        				*
        			FROM
        				(
        					VALUES
        						(
        							'010400000000000000':::GEOMETRY,
        							ARRAY[21483:::INT8,(-6894):::INT8,(-10659):::INT8,1:::INT8,(-18238):::INT8]
        						),
        						(
        							'01020000C00300000080E5F10C1CD5D6C1422493477F46F7C1EC46939563ADF341E04E0FB7DE32D3C1F0CB9AB80E13FF41502193D6B43BF94156E8FAEA4A86ECC10899272CD924D4C174C245FF2330E541A4970A42C6E6FF41144F9E0683D3F5418EDED7B379ADFBC1':::GEOMETRY,
        							CASE
        							WHEN false THEN NULL
        							ELSE COALESCE(
        								ARRAY[25033:::INT8,24157:::INT8,(-655):::INT8,3831:::INT8,(-27081):::INT8],
        								NULL
        							)
        							END
        						),
        						(
        							COALESCE(
        								'01060000C00200000001030000C0010000000B00000052BFD7613599ECC1102F466CA941EA41B015172C4BDEEB41302DA2C1C070DC41645FEE0C1019F9C1D8EC1362C82FD14100AAF445A819DA4174CA9A5B8C0CEE4138429D9969F8F341BEA13D2E9954F7C17C844AC85841F84110C41102D1DEC741C0846314C4ECFE41D80DC32AE5E6F44104CFCD608BAEF941A2D898537833FBC166C73C68F870F841B85388AF7ED2FA41F429AF522A5A02428C8BE7B9B1AEF341806E2903092ACD414A6EF0E2C34DF5418013A747FFECFBC1B540725D9A4302C200B631ECE41C88C1C819C32FBB9DFB41AA5FA7715BC6F4C1E856E0D79E54E94180C60BF74F6EF1C1CCED1FA21394FF41D8AE4B7FE630E341DC7778862FCCFA412D8DC57D1080F0C1E61BC8852278F74146D6B0D04802F64188A9107E170AFE41381AB0F952DBD8C1524F57E987ADF2416077F156F9A9EC4164A22FDAF61AFB4152BFD7613599ECC1102F466CA941EA41B015172C4BDEEB41302DA2C1C070DC4101030000C0010000000B0000003363D543D1B2FFC1A0665FE13DB3B2C1C3ED5CBC16B0F1C15037D1FE90B5D6C1DC49A18586D8FEC1B1121A01EE87F1C1A0DD69FE54C4C4415C223F83271DE3C18B339CE79C1701C273B5D97DCB5E01C2AFC67214B10401C2DCC8C8EFD653E1417885E5650889F5415E3325277719F1C19AFFBD65775502428CC5F66337CEEBC15E50B46A7F2702424E5B1690B101E1C1B8B9063987AEE2C15C7E68EA1D38E041989F36A124FDF34130E6C1BBAF23C3C1E88975AE335D0142795BC674C428F8C12E0A16BF4158F441087097B97E39DF41CD8E9BD86AFDF2C1A4696CA12CC0FD41F07166E8FA1E0242C852DDA09354F9412C0328E248FBFCC192DEEDD02EE4F0C19097E29362F3C5C102F4C4EEC42202429B3DB7D03B54F6C1904BFF3F43D6D9416C3CF41AD7DCFCC116317A2DC387F241E3E56628F948F4C120DEA57AEED8FDC13363D543D1B2FFC1A0665FE13DB3B2C1C3ED5CBC16B0F1C15037D1FE90B5D6C1':::GEOMETRY,
        								'01060000000200000001030000000100000004000000000000000000444000000000000044400000000000003440000000000080464000000000008046400000000000003E4000000000000044400000000000004440010300000002000000060000000000000000003440000000000080414000000000000024400000000000003E40000000000000244000000000000024400000000000003E4000000000000014400000000000804640000000000000344000000000000034400000000000804140040000000000000000003E40000000000000344000000000000034400000000000002E40000000000000344000000000000039400000000000003E400000000000003440':::GEOMETRY
        							),
        							ARRAY[(-8668):::INT8,1:::INT8]
        						),
        						('0101000040000000000000F87F000000000000F87F000000000000F87F':::GEOMETRY, NULL),
        						(
        							'01070000000600000001050000000600000001020000000200000000E8C61407BAFCC1AAA7791402E900C29EEA41153B25EAC1E283D80F36CCF5C1010200000004000000F6C9D48D75C9FCC1EAFD7EAFDA2501C2D07DAD5799BADC414C8AC1E20E72E2C1DCF792C94181F441C0E760C98D37B1C1F0E1FC0FBFC8DFC112FBFE5CF133F7410102000000040000000A20880FA3B3EFC15E79084363AEE4C158D21ED93745E4C1660E3332FC2BF8C1A833CD249FDCF541F01D516EB451E7C1CECCE24A4B34024288AF354ED7A0F5C1010200000003000000C0AAAF0CBD6AB8411319F783FB2F02C2F857DA2C3229FD411856AA7B25C6D141C611CFAA5DD3F741245A5194234FF341010200000002000000783FBC17D9E70142CCAA072D5C01EAC1F889008EE812F34118C0E78AD3B8FC4101020000000400000080A79CC9A366D9411A5A5B3ACFE3FFC1A838028C6A96DE41FF7D056A4B91F0C1A65BA39A0204F1418642B81D8567F5C1642072B8649BE941002261FD7274C3C10105000000030000000102000000040000004B3FC2EBDA3F02C26290B954EE34FAC160BFC565A876B6414825A8202C8AFBC18C9009E70ECCFD41B0E0EAB45EF4C14150FEEB31D735FF4196C99883FF35F9410102000000030000002873813A65FAF8C1800639E54A18CCC12A0F1DBAB3BDF4C1508FFA8798C3D3C1A2E94543588502421C5B1D014EDDE741010200000002000000FEAB31CFA48BE5C180325269C6DFBF41583CEDD9C4DDD4C1C087A9B5E810E141010200000003000000A0E556BA4DD2CBC1E55C0E885EE4F2C180239B2F9782B641B2D8C13C47A4E8C158EA170425ACFC41E691868E95E3F5C1010500000009000000010200000003000000D0326605FDECD3C1DC17056019E0F8C1382B20BCEB4BE141225BE26C2525EFC16477A850AF7BEB41B227EADAC719E7C101020000000400000058CBC60AAF00FE41DACCD6671546F741D0D3481600BEF041DA4983568082F24130720ECEBA0901C2A82C8404F77CF54164D7566740F9EFC1081B8BA1B6F5EC41010200000002000000E8D7397B6EB2E141381B73C1718CF0C19489A1AD8E1BEA4198C3D53B293CD041010200000002000000BC89F2182024E1413CCF1727437AEF41E03024997DB0C0C1C6703B86E5CDF641010200000002000000A486D6332625E241408B4E74016EAEC13052F2432331D54100EBBC9C48438841010200000002000000C4C3B718A032E0C16EC00699F24AF441CC68FF89D63501C244F866C6A287E241010200000006000000342C0D1732E4E6418C50AB3C3A6EE341B42DC641DCADEA41201CC279595BFC41648EA338B382DDC16C3D721A32B4F541223447A37E85F1C1AC636953BDC5FA41B4C685163A0A00C29C9FE806D7D6004266A6273D92BFFDC1828B7F7D44CBF841010200000005000000E882E42A976CFAC15C456E9C02A7F041FCC724421673F4C15272B83A07F0E2C1F06A747DD38FC841FEBD5161E323F74114AD01F1E25FEA4174CC24432373FE41E7CD9556F2DAF4C1901864CE5506FD41010200000004000000E414F65CE2DFFEC1BC1FD29674A0E1413E0C56FE38ABF5410049BADC78D893C1A82F5C62C93EDD4126824E9A043FF741DCE8B42FF517EC4108BD494FF39A0242010200000003000000BE3F487DFC63FA41C95863AD105801C22E878F1DF617FA41101C38BE0D83EEC1944340D9F908E641809A2A179A61BFC10104000000090000000101000000FFE9B574584501C2C8A44ABCAA1801C2010100000000FBF686A4CCADC1703B60A9E2FADB410101000000A867AF0FD45DFE414EE785343D0001C20101000000308DA2CDF913C8410083F18096888A4101010000008C70AA4D5804E6416C76B2131DC9EB410101000000D8B8C3C2940BFC41009850D14332B1C1010100000047FA78A103DAF4C1BB33CABDD4FC01C20101000000E4E8617176D6EEC1A2B0438E1D11F0C1010100000007B0DE07BE4B02C21460504CFD0AE241':::GEOMETRY,
        							NULL
        						)
        				)
        					AS tab_26457 (col_61620, col_61621)
        		)
        SELECT
        	tab_26460._jsonb AS col_61622,
        	'00:00:00':::INTERVAL AS col_61623,
        	'65b3:29f0:b3dc:9267:b87b:9f4c:5969:cc90/45':::INET AS col_61624,
        	NULL AS col_61625,
        	crdb_internal.reset_sql_stats()::BOOL AS col_61626,
        	'00000000-0000-0000-0000-000000000000':::UUID AS col_61627,
        	tab_26458.crdb_internal_mvcc_timestamp AS col_61628,
        	tab_26458._inet AS col_61629,
        	'2028-11-13 22:44:04.000383':::TIMESTAMP AS col_61630
        FROM
        	defaultdb.public.seed@[0] AS tab_26458,
        	with_10688 AS cte_ref_3164,
        	defaultdb.public.seed@[0] AS tab_26459,
        	defaultdb.public.seed@[0] AS tab_26460;

Schema:

    rsg_test.go:668: To reproduce, use schema:
    rsg_test.go:670: SET sql_safe_updates = false;;
    rsg_test.go:670: SET CLUSTER SETTING sql.stats.automatic_collection.enabled = false;;
    rsg_test.go:670: SET CLUSTER SETTING sql.stats.histogram_collection.enabled = false;;
    rsg_test.go:670: CREATE TABLE table1 (col1_0 DATE NOT NULL, col1_1 UUID NOT NULL, col1_2 REGROLE, col1_3 BIT(16) NOT NULL, col1_4 STRING NOT NULL AS (lower(CAST(col1_1 AS STRING))) STORED, col1_5 STRING NOT NULL AS (CASE WHEN col1_2 IS NULL THEN e'\x06yg\x05\x16':::STRING ELSE ',':::STRING END) VIRTUAL, PRIMARY KEY (col1_5 ASC, col1_0, col1_1 ASC), INDEX (col1_2 ASC, col1_1 DESC) STORING (col1_3) WHERE ((table1.col1_5 = e'\U00002603':::STRING) AND (table1.col1_0 > '1970-01-01':::DATE)) AND (table1.col1_4 > e'\'':::STRING), UNIQUE (col1_0, col1_1) WHERE ((table1.col1_0 <= 'infinity':::DATE) OR (table1.col1_5 != e'\U00002603':::STRING)) AND (table1.col1_4 <= e'\U00002603':::STRING), INDEX (lower(CAST(col1_3 AS STRING)), col1_4, col1_3 ASC, col1_0 DESC, col1_5 DESC) WHERE ((table1.col1_4 > e'\U00002603':::STRING) AND (table1.col1_5 >= e'\U00002603':::STRING)) OR (table1.col1_0 = '5874897-12-31':::DATE), UNIQUE (col1_5 ASC, col1_4 DESC, col1_0 DESC, col1_1 DESC) STORING (col1_3) WHERE ((table1.col1_4 <= e'\x00':::STRING) AND (table1.col1_5 <= e'\x00':::STRING)) AND (table1.col1_0 != '5874897-12-31':::DATE), UNIQUE (col1_4, col1_1, col1_0, col1_5 DESC, col1_2 DESC, col1_3 DESC) WHERE ((table1.col1_0 <= '1970-01-01':::DATE) AND (table1.col1_5 = '"':::STRING)) OR (table1.col1_4 <= '"':::STRING), FAMILY (col1_1, col1_0), FAMILY (col1_3, col1_4, col1_2));
    rsg_test.go:670: ALTER TABLE table1 INJECT STATISTICS e'[{"avg_size": 21, "columns": ["col1_0"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 4949339455253270536, "histo_buckets": [{"distinct_range": 0, "num_eq": 7046053971035904516, "num_range": 0, "upper_bound": "1976-01-24"}, {"distinct_range": 0, "num_eq": 3534186872152824534, "num_range": 1613714992744844259, "upper_bound": "1977-07-21"}, {"distinct_range": 900, "num_eq": 0, "num_range": 900, "upper_bound": "1987-12-18"}, {"distinct_range": 3410955973908466000, "num_eq": 5000000, "num_range": 3410955973908466184, "upper_bound": "1989-04-18"}, {"distinct_range": 0, "num_eq": 2000, "num_range": 80000, "upper_bound": "1989-11-25"}, {"distinct_range": 1703473461876484600, "num_eq": 2975236466047080808, "num_range": 1703473461876484713, "upper_bound": "1990-01-24"}, {"distinct_range": 30860500803.124252, "num_eq": 8467495811133883388, "num_range": 100000000000, "upper_bound": "1991-03-08"}, {"distinct_range": 0, "num_eq": 3857942069356356664, "num_range": 2000, "upper_bound": "1994-09-30"}, {"distinct_range": 30000000000, "num_eq": 5572981327138672060, "num_range": 30000000000, "upper_bound": "1994-12-16"}], "histo_col_type": "DATE", "name": "__auto__", "null_count": 0, "row_count": 8453872526396682168}, {"avg_size": 29, "columns": ["col1_1"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 801002318312114283, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 8453872526396682168}, {"avg_size": 28, "columns": ["col1_2"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 4385279293949416569, "histo_buckets": [{"distinct_range": 0, "num_eq": 3112816969472174078, "num_range": 0, "upper_bound": "0"}, {"distinct_range": 19024196020.232033, "num_eq": 8159490530764565357, "num_range": 70000000000, "upper_bound": "85658485"}, {"distinct_range": 0, "num_eq": 10, "num_range": 3938564347498674337, "upper_bound": "538892166"}, {"distinct_range": 700000000, "num_eq": 7000000, "num_range": 700000000, "upper_bound": "1551050876"}, {"distinct_range": 489849554.8535616, "num_eq": 7000000000, "num_range": 1000000000, "upper_bound": "2896159958"}, {"distinct_range": 6138066305526036000, "num_eq": 800, "num_range": 7214382437323189758, "upper_bound": "3095350341"}], "histo_col_type": "REGROLE", "name": "__auto__", "null_count": 4744916469857464754, "row_count": 8453872526396682168}, {"avg_size": 12, "columns": ["col1_3"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 3282948477013058855, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 8453872526396682168}, {"avg_size": 14, "columns": ["col1_4"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 7150685835232959961, "histo_buckets": [{"distinct_range": 0, "num_eq": 200000, "num_range": 0, "upper_bound": "\\\\0KB\\u000b\\u0005\\u001b)"}], "histo_col_type": "STRING", "name": "__auto__", "null_count": 0, "row_count": 8453872526396682168}, {"avg_size": 26, "columns": ["col1_5"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 5029061351332107243, "histo_buckets": [{"distinct_range": 0, "num_eq": 8000, "num_range": 0, "upper_bound": ""}, {"distinct_range": 6082127150780074000, "num_eq": 7000000000, "num_range": 6082127150780073694, "upper_bound": "\\u0001X-TD\\u0008~"}, {"distinct_range": 1646384110255388000, "num_eq": 7903371240699669200, "num_range": 3858297912501970667, "upper_bound": "\\u00136"}, {"distinct_range": 0, "num_eq": 5000000, "num_range": 600000000, "upper_bound": "\'"}, {"distinct_range": 8020967127731598000, "num_eq": 4530829891459499590, "num_range": 8020967127731598488, "upper_bound": "3Jv\\u001c\\u000cHa"}, {"distinct_range": 953209847905286400, "num_eq": 3606641679196360543, "num_range": 953209847905286449, "upper_bound": "9 \\\\\\u0010gY9"}], "histo_col_type": "STRING", "name": "__auto__", "null_count": 0, "row_count": 8453872526396682168}]':::JSONB;
    rsg_test.go:670: CREATE TYPE rand_typ_0 AS ENUM ('dz', 'vy', 'pmn', 'pgnbt', 'r');
    rsg_test.go:670: CREATE TYPE rand_typ_1 AS ENUM ('xy', 'b');
    rsg_test.go:670: CREATE TYPE rand_typ_2 AS ENUM ('hqqz', 'lh', 'iwdra', 'ngqu', 'f', 'o');
    rsg_test.go:670: CREATE TYPE rand_typ_3 AS ENUM ('udqz', 'qxz');
    rsg_test.go:670: CREATE TYPE rand_typ_4 AS ENUM ('llmy', 'qy', 'x', 'oc');
    rsg_test.go:670: SET sql_safe_updates = false;;
    rsg_test.go:670: 
        BEGIN; CREATE TYPE greeting AS ENUM ('hello', 'howdy', 'hi', 'good day', 'morning'); COMMIT;
        BEGIN;
        CREATE TABLE IF NOT EXISTS seed AS
        	SELECT
        		g::INT2 AS _int2,
        		g::INT4 AS _int4,
        		g::INT8 AS _int8,
        		g::FLOAT4 AS _float4,
        		g::FLOAT8 AS _float8,
        		'2001-01-01'::DATE + g AS _date,
        		'2001-01-01'::TIMESTAMP + g * '1 day'::INTERVAL AS _timestamp,
        		'2001-01-01'::TIMESTAMPTZ + g * '1 day'::INTERVAL AS _timestamptz,
        		g * '1 day'::INTERVAL AS _interval,
        		g % 2 = 1 AS _bool,
        		g::DECIMAL AS _decimal,
        		g::STRING AS _string,
        		g::STRING::BYTES AS _bytes,
        		substring('00000000-0000-0000-0000-' || g::STRING || '00000000000', 1, 36)::UUID AS _uuid,
        		'0.0.0.0'::INET + g AS _inet,
        		g::STRING::JSONB AS _jsonb,
        		enum_range('hello'::greeting)[g] as _enum
        	FROM
        		generate_series(1, 5) AS g;
        COMMIT;
        
        INSERT INTO seed DEFAULT VALUES;
        CREATE INDEX on seed (_int8, _float8, _date);
        CREATE INVERTED INDEX on seed (_jsonb);
        ;
    rsg_test.go:672: 
    rsg_test.go:673: -- test log scope end --
test logs left over in: /artifacts/tmp/_tmp/d437d2c847dfedbc4972f231c3331c8e/logTestRandomSyntaxSQLSmith3429083192
--- FAIL: TestRandomSyntaxSQLSmith (301.61s)
Help

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

Same failure on other branches

/cc @cockroachdb/sql-foundations

This test on roachdash | Improve this report!

Jira issue: CRDB-33862

@cockroach-teamcity cockroach-teamcity added branch-release-22.2 Used to mark GA and release blockers, technical advisories, and bugs for 22.2 C-test-failure Broken test (automatically or manually discovered). O-robot Originated from a bot. release-blocker Indicates a release-blocker. Use with branch-release-2x.x label to denote which branch is blocked. T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions) labels Nov 25, 2023
@cockroach-teamcity cockroach-teamcity added this to the 22.2 milestone Nov 25, 2023
@rafiss
Copy link
Collaborator

rafiss commented Nov 27, 2023

The statement timed out. One thing I noticed is that one of the columns it selects is crdb_internal.reset_sql_stats - I wonder if that either is expected to take a long time, or if that could have a problem if it's being executed while running a query that reads from tables.

The full setup and query is

set enable_implicit_transaction_for_batch_statements = false;

SET sql_safe_updates = false;;
SET CLUSTER SETTING sql.stats.automatic_collection.enabled = false;;
SET CLUSTER SETTING sql.stats.histogram_collection.enabled = false;;

CREATE TABLE table1 (col1_0 DATE NOT NULL, col1_1 UUID NOT NULL, col1_2 REGROLE, col1_3 BIT(16) NOT NULL, col1_4 STRING NOT NULL AS (lower(CAST(col1_1 AS STRING)))
STORED, col1_5 STRING NOT NULL AS (CASE WHEN col1_2 IS NULL THEN e'\x06yg\x05\x16':::STRING ELSE ',':::STRING END) VIRTUAL, PRIMARY KEY (col1_5 ASC, col1_0, col1_1 ASC), INDEX (col1_2 ASC, col1_1 DESC) STORING (col1_3) WHERE ((table1.col1_5 = e'\U00002603':::STRING) AND (table1.col1_0 > '1970-01-01':::DATE)) AND (table1.col1_4 > e'\'':::STRING), UNIQUE (col1_0, col1_1
) WHERE ((table1.col1_0 <= 'infinity':::DATE) OR (table1.col1_5 != e'\U00002603':::STRING)) AND (table1.col1_4 <= e'\U00002603':::STRING), INDEX (lower(CAST(col1_3 AS STRING)), col1_4,
col1_3 ASC, col1_0 DESC, col1_5 DESC) WHERE ((table1.col1_4 > e'\U00002603':::STRING) AND (table1.col1_5 >= e'\U00002603':::STRING)) OR (table1.col1_0 = '5874897-12-31':::DATE), UNIQUE
(col1_5 ASC, col1_4 DESC, col1_0 DESC, col1_1 DESC) STORING (col1_3) WHERE ((table1.col1_4 <= e'\x00':::STRING) AND (table1.col1_5 <= e'\x00':::STRING)) AND (table1.col1_0 != '5874897-12-31':::DATE), UNIQUE (col1_4, col1_1, col1_0, col1_5 DESC, col1_2 DESC, col1_3 DESC) WHERE ((table1.col1_0 <= '1970-01-01':::DATE) AND (table1.col1_5 = '"':::STRING)) OR (table1.col1_4 <= '"':::STRING), FAMILY (col1_1, col1_0), FAMILY (col1_3, col1_4, col1_2));

ALTER TABLE table1 INJECT STATISTICS e'[{"avg_size": 21, "columns": ["col1_0"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 4949339455253270536, "histo_buckets": [{"distinct_range": 0, "num_eq": 7046053971035904516, "num_range": 0, "upper_bound": "1976-01-24"}, {"distinct_range": 0, "num_eq": 3534186872152824534, "num_range": 1613714992744844259, "upper_bound": "1977-07-21"}, {"distinct_range": 900, "num_eq": 0, "num_range": 900, "upper_bound": "1987-12-18"}, {"distinct_range": 3410955973908466000, "num_eq": 5000000, "num_range": 3410955973908466184, "upper_bound": "1989-04-18"}, {"distinct_range": 0, "num_eq": 2000, "num_range": 80000, "upper_bound": "1989-11-25"}, {"distinct_range": 1703473461876484600, "num_eq": 2975236466047080808, "num_range": 1703473461876484713, "upper_bound": "1990-01-24"}, {"distinct_range": 30860500803.124252, "num_eq": 8467495811133883388, "num_range": 100000000000, "upper_bound": "1991-03-08"}, {"distinct_range": 0, "num_eq": 3857942069356356664, "num_range": 2000, "upper_bound": "1994-09-30"}, {"distinct_range": 30000000000, "num_eq": 5572981327138672060, "num_range": 30000000000, "upper_bound": "1994-12-16"}], "histo_col_type": "DATE", "name": "__auto__", "null_count": 0, "row_count": 8453872526396682168}, {"avg_size": 29, "columns": ["col1_1"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 801002318312114283, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 8453872526396682168}, {"avg_size": 28, "columns": ["col1_2"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 4385279293949416569, "histo_buckets": [{"distinct_range": 0, "num_eq": 3112816969472174078, "num_range": 0, "upper_bound": "0"}, {"distinct_range": 19024196020.232033, "num_eq": 8159490530764565357, "num_range": 70000000000, "upper_bound": "85658485"}, {"distinct_range": 0, "num_eq": 10, "num_range": 3938564347498674337, "upper_bound": "538892166"}, {"distinct_range": 700000000, "num_eq": 7000000, "num_range": 700000000, "upper_bound": "1551050876"}, {"distinct_range": 489849554.8535616, "num_eq": 7000000000, "num_range": 1000000000, "upper_bound": "2896159958"}, {"distinct_range": 6138066305526036000, "num_eq": 800, "num_range": 7214382437323189758, "upper_bound": "3095350341"}], "histo_col_type": "REGROLE", "name": "__auto__", "null_count": 4744916469857464754, "row_count": 8453872526396682168}, {"avg_size": 12, "columns": ["col1_3"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 3282948477013058855, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 8453872526396682168}, {"avg_size": 14, "columns": ["col1_4"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 7150685835232959961, "histo_buckets": [{"distinct_range": 0, "num_eq": 200000, "num_range": 0, "upper_bound": "\\\\0KB\\u000b\\u0005\\u001b)"}], "histo_col_type": "STRING", "name": "__auto__", "null_count": 0, "row_count": 8453872526396682168}, {"avg_size": 26, "columns": ["col1_5"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 5029061351332107243, "histo_buckets": [{"distinct_range": 0, "num_eq": 8000, "num_range": 0, "upper_bound": ""}, {"distinct_range": 6082127150780074000, "num_eq": 7000000000, "num_range": 6082127150780073694, "upper_bound": "\\u0001X-TD\\u0008~"}, {"distinct_range": 1646384110255388000, "num_eq": 7903371240699669200, "num_range": 3858297912501970667, "upper_bound": "\\u00136"}, {"distinct_range": 0, "num_eq": 5000000, "num_range": 600000000, "upper_bound": "\'"}, {"distinct_range": 8020967127731598000, "num_eq": 4530829891459499590, "num_range": 8020967127731598488, "upper_bound": "3Jv\\u001c\\u000cHa"}, {"distinct_range": 953209847905286400, "num_eq": 3606641679196360543, "num_range": 953209847905286449, "upper_bound": "9 \\\\\\u0010gY9"}], "histo_col_type": "STRING", "name": "__auto__", "null_count": 0, "row_count": 8453872526396682168}]':::JSONB;

CREATE TYPE rand_typ_0 AS ENUM ('dz', 'vy', 'pmn', 'pgnbt', 'r');
CREATE TYPE rand_typ_1 AS ENUM ('xy', 'b');
CREATE TYPE rand_typ_2 AS ENUM ('hqqz', 'lh', 'iwdra', 'ngqu', 'f', 'o');
CREATE TYPE rand_typ_3 AS ENUM ('udqz', 'qxz');
CREATE TYPE rand_typ_4 AS ENUM ('llmy', 'qy', 'x', 'oc');

SET sql_safe_updates = false;;

        BEGIN; CREATE TYPE greeting AS ENUM ('hello', 'howdy', 'hi', 'good day', 'morning'); COMMIT;
        BEGIN;
        CREATE TABLE IF NOT EXISTS seed AS
                SELECT
                        g::INT2 AS _int2,
                        g::INT4 AS _int4,
                        g::INT8 AS _int8,
                        g::FLOAT4 AS _float4,
                        g::FLOAT8 AS _float8,
                        '2001-01-01'::DATE + g AS _date,
                        '2001-01-01'::TIMESTAMP + g * '1 day'::INTERVAL AS _timestamp,
                        '2001-01-01'::TIMESTAMPTZ + g * '1 day'::INTERVAL AS _timestamptz,
                        g * '1 day'::INTERVAL AS _interval,
                        g % 2 = 1 AS _bool,
                        g::DECIMAL AS _decimal,
                        g::STRING AS _string,
                        g::STRING::BYTES AS _bytes,
                        substring('00000000-0000-0000-0000-' || g::STRING || '00000000000', 1, 36)::UUID AS _uuid,
                        '0.0.0.0'::INET + g AS _inet,
                        g::STRING::JSONB AS _jsonb,
                        enum_range('hello'::greeting)[g] as _enum
                FROM
                        generate_series(1, 5) AS g;
        COMMIT;

        INSERT INTO seed DEFAULT VALUES;
        CREATE INDEX on seed (_int8, _float8, _date);
        CREATE INVERTED INDEX on seed (_jsonb);
        ;

        WITH
                with_290468 (col_1649701)
                        AS (
                                SELECT * FROM (VALUES (3230195005:::OID), (410968894:::OID), (386811652:::OID)) AS tab_712209 (col_1649701)
                        ),
                with_290471 (col_1649705)
                        AS (
                                SELECT
                                        *
                                FROM
                                        (
                                                VALUES
                                                        ('morning':::greeting),
                                                        ('hi':::greeting),
                                                        (
                                                                (
                                                                        WITH
                                                                                with_290469 (col_1649702) AS (SELECT NULL AS col_1649702),
                                                                                with_290470 (col_1649703)
                                                                                        AS (
                                                                                                SELECT
                                                                                                        *
                                                                                                FROM
                                                                                                        (VALUES (0:::OID), (NULL), (4013171479:::OID))
                                                                                                                AS tab_712210 (col_1649703)
                                                                                        )
                                                                        SELECT
                                                                                'howdy':::greeting AS col_1649704
                                                                        LIMIT
                                                                                1:::INT8
                                                                )
                                                        )
                                        )
                                                AS tab_712211 (col_1649705)
                        )
        SELECT
                count(*) AS col_1649706
        FROM
                defaultdb.public.table1@[0] AS tab_712212
        WHERE
                NULL
        GROUP BY
                tab_712212.col1_5, tab_712212.col1_1, tab_712212.col1_0
        ORDER BY
                tab_712212.col1_0 DESC NULLS LAST, tab_712212.col1_1 DESC NULLS LAST
        LIMIT
                75:::INT8;

I used the repro instructions but it didn't time out.

I'm moving to SQL Queries in case they have a way to see why this timed out. But if not, I think this can be closed.

@rafiss rafiss changed the title sql/tests: TestRandomSyntaxSQLSmith failed sql/tests: TestRandomSyntaxSQLSmith failed [statement timeout; uses crdb_internal.reset_sql_stats] Nov 27, 2023
@rafiss rafiss added T-sql-queries SQL Queries Team and removed T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions) labels Nov 27, 2023
@github-project-automation github-project-automation bot moved this to Triage in SQL Queries Nov 27, 2023
@exalate-issue-sync exalate-issue-sync bot changed the title sql/tests: TestRandomSyntaxSQLSmith failed [statement timeout; uses crdb_internal.reset_sql_stats] sql/tests: TestRandomSyntaxSQLSmith failed Nov 28, 2023
@mgartner mgartner removed the release-blocker Indicates a release-blocker. Use with branch-release-2x.x label to denote which branch is blocked. label Nov 29, 2023
@DrewKimball
Copy link
Collaborator

        goroutine 7887905 [runnable]:
        github.com/cockroachdb/cockroach/pkg/util/pretty.Concat({0x63c73c0?, 0xc011a7cde0}, {0x63c73c0, 0xc011a7d820})
        	github.com/cockroachdb/cockroach/pkg/util/pretty/document.go:110 +0x13a
        github.com/cockroachdb/cockroach/pkg/util/pretty.flatten({0x63c73c0?, 0xc011a7bb80?})
        	github.com/cockroachdb/cockroach/pkg/util/pretty/document.go:165 +0x373
        github.com/cockroachdb/cockroach/pkg/util/pretty.flatten({0x63c73c0?, 0xc011a7bba0?})
        	github.com/cockroachdb/cockroach/pkg/util/pretty/document.go:165 +0x35e
        github.com/cockroachdb/cockroach/pkg/util/pretty.flatten({0x63d00c0?, 0xc006bb2a50?})
        	github.com/cockroachdb/cockroach/pkg/util/pretty/document.go:167 +0x3eb
        github.com/cockroachdb/cockroach/pkg/util/pretty.flatten({0x63c73c0?, 0xc011a7bbc0?})
        	github.com/cockroachdb/cockroach/pkg/util/pretty/document.go:165 +0x35e
        github.com/cockroachdb/cockroach/pkg/util/pretty.flatten({0x63c7420?, 0xc011a7bbe0?})
        	github.com/cockroachdb/cockroach/pkg/util/pretty/document.go:177 +0x85
        github.com/cockroachdb/cockroach/pkg/util/pretty.flatten({0x63c73c0?, 0xc011a7bc20?})
        	github.com/cockroachdb/cockroach/pkg/util/pretty/document.go:165 +0x35e
        github.com/cockroachdb/cockroach/pkg/util/pretty.flatten({0x63c73c0?, 0xc011a7bc40?})
        	github.com/cockroachdb/cockroach/pkg/util/pretty/document.go:165 +0x35e
        github.com/cockroachdb/cockroach/pkg/util/pretty.flatten({0x63c73c0?, 0xc011a7bc60?})
        	github.com/cockroachdb/cockroach/pkg/util/pretty/document.go:165 +0x35e
        github.com/cockroachdb/cockroach/pkg/util/pretty.flatten({0x63c73c0?, 0xc011a7bc80?})
        	github.com/cockroachdb/cockroach/pkg/util/pretty/document.go:165 +0x35e
        github.com/cockroachdb/cockroach/pkg/util/pretty.Group(...)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/document.go:155
        github.com/cockroachdb/cockroach/pkg/util/pretty.makeTableNestedSections.func1({0x63d0060, 0xc006bb2c20}, {0x63c73c0?, 0xc011a7bc80})
        	github.com/cockroachdb/cockroach/pkg/util/pretty/util.go:312 +0x3c
        github.com/cockroachdb/cockroach/pkg/util/pretty.simplifyNil(...)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/util.go:168
        github.com/cockroachdb/cockroach/pkg/util/pretty.makeTableNestedSections(0x5825c30, {0xc0210cb8c0, 0x9, 0x0?})
        	github.com/cockroachdb/cockroach/pkg/util/pretty/util.go:310 +0x223
        github.com/cockroachdb/cockroach/pkg/util/pretty.Table(0x0, 0x4d77f00?, {0xc0210cb8c0, 0x9, 0x9})
        	github.com/cockroachdb/cockroach/pkg/util/pretty/util.go:245 +0x5f
        github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*PrettyCfg).rlTable(...)
        	github.com/cockroachdb/cockroach/pkg/sql/sem/tree/pretty.go:201
        github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*Select).doc(0xc019d9c300?, 0x949c260)
        	github.com/cockroachdb/cockroach/pkg/sql/sem/tree/pretty.go:566 +0x46
        github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*PrettyCfg).Doc(0x20?, {0x63c5e00, 0xc0145f5270})
        	github.com/cockroachdb/cockroach/pkg/sql/sem/tree/pretty.go:173 +0x42
        github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*ParenSelect).doc(0x13ae534?, 0x63c54a0?)
        	github.com/cockroachdb/cockroach/pkg/sql/sem/tree/pretty.go:504 +0x2a
        github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*PrettyCfg).Doc(0x54d9c98?, {0x63c54a0, 0xc004f4a070})
        	github.com/cockroachdb/cockroach/pkg/sql/sem/tree/pretty.go:173 +0x42
        github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*Subquery).doc(0xc01889a330, 0x63c6720?)
        	github.com/cockroachdb/cockroach/pkg/sql/sem/tree/pretty.go:678 +0x71
        github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*PrettyCfg).Doc(0x13b1dcc?, {0x63c6720, 0xc01889a330})
        	github.com/cockroachdb/cockroach/pkg/sql/sem/tree/pretty.go:173 +0x42
        github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*Exprs).doc(0xc0148392f0, 0x949c260)
        	github.com/cockroachdb/cockroach/pkg/sql/sem/tree/pretty.go:412 +0x105
        github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*PrettyCfg).Doc(0x63d0140?, {0x63c46a0, 0xc0148392f0})
        	github.com/cockroachdb/cockroach/pkg/sql/sem/tree/pretty.go:173 +0x42
        github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*ValuesClause).docTable(0xc04b385c68, 0x6435e40?)
        	github.com/cockroachdb/cockroach/pkg/sql/sem/tree/pretty.go:1094 +0xb8
        github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*Select).docTable(0xc0145f5310, 0x4d77f00?)
        	github.com/cockroachdb/cockroach/pkg/sql/sem/tree/pretty.go:573 +0xdf
        github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*Select).doc(0x452c1f?, 0x949c260)
        	github.com/cockroachdb/cockroach/pkg/sql/sem/tree/pretty.go:566 +0x1e
        github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*PrettyCfg).Doc(0xc02a65b608?, {0x63c5e00, 0xc0145f5310})
        	github.com/cockroachdb/cockroach/pkg/sql/sem/tree/pretty.go:173 +0x42
        github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*ParenSelect).doc(0x0?, 0x63c54a0?)
        	github.com/cockroachdb/cockroach/pkg/sql/sem/tree/pretty.go:504 +0x2a
        github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*PrettyCfg).Doc(0x54d9c98?, {0x63c54a0, 0xc004f4a080})
        	github.com/cockroachdb/cockroach/pkg/sql/sem/tree/pretty.go:173 +0x42
        github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*Subquery).doc(0xc01889a360, 0x63c6720?)
        	github.com/cockroachdb/cockroach/pkg/sql/sem/tree/pretty.go:678 +0x71
        github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*PrettyCfg).Doc(0x4508e7?, {0x63c6720, 0xc01889a360})
        	github.com/cockroachdb/cockroach/pkg/sql/sem/tree/pretty.go:173 +0x42
        github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*AliasedTableExpr).doc(0xc0145f5400, 0x63c2d60?)
        	github.com/cockroachdb/cockroach/pkg/sql/sem/tree/pretty.go:690 +0x66
        github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*PrettyCfg).Doc(0x63d0140?, {0x63c2d60, 0xc0145f5400})
        	github.com/cockroachdb/cockroach/pkg/sql/sem/tree/pretty.go:173 +0x42
        github.com/cockroachdb/cockroach/pkg/sql/sem/tree.TableExprs.doc({0xc02b47ccb0, 0x1, 0x1?}, 0x949c260)
        	github.com/cockroachdb/cockroach/pkg/sql/sem/tree/pretty.go:298 +0xc5
        github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*From).docRow(0xc0248b8a00, 0x1?)
        	github.com/cockroachdb/cockroach/pkg/sql/sem/tree/pretty.go:617 +0x51
        github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*SelectClause).docTable(0xc0248b8a00, 0x6435c00?)
        	github.com/cockroachdb/cockroach/pkg/sql/sem/tree/pretty.go:601 +0x1cf
        github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*Select).docTable(0xc0145f5630, 0x4d77f00?)
        	github.com/cockroachdb/cockroach/pkg/sql/sem/tree/pretty.go:573 +0xdf
        github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*Select).doc(0x2?, 0x949c260)
        	github.com/cockroachdb/cockroach/pkg/sql/sem/tree/pretty.go:566 +0x1e
        github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*PrettyCfg).Doc(0xc019221fe0?, {0x63c5e00, 0xc0145f5630})
        	github.com/cockroachdb/cockroach/pkg/sql/sem/tree/pretty.go:173 +0x42
        github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*UnionClause).doc(0xc011a2c7c0, 0x63c6a00?)
        	github.com/cockroachdb/cockroach/pkg/sql/sem/tree/pretty.go:1418 +0x131
        github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*PrettyCfg).Doc(0x0?, {0x63c6a00, 0xc011a2c7c0})
        	github.com/cockroachdb/cockroach/pkg/sql/sem/tree/pretty.go:173 +0x42
        github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*With).docRow(0xc011a2c820, 0xc056548780?)
        	github.com/cockroachdb/cockroach/pkg/sql/sem/tree/pretty.go:665 +0x1c5
        github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*Select).docTable(0xc0145f5c20, 0x4d77f00?)
        	github.com/cockroachdb/cockroach/pkg/sql/sem/tree/pretty.go:571 +0x6c
        github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*Select).doc(0x16?, 0x949c260)
        	github.com/cockroachdb/cockroach/pkg/sql/sem/tree/pretty.go:566 +0x1e
        github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*PrettyCfg).Doc(0x4c85860?, {0x63c5e00, 0xc0145f5c20})
        	github.com/cockroachdb/cockroach/pkg/sql/sem/tree/pretty.go:173 +0x42
        github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*PrettyCfg).Pretty(0x949c260, {0x63c5e00?, 0xc0145f5c20?})
        	github.com/cockroachdb/cockroach/pkg/sql/sem/tree/pretty.go:165 +0x28
        github.com/cockroachdb/cockroach/pkg/internal/sqlsmith.(*Smither).Generate(0x0?)
        	github.com/cockroachdb/cockroach/pkg/internal/sqlsmith/sqlsmith.go:181 +0x73
        github.com/cockroachdb/cockroach/pkg/sql/tests_test.TestRandomSyntaxSQLSmith.func2({0x6402df0, 0xc03ce85580}, 0x4a6b8a0?, 0xc01b553268?)
        	github.com/cockroachdb/cockroach/pkg/sql/tests_test/pkg/sql/tests/rsg_test.go:642 +0x59
        github.com/cockroachdb/cockroach/pkg/sql/tests_test.testRandomSyntax.func3({0x6402df0, 0xc03ce85580}, 0x707000003474fcc?)
        	github.com/cockroachdb/cockroach/pkg/sql/tests_test/pkg/sql/tests/rsg_test.go:844 +0xb4
        github.com/cockroachdb/cockroach/pkg/util/ctxgroup.GroupWorkers.func1({0x6402df0?, 0xc03ce85580?})
        	github.com/cockroachdb/cockroach/pkg/util/ctxgroup/ctxgroup.go:177 +0x2b
        github.com/cockroachdb/cockroach/pkg/util/ctxgroup.Group.GoCtx.func1()
        	github.com/cockroachdb/cockroach/pkg/util/ctxgroup/ctxgroup.go:168 +0x25
        golang.org/x/sync/errgroup.(*Group).Go.func1()
        	golang.org/x/sync/errgroup/external/org_golang_x_sync/errgroup/errgroup.go:74 +0x64
        created by golang.org/x/sync/errgroup.(*Group).Go
        	golang.org/x/sync/errgroup/external/org_golang_x_sync/errgroup/errgroup.go:71 +0xa5

        goroutine 8140062 [runnable]:
        github.com/cockroachdb/cockroach/pkg/sql/opt/memo.(*FakeRelExpr).Relational(0xc0119e8d38?)
        	github.com/cockroachdb/cockroach/bazel-out/k8-fastbuild/bin/pkg/sql/opt/memo/expr.og.go:8287 +0x36
        github.com/cockroachdb/cockroach/pkg/sql/opt/memo.(*statisticsBuilder).statsFromChild(0x0?, {0x645d450?, 0xc014a50bf8?}, 0x0?)
        	github.com/cockroachdb/cockroach/pkg/sql/opt/memo/statistics_builder.go:272 +0x50
        github.com/cockroachdb/cockroach/pkg/sql/opt/memo.(*statisticsBuilder).colStatFromInput(0xc011bfbe90?, {{{0x3ff0000000000000?, 0x0?}, 0x0?}}, {0x645d450?, 0xc014a50bf8})
        	github.com/cockroachdb/cockroach/pkg/sql/opt/memo/statistics_builder.go:321 +0x1a9
        github.com/cockroachdb/cockroach/pkg/sql/opt/memo.(*statisticsBuilder).selectivityFromNullsRemoved.func1(0x37)
        	github.com/cockroachdb/cockroach/pkg/sql/opt/memo/statistics_builder.go:4158 +0xd3
        github.com/cockroachdb/cockroach/pkg/sql/opt.ColSet.ForEach.func1(0x645d450?)
        	github.com/cockroachdb/cockroach/pkg/sql/opt/colset.go:83 +0x22
        github.com/cockroachdb/cockroach/pkg/util.FastIntSet.ForEach({{0x1d8000000000000, 0x0}, 0x0}, 0xc011bfbfa0)
        	github.com/cockroachdb/cockroach/pkg/util/pkg/util/fast_int_set.go:206 +0x9a
        github.com/cockroachdb/cockroach/pkg/sql/opt.ColSet.ForEach({{{0xc011bfc258?, 0x3ddb7cdfd9d7bdbb?}, 0x0?}}, 0x3ddb7cdfd9d7bdbb?)
        	github.com/cockroachdb/cockroach/pkg/sql/opt/colset.go:83 +0x3a
        github.com/cockroachdb/cockroach/pkg/sql/opt/memo.(*statisticsBuilder).selectivityFromNullsRemoved(0xc011bfc258?, {0x645d450?, 0xc014a50bf8?}, {{{0x0?, 0x0?}, 0x0?}}, {{{0x643ede0?, 0x0?}, 0x0?}})
        	github.com/cockroachdb/cockroach/pkg/sql/opt/memo/statistics_builder.go:4156 +0xae
        github.com/cockroachdb/cockroach/pkg/sql/opt/memo.(*statisticsBuilder).constrainExpr(0xc010d8f580, {0x645d450, 0xc014a50bf8}, 0x0?, 0xc014a50a08, 0x450a36?)
        	github.com/cockroachdb/cockroach/pkg/sql/opt/memo/statistics_builder.go:3328 +0x22c
        github.com/cockroachdb/cockroach/pkg/sql/opt/memo.(*statisticsBuilder).applyFiltersItem(0xc010d8f580, 0xc00abd6b00, {0x645d450, 0xc014a50bf8}, 0xc014a50a08)
        	github.com/cockroachdb/cockroach/pkg/sql/opt/memo/statistics_builder.go:3226 +0xb15
        github.com/cockroachdb/cockroach/pkg/sql/opt/memo.(*statisticsBuilder).applyFilters(0xc02bd8f700?, {0xc00abd6b00?, 0x3?, 0x44faad?}, {0x645d450?, 0xc014a50bf8}, 0x5342f60?, 0x0)
        	github.com/cockroachdb/cockroach/pkg/sql/opt/memo/statistics_builder.go:3095 +0x23b
        github.com/cockroachdb/cockroach/pkg/sql/opt/memo.(*statisticsBuilder).filterRelExpr(0x0?, {0xc00abd6b00?, 0x1, 0x1}, {0x645d450, 0xc014a50bf8}, {{{0xc014a50a68?, 0x0?}, 0x0?}}, 0xc014a50a08, ...)
        	github.com/cockroachdb/cockroach/pkg/sql/opt/memo/statistics_builder.go:3049 +0x12e
        github.com/cockroachdb/cockroach/pkg/sql/opt/memo.(*statisticsBuilder).buildSelect(0xc014a50a68?, 0xc014a50bf8, 0xc014a50a08)
        	github.com/cockroachdb/cockroach/pkg/sql/opt/memo/statistics_builder.go:1013 +0x185
        github.com/cockroachdb/cockroach/pkg/sql/opt/memo.(*logicalPropsBuilder).buildSelectProps(0xc010d8f570, 0xc014a50bf8, 0xc014a50a08)
        	github.com/cockroachdb/cockroach/pkg/sql/opt/memo/logical_props_builder.go:288 +0x3a6
        github.com/cockroachdb/cockroach/pkg/sql/opt/memo.(*Memo).MemoizeSelect(0xc010d8f440, {0x645c1c0?, 0xc0119e8d38}, {0xc00abd6b00, 0x1, 0x1})
        	github.com/cockroachdb/cockroach/bazel-out/k8-fastbuild/bin/pkg/sql/opt/memo/expr.og.go:19879 +0x177
        github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructSelect(0xc00cbc7b98, {0x645c1c0?, 0xc0119e8d38?}, {0xc00abd6b00, 0x1, 0x1})
        	github.com/cockroachdb/cockroach/bazel-out/k8-fastbuild/bin/pkg/sql/opt/norm/factory.og.go:1451 +0x4990
        github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildPartialIndexPredicate(0xc0547d8780, 0xc0161e1ad0, 0xc012a72300, {0x641f608?, 0xc05aaa4900?}, {0x54f7b3d, 0xf})
        	github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/partial_index.go:177 +0x385
        github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).addPartialIndexPredicatesForTable(0xc0547d8780, 0xc0161e1ad0, {0x645d3c0?, 0xc011b944b8})
        	github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/partial_index.go:105 +0x3dc
        github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildScan(0xc0547d8780, 0xc0161e1ad0, {0xc006d55860?, 0x9, 0x6?}, 0xc01544d5e0, {0x0, 0x0, 0xc006dff3b0?}, 0xc0161e1400, ...)
        	github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/select.go:665 +0x9b7
        github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildDataSource(0xc0547d8780, {0x63f56b8?, 0xc0274d05c0?}, 0xc01544d5e0, {0x0, 0x0, 0x0}, 0xc0161e1400)
        	github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/select.go:120 +0x7b4
        github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildDataSource(0xc0547d8780, {0x63f4f38?, 0xc01544d720?}, 0x14402c00?, {0x0?, 0xc010e5d278?, 0x645d0f0?}, 0xc0161e1400)
        	github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/select.go:65 +0x1145
        github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildJoin(0xc0547d8780, 0xc01544d950, {0x0, 0x0, 0x0}, 0xc0161e1400)
        	github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/join.go:48 +0x12e
        github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildDataSource(0xc0547d8780, {0x63f5478?, 0xc01544d950?}, 0x0?, {0x0?, 0xc03e770350?, 0xc011bfef38?}, 0xc0161e1400)
        	github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/select.go:77 +0x103d
        github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildJoin(0xc0547d8780, 0xc01544dd60, {0x0, 0x0, 0x0}, 0xc0161e1400)
        	github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/join.go:48 +0x12e
        github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildDataSource(0xc0547d8780, {0x63f5478?, 0xc01544dd60?}, 0x0?, {0x0?, 0x0?, 0x0?}, 0xc0161e1400)
        	github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/select.go:77 +0x103d
        github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildFromTablesRightDeep(0xc0547d8780, {0xc0025c2e50, 0x1, 0x1}, {0x0, 0x0, 0x0}, 0x8?)
        	github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/select.go:1235 +0x8d
        github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildFromTables(0x0?, {0xc0025c2e50?, 0xc02617bda0?, 0x0?}, {0x0?, 0x40000?, 0x203009?}, 0x203009?)
        	github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/select.go:1212 +0xb8
        github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildFrom(0xc0547d8780, {{0xc0025c2e50, 0x1, 0x1}, {{0x0, 0x0}}}, {0x0?, 0x0?, 0x0?}, 0xc0161e1400)
        	github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/select.go:1139 +0x265
        github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildSelectClause(0xc011bffcb0?, 0xc050089c20, {0x0, 0x0, 0x0}, {0x0, 0x0, 0x0}, {0x0, 0x0, ...}, ...)
        	github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/select.go:1060 +0xe5
        github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildSelectStmtWithoutParens(0xc00f692c00?, {0x6435c00?, 0xc050089c20?}, {0x0?, 0x0, 0x0}, 0xc02617ba40, {0x0, 0x0, 0x0}, ...)
        	github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/select.go:1008 +0x21b
        github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildSelect.func1(0x0?)
        	github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/select.go:977 +0x87
        github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).processWiths(0x44872c?, 0x0?, 0xc01e31bb30?, 0xc011bfff68)
        	github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/with.go:117 +0x63
        github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildSelect(0xc0547d8780, 0x6?, {0x0, 0x0, 0x0}, {0x0, 0x0, 0x0}, 0x203005?)
        	github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/select.go:976 +0x5ab
        github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildStmt(0xc0547d8780, {0x642c1a0?, 0xc049c36050?}, {0x0, 0x0, 0x0}, 0x0?)
        	github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/builder.go:316 +0x828
        github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildStmtAtRoot(0xc0547d8780, {0x642c1a0?, 0xc049c36050?}, {0x0?, 0x0?, 0x0?})
        	github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/builder.go:256 +0x1ad
        github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).Build(0xc0547d8780)
        	github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/builder.go:230 +0x305
        github.com/cockroachdb/cockroach/pkg/sql.(*optPlanningCtx).buildExecMemo(0xc00cbc7b10, {0x6402e98?, 0xc02617bda0})
        	github.com/cockroachdb/cockroach/pkg/sql/plan_opt.go:561 +0x508
        github.com/cockroachdb/cockroach/pkg/sql.(*planner).makeOptimizerPlan(0xc00cbc7180, {0x6402e98?, 0xc02617bd10?})
        	github.com/cockroachdb/cockroach/pkg/sql/plan_opt.go:232 +0x1b1
        github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).makeExecPlan(0xc00cbc6c00, {0x6402e98, 0xc02617bd10}, 0xc00cbc7180)
        	github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:1475 +0x4e
        github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).dispatchToExecutionEngine(0xc00cbc6c00, {0x6402e98, 0xc02617bd10}, 0xc00cbc7180, {0x7fe84f4f9760, 0xc00cafbac8})
        	github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:1086 +0x308
        github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execStmtInOpenState(0xc00cbc6c00, {0x6402e98?, 0xc02617bb00?}, {{0x642c1a0, 0xc049c36050}, {0xc010a883d7, 0x361}, 0x0, 0x4}, 0x0, ...)
        	github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:694 +0x2378
        github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execStmt.func1({0x6402e98?, 0xc02617bb00?})
        	github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:131 +0xfc
        github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execWithProfiling(0x6402e98?, {0x6402e98?, 0xc02617bb00?}, {0x642c1a0?, 0xc049c36050?}, 0x0?, 0x0?)
        	github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:2440 +0x330
        github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execStmt(0xc00cbc6c00, {0x6402e98, 0xc02617bb00}, {{0x642c1a0, 0xc049c36050}, {0xc010a883d7, 0x361}, 0x0, 0x4}, 0x0, ...)
        	github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:130 +0x49f
        github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execCmd.func1({{{0x642c1a0, 0xc049c36050}, {0xc010a883d7, 0x361}, 0x0, 0x4}, {0xc15083c1f39267f7, 0x1b659d98c1b, 0x0}, {0xc15083c1f3926d9f, ...}, ...}, ...)
        	github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:2129 +0x306
        github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execCmd(0xc00cbc6c00)
        	github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:2133 +0x1168
        github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).run(0xc00cbc6c00, {0x6402df0, 0xc01e2ad6c0}, 0xc02692da00?, 0x0?, 0xc0001337d0?)
        	github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:2054 +0x20b
        github.com/cockroachdb/cockroach/pkg/sql.(*Server).ServeConn(0xc02692db00?, {0x6402df0?, 0xc01e2ad6c0?}, {0xc006549000?}, 0x3?, 0xc034576890?)
        	github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:882 +0xe6
        github.com/cockroachdb/cockroach/pkg/sql/pgwire.(*conn).processCommandsAsync.func1()
        	github.com/cockroachdb/cockroach/pkg/sql/pgwire/conn.go:769 +0x54f
        created by github.com/cockroachdb/cockroach/pkg/sql/pgwire.(*conn).processCommandsAsync
        	github.com/cockroachdb/cockroach/pkg/sql/pgwire/conn.go:676 +0x22e


        goroutine 8140169 [runnable]:
        github.com/cockroachdb/cockroach/pkg/sql/parser.(*sqlParserImpl).Parse(0xc011cb6098, {0x63dac90?, 0xc011cb6030?})
        	sql-gen.y:15098 +0x7f03e
        github.com/cockroachdb/cockroach/pkg/sql/parser.(*Parser).parse(0xc011cb6000, 0x478a50?, {0xc0292536e0, 0x27}, {0xc00f875800?, 0xc012234448?, 0x45ce93?}, 0x4000?)
        	github.com/cockroachdb/cockroach/pkg/sql/parser/parse.go:228 +0x1b1
        github.com/cockroachdb/cockroach/pkg/sql/parser.(*Parser).parseWithDepth(0xc011cb6000, 0x1, {0xc0292536e0?, 0x27}, 0x580?)
        	github.com/cockroachdb/cockroach/pkg/sql/parser/parse.go:208 +0x1b6
        github.com/cockroachdb/cockroach/pkg/sql/parser.(*Parser).parseOneWithInt(0x54e7be6?, {0xc0292536e0?, 0xc0122345d8?}, 0x1?)
        	github.com/cockroachdb/cockroach/pkg/sql/parser/parse.go:144 +0x45
        github.com/cockroachdb/cockroach/pkg/sql/parser.ParseOneWithInt(...)
        	github.com/cockroachdb/cockroach/pkg/sql/parser/parse.go:303
        github.com/cockroachdb/cockroach/pkg/sql/parser.parseExprsWithInt({0xc0122346e8?, 0x68?, 0x3?}, 0xc012234748?)
        	github.com/cockroachdb/cockroach/pkg/sql/parser/parse.go:344 +0xca
        github.com/cockroachdb/cockroach/pkg/sql/parser.ParseExprWithInt({0xc00a80bf60?, 0x6402e98?}, 0x1a12aad?)
        	github.com/cockroachdb/cockroach/pkg/sql/parser/parse.go:381 +0x45
        github.com/cockroachdb/cockroach/pkg/sql/parser.ParseExpr(...)
        	github.com/cockroachdb/cockroach/pkg/sql/parser/parse.go:372
        github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).addComputedColsForTable(0xc021eb74a0, 0xc018bae000, {{0x2?, 0x54cd42a?}, 0x0?})
        	github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/select.go:816 +0x17e
        github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildScan(0xc021eb74a0, 0xc018bae000, {0xc019d8d4a0?, 0x9, 0x6?}, 0xc01e2411d0, {0x0, 0x0, 0xc006dff3b0?}, 0xc017451800, ...)
        	github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/select.go:658 +0x925
        github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildDataSource(0xc021eb74a0, {0x63f56b8?, 0xc032ebf0c0?}, 0xc01e2411d0, {0x0, 0x0, 0x0}, 0xc017451800)
        	github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/select.go:120 +0x7b4
        github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildDataSource(0xc021eb74a0, {0x63f4f38?, 0xc01e241220?}, 0x0?, {0x0?, 0x0?, 0x0?}, 0xc017451800)
        	github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/select.go:65 +0x1145
        github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildFromTablesRightDeep(0xc021eb74a0, {0xc00163aca0, 0x1, 0x1}, {0x0, 0x0, 0x0}, 0x8?)
        	github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/select.go:1235 +0x8d
        github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildFromTables(0x0?, {0xc00163aca0?, 0xc01e030fc0?, 0x0?}, {0x0?, 0x40000?, 0x203007?}, 0x203007?)
        	github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/select.go:1212 +0xb8
        github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildFrom(0xc021eb74a0, {{0xc00163aca0, 0x1, 0x1}, {{0x0, 0x0}}}, {0x0?, 0x0?, 0x0?}, 0xc017451800)
        	github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/select.go:1139 +0x265
        github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildSelectClause(0xc012235cb0?, 0xc033225860, {0xc055a9d880, 0x1, 0x1}, {0x0, 0x0, 0x0}, {0x0, 0x0, ...}, ...)
        	github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/select.go:1060 +0xe5
        github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildSelectStmtWithoutParens(0xc00fe58900?, {0x6435c00?, 0xc033225860?}, {0xc055a9d880?, 0x1, 0x1}, 0xc01e030db0, {0x0, 0x0, 0x0}, ...)
        	github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/select.go:1008 +0x21b
        github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildSelect.func1(0x0?)
        	github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/select.go:977 +0x87
        github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).processWiths(0x44872c?, 0x0?, 0xc01ecc1650?, 0xc012235f68)
        	github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/with.go:117 +0x63
        github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildSelect(0xc021eb74a0, 0x6?, {0x0, 0x0, 0x0}, {0x0, 0x0, 0x0}, 0x203005?)
        	github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/select.go:976 +0x5ab
        github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildStmt(0xc021eb74a0, {0x642c1a0?, 0xc01e241360?}, {0x0, 0x0, 0x0}, 0x0?)
        	github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/builder.go:316 +0x828
        github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildStmtAtRoot(0xc021eb74a0, {0x642c1a0?, 0xc01e241360?}, {0x0?, 0x0?, 0x0?})
        	github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/builder.go:256 +0x1ad
        github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).Build(0xc021eb74a0)
        	github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/builder.go:230 +0x305
        github.com/cockroachdb/cockroach/pkg/sql.(*optPlanningCtx).buildExecMemo(0xc00fe6e210, {0x6402e98?, 0xc01e030fc0})
        	github.com/cockroachdb/cockroach/pkg/sql/plan_opt.go:561 +0x508
        github.com/cockroachdb/cockroach/pkg/sql.(*planner).makeOptimizerPlan(0xc00fe6d880, {0x6402e98?, 0xc01e030f60?})
        	github.com/cockroachdb/cockroach/pkg/sql/plan_opt.go:232 +0x1b1
        github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).makeExecPlan(0xc00fe6d300, {0x6402e98, 0xc01e030f60}, 0xc00fe6d880)
        	github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:1475 +0x4e
        github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).dispatchToExecutionEngine(0xc00fe6d300, {0x6402e98, 0xc01e030f60}, 0xc00fe6d880, {0x7fe84f4f9760, 0xc00f8f82c8})
        	github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:1086 +0x308
        github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execStmtInOpenState(0xc00fe6d300, {0x6402e98?, 0xc01e030e40?}, {{0x642c1a0, 0xc01e241360}, {0xc011287405, 0x1bc}, 0x0, 0x1}, 0x0, ...)
        	github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:694 +0x2378
        github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execStmt.func1({0x6402e98?, 0xc01e030e40?})
        	github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:131 +0xfc
        github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execWithProfiling(0x6402e98?, {0x6402e98?, 0xc01e030e40?}, {0x642c1a0?, 0xc01e241360?}, 0x0?, 0x0?)
        	github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:2440 +0x330
        github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execStmt(0xc00fe6d300, {0x6402e98, 0xc01e030e40}, {{0x642c1a0, 0xc01e241360}, {0xc011287405, 0x1bc}, 0x0, 0x1}, 0x0, ...)
        	github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:130 +0x49f
        github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execCmd.func1({{{0x642c1a0, 0xc01e241360}, {0xc011287405, 0x1bc}, 0x0, 0x1}, {0xc15083c1f3b4cd33, 0x1b659fbf15a, 0x0}, {0xc15083c1f3b4d437, ...}, ...}, ...)
        	github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:2129 +0x306
        github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execCmd(0xc00fe6d300)
        	github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:2133 +0x1168
        github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).run(0xc00fe6d300, {0x6402df0, 0xc003be7480}, 0xc02692da00?, 0x0?, 0xc023563d30?)
        	github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:2054 +0x20b
        github.com/cockroachdb/cockroach/pkg/sql.(*Server).ServeConn(0xc02692db00?, {0x6402df0?, 0xc003be7480?}, {0xc006549000?}, 0x3?, 0xc019167230?)
        	github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:882 +0xe6
        github.com/cockroachdb/cockroach/pkg/sql/pgwire.(*conn).processCommandsAsync.func1()
        	github.com/cockroachdb/cockroach/pkg/sql/pgwire/conn.go:769 +0x54f
        created by github.com/cockroachdb/cockroach/pkg/sql/pgwire.(*conn).processCommandsAsync
        	github.com/cockroachdb/cockroach/pkg/sql/pgwire/conn.go:676 +0x22e


        goroutine 7887904 [runnable]:
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc01196f140)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:184 +0xe32
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc011d824c0)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:141 +0x57c
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc011d824e0)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:141 +0x57c
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc011d824a0)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:132 +0x7ea
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc011d82460)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:136 +0xa65
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc011d82480)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:147 +0x857
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc011d82420)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:132 +0x7ea
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc011d82440)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:141 +0x57c
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc011d82200)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:132 +0x7ea
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc011d823e0)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:141 +0x57c
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc011d82400)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:141 +0x57c
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc011d823c0)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:132 +0x7ea
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc011d822e0)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:136 +0xa65
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc011d82380)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:141 +0x57c
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc011d823a0)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:141 +0x57c
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc011d82360)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:132 +0x7ea
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc011d82320)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:136 +0xa65
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc011d82340)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:141 +0x57c
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc011d82300)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:132 +0x7ea
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc011d822a0)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:132 +0x7ea
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc011d822c0)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:141 +0x57c
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc011d82280)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:132 +0x7ea
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc011d82240)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:136 +0xa65
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc011d82260)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:147 +0x857
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc011d82220)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:132 +0x7ea
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc011d821c0)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:132 +0x7ea
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc011d821e0)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:141 +0x57c
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc011d820e0)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:132 +0x7ea
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc011d82180)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:141 +0x57c
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc011d821a0)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:141 +0x57c
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc011d82160)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:132 +0x7ea
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc011d82120)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:136 +0xa65
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc011d82140)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:147 +0x857
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc011d82100)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:132 +0x7ea
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc011d820a0)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:132 +0x7ea
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc011d820c0)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:141 +0x57c
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc011971ac0)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:132 +0x7ea
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc011d82020)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:141 +0x57c
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc011d82060)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:141 +0x57c
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc011d82080)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:147 +0x857
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc011d82040)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:132 +0x7ea
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc011971e60)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:132 +0x7ea
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc011d82000)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:141 +0x57c
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc011971e40)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:132 +0x7ea
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc011971dc0)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:136 +0xa65
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc011971e00)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:141 +0x57c
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc011971e20)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:141 +0x57c
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc011971de0)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:132 +0x7ea
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc011971d40)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:132 +0x7ea
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc011971d80)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:141 +0x57c
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc011971da0)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:141 +0x57c
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc011971d60)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:132 +0x7ea
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc011971ba0)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:132 +0x7ea
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc011971cc0)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:141 +0x57c
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc011971d00)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:141 +0x57c
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc011971d20)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:147 +0x857
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc011971ce0)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:132 +0x7ea
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc011971c80)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:132 +0x7ea
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc011971ca0)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:141 +0x57c
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc011971c60)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:132 +0x7ea
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc011971be0)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:136 +0xa65
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc011971c20)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:141 +0x57c
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc011971c40)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:141 +0x57c
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc011971c00)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:132 +0x7ea
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc011971bc0)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:132 +0x7ea
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc011971b60)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:132 +0x7ea
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc011971b80)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:141 +0x57c
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc011971b40)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:132 +0x7ea
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc011971b00)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:136 +0xa65
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc011971b20)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:147 +0x857
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc011971ae0)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:132 +0x7ea
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc011971a80)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:132 +0x7ea
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc011971aa0)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:141 +0x57c
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc011971880)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:132 +0x7ea
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc011971a00)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:141 +0x57c
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc011971a40)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:141 +0x57c
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc011971a60)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:147 +0x857
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc011971a20)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:132 +0x7ea
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc0119719c0)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:132 +0x7ea
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc0119719e0)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:141 +0x57c
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc0119719a0)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:132 +0x7ea
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc011971960)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:136 +0xa65
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc011971980)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:141 +0x57c
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc011971920)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:132 +0x7ea
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc011971940)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:141 +0x57c
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc011971900)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:132 +0x7ea
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc0119718c0)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:136 +0xa65
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc0119718e0)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:147 +0x857
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc0119718a0)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:132 +0x7ea
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc011971840)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:132 +0x7ea
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc011971860)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:141 +0x57c
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc01196f1a0)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:132 +0x7ea
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc011970540)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:141 +0x57c
        github.com/cockroachdb/cockroach/pkg/util/pretty.(*beExec).be(0xc04241bc30, {0xf650?, 0x2789?}, 0xc0119717e0)
        	github.com/cockroachdb/cockroach/pkg/util/pretty/pretty.go:141 +0x57c
        created by golang.org/x/sync/errgroup.(*Group).Go
        	golang.org/x/sync/errgroup/external/org_golang_x_sync/errgroup/errgroup.go:71 +0xa5

        goroutine 8140063 [runnable]:
        github.com/cockroachdb/cockroach/pkg/sql/parser.sqllex1({0x63dac90?, 0xc011c8c118?}, 0xc011c8c180?)
        	yaccpar:117 +0x19d
        github.com/cockroachdb/cockroach/pkg/sql/parser.(*sqlParserImpl).Parse(0xc011c8c180, {0x63dac90?, 0xc011c8c118?})
        	yaccpar:204 +0x7f69f
        github.com/cockroachdb/cockroach/pkg/sql/parser.(*Parser).parse(0xc011c8c0e8, 0x46f445?, {0xc010ce0000, 0x36a}, {0xc011de4000?, 0x1000?, 0x7fe847deefff?}, 0x7fe847c56100?)
        	github.com/cockroachdb/cockroach/pkg/sql/parser/parse.go:228 +0x1b1
        github.com/cockroachdb/cockroach/pkg/sql/parser.(*Parser).parseWithDepth(0xc011c8c0e8, 0x1, {0xc010ce0000?, 0x36a}, 0x4d1c420?)
        	github.com/cockroachdb/cockroach/pkg/sql/parser/parse.go:208 +0x1b6
        github.com/cockroachdb/cockroach/pkg/sql/parser.(*Parser).ParseWithInt(...)
        	github.com/cockroachdb/cockroach/pkg/sql/parser/parse.go:140
        github.com/cockroachdb/cockroach/pkg/sql/pgwire.(*conn).handleSimpleQuery(0xc011c8c000, {0x6402df0, 0xc0417b0a80}, 0x6402df0?, {0xc0417b0a80?, 0x461500?, 0x0?}, 0xc0018ad310?)
        	github.com/cockroachdb/cockroach/pkg/sql/pgwire/conn.go:868 +0x114
        github.com/cockroachdb/cockroach/pkg/sql/pgwire.(*conn).serveImpl.func5(0xc011c8c000, 0xc04103aa00, 0xc0018ad442, 0xc0018ad444, {0x63f3978, 0xc037990dc0}, 0xc006549000, 0xc00fdeacc0, 0xc0018ad440)
        	github.com/cockroachdb/cockroach/pkg/sql/pgwire/conn.go:508 +0x5fa
        github.com/cockroachdb/cockroach/pkg/sql/pgwire.(*conn).serveImpl(0xc011c8c000, {0x6402e98, 0xc01226e120}, 0xc04103a9f0, 0xc006549000, 0xc01226e090, {0x0, 0x4, {0x1, {0x54b7d41, ...}, ...}, ...})
        	github.com/cockroachdb/cockroach/pkg/sql/pgwire/conn.go:575 +0xc8d
        github.com/cockroachdb/cockroach/pkg/sql/pgwire.(*Server).serveConn(0xc018959680, {0x6402e98, 0xc01226e120}, {0x6443028, 0xc014c12e00}, {{{0xc00f6e902f, 0x4}}, 0x1, 0xc01226e0c0, 0xc01226e0f0, ...}, ...)
        	github.com/cockroachdb/cockroach/pkg/sql/pgwire/conn.go:174 +0x29e
        github.com/cockroachdb/cockroach/pkg/sql/pgwire.(*Server).ServeConn(0xc018959680, {0x6402e98, 0xc01226e120}, {0x64493d8?, 0xc042fd8b10}, 0x90?)
        	github.com/cockroachdb/cockroach/pkg/sql/pgwire/server.go:921 +0xd29
        github.com/cockroachdb/cockroach/pkg/server.(*SQLServer).startServeSQL.func1.1({0x6402e98?, 0xc01d580840?}, {0x64493d8, 0xc042fd8b10})
        	github.com/cockroachdb/cockroach/pkg/server/server_sql.go:1478 +0xc8
        github.com/cockroachdb/cockroach/pkg/util/netutil.(*Server).ServeWith.func1({0x6402e98, 0xc01d580840})
        	github.com/cockroachdb/cockroach/pkg/util/netutil/net.go:162 +0xd7
        github.com/cockroachdb/cockroach/pkg/util/stop.(*Stopper).RunAsyncTaskEx.func2()
        	github.com/cockroachdb/cockroach/pkg/util/stop/stopper.go:489 +0x146
        created by github.com/cockroachdb/cockroach/pkg/util/stop.(*Stopper).RunAsyncTaskEx
        	github.com/cockroachdb/cockroach/pkg/util/stop/stopper.go:480 +0x43b


@DrewKimball
Copy link
Collaborator

Maybe a dupe of #91197?

@DrewKimball
Copy link
Collaborator

Closing as dupe of #91197

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
branch-release-22.2 Used to mark GA and release blockers, technical advisories, and bugs for 22.2 C-test-failure Broken test (automatically or manually discovered). O-robot Originated from a bot. T-sql-queries SQL Queries Team
Projects
Archived in project
Development

No branches or pull requests

4 participants