| Ticket Hash: | a7debbe0ad1cbe469159db7f8c4ba03fe7049c13 | |||
| Title: | BETWEEN issue in view | |||
| Status: | Closed | Type: | Code_Defect | |
| Severity: | Critical | Priority: | Immediate | |
| Subsystem: | Unknown | Resolution: | Fixed | |
| Last Modified: | 2019-09-09 20:18:05 | |||
| Version Found In: | 3.29.0 | |||
| User Comments: | ||||
|
mrigger added on 2019-09-07 18:51:40:
Consider the following test case:
CREATE TABLE t0(c0);
INSERT INTO t0(c0) VALUES('');
CREATE VIEW v2(c0, c1) AS SELECT 'B' COLLATE NOCASE, 'a' FROM t0 ORDER BY t0.c0;
SELECT SUM(count) FROM (SELECT v2.c1 BETWEEN v2.c0 AND v2.c1 as count FROM v2); -- expected: 0, actual: 1
I would expect SUM() to yield 0 since the condition evaluates to false: SELECT v2.c1 BETWEEN v2.c0 AND v2.c1 as count FROM v2; -- 0 dan added on 2019-09-09 20:18:05: Fixed by [b9ec7220]. | ||||