Annex RDS forum

This tricky bug only shows up when evaluating two values (eg: b+c) 'true' that are not caged by parenthesis, else it hides unnoticed, giving false confidence to other code, such as the following snippet, which appears to run ok...
But both lines 2 and 3 have a bug, even though they are not failing because the IF evaluates as false, despite the ELSE of line 3 obviously being true.
Changing the value of 'a' from 11 to 1 will cause lines 2 and 3 to fail because the IF condition will then evaluate to true.

The bug can be avoided by using parenthesis, eg the following line will be ok whether it evaluates to true or false...

Yes, comparison operators should be given lower priority than arithmetic operators.

Using the parenthesis will avoid any misinterpretation.

Let's not forget the case of the power operator, which should precede the multiplication operator, but it is not.

First you do what is in parentheses;
Then Powers/Roots from left to right;
Then Multiply/Divide from left to right;
Finally Add/Subtract from left to right.

It seems from my code that Annex gives priority to the first operator it finds by traversing the instruction from left to right, regardless of whether it is power or multiply.
When in doubt, I always use the parenthesis system.
But if I'm right, it would be convenient to correct it in the help manual.