Hello ! This fix the example I gave on the other email it was "r <> r" but it's more easy to see the problem with "r = r".
Nice explanation ! With your knowledge could you give your view about how evaluation of calculated/function columns should be done to have correct results. Like another example given on other thread: _________ CREATE TABLE a(b); INSERT INTO a(b) VALUES(1),(2),(3); SELECT a, random() as r FROM a WHERE r = r; _________
