I would like to report an unwanted behavior in Lucee tested from 5.3.12.1 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]
GO
While inserting records in the table
<cfquery datasource="testdb">
INSERT INTO valuetester (
[dec]
)VALUES(
<cfqueryparam cfsqltype="cf_sql_decimal" scale="2" value="3.28">
)
</cfquery>
Produces this result:
Why not 3.28000000000000000000 ?
Also switched between MSSQL drivers and versions