nhibernate-core icon indicating copy to clipboard operation
nhibernate-core copied to clipboard

Error in command when using the formula property for CAST in DB2

Open LendaUrbana opened this issue 1 year ago • 0 comments

I am using the mapping below with the formula property, to perform a CAST on a field in a DB2 database. However, when the command is generated, it is invalid because it is including the alias incorrectly as shown below.

Map(c => c.wdesc).CustomType<CastedStringType>().Formula("CAST(wdesc as VARCHAR(30) CCSID 37)").Length(30).Not.Nullable()

Same error Map(c => c.wdesc).Formula("CAST(wdesc as VARCHAR(30) CCSID 37)").Length(30).Not.Nullable()

Field with command error (CAST(ilm4_.wdesc as VARCHAR(30) ilm4_.CCSID 37))

The alias is being inserted in the CCSID and is not necessary in these cast cases

For working correct (CAST(ilm4_.wdesc as VARCHAR(30) CCSID 37))

I'm using the latest versions of hibernate and fluence hibernate , and I tested with older versions and the same error occurs.

LendaUrbana avatar May 23 '24 15:05 LendaUrbana