pkg/ccl/testccl/sqlccl/sqlccl_test: TestShowCreateRedactableValues failed

[github-actions]

pkg/ccl/testccl/sqlccl/sqlccl_test.TestShowCreateRedactableValues failed on master @ d8073b58467ddb4c5b2ebe4a485fc42fb98f7200:

Fatal error:

panic: test timed out after 4m57s
running tests:
	TestShowCreateRedactableValues (4m57s)

Stack:

goroutine 29526 [running]:
testing.(*M).startAlarm.func1()
	GOROOT/src/testing/testing.go:2366 +0x385
created by time.goFunc
	GOROOT/src/time/sleep.go:177 +0x2d

Log preceding fatal error

=== RUN   TestShowCreateRedactableValues
    test_log_scope.go:170: test logs captured to: outputs.zip/logTestShowCreateRedactableValues418509647
    test_log_scope.go:81: use -show-logs to present logs inline
    show_create_test.go:35: seed: 5556913777450944447
    test_server_shim.go:157: automatically injected a shared process virtual cluster under test; see comment at top of test_server_shim.go for details.
    show_create_test.go:86: SET CLUSTER SETTING sql.stats.automatic_collection.enabled = false;
    show_create_test.go:86: SET CLUSTER SETTING sql.stats.histogram_collection.enabled = false;
    show_create_test.go:86: CREATE TABLE table_1 (col1_0 STRING COLLATE en_US NULL, col1_1 DECIMAL[] NOT NULL, col1_2 DATE, col😀1😎_3 GEOGRAPHY NOT NULL, col1_4 BOX2D NOT NULL, "c\vol1_5" GEOMETRY, col1_6 BIT(45) NOT NULL, "c o%pl😤1_7" OID, 🙄c🙁ol1_8 FLOAT8 NOT NULL, col1_9 BIT(2) NOT NULL, col1_10 UUID NOT NULL, col1_11 GEOMETRY NOT NULL, "�col1\\x25_12" BOOL NOT NULL, col1_13 FLOAT8 NOT NULL AS (🙄c🙁ol1_8 + 1.3200237197440075:::FLOAT8) STORED, col1_14 STRING NULL AS (lower(CAST(col1_0 AS STRING))) STORED, "co l1😲_15" STRING NOT NULL AS (lower(CAST("�col1\\x25_12" AS STRING))) VIRTUAL, col1_16 STRING AS (CASE WHEN col1_2 IS NULL THEN 'allosaurus6':::STRING ELSE e'T\x04B+H\f\'w':::STRING END) STORED, PRIMARY KEY (col1_10), INDEX (col1_13 ASC, col1_2) WHERE (((((table_1.col1_14 = e'\'':::STRING) OR (table_1."co l1😲_15" >= 'allosaurusX':::STRING)) OR (table_1.🙄c🙁ol1_8 = (-1.0):::FLOAT8)) AND (table_1.col1_2 >= 'infinity':::DATE)) AND table_1."�col1\\x25_12") AND (table_1.col1_16 <= e'allosaurus\x00':::STRING), UNIQUE ("�col1\\x25_12" DESC, "co l1😲_15" DESC) STORING (col1_1, col😀1😎_3, "c o%pl😤1_7", 🙄c🙁ol1_8, col1_13, col1_14, col1_16) WHERE ((((((table_1.col1_14 < e'allosaurus\U00002603':::STRING) AND (table_1.col1_16 != e'allosaurus\x00':::STRING)) OR table_1."�col1\\x25_12") AND (table_1.🙄c🙁ol1_8 != (-1.0):::FLOAT8)) OR (table_1.col1_13 < 5e-324:::FLOAT8)) OR (table_1."co l1😲_15" <= 'allosaurusX':::STRING)) AND (table_1.col1_2 != 'infinity':::DATE), INDEX (lower(CAST(col1_4 AS STRING)) ASC, col1_1), INVERTED INDEX (col1_16 gin_trgm_ops ASC) WHERE ((((((table_1.🙄c🙁ol1_8 >= 5e-324:::FLOAT8) AND (table_1."co l1😲_15" > e'\'':::STRING)) OR (table_1.col1_14 > 'allosaurusX':::STRING)) OR (table_1.col1_2 <= '5874897-12-31':::DATE)) AND (table_1.col1_16 = e'\'':::STRING)) OR (NOT table_1."�col1\\x25_12")) OR (table_1.col1_13 <= 'NaN':::FLOAT8), UNIQUE (lower(CAST(col1_0 AS STRING)) ASC, col1_4 ASC), INDEX (col1_1 DESC))
    show_create_test.go:86: CREATE TABLE table_2 ("col2 _0" STRING NOT NULL, col2_1 GEOMETRY NOT NULL, "	col2_2" NAME NOT NULL, col2͝_3 UUID NOT NULL, PRIMARY KEY ("col2 _0" ASC, "	col2_2" ASC))
    show_create_test.go:86: CREATE TABLE "ta\\xccble_3" (col3_0 TIMETZ NOT NULL, "co!l3_1" PG_LSN NOT NULL, col3_2 INT4 NULL, "c""ol3_3" FLOAT8 NOT NULL, PRIMARY KEY (col3_0), INDEX (col3_2 DESC, col3_0) WHERE (("ta\\xccble_3".col3_2 = (-2147483648):::INT8) OR ("ta\\xccble_3".col3_0 = '00:00:00+15:59':::TIMETZ)) AND ("ta\\xccble_3"."c""ol3_3" > '-Inf':::FLOAT8), UNIQUE (col3_2, col3_0) STORING ("co!l3_1"), INDEX (col3_2 DESC) STORING ("co!l3_1", "c""ol3_3") PARTITION BY LIST (col3_2) (PARTITION "ta\\x😪c😯cble_3_part_0" VALUES IN (((-875131360):::INT8,), (1508098969:::INT8,), (352242523:::INT8,), ((-1102959645):::INT8,), (385072170:::INT8,)), PARTITION "ta\\xccble_3_part_1" VALUES IN (((-1794732500):::INT8,), ((-1347828445):::INT8,), (1238296748:::INT8,), (2063622529:::INT8,), ((-197669238):::INT8,)), PARTITION "ta\\xccble_3_part_2" VALUES IN ((1370404045:::INT8,), ((-1210792288):::INT8,), (770325891:::INT8,), ((-1648136352):::INT8,), (106464056:::INT8,)), PARTITION "ta \\xccble_3_part_3" VALUES IN ((541819368:::INT8,), ((-765348627):::INT8,), ((-1118905368):::INT8,), ((-2061749790):::INT8,), ((-387677565):::INT8,)), PARTITION "ta\\xccble_3_part_4" VALUES IN ((1496459390:::INT8,), (217451178:::INT8,), ((-360720261):::INT8,), ((-150627823):::INT8,), (2143316998:::INT8,)), PARTITION "ta\\x ccble_3_part͓_5" VALUES IN (((-334075168):::INT8,), (211296881:::INT8,), (2076942240:::INT8,), (312690188:::INT8,), ((-1859668313):::INT8,)), PARTITION "ta\\xccble_3_part_6" VALUES IN (((-717036805):::INT8,), ((-1604179804):::INT8,), ((-863990209):::INT8,), (466823453:::INT8,), (762026986:::INT8,)), PARTITION "ta\\xc😓cble_3_paRt_7" VALUES IN ((719900620:::INT8,), (556210549:::INT8,), ((-617239800):::INT8,), ((-250471613):::INT8,), ((-1402074208):::INT8,)), PARTITION "ta\\xccble_3_part_8" VALUES IN (((-3485783):::INT8,), (1320778459:::INT8,), (176084254:::INT8,), ((-1725687768):::INT8,), (2130409689:::INT8,)), PARTITION "DEFAULT" VALUES IN ((DEFAULT,))) WHERE (("ta\\xccble_3".col3_2 <= 0:::INT8) OR ("ta\\xccble_3"."c""ol3_3" > '-Inf':::FLOAT8)) AND ("ta\\xccble_3".col3_0 != '00:00:00+15:59':::TIMETZ) NOT VISIBLE, INDEX (lower(CAST("co!l3_1" AS STRING)) ASC) WHERE "ta\\xccble_3"."c""ol3_3" != 3.4028234663852886e+38:::FLOAT8 VISIBILITY 0.60, UNIQUE (lower(CAST(col3_0 AS STRING)) DESC), UNIQUE (col3_0 ASC, col3_2 ASC), INDEX (lower(CAST("co!l3_1" AS STRING)), col3_2 ASC) STORING ("co!l3_1", "c""ol3_3"), INDEX (col3_2 ASC) NOT VISIBLE, FAMILY (col3_2), FAMILY (col3_0), FAMILY ("co!l3_1", "c""ol3_3"))
    show_create_test.go:86: CREATE TABLE table_4 ("%qcol\\U001019C6😞4_0" INET[] NOT NULL, col4_1 BIT(32) NOT NULL, "col""4_2" JSONB NOT NULL, "cOl4_3" CHAR NOT NULL, col4_4 NAME NOT NULL, col4_5 FLOAT4 NOT NULL, "col�4_6" STRING COLLATE en_US NOT NULL, "c͊%b3ol4_7" TSVECTOR, col4_8 NAME, " col4_9" STRING COLLATE de_DE, col4_10 NAME NULL, "col4%v_11" INT4 NOT NULL, "?col4_12" UUID NOT NULL, "co'l4_13" STRING NULL AS (lower(col4_10)) VIRTUAL, col4_14 STRING NOT NULL AS (lower(CAST("?col4_12" AS STRING))) STORED, co😑l4_15 STRING NULL AS (lower(col4_10)) STORED, FAMILY ("col""4_2"), FAMILY ("c͊%b3ol4_7"), FAMILY (col4_4, col4_10, "cOl4_3"), FAMILY ("col4%v_11", "col�4_6", col4_5, col4_8), FAMILY (col4_1), FAMILY ("%qcol\\U001019C6😞4_0", col4_14, co😑l4_15, "?col4_12"), FAMILY (" col4_9"))
    show_create_test.go:86: CREATE TABLE table_5 (col5_0 REFCURSOR NOT NULL, col5_1 STRING, col5_2 INT4 NOT NULL, col5_3 GEOGRAPHY NOT NULL, col5_4 INT4 NOT NULL, "col(5_5" TIMESTAMP NOT NULL, "%7bcol-%v5_6" INT8 NOT NULL AS (col5_2 + col5_4) STORED, "co'l5😘_7" STRING NOT NULL AS (lower(CAST(col5_0 AS STRING))) STORED, "c(o\\u132Bl5_8" INT8 NOT NULL AS (col5_4 + col5_2) STORED, col5_9 INT8 NOT NULL AS (col5_2 + col5_4) STORED, UNIQUE ("%7bcol-%v5_6" DESC) PARTITION BY LIST ("%7bcol-%v5_6") (PARTITION table_5_part_0 VALUES IN ((6329962212375086123:::INT8,), (3369445162914711511:::INT8,)), PARTITION table_5_part_1 VALUES IN (((-6652771908964821417):::INT8,), ((-9223372036854775807):::INT8,)), PARTITION table_5_part_2 VALUES IN ((8423945906463835475:::INT8,), (7364570321254649960:::INT8,))) WHERE (((((table_5.col5_1 < 'allosaurus"':::STRING) AND (table_5.col5_9 < 0:::INT8)) OR (table_5."co'l5😘_7" = e'\'':::STRING)) AND (table_5."%7bcol-%v5_6" < (-2147483648):::INT8)) AND (table_5."c(o\\u132Bl5_8" > 127:::INT8)) OR (table_5.col5_2 > (-2147483648):::INT8), INVERTED INDEX (col5_4 ASC, col5_1 gin_trgm_ops ASC) WHERE (((((((table_5.col5_9 < 1:::INT8) AND (table_5.col5_4 >= 32767:::INT8)) OR (table_5.col5_2 = 0:::INT8)) OR (table_5."c(o\\u132Bl5_8" != 127:::INT8)) OR (table_5."%7bcol-%v5_6" <= 9223372036854775807:::INT8)) OR (table_5.col5_1 >= e'allosaurus\U00002603':::STRING)) OR (table_5."co'l5😘_7" = 'allosaurusX':::STRING)) AND (table_5."col(5_5" <= '4714-11-24 00:00:00 BC':::TIMESTAMP))
    show_create_test.go:86: ALTER TABLE table_1 INJECT STATISTICS e'[{"avg_size": 22, "columns": ["col1_0"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 3585784968838928890, "histo_col_type": "", "name": "__auto__", "null_count": 2514550547579941875, "row_count": 4680452097608034456}, {"avg_size": 5, "columns": ["col1_1"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 4218018463005590967, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 4680452097608034456}, {"avg_size": 13, "columns": ["col1_2"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 345720724516229571, "histo_col_type": "", "name": "__auto__", "null_count": 3311816551238172821, "row_count": 4680452097608034456}, {"avg_size": 15, "columns": ["col\U0001F6001\U0001F60E_3"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 2907665074860799798, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 4680452097608034456}, {"avg_size": 16, "columns": ["col1_4"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 3372535119967525189, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 4680452097608034456}, {"avg_size": 9, "columns": ["\\"c\\\\vol1_5\\""], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 306476571637098113, "histo_col_type": "", "name": "__auto__", "null_count": 2753200414149112859, "row_count": 4680452097608034456}, {"avg_size": 4, "columns": ["col1_6"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 5607026790908745, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 4680452097608034456}, {"avg_size": 9, "columns": ["\\"c o%pl\U0001F6241_7\\""], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 923434822467034662, "histo_col_type": "", "name": "__auto__", "null_count": 2785922159075870594, "row_count": 4680452097608034456}, {"avg_size": 4, "columns": ["\U0001F644c\U0001F641ol1_8"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 4478856882300170231, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 4680452097608034456}, {"avg_size": 7, "columns": ["col1_9"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 369381688086872596, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 4680452097608034456}, {"avg_size": 15, "columns": ["col1_10"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 39044700065630430, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 4680452097608034456}, {"avg_size": 13, "columns": ["col1_11"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 4044982223974703, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 4680452097608034456}, {"avg_size": 20, "columns": ["\\"\\u000bcol1\\\\\\\\x25_12\\""], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 1512984621672586607, "histo_buckets": [{"distinct_range": 0, "num_eq": 1579209224690809752, "num_range": 0, "upper_bound": "false"}], "histo_col_type": "BOOL", "histo_version": 3, "name": "__auto__", "null_count": 0, "row_count": 4680452097608034456}, {"avg_size": 13, "columns": ["col1_13"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 4220395127410041087, "histo_buckets": [{"distinct_range": 0, "num_eq": 7000000000, "num_range": 0, "upper_bound": "1.32161483344786"}, {"distinct_range": 307.6911277500215, "num_eq": 200000000, "num_range": 1000, "upper_bound": "-0.029892111560045453"}, {"distinct_range": 100000, "num_eq": 3476719557065752418, "num_range": 100000, "upper_bound": "-0.4393674453942997"}, {"distinct_range": 7962760914646844000, "num_eq": 912214547501136587, "num_range": 7962760914646844248, "upper_bound": "-0.48375605487057693"}, {"distinct_range": 0, "num_eq": 30000000000, "num_range": 700, "upper_bound": "-0.7033875502939244"}], "histo_col_type": "FLOAT8", "histo_version": 3, "name": "__auto__", "null_count": 0, "row_count": 4680452097608034456}, {"avg_size": 31, "columns": ["col1_14"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 599658023305603771, "histo_col_type": "", "name": "__auto__", "null_count": 4188072564012998473, "row_count": 4680452097608034456}, {"avg_size": 30, "columns": ["\\"co l1\U0001F632_15\\""], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 1551123861326613971, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 4680452097608034456}, {"avg_size": 4, "columns": ["col1_16"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 3376726552266828593, "histo_buckets": [{"distinct_range": 0, "num_eq": 200000000, "num_range": 0, "upper_bound": "(\\u0003Jh\\u0008%<a9"}, {"distinct_range": 7000, "num_eq": 50000000, "num_range": 7000, "upper_bound": "\x7f\x7f4tZO|g@"}], "histo_col_type": "STRING", "histo_version": 3, "name": "__auto__", "null_count": 1566418113762420652, "row_count": 4680452097608034456}]':::JSONB
    show_create_test.go:86: ALTER TABLE table_2 INJECT STATISTICS e'[{"avg_size": 30, "columns": ["\\"col2 _0\\""], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 49019, "histo_buckets": [{"distinct_range": 0, "num_eq": 2057024968157181158, "num_range": 0, "upper_bound": "zJ7"}], "histo_col_type": "STRING", "histo_version": 3, "name": "__auto__", "null_count": 0, "row_count": 100000}, {"avg_size": 17, "columns": ["col2_1"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 87716, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 100000}, {"avg_size": 21, "columns": ["\\"\\tcol2_2\\""], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 64387, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 100000}, {"avg_size": 8, "columns": ["col2\u035D_3"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 32578, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 100000}]':::JSONB
    show_create_test.go:86: ALTER TABLE "ta\\xccble_3" INJECT STATISTICS e'[{"avg_size": 17, "columns": ["col3_0"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 2780770748178692399, "histo_col_type": "TIMETZ", "histo_version": 3, "name": "__auto__", "null_count": 0, "row_count": 4813271517705663302}, {"avg_size": 22, "columns": ["\\"co!l3_1\\""], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 3397699409174336298, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 4813271517705663302}, {"avg_size": 22, "columns": ["col3_2"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 3237933750698753349, "histo_col_type": "INT4", "histo_version": 3, "name": "__auto__", "null_count": 2357649698564474868, "row_count": 4813271517705663302}, {"avg_size": 8, "columns": ["\\"c\\"\\"ol3_3\\""], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 3636827187281636985, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 4813271517705663302}]':::JSONB
    show_create_test.go:86: ALTER TABLE table_4 INJECT STATISTICS e'[{"avg_size": 24, "columns": ["\\"%qcol\\\\\\\\U001019C6\U0001F61E4_0\\""], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 291162052845885433, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 333455262981663582}, {"avg_size": 31, "columns": ["col4_1"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 185639049291133032, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 333455262981663582}, {"avg_size": 7, "columns": ["\\"col\\"\\"4_2\\""], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 139107180746574881, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 333455262981663582}, {"avg_size": 7, "columns": ["\\"cOl4_3\\""], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 43949024087168457, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 333455262981663582}, {"avg_size": 0, "columns": ["col4_4"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 332937992980853429, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 333455262981663582}, {"avg_size": 23, "columns": ["col4_5"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 308002087781250500, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 333455262981663582}, {"avg_size": 7, "columns": ["\\"col\\u000b4_6\\""], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 83697941043195239, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 333455262981663582}, {"avg_size": 1, "columns": ["\\"c\u034A%b3ol4_7\\""], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 112073128987813325, "histo_col_type": "", "name": "__auto__", "null_count": 181691148029719195, "row_count": 333455262981663582}, {"avg_size": 27, "columns": ["col4_8"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 271509527573460933, "histo_col_type": "", "name": "__auto__", "null_count": 231362963433955768, "row_count": 333455262981663582}, {"avg_size": 14, "columns": ["\\" col4_9\\""], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 253301597732790954, "histo_col_type": "", "name": "__auto__", "null_count": 174651503766562649, "row_count": 333455262981663582}, {"avg_size": 11, "columns": ["col4_10"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 99490902228740934, "histo_col_type": "", "name": "__auto__", "null_count": 34481996002195711, "row_count": 333455262981663582}, {"avg_size": 19, "columns": ["\\"col4%v_11\\""], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 66301676650470800, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 333455262981663582}, {"avg_size": 0, "columns": ["\\"?col4_12\\""], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 238603569523189744, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 333455262981663582}, {"avg_size": 0, "columns": ["\\"co\'l4_13\\""], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 137344378580496435, "histo_col_type": "", "name": "__auto__", "null_count": 191388799022754050, "row_count": 333455262981663582}, {"avg_size": 21, "columns": ["col4_14"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 93223178706375256, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 333455262981663582}, {"avg_size": 0, "columns": ["co\U0001F611l4_15"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 32050719741386492, "histo_col_type": "", "name": "__auto__", "null_count": 144440560764154725, "row_count": 333455262981663582}]':::JSONB
    show_create_test.go:86: ALTER TABLE table_5 INJECT STATISTICS e'[{"avg_size": 0, "columns": ["col5_0"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 0, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 0}, {"avg_size": 0, "columns": ["col5_1"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 0, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 0}, {"avg_size": 0, "columns": ["col5_2"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 0, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 0}, {"avg_size": 0, "columns": ["col5_3"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 0, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 0}, {"avg_size": 0, "columns": ["col5_4"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 0, "histo_buckets": [{"distinct_range": 0, "num_eq": 5000, "num_range": 0, "upper_bound": "-1"}, {"distinct_range": 7496302739846403000, "num_eq": 6275724960941871356, "num_range": 7496302739846403267, "upper_bound": "-832118091"}, {"distinct_range": 5047264127.087689, "num_eq": 0, "num_range": 9000000000, "upper_bound": "-1899667987"}, {"distinct_range": 100, "num_eq": 8000000, "num_range": 100, "upper_bound": "2005538163"}, {"distinct_range": 0, "num_eq": 192508939535282723, "num_range": 9000000000, "upper_bound": "-233010684"}, {"distinct_range": 0, "num_eq": 30000000, "num_range": 3336163022591283633, "upper_bound": "-1571973439"}, {"distinct_range": 5823607422079412000, "num_eq": 0, "num_range": 6676927090318937870, "upper_bound": "-32768"}], "histo_col_type": "INT4", "histo_version": 3, "name": "__auto__", "null_count": 0, "row_count": 0}, {"avg_size": 0, "columns": ["\\"col(5_5\\""], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 0, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 0}, {"avg_size": 0, "columns": ["\\"%7bcol-%v5_6\\""], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 0, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 0}, {"avg_size": 0, "columns": ["\\"co\'l5\U0001F618_7\\""], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 0, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 0}, {"avg_size": 0, "columns": ["\\"c(o\\\\\\\\u132Bl5_8\\""], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 0, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 0}, {"avg_size": 0, "columns": ["col5_9"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 0, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 0}]':::JSONB
    show_create_test.go:86: CREATE TYPE rand_typ_0 AS ENUM ('oynpcu', 'fhar', 'le')
    show_create_test.go:86: CREATE TYPE rand_typ_1 AS ENUM ('bhbo', 'dzsro', 'gpqh', 'fqqefd')
    show_create_test.go:86: SET statement_timeout = '30s';
    show_create_test.go:108: CREATE SEQUENCE defaultdb.public.seq_1
    show_create_test.go:108: CREATE OR REPLACE FUNCTION "fun\\U0008000Bc_1"(p0 TIMESTAMPTZ DEFAULT '2017-01-12 04:09:05.000296+00':::TIMESTAMPTZ, IN p1 FLOAT4 DEFAULT 0.02799028903245926:::FLOAT8)
        	RETURNS SETOF RECORD
        	LANGUAGE SQL
        	STABLE
        	NOT LEAKPROOF
        	AS $funcbody$
        SELECT p1 AS col_1, p0 AS col_2;
        SELECT count(*) AS col_3 FROM defaultdb.public."ta\\xccble_3"@"ta\\xccble_3_expr_idx" AS tab_2 GROUP BY tab_2.col3_0 HAVING bool_or(true::BOOL)::BOOL;
        SELECT NULL AS col_4, tab_4.col4_1 AS "col
        _5", tab_4."c͊%b3ol4_7" AS "co\vl_6" FROM defaultdb.public.table_4@[0] AS "😸tAb_3" JOIN defaultdb.public.table_4@[0] AS tab_4 ON (((("😸tAb_3".col4_14) = (tab_4.col4_10)) AND (("😸tAb_3"."co'l4_13") = (tab_4.co😑l4_15))) AND (("😸tAb_3".col4_4) = (tab_4.col4_10))) AND (("😸tAb_3".col4_4) = (tab_4."co'l4_13")) WHERE (true OR currval('defaultdb.public.seq_1':::STRING)::BOOL) LIMIT 93:::INT8;
        SELECT count(*) AS "Col_7" FROM defaultdb.public.table_2 AS tab_5 WHERE true GROUP BY tab_5."col2 _0" LIMIT 28:::INT8;
        SELECT p0 AS "col _8", NULL AS col_9, e'allosaurus\x00':::STRING AS col_10, tab_6."	col2_2" AS col_11, tab_7."col2 _0" AS col_12, 0.2554199993610382:::FLOAT8 AS col_13 FROM defaultdb.public.table_2 AS tab_6 JOIN defaultdb.public.table_2 AS tab_7 ON ((tab_6."col2 _0") = (tab_7."col2 _0")) AND ((tab_6."	col2_2") = (tab_7."	col2_2")) WHERE false;
        SELECT NULL AS """col _14" FROM defaultdb.public.table_5 AS " taB_8" JOIN defaultdb.public.table_5 AS "\\U0003BAEBtab_9" ON (" taB_8"."%7bcol-%v5_6") = ("\\U0003BAEBtab_9"."%7bcol-%v5_6") JOIN defaultdb.public."ta\\xccble_3"@"ta\\xccble_3_col3_2_col3_0_key" AS tab_10 INNER JOIN defaultdb.public."ta\\xccble_3"@"ta\\xccble_3_col3_2_col3_0_key" AS tab_11 ON NULL ON true LIMIT 26:::INT8
        $funcbody$
    show_create_test.go:108: ALTER TABLE defaultdb.public."ta\\xccble_3" ALTER PRIMARY KEY USING COLUMNS ("co!l3_1")

Parameters:

• attempt=1
• run=1
• shard=11

Help

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

Same failure on other branches

• pkg/ccl/testccl/sqlccl/sqlccl_test: TestShowCreateRedactableValues failed #124217 pkg/ccl/testccl/sqlccl/sqlccl_test: TestShowCreateRedactableValues failed [C-test-failure O-robot T-sql-queries branch-release-23.1 release-blocker]

This test on roachdash | Improve this report!

Jira issue: CRDB-38825

[yuzefovich]

dup of #123017 that has been fixed