Skip to content

bug: float rounding issue for mssql inline scripts #7403

@afefelov

Description

@afefelov

Describe the bug

SELECT
    convert(numeric(16,2), Expenses) as expenses,
FROM
BanksRegisters.vReports
where ReportID = 4928
ORDER BY
    ReportID; 

This query in any tool outside windmill returns expenses casted to 7.69 as it should be.

In windmill it is :

 [
    {
        "expenses": **7.6899999999999995**,
     }
]

As discussed in discord it seems to be an issue with casting to float internally.

To reproduce

  1. Go to '...'
  2. Click on '....'
  3. Scroll down to '....'
  4. See error

Expected behavior

Should be casted to 7.69

Screenshots

No response

Browser information

No response

Application version

No response

Additional Context

No response

Metadata

Metadata

Assignees

Labels

bugSomething isn't working

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions