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 18.104.22.1683 this fails because the generated statement that gets to the remote server is
SELECT FIRST 1 FROM RemoteTable
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
This problem has been fixed in SQL Anywhere 16.0.0 build 2048 an up.
answered 20 Jul '15, 13:23