Symptom
- Query with a "LIKE" statement and cache enable using JDBC "prepared statement" returns incorrect result
- Using NOT LIKE clause with local variable assigned to a constant string could return different result
- Comparing to the constant string if the column has NULL values in it
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE)
- Dataserver
Product
SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0
Keywords
JDBC, NOT LIKE, statement cache enable, prepared statement, null, CR763247, CR#763247, 763247, jConnect , 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.