if you execute a statement like this:
select first field1, field2 from exampleTable where field1 = '1';
then you get a warning like this:
The result returned is non deterministic SQLCode=122
So far it's OK, because in this case you need an "order by" clause here.
But when you use the same statement inside of a BEGIN END block putting the values into some declared variables,
BEGIN declare varField1 varchar; declare varField2 varchar; select first field1, field2 into varField1, varField2 from exampleTable where field1 = '1'; END
the warning does not come up! Why?
Is the "order by" clause not needed here? Is this statement suddenly deterministic?...
(using SQL Anywhere 12)
select first field1, field2 from exampleTable where field1 = '1';--- what this expression is supposed to do? It doesn't pass selected fields to somewhere.
intoselects make no sense