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

Solution Verified - Updated -


  • 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.


  • Red Hat JBoss Data Services (EDS) 5.3.1

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In