/ Check-in [d9676284]
Login

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

Overview
Comment:Make more aggressive use of transitivity in optimizing queries. Add a test case.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | transitive-constraints
Files: files | file ages | folders
SHA1: d96762841a461e192fb2f317d684d000376350dd
User & Date: drh 2013-01-17 15:05:17
Context
2013-01-17
16:18
Avoid unnecessary collating sequence and affinity restrictions on the use of transitivity. Add test cases to show that the restrictions are not needed. check-in: 56549f45 user: drh tags: transitive-constraints
15:05
Make more aggressive use of transitivity in optimizing queries. Add a test case. check-in: d9676284 user: drh tags: transitive-constraints
00:08
Improved comments explaining the operation of the findTerm() utility routine in where.c. Increase the maximum number of levels of transitivity from 4 to 11. check-in: fe152f8b user: drh tags: transitive-constraints
Changes
Unified Diffs Side-by-Side Diffs Patch

Changes to src/where.c.

Changes to test/autoindex1.test.