The forum will be down for scheduled maintenance on Saturday, March 4 beginning at 10am EST. Actual downtime is unknown but may be several hours.

I have a Proxy Table from a SQL Server data base that I am trying to execute a IF EXISTS (SELECT 1 FROM RemoteTable) RETURN 0 ELSE 0

This was working with SQLAnywhere 11 and now with SQLAnywhere this fails because the generated statement that gets to the remote server is


The issue is the FIRST that is thrown into the statement. This was reported for ORACLE proxy tables last october but I couldn't find any place where it had been corrected or reported for SQL SErver.

asked 16 Jul '15, 18:08

RayDavis348's gravatar image

accept rate: 0%

Comment Text Removed

SELECT 1 or SELECT (*) both issue the SELECT FIRST syntax.

I've settled on the rather crude return (coalesce (select 1 from RemoteTable, 0)) which works because the problem is with the IF EXISTS statement

I primarily wanted to let SAP know its a problem for SQL Server as well as Oracle.

(17 Jul '15, 09:58) RayDavis348
Comment Text Removed

This problem has been fixed in SQL Anywhere 16.0.0 build 2048 an up.

permanent link

answered 20 Jul '15, 13:23

Karim%20Khamis's gravatar image

Karim Khamis
accept rate: 40%


The according CR #764386 link shows that:

    ================(Build #2048  - Engineering Case #764386)================

    If an application executed a query against a Microsoft SQL Server proxy table 
    that contained SELECT FIRST or a subquery in an IF EXISTS( … ), then there 
    was a chance the Remote Data Access layer would incorrectly send the SELECT 
    FIRST to the remote server. Note that a similar problem existed with remote 
    Oracle servers as well. These problems have now been fixed and the Remote 
    Data Access layer will now send a TOP 1 instead.
(21 Jul '15, 07:40) Volker Barth
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 16 Jul '15, 18:08

question was seen: 757 times

last updated: 21 Jul '15, 07:40