/ Check-in [591de898]
Login

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

Overview
Comment:Pass the BTREE_UNORDERED hint into both sqlite3BtreeOpen() and into sqlite3BtreeCreateTable().
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1:591de898f41630156cc0fc6ef17dd3ee5e7c479f
User & Date: drh 2011-06-29 17:11:39
Context
2011-07-01
13:50
Ignore the database name on the target table when parsing a CREATE TABLE statement out of the sqlite_master table. This is a fix for ticket [d6ddba6706353] that preserves backwards compatibility. check-in: 009c96ea user: drh tags: trunk
2011-06-30
20:17
Experimental changes to improve optimization of DISTINCT queries. check-in: f7ba0219 user: dan tags: experimental
2011-06-29
17:11
Pass the BTREE_UNORDERED hint into both sqlite3BtreeOpen() and into sqlite3BtreeCreateTable(). check-in: 591de898 user: drh tags: trunk
2011-06-28
14:16
Merge the fts3-changes branch back into the trunk. check-in: b9477eb0 user: dan tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to src/vdbe.c.

  3168   3168       ** sqlite3BtreeCreateTable() with the BTREE_BLOBKEY flag before
  3169   3169       ** opening it. If a transient table is required, just use the
  3170   3170       ** automatically created table with root-page 1 (an BLOB_INTKEY table).
  3171   3171       */
  3172   3172       if( pOp->p4.pKeyInfo ){
  3173   3173         int pgno;
  3174   3174         assert( pOp->p4type==P4_KEYINFO );
  3175         -      rc = sqlite3BtreeCreateTable(pCx->pBt, &pgno, BTREE_BLOBKEY); 
         3175  +      rc = sqlite3BtreeCreateTable(pCx->pBt, &pgno, BTREE_BLOBKEY | pOp->p5); 
  3176   3176         if( rc==SQLITE_OK ){
  3177   3177           assert( pgno==MASTER_ROOT+1 );
  3178   3178           rc = sqlite3BtreeCursor(pCx->pBt, pgno, 1, 
  3179   3179                                   (KeyInfo*)pOp->p4.z, pCx->pCursor);
  3180   3180           pCx->pKeyInfo = pOp->p4.pKeyInfo;
  3181   3181           pCx->pKeyInfo->enc = ENC(p->db);
  3182   3182         }