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

Solution Verified - Updated -

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.

Environment

  • Red Hat JBoss Data Services (EDS) 5.3.1

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In