SAP Knowledge Base Article - Preview

2232323 - The behavior of a query that is specifying the same correlation name in the same FROM clause

Symptom

A query of an incorrect statement does not fail with an error and may have returned an incorrect result set.

For example, Even if you have specified the same correlation name in the same FROM clause, a query does not fail with an error,

Sample error message

Could not execute statement.
  More than one table is identified as 'table2'
  SQLCODE=-139, ODBC 3 State="42000"

And, this behavior also occurs on SAP SQL Anywhere.


Read more...

Environment

  • SAP IQ 16.0
  • SAP IQ 15.x
  • SAP SQL Anywhere 16.0
  • SAP SQL Anywhere 12.0
  • SAP SQL Anywhere 11.0

Product

SAP IQ 16.0 ; SAP SQL Anywhere 16.0 ; SAP Sybase IQ 15.2 ; SAP Sybase IQ 15.4 ; SAP Sybase SQL Anywhere 12.0 ; Sybase SQL Anywhere 11.0

Keywords

KBA , BC-SYB-IQ , Sybase IQ , BC-SYB-SQA , SQL Anywhere (on premise, on demand) , 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.