/ Check-in [5d506743]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Remove an unnecessary temporary register allocation.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | orderby-planning
Files: files | file ages | folders
SHA1: 5d506743f541b022cde04a9606baa4680cdfd70b
User & Date: dan 2014-03-24 09:34:58
Context
2014-03-24
18:08
Avoid unnecessary moving of content between registers during an ORDER BY. check-in: 4f472acc user: drh tags: orderby-planning
09:34
Remove an unnecessary temporary register allocation. check-in: 5d506743 user: dan tags: orderby-planning
02:20
Remove a pointless OP_Once operation in ORDER BY clauses with LIMIT. check-in: e6c59d23 user: drh tags: orderby-planning
Changes
Hide Diffs Side-by-Side Diffs Show Whitespace Changes Patch

Changes to src/select.c.

  1142   1142   
  1143   1143     if( pSort->labelBkOut ){
  1144   1144       sqlite3VdbeAddOp2(v, OP_Gosub, pSort->regReturn, pSort->labelBkOut);
  1145   1145       sqlite3VdbeAddOp2(v, OP_Goto, 0, addrBreak);
  1146   1146       sqlite3VdbeResolveLabel(v, pSort->labelBkOut);
  1147   1147     }
  1148   1148     iTab = pSort->iECursor;
  1149         -  regRow = sqlite3GetTempReg(pParse);
  1150   1149     if( eDest==SRT_Output || eDest==SRT_Coroutine ){
  1151   1150       regRowid = 0;
  1152   1151       regRow = pDest->iSdst;
  1153   1152       nSortData = nColumn;
  1154   1153     }else{
  1155   1154       regRowid = sqlite3GetTempReg(pParse);
  1156   1155       regRow = sqlite3GetTempReg(pParse);