diff options
| author | drh <drh@noemail.net> | 2014-02-04 23:45:45 +0000 |
|---|---|---|
| committer | drh <drh@noemail.net> | 2014-02-04 23:45:45 +0000 |
| commit | e08ecad58a7f11b915920eaf0b9833b87ba02ea3 (patch) | |
| tree | 786edb01bf6789f9fde5dad233cd82decb36ea37 /src/expr.c | |
| parent | ee06c99b49e5812403eb2b2762da4d5fee4e4d18 (diff) | |
| download | sqlite-e08ecad58a7f11b915920eaf0b9833b87ba02ea3.tar.gz sqlite-e08ecad58a7f11b915920eaf0b9833b87ba02ea3.zip | |
Do not mark the ephemeral tables used to hold the RHS of IN clauses as
unordered because the NGQP will use those ephemeral tables to help order the
output. This is not an issue for standard SQLite since ephemeral tables
there are always ordered, regardless of the hint. It only affects systems
that substitute an alternative storage engine.
FossilOrigin-Name: f2504089df0bf4011864e67825b37f6aa3d03458
Diffstat (limited to 'src/expr.c')
| -rw-r--r-- | src/expr.c | 1 |
1 files changed, 0 insertions, 1 deletions
diff --git a/src/expr.c b/src/expr.c index 7323e5d4f..ee9d7877a 100644 --- a/src/expr.c +++ b/src/expr.c @@ -1763,7 +1763,6 @@ int sqlite3CodeSubselect( */ pExpr->iTable = pParse->nTab++; addr = sqlite3VdbeAddOp2(v, OP_OpenEphemeral, pExpr->iTable, !isRowid); - if( rMayHaveNull==0 ) sqlite3VdbeChangeP5(v, BTREE_UNORDERED); pKeyInfo = isRowid ? 0 : sqlite3KeyInfoAlloc(pParse->db, 1, 1); if( ExprHasProperty(pExpr, EP_xIsSelect) ){ |