I'm having a problem where a single development machine has stopped receiving SQL errors when it attempts to use an illegally formatted string as a
(where the 'Id' column is of type UNIQUEIDENTIFIER)
When this query is executed against a database from InteractiveSQL, or via the C API on any of our other development PCs, this generates a -157 error: "
The only thing I'm aware of which makes this development machine different from the others is that I upgraded it to use SQLAnywhere 18.104.22.16853, whereas the other machines are running 22.214.171.12498. This behaviour remains the same, though, when I downgrade back to 126.96.36.19998.
Is there perhaps a local setting or configuration file that could be causing this unexpected lack-of-error only when executing the query through the C API, and only on this one computer? I'm just trying to work out why I'd be seeing different behaviour on this single Mac computer than on any of the other Macs and PCs.