roachtest: unoptimized-query-oracle/disable-rules=half failed

[mgartner]

From #84067 (comment)

roachtest.unoptimized-query-oracle/disable-rules=half failed with artifacts on master @ 6374bd83f192bd509e50313acb431690b9c3f8ae:

		  | + 	"1.0948368155551953,0,0000-01-01 21:14:18.311286 -0720 -0720,NULL",
		  | + 	"1.0948368155551953,0,0000-01-01 21:14:18.311286 -0720 -0720,NULL",
		  |   	"[1, 2],0,0000-01-01 21:14:18.311286 -0720 -0720,NULL",
		  |   	"[1, 2],0,0000-01-01 21:14:18.311286 -0720 -0720,NULL",
		  |   	... // 18 identical elements
		  |   	``[[{"0R-F4GF-u": [{"N?X7D": null}, [{}], [false], 1.0355662151258``...,
		  |   	``[[{}], {"a": []}, {}, [[], true], {"bar": {"foo": []}, "de_Mw4bO``...,
		  |   	strings.Join({
		  |   		``[null, ["^?+uF~"], ["b", {}], 0.03625670560293362, [0.1518913562``,
		  |   		"4037997, {}]],0,0000-01-01 21:14:18.311286 -0720 -0720,",
		  | - 		"NULL",
		  | + 		"1657452278285604764.0000000000",
		  |   	}, ""),
		  |   	``[true, {"b": [null, [[]]], "|Pj": []}, {}, "foobar"],0,0000-01-0``...,
		  |   	``[{"$.To<<[zB": {"bar": [true], "foobar": {"&hr": true}}, "-N6~'&``...,
		  |   	... // 3 identical elements
		  |   	``[{"TAvFgL": {}}, {}, {"#hr": {"JT#qF0Z]j$\\f": {}, "baz": "*6Dm<``...,
		  |   	``[{"a": "W$\\gG_", "foo": [{"Nq9'to8gxi_G": 0.3532539464625488}]}``...,
		  |   	strings.Join({
		  |   		``[{"a": 1.0088252099618846, "b": false}, {"bar": [[{"UNBK!a": []}``,
		  |   		``], []]}, {"!Q^(+BgIZn": 3.9861126137994796}],0,0000-01-01 21:14:``,
		  |   		"18.311286 -0720 -0720,",
		  | - 		"1657452278285604764.0000000000",
		  | + 		"NULL",
		  |   	}, ""),
		  |   	``[{"b": [null], "foo": {}}, {}, [0.9151866621393951, {"baz": 1.88``...,
		  |   	"[{\"foobar\": null, \"itH4h``Sn\": [[[]]]}, [{}, 0.2754294134231505],"...,
		  |   	... // 65 identical elements
		  |   	``{"test": "json"},0,0000-01-01 21:14:18.311286 -0720 -0720,165745``...,
		  |   	``{"test": "json"},0,0000-01-01 21:14:18.311286 -0720 -0720,165745``...,
		  | + 	``{"test": "json"},0,0000-01-01 21:14:18.311286 -0720 -0720,1657452278285604764.0000000000``,
		  | + 	``{"test": "json"},0,0000-01-01 21:14:18.311286 -0720 -0720,1657452278285604764.0000000000``,
		  |   	``{"test": "json"},0,0000-01-01 21:14:18.311286 -0720 -0720,165745``...,
		  | - 	``{"test": "json"},0,0000-01-01 21:14:18.311286 -0720 -0720,NULL``,
		  | - 	``{"test": "json"},0,0000-01-01 21:14:18.311286 -0720 -0720,NULL``,
		  |   	``{"test": "json"},0,0000-01-01 21:14:18.311286 -0720 -0720,NULL``,
		  |   	``{"test": "json"},0,0000-01-01 21:14:18.311286 -0720 -0720,NULL``,
		  |   	... // 17 identical elements
		  |   }
		  | sql: SELECT
		  | 	tab_701.col2_7 AS col_2231,
		  | 	0:::OID AS col_2232,
		  | 	'21:14:18.311286-07:20:00':::TIMETZ AS col_2233,
		  | 	lag(tab_701.crdb_internal_mvcc_timestamp::DECIMAL) OVER (PARTITION BY tab_701.crdb_internal_mvcc_timestamp, tab_701.col2_1, tab_701.tableoid ORDER BY tab_701.tableoid, tab_701.col2_10 ASC)::DECIMAL
		  | 		AS col_2234
		  | FROM
		  | 	defaultdb.public.table2@[0] AS tab_701
		  | ORDER BY
		  | 	tab_701.col2_14
		Error types: (1) *withstack.withStack (2) *errutil.withPrefix (3) *withstack.withStack (4) *errutil.leafError

Parameters: ROACHTEST_cloud=gce , ROACHTEST_cpu=4 , ROACHTEST_ssd=0

Help

See: roachtest README

See: How To Investigate (internal)

This test on roachdash | Improve this report!

Jira issue: CRDB-17518

[mgartner]

I couldn't reproduce incorrect results. Closing.