2156995 - Query with decimal conversion using IN clause does not return correct result on ASE 15.7 SP132

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

SAP Adaptive Server Enterprise (ASE) 15.7 SP132

KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem