2495721 - Insert from float to decimal fails but does not state an error - SAP ASE

Error when trying to insert data:

Create table test2 (a numeric (18,9))
go

• If statement cache is ON:

insert into test2 values (1.1099999999999999)
go
Truncation error occurred.
Command has been aborted.
(0 rows affected)

• If statement cache is OFF:

insert into test2 values (1.1099999999999999)
go

Msg 241, Level 16, State 2:
Server 'da_prime', Line 1:
Scale error during implicit conversion of NUMERIC value '1.1099999999999999' to a NUMERIC field.

SAP Adaptive Server Enterprise (ASE) all versions

KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem