SQLite

View Ticket
Login
2016-11-24
00:00 Fixed ticket [1a68465637]: Assertion fault on a conditional row-value expression plus 5 other changes (artifact: ddff0332d0 user: drh)
2016-11-23
21:13
Code constant vector components outside of any loops in CASE and BETWEEN expressions. Fix for [1a684656]. (check-in: 4c6efe600d user: drh tags: branch-3.15)
19:31
Code constant vector components outside of any loops in CASE and BETWEEN expressions. Fix for [1a684656]. (check-in: c08aff13ea user: dan tags: trunk)
18:36 New ticket [1a68465637] Assertion fault on a conditional row-value expression. (artifact: 2564b3cd50 user: drh)

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
8.61 years ago
Created: 2016-11-23 18:36:55
8.61 years ago
Version Found In: 3.15.1
User Comments:
drh added on 2016-11-23 18:36:55:

Each of the following two queries generates aa assertion fault in SQLite 3.15.1:

SELECT 1 WHERE (2,2) BETWEEN (1,1) AND (3,3);
SELECT CASE (2,2) WHEN (1,1) THEN 1 ELSE 2 END;

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.