You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Using the public Playground (version 0.12.2), the Playground displays incorrect results for the round function. It seems to be missing the decimal points in the output.
The generated SQL is correct, and pasting that SQL into SQLite shows the expected results.
PRQL input
from [{ a=1}]select {
math.round 11.23,
math.round 14.56}
SQL output
WITH table_0 AS (
SELECT1AS a
)
SELECT
ROUND(1.23, 1),
ROUND(4.56, 1)
FROM
table_0
-- Generated by PRQL compiler version:0.12.2 (https://prql-lang.org)
Expected SQL output
==== EXPECTED ====
ROUND(1.23, 1) ROUND(4.56, 1)
1.24.6==== ACTUAL ====
round(1.23, 1) round(4.56, 1)
1246<-- Note the lack of decimal points
MVCE confirmation
Minimal example
New issue
Anything else?
No response
The text was updated successfully, but these errors were encountered:
What happened?
Using the public Playground (version 0.12.2), the Playground displays incorrect results for the
round
function. It seems to be missing the decimal points in the output.The generated SQL is correct, and pasting that SQL into SQLite shows the expected results.
PRQL input
SQL output
Expected SQL output
MVCE confirmation
Anything else?
No response
The text was updated successfully, but these errors were encountered: