Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.
|Comment:||Add the ability to use indices for the first few terms of an ORDER BY clause, then sort in batches to handle the later terms.|
|Downloads:||Tarball | ZIP archive | SQL archive|
|Timelines:||family | ancestors | descendants | both | trunk|
|Files:||files | file ages | folders|
|User & Date:||drh 2014-03-21 20:58:42|
|00:27||Fix the ORDER BY optimization logic so that it will do a block-sort on a partial DESC ORDER BY. This enhancement uncovered a memory leak in pushUntoSorter() which is also fixed. (check-in: c36f7461 user: drh tags: trunk)|
|20:58||Add the ability to use indices for the first few terms of an ORDER BY clause, then sort in batches to handle the later terms. (check-in: fa06a6fe user: drh tags: trunk)|
|19:56||Change the names of SRT_DistTable and SRT_Table used by CTE to more meaningful SRT_DistFifo and SRT_Fifo, respectively. Simplify the IgnorableOrderby() macro in the process. (check-in: 45d8cc67 user: drh tags: trunk)|
|18:45||Merge the OFFSET-on-query-without-FROM fix from trunk. (check-in: 71e9ae72 user: drh tags: orderby-planning)|
Changes to src/btree.c.
Changes to src/btree.h.
Changes to src/expr.c.
Changes to src/pragma.c.
Changes to src/select.c.
Changes to src/sqliteInt.h.
Changes to src/vdbe.c.
Changes to src/vdbeInt.h.
Changes to src/vdbeaux.c.
Changes to src/vdbesort.c.
Changes to src/where.c.
Changes to src/whereInt.h.
Changes to test/distinct.test.
Changes to test/orderby5.test.
Changes to test/whereG.test.