SAP Knowledge Base Article - Preview

2000988 - Select SQL Statements Produce Inconsistent Result Sets With or Without Indexes


A query that used to work before SQL Anywhere version 10 will produce different result sets with or without the existence of indexes.



Verified in:

  • SAP Sybase SQL Anywhere 10.0.1 
  • SAP Sybase SQL Anywhere 11.0.1 with EBFs: 2450,2472,2713,2960,3113
  • SAP Sybase SQL Anywhere 12.0.1
  • SAP SQL Anywhere 16.0.0 with EBFs: 1324, 1843 


SAP SQL Anywhere 16.0 ; SAP Sybase SQL Anywhere 12.0 ; Sybase SQL Anywhere 10.0 ; Sybase SQL Anywhere 11.0


different result sets unique indexes , KBA , BC-SYB-SQA , SQL Anywhere (on premise, on demand) , Bug Filed

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.