]> git.ipfire.org Git - thirdparty/sqlite.git/commit
The idea of coding IN operator with a short list on the RHS as an OR expression
authordrh <drh@noemail.net>
Fri, 1 Aug 2014 15:34:36 +0000 (15:34 +0000)
committerdrh <drh@noemail.net>
Fri, 1 Aug 2014 15:34:36 +0000 (15:34 +0000)
commite80c9b9ad5e62af9ccd8a4ce8f069c965dde6070
tree1e1a99143b41337a4d6e3b907cd99a6fcb6f9fb5
parent3a85625d87c2b5d0f4cd504cb4fdc5d8fc5ee8c4
The idea of coding IN operator with a short list on the RHS as an OR expression
turns out to be helpful.  If the list is of length 1 or 2, the OR expression
is very slightly faster, but the ephemeral table approach is clearly better for
all list lengths greater than 2.  Better to keep the code simple.

FossilOrigin-Name: e13175d3579e1045165bab091b3b28951d691704
manifest
manifest.uuid
src/expr.c
src/sqliteInt.h