[sqlite] Contstant WHERE terms still require table scan?

[Mark Lawrence]

I'm wondering if it would be possible to optimize the query planner for
situations where one of the WHERE clauses is a constant that evaluates
to false?

    CREATE TABLE x(
        id INTEGER PRIMARY KEY
    );

    EXPLAIN QUERY PLAN SELECT
        x.id
    FROM
        x
    WHERE
        1=0
    ;

    -- selectid    order       from        detail      
    -- ----------  ----------  ----------  ------------
    -- 0           0           0           SCAN TABLE x


This would potentially allow me to shortcut some largish UNION
statements.

Mark.
-- 
Mark Lawrence
Home:   +41 44 520 12 59
Mobile: +41 76 796 65 68