Querying a bigdecimal column with a string value returns records in EDS

Issue

• Querying a column defined with bigdecimal data type with a string value returns records and shouldn't. The below SQL returns records when I dont expect it to:

select * from CommonTrades where TRAD_TRADE_ID IN ('RR','Rt')

• The IN clause with different string values returns the records.