/ Ticket Change Details
SQLite training in Houston TX on 2019-11-05 (details)
Part of the 2019 Tcl Conference

Artifact ID: 10bc68257e7ae3ed5f17d69f0a265b55d8957c8d
Ticket: 93fb9f89d6a69dc3d8e627197d21a15dcb4eaaf7
Index causes incorrect WHERE clause evaluation
User & Date: drh 2009-08-19 15:21:05

  1. Appended to comment:

    drh added on 2009-08-19 15:21:05:
    This error is present in all prior versions of SQLite back through version 3.1.3 (2005-02-19) and perhaps earlier. (Version 3.1.3 is as far back as we looked.)

    The fix for the problem is check-in [e72186f2d68d28c2e0c32894f9adb28c155b5f63].

    Test cases for this fix are in the test/whereB.test test script.

  2. Change priority to "Immediate"
  3. Change resolution to "Fixed"
  4. Change status to "Fixed"