-
Notifications
You must be signed in to change notification settings - Fork 4.1k
roachtest.costfuzz failed due to scientific notation v. decimal notation #86796
Copy link
Copy link
Closed
Labels
C-test-failureBroken test (automatically or manually discovered).Broken test (automatically or manually discovered).T-sql-queriesSQL Queries TeamSQL Queries Team
Description
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
This test on roachdash | Improve this report!
Originally posted by @cockroach-teamcity in #85658 (comment)
Jira issue: CRDB-18938
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
C-test-failureBroken test (automatically or manually discovered).Broken test (automatically or manually discovered).T-sql-queriesSQL Queries TeamSQL Queries Team
Type
Projects
Status
Done