Incorrect Results When Filtering on generate_series Table

(1) By orange (20030618) on 2025-03-13 17:24:07 [source]

Test Case:
select  
  ref_0.value as c_0
from 
  generate_series(60, 73, 6) as ref_0
where ref_0.value=66;

Expected Result:
66

Actual Result:
The query returns no results (empty).

SQLite Version:
3.48.0 2025-01-11 16:28:41 3e2875dac27de1525d9c78f38ac5f1fc12fec7e1b43dbdf47798b128fae49084 (64-bit)

(2) By Richard Hipp (drh) on 2025-03-13 18:52:36 in reply to 1 [link] [source]

Fixed at check-in 202503131851.