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