Ticket Hash: | ef36060112a5059184965d3c9816caf0c5f3bace | |||
Title: | Incorrect affinity transformations on DELETE | |||
Status: | Fixed | Type: | Code_Defect | |
Severity: | Severe | Priority: | Immediate | |
Subsystem: | Unknown | Resolution: | Fixed | |
Last Modified: | 2016-08-26 12:01:20 | |||
Version Found In: | 3.14.1 | |||
User Comments: | ||||
drh added on 2016-08-26 05:17:58:
In the SQL below, the DELETE operation is a no-op. CREATE TABLE t1(a INT UNIQUE, b INT); INSERT INTO t1(a,b) VALUES('1','2'); SELECT * FROM t1 WHERE a='1' AND b='2'; DELETE FROM t1 WHERE a='1' AND b='2'; SELECT * FROM t1; Even the SELECT on the third line outputs the row, and the DELETE has the exact same WHERE clause, the DELETE does not delete the row. Bisecting suggests that this problem was introduced by check-in [85c467041c9378ca] on 2016-01-30 for version 3.11.0. |