I would like to report an unwanted behavior in Lucee tested from 126.96.36.199 up to 6.0:
I have a simple table in MSSQL:
CREATE TABLE [dbo].[valuetester](
[id] [int] IDENTITY(1,1) NOT NULL,
[dec] [decimal](38, 20) NULL
) ON [PRIMARY]
While inserting records in the table
INSERT INTO valuetester (
<cfqueryparam cfsqltype="cf_sql_decimal" scale="2" value="3.28">
Produces this result:
Why not 3.28000000000000000000 ?
Also switched between MSSQL drivers and versions
Same here with Lucee 188.8.131.525 and MSSQL, tried some other sqltypes too:
With CF2018 and MSSQL:
So in my tests Lucee numeric/decimal/double = CF double/float and Lucee real/float = CF real.