/ Check-in [e72186f2]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:If a binary operator in a WHERE clause that should be performed with no affinity conversions applied to its operands (see http://www.sqlite.org/datatype3.html) is optimized by index lookup, do not apply any conversions to the key value before looking it up in the index. Fix for [93fb9f89d6].
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: e72186f2d68d28c2e0c32894f9adb28c155b5f63
User & Date: dan 2009-08-13 19:21:17
Original Comment: If a binary operator in a WHERE clause that should be performed with no affinity conversions applied to its operands (see http://www.sqlite.org/datatype3.html) is optimized by index lookup, do not apply any conversions to the key value before looking it up in the index. Fix for 93fb9f89d6.
References
2016-09-03
15:24 Ticket [199df416] Different answer with and without index on IN operator with type mismatch status still Open with 6 other changes artifact: 6a413497 user: drh
2009-08-19
15:21 Fixed ticket [93fb9f89]: Index causes incorrect WHERE clause evaluation plus 3 other changes artifact: 10bc6825 user: drh
Context
2009-08-13
19:54
Tweak to the new whereB.test file to make it more consistent. check-in: 06098505 user: drh tags: trunk
19:21
If a binary operator in a WHERE clause that should be performed with no affinity conversions applied to its operands (see http://www.sqlite.org/datatype3.html) is optimized by index lookup, do not apply any conversions to the key value before looking it up in the index. Fix for [93fb9f89d6]. check-in: e72186f2 user: dan tags: trunk
18:14
Enhancements to the whereB.test to check more affinity corner cases. check-in: 10484598 user: drh tags: trunk
Changes
Unified Diffs Side-by-Side Diffs Patch

Changes to src/delete.c.

Changes to src/insert.c.

Changes to src/sqliteInt.h.

Changes to src/where.c.