Incorrect result for COUNT on view with window function
(1) By ChiZhang on 2023-03-03 02:19:28 [source]
Consider the following test case:
CREATE TABLE t0(c0); INSERT INTO t0(c0) VALUES (0); CREATE VIEW v0(c0) AS SELECT TOTAL(0) OVER (PARTITION BY t0.c0) FROM t0; SELECT COUNT(*) FROM v0 WHERE ('1' IS NOT('1' NOTNULL))-(0);
This query produces
0, which I believe, is unexpected. Since ('1' IS NOT('1' NOTNULL)) will return
1, so this condition is true and I expect the result to be
1. Note that this reproduces also on the latest trunk version (8fe13f7a).
(2) By Richard Hipp (drh) on 2023-03-03 21:01:42 in reply to 1 [link] [source]
Should now be fixed on trunk.