SQLite

View Ticket
Login
Ticket Hash: 7e07a3dbf5a8cd26e87418764625816f24f11046
Title: LIKELY() seems to cause unexpected affinity conversion for rowid
Status: Fixed Type: Code_Defect
Severity: Important Priority: Immediate
Subsystem: Unknown Resolution: Fixed
Last Modified: 2019-08-22 16:39:06
Version Found In: 3.29.0
User Comments:
mrigger added on 2019-08-22 14:34:30: (text/x-fossil-wiki)
Consider the following test case:

<pre>
CREATE TABLE t0 (c0);
INSERT INTO t0(c0) VALUES ('a');
SELECT * FROM t0 WHERE LIKELY(t0.rowid) <= '0'; -- unexpected: row is not fetched
</pre>

Unexpectedly, no row is fetched. The expression LIKELY(t0.rowid) <= '0' should evaluate to TRUE:

<pre>
SELECT LIKELY(t0.rowid) <= '0' FROM t0; -- 1
</pre>