Skip to content

roachtest.costfuzz failed due to scientific notation v. decimal notation #86796

@rytaft

Description

@rytaft

roachtest.costfuzz failed with artifacts on master @ f4042d47fa8062a612c38d4696eb6bee9cee7c21:

		  |   		"1.11,0,1986-08-04 01:37:10.00077 +0000 UTC,-3",
		  | + 		".",
		  |   		"496594284072061722",
		  | + 		"E+27,-2.",
		  |   		"0",
		  | - 		"00000000,-2.0129749084999493,-3496594284072061722000000000",
		  | + 		"129749084999493,-3.496594284072061722E+27",
		  |   	}, ""),
		  |   	"1.11,0,1988-02-02 02:14:01.000494 +0000 UTC,-3496594284072061721"...,
		  |   	"1.11,0,1989-02-10 10:51:16.000188 +0000 UTC,-3496594284072061719"...,
		  |   	"1.11,0,1991-03-12 19:37:05.000941 +0000 UTC,-3496594284072061721"...,
		  |   	"1.11,0,1991-04-05 23:25:23.000015 +0000 UTC,-3496594284072061586"...,
		  |   	"1.11,0,1997-05-19 00:08:20 +0000 UTC,-5.84595187342303731122E+29"...,
		  |   	strings.Join({
		  |   		"1.11,0,1997-05-20 03:46:40 +0000 UTC,-34965942840715594523602606",
		  |   		"28.034",
		  | - 		"0",
		  |   		",-2.0129749084999493,-3496594284071559452360260628.034",
		  | - 		"0",
		  |   	}, ""),
		  |   	"1.11,0,1999-02-23 01:18:56.000557 +0000 UTC,-3496594284072061721"...,
		  |   	"1.11,0,2002-08-13 23:25:33.000643 +0000 UTC,-3496594284072061721"...,
		  |   	... // 62 identical elements
		  |   	"1.11,0,2019-02-27 14:32:12.000197 +0000 UTC,-3496594284072061721"...,
		  |   	"1.11,0,2020-07-02 23:58:51.00079 +0000 UTC,-34965942840720617219"...,
		  |   	strings.Join({
		  |   		"1.11,0,2021-12-24 00:36:05.000773 +0000 UTC,-3",
		  | + 		".",
		  |   		"496594284072061722",
		  | + 		"E+27,-2.",
		  |   		"0",
		  | - 		"00000000,-2.0129749084999493,-3496594284072061722000000000",
		  | + 		"129749084999493,-3.496594284072061722E+27",
		  |   	}, ""),
		  |   	"1.11,0,2025-09-22 01:21:45.000531 +0000 UTC,-3496594284072061721"...,
		  |   	"1.11,0,2026-12-12 07:32:02.000115 +0000 UTC,Infinity,-2.01297490"...,
		  |   	... // 8 identical elements
		  |   }
		  | sql: SELECT
		  | 	1.11:::DECIMAL AS col_1,
		  | 	0:::OID AS col_2,
		  | 	tab_1.col2_1 AS col_3,
		  | 	tab_1.col2_3 AS col_4,
		  | 	(-2.0129749084999493):::FLOAT8 AS col_5,
		  | 	tab_1.col2_3 AS col_6
		  | FROM
		  | 	defaultdb.public.table2@[0] AS tab_1
		  | ORDER BY
		  | 	tab_1.col2_3 ASC
		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!

Originally posted by @cockroach-teamcity in #85658 (comment)

Jira issue: CRDB-18938

Metadata

Metadata

Assignees

Labels

C-test-failureBroken test (automatically or manually discovered).T-sql-queriesSQL Queries Team

Type

No type

Projects

Status

Done

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions