| Ticket Hash: | b2d4edaffdc156ccebca2aab945215b4d75ba912 | ||
| Title: | Comparison on view malfunctions | ||
| Status: | Fixed | Type: | Code_Defect |
| Severity: | Important | Priority: | Immediate |
| Subsystem: | Unknown | Resolution: | Fixed |
| Last Modified: | 2019-10-07 01:07:56 | ||
| Version Found In: | 3.30.0 | ||
| User Comments: | ||||
|
mrigger added on 2019-10-05 21:09:57:
Consider the following example:
CREATE TABLE t0(c0);
INSERT INTO t0(c0) VALUES (0);
CREATE VIEW v0(c0) AS SELECT t0.rowid FROM t0 ORDER BY 1;
SELECT COUNT(*) FROM v0 WHERE ABS('1') = v0.c0; -- expected: 1, actual: 0
The COUNT()'s result indicates that the value in the table does not match the condition in the WHERE clause. However, the following query indicates that it does:
SELECT ABS('1') = v0.c0 FROM v0; -- 1
| ||||