|Title:||Comparison of row values results in incorrect result|
|Last Modified:||2019-10-22 10:43:16|
|Version Found In:||3.30.0|
mrigger added on 2019-10-21 14:45:34:
Consider the following test case: <pre> CREATE TABLE t0(c0 COLLATE NOCASE, c1); INSERT INTO t0 VALUES('a', 'A'); SELECT * FROM t0 WHERE (+ t0.c1, 1) >= (t0.c0, 1); -- expected: row is not fetched, actual: row is fetched </pre> I would not expect the row to be fetched, because the expression should evaluate to TRUE: <pre> SELECT (+ t0.c1, 1) >= (t0.c0, 1) FROM t0; -- 0 </pre>
mrigger added on 2019-10-22 10:43:16: (text/x-fossil-wiki)
It seems that the check-in did not fix this issue-I detected the same bug again, and can still reproduce the issue on the current trunk.