SQLite

View Ticket
Login
2016-11-24
00:00 Fixed ticket [1a684656]: Assertion fault on a conditional row-value expression plus 5 other changes (artifact: ddff0332 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: 4c6efe60 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: c08aff13 user: dan tags: trunk)
18:36 New ticket [1a684656] Assertion fault on a conditional row-value expression. (artifact: 2564b3cd 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
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.