some_old_guy

·10개월 전·discuss

The fact that it stops at the first range isn't intuitive to me at all, and I've been using sqlite for 20 years now.

Given a covering index on (thing_date, thing_color)

I would think a scan would not be needed for the query:

select thing_date, thing_color where thing_date < date and thing_color = 'blue'

I also can't think of a reason this is the case given the underlying data structures.