bug: float rounding issue for mssql inline scripts

Open
#7,403 0 comments 0 reactions 1 assignee View on GitHub

@rubenfiszel is already working on this.

Since Dec 17, 2025.

Assessment

This issue has not been assessed yet.

Description

bug
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

Dominant language
Rust
Stars
18k
Forks
1.1k
Avg merge
1d 1h
Merged PRs (30d)
328

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

More from windmill-labs/windmill

All issues in windmill-labs/windmill

Similar issues

More Rust issues

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.