it was causing multiple performance regressions. In its place, reduce the
estimated row count for DISTINCT subsqueries by a factor of 8.
FossilOrigin-Name: 796a65fa61373b5def9bf94e068e2dae9381a084c7e2c1e5df26929e9b07ca07
table scan for a materialized view or subquery if the full scan is the
outer-most loop. This is shown to speed up some queries.
FossilOrigin-Name: e3754cc18824aad4113ad6d81e33e5c763beb9705fc6af88d8f8c870a03c731d
ALL, and one side of that UNION ALL is a query on a view that includes an
ORDER BY. Fix for ticket [190c2507].
FossilOrigin-Name: 590ca83b8e8cdd5d24ed7f10f43e540aa0627f22
check-in (6305). Discovered by regression test on 64-bit linux.
Test cases added so that the problems is detected on 32-bit systems. (CVS 6332)
FossilOrigin-Name: fa0008502ec4f891bfed4a11f01650d274f95c44
to problems fixed. The hack causes failures in alias.test, but those are much
less serious than the aforementioned tickets. This is a stop-gap until we can
figure out a proper fix. (CVS 5711)
FossilOrigin-Name: a67da9dd2ff6acc163de4ce2b836b03e3f159a88
