Sybase SQL Anywhere 220.127.116.1134
This script to reproduce the problem:
Now, perform basic query:
i get an error message:
Could not execute statement. Illegal reference to correlation name 'TEST1' SQLCODE=-824, ODBC 3 State="42S02"
though if the request to change bit
it is executed without error.
That is the Problem that the SA12 is why it does not like the transfer of the table field as a parameter to the SP ( MyProc(TEST1.ID) ).
Q: This is my fault, or this is a bug SA12 ?
P.S. Sorry this error I can not check on the more recent versions (builds) SA12, so I do not have a subscription to technical support and version SA12 Developers stuck on 18.104.22.16834 ;-(
asked 02 Jun '15, 11:11
I'd like to add a link to a great (as usual) Glenn Paulley article comparing LATERAL and the APPLY operators: