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.
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.
Close
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.