| Ticket Hash: | 1a68465637e1b0141c390ae080b24aa29f9b2a0d | |||
| Title: | Assertion fault on a conditional row-value expression | |||
| Status: | Fixed | Type: | Code_Defect | |
| Severity: | Severe | Priority: | Immediate | |
| Subsystem: | Unknown | Resolution: | Fixed | |
| Last Modified: | 2016-11-24 00:00:11 | |||
| Version Found In: | 3.15.1 | |||
| User Comments: | ||||
drh added on 2016-11-23 18:36:55:
(text/x-fossil-wiki)
Each of the following two queries generates aa assertion fault in SQLite 3.15.1: <blockquote><verbatim> SELECT 1 WHERE (2,2) BETWEEN (1,1) AND (3,3); SELECT CASE (2,2) WHEN (1,1) THEN 1 ELSE 2 END; </verbatim></blockquote> This problem was originally reported by Mark Brand on the SQLite mailing list. The problem is specific to 3.15.0 and 3.15.1, since it requires the use of row value expressions which were introduced in version 3.15.0. | ||||