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 |