7 Commits

Author	SHA1	Message	Date
drh	67656ac78a	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:forumpost/eb8613976a|forum post eb8613976a]. FossilOrigin-Name: f1f9b5de3c59489b94963685660b3ddc45eece5535b02fec399b6ece0e38563d	2021-05-04 23:21:35 +00:00
drh	8210233c7b	Revise tests cases to align with the new EXPLAIN QUERY PLAN output. ... FossilOrigin-Name: 50fbd532602d2c316813046ed6be8be2991c281eb5f295c4c28520a0de73862c	2021-03-20 15:11:29 +00:00
drh	69c15fee98	Refinements to the determination of when an A==B term is an equivalence. ... Add test cases. FossilOrigin-Name: 6bfaf525cac2e0c0a4a3bd3a1fc7bf5bd3234303	2015-05-18 11:34:52 +00:00
drh	5d8806e07c	A few more test cases for the IS operator. ... FossilOrigin-Name: f397c8622ae5a36a71f81d9f2549ca314005ece5	2015-05-14 14:03:21 +00:00
drh	70a0222f07	Add regression tests for ticket [c620261b5b5]. ... FossilOrigin-Name: 05a35b09b140fed0898afd36bc641e275545a35f	2013-10-28 20:38:52 +00:00
drh	b5246e518b	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] FossilOrigin-Name: 3b30b75b342bb6b424ad2bf7cd841b2c88bdad44	2013-07-08 21:12:57 +00:00
drh	63db0392ae	Avoid unnecessary collating sequence and affinity restrictions on the use ... of transitivity. Add test cases to show that the restrictions are not needed. FossilOrigin-Name: 56549f45666b53876012df5c2bdf813474e10925	2013-01-17 16:18:55 +00:00