4 Commits

Author	SHA1	Message	Date
drh	81f5ef05a9	Fix the IN-early-out optimization so that it works even for the corner case ... where the NULL bypass fires before the affinity of the LHS operator has been set. Fix for the problem described in [forum:/forumpost/6a3ec138e9|forum post 6a3ec138e9]. FossilOrigin-Name: eb40248ce606b792a02e4e0b7dd826a82891c5f4c9793f3ca5d332e593109525	2021-04-29 15:49:34 +00:00
drh	14c98a4f40	At the end of the right-hand table loop of a LEFT JOIN that uses an IN ... operator in the ON clause, put the OP_IfNoHope operator after the OP_IfNotOpen operator, not before, to avoid a (harmless) uninitialized register reference. Ticket [82b588d342d515d1] FossilOrigin-Name: 8b437b47266ec2d80d85eafcfdd6949556d6c28d9d67d5f43d89799f0f5b7bd0	2020-03-16 03:07:53 +00:00
drh	6d6decb8d9	Only choose to scan an IN operator rather than use an index if we have ... real STAT1 data to suggest it is advantageous. FossilOrigin-Name: 30e874661dcc1a2ecb40df2ef74582151d85bb36c754a38548829a3b6285f18d	2018-06-08 21:21:01 +00:00
drh	056f5396fe	Test cases. ... FossilOrigin-Name: 085e863713a3f2d420c0076b275a6ac445a59d4d93f9eb0e8503b4e3f5589249	2018-06-07 16:07:00 +00:00