Symptom
- Statement cache turned on
- "literal autoparam" is enabled
- Queries with decimal conversion using IN clause does not return correct result:
select TASK_NO from ep_acct_lock_dol where TASK_NO in (convert(decimal(16,0),'167761701'),convert(decimal(16,0),'167761702'))
The correct result set should be :
TASK_NO
-------------------
167761701
167761702
(2 rows affected)
But the output of the query was empty:
TASK_NO
-------------------
(0 rows affected)
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) 15.7 SP132
Product
SAP Adaptive Server Enterprise 15.7
Keywords
KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.