roachtest: unoptimized-query-oracle/disable-rules=all/rand-tables failed

[cockroach-teamcity]

roachtest.unoptimized-query-oracle/disable-rules=all/rand-tables failed with artifacts on master @ c4ab095c4f65b9140661ed57adddc690b1e3ce3f:

  	"NULL,3.3710177345490564,0,-7417,☃,BOX(100000 -9.99,99900100000"...,
  	... // 6 identical elements
  }
sql: SELECT
	tab_568.col5_4 AS col_1714,
	tab_568.c😌ol5_15 AS col_1715,
	0:::OID AS col_1716,
	tab_568.col5_10 AS col_1717,
	tab_568.col5_16 AS col_1718,
	'BOX(100000 -9.99,99900100000 88799999990.01)':::BOX2D AS col_1719,
	'a ':::STRING AS col_1720,
	tab_568."c}o l5_17" AS col_1721,
	tab_568.col5_13 AS col_1722,
	e'\U000D6993\U0001994C\U0007F022\U000D346D\U000BC3E7\U000EDADD\U0008B214' COLLATE da_DK AS col_1723
FROM
	defaultdb.public.table_5@[0] AS tab_568
ORDER BY
	tab_568.col5_1 NULLS FIRST,
	tab_568.col5_4 ASC,
	col_1720 DESC NULLS LAST,
	tab_568."c ol5'_8" ASC NULLS LAST,
	tab_568.crdb_internal_mvcc_timestamp DESC NULLS FIRST,
	tab_568.col5_16 DESC NULLS LAST,
	tab_568."co'l5_9" NULLS FIRST,
	tab_568."co😗l5""_0" DESC,
	tab_568.col5_14 ASC NULLS LAST,
	col_1723 DESC NULLS LAST,
	tab_568.c😌ol5_15 NULLS LAST,
	tab_568.col5_5 DESC NULLS FIRST,
	tab_568.col5_7 NULLS FIRST,
	tab_568."c}o l5_17" ASC NULLS LAST,
	col_1721 DESC NULLS FIRST,
	tab_568." col5_12" ASC,
	col_1714 NULLS FIRST,
	tab_568."""c ol 	5_3" DESC NULLS LAST,
	tab_568.col5_13 NULLS FIRST,
	col_1717,
	col_1718 ASC NULLS FIRST,
	col_1719 ASC,
	tab_568."col%p5_11",
	col_1722,
	tab_568.col5_2 DESC NULLS LAST,
	col_1715,
	col_1716 NULLS FIRST,
	tab_568.col5_10 ASC,
	tab_568.tableoid NULLS FIRST,
	tab_568.c̘ol5_6 NULLS LAST
LIMIT
	67:::INT8
test artifacts and logs in: /artifacts/unoptimized-query-oracle/disable-rules=all/rand-tables/run_1

Parameters:

• ROACHTEST_arch=amd64
• ROACHTEST_cloud=gce
• ROACHTEST_coverageBuild=false
• ROACHTEST_cpu=4
• ROACHTEST_encrypted=false
• ROACHTEST_metamorphicBuild=false
• ROACHTEST_ssd=0

Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

Same failure on other branches

• roachtest: [LIMIT dropped with row-based engine] unoptimized-query-oracle/disable-rules=all/rand-tables failed #122748 roachtest: unoptimized-query-oracle/disable-rules=all/rand-tables failed [C-test-failure O-roachtest O-robot O-rsg T-sql-queries branch-release-23.2 release-blocker]
• roachtest: [- replaced with 0] unoptimized-query-oracle/disable-rules=all/rand-tables failed #118273 roachtest: unoptimized-query-oracle/disable-rules=all/rand-tables failed [C-test-failure O-roachtest O-robot P-3 T-sql-queries branch-release-23.1]

/cc @cockroachdb/sql-queries

This test on roachdash | Improve this report!

Jira issue: CRDB-38049

[cockroach-teamcity]

roachtest.unoptimized-query-oracle/disable-rules=all/rand-tables failed with artifacts on master @ e0068814dfcb4f975a53b79b5546b5fb85c0f927:

+ 	" ",
+ 	" ",
+ 	" ",
+ 	" ",
+ 	" ",
+ 	" ",
+ 	" ",
  }
sql: SELECT
	' ':::STRING AS col_146
FROM
	(
		SELECT
			(e'l\x06k':::STRING, '''M'':457B,948C,996C ''evTqRcY'':190A,627A ''mju'':211C,433C ''t''':::TSVECTOR)
				AS col_134,
			tab_45.col3_3 AS col_135,
			tab_45.tableoid AS col_136,
			tab_45.col3_1 AS col_137,
			tab_45."co%ql|3_0" AS col_138,
			tab_45."col3_2" AS col_139
		FROM
			defaultdb.public.table_3@[0] AS tab_45
		ORDER BY
			col_134,
			col_138 DESC NULLS LAST,
			tab_45."col3_2" ASC NULLS LAST,
			tab_45.tableoid DESC,
			tab_45."co%ql|3_0",
			col_137 NULLS FIRST,
			col_139 ASC NULLS LAST,
			col_135 ASC,
			tab_45.col3_3,
			tab_45.col3_1 DESC,
			tab_45.crdb_internal_mvcc_timestamp ASC NULLS FIRST,
			col_136 ASC NULLS FIRST
		LIMIT
			29:::INT8
	)
		AS tab_46 (col_140, col_141, col_142, col_143, col_144, col_145)
ORDER BY
	tab_46.col_144 DESC,
	col_146 ASC NULLS FIRST,
	tab_46.col_143,
	tab_46.col_145 ASC NULLS FIRST,
	tab_46.col_140 DESC NULLS FIRST,
	tab_46.col_141 ASC NULLS LAST,
	tab_46.col_142 ASC NULLS FIRST
LIMIT
	17:::INT8
test artifacts and logs in: /artifacts/unoptimized-query-oracle/disable-rules=all/rand-tables/run_1

Parameters:

• ROACHTEST_arch=amd64
• ROACHTEST_cloud=gce
• ROACHTEST_coverageBuild=false
• ROACHTEST_cpu=4
• ROACHTEST_encrypted=false
• ROACHTEST_metamorphicBuild=false
• ROACHTEST_ssd=0

Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

Same failure on other branches

• roachtest: [LIMIT dropped with row-based engine] unoptimized-query-oracle/disable-rules=all/rand-tables failed #122748 roachtest: unoptimized-query-oracle/disable-rules=all/rand-tables failed [C-test-failure O-roachtest O-robot O-rsg T-sql-queries branch-release-23.2 release-blocker]
• roachtest: [- replaced with 0] unoptimized-query-oracle/disable-rules=all/rand-tables failed #118273 roachtest: unoptimized-query-oracle/disable-rules=all/rand-tables failed [C-test-failure O-roachtest O-robot P-3 T-sql-queries branch-release-23.1]

This test on roachdash | Improve this report!

[rytaft]

Dup of #122748