SAP Knowledge Base Article - Preview

3380593 - SELECT results incorrect with 'disable varbinary truncation' enabled - SAP ASE

Symptom

  • Wrong results from a SELECT query that uses a unique index defined on a varbinary key column.

  • Rows missing from result set.


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0
  • Configuration option "disable varbinary truncation" is enabled

Keywords


incorrect SELECT results, disable truncation issue, unique index issue, missing rows in result set, SELECT query error, CR 769843, unique index column error, trailing null bytes, query result mismatch , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Known Error

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.