SQLite

All files named ”test/transitive1.test”
Login

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

History for test/transitive1.test

2021-10-06
10:04
[f8ee983600] part of check-in [79e90a8225] One corner case for the fix at [8b24c177061c3836] was not quite right. Caught overnight by both OSSFuzz and dbsqlfuzz and repaired here. (check-in: [79e90a8225] user: drh branch: trunk, size: 39963)
2021-10-04
11:10
[d75f4c919b] part of check-in [8b24c17706] Fix query plans created by whereShortCut() so that they always check transitive constraints that drive an index. The is analogous to the [f1f9b5de3c59489b] check-in, just for whereShortCut() rather than the full query planner. Fix for the issue described by forum post a65cacbf5e1c41ba. (check-in: [8b24c17706] user: drh branch: trunk, size: 39551)
2021-08-30
17:02
[7dcd1f2638] part of check-in [46e28cbcf6] Do not disable a rowid=? term used to drive an IPK index if it is a transitive constraint. Commit [f1f9b5de] made the same change for non-IPK indexes. (check-in: [46e28cbcf6] user: dan branch: trunk, size: 39002)
2021-05-04
23:21
[06bcfeeb2e] part of check-in [f1f9b5de3c] When applying the optimization that disables WHERE clause terms that drive indexes, make sure not to do so if the term being disabled is a transitive constraint. Fix for the problem identified by forum post eb8613976a. (check-in: [f1f9b5de3c] user: drh branch: trunk, size: 38432)
2021-03-20
15:11
[239eec5343] part of check-in [50fbd53260] Revise tests cases to align with the new EXPLAIN QUERY PLAN output. (check-in: [50fbd53260] user: drh branch: eqp-improvements, size: 37537)
2015-05-18
11:34
[293300f469] part of check-in [6bfaf525ca] Refinements to the determination of when an A==B term is an equivalence. Add test cases. (check-in: [6bfaf525ca] user: drh branch: transitive-constraints, size: 37549)
2015-05-14
14:03
[875a9f0097] part of check-in [f397c8622a] A few more test cases for the IS operator. (check-in: [f397c8622a] user: drh branch: index-is-operator, size: 35604)
2013-10-28
20:38
[03f532954f] part of check-in [05a35b09b1] Add regression tests for ticket [c620261b5b5]. (check-in: [05a35b09b1] user: drh branch: trunk, size: 35105)
2013-07-08
21:12
[0ee69546d6] part of check-in [3b30b75b34] Fix an adverse interaction between the IS NOT NULL optimization (available only with SQLITE_ENABLE_STAT3) and the transitive constraint processing. Fix for ticket [d805526eae253] (check-in: [3b30b75b34] user: drh branch: trunk, size: 3091)
2013-01-17
16:18
Added: [d04aa9023e] part of check-in [56549f4566] 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: [56549f4566] user: drh branch: transitive-constraints, size: 1674)