SQLite: Check-in [75a803e6]

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

Overview

Comment:	Add the SQLITE_REVERSE_UNORDERED_SELECTS compile-time option that causes the "PRAGMA reverse_unordered_selects" setting to be on by default.
Downloads:	Tarball \| ZIP archive \| SQL archive
Timelines:	family \| ancestors \| descendants \| both \| trunk
Files:	files \| file ages \| folders
SHA1:	75a803e694d2c4e67579f45d54a0aaf120411a6e
User & Date:	drh 2014-12-09 15:12:11

Context

2014-12-09
19:07		Make the sqlite3_table_column_metadata() interface available by default and without requiring the SQLITE_ENABLE_COLUMN_METADATA compile-time option. Other sqlite3_column_* interfaces that have a run-time penalty even if they are unused still require the SQLITE_ENABLE_COLUMN_METADATA option at compile-time. (check-in: 4f7549ff user: drh tags: trunk)
15:12		Add the SQLITE_REVERSE_UNORDERED_SELECTS compile-time option that causes the "PRAGMA reverse_unordered_selects" setting to be on by default. (check-in: 75a803e6 user: drh tags: trunk)
14:42		Increase the default minimum PMA size for multi-threaded sorting from 10x the page size to 250x the page size. Provide the SQLITE_SORTER_PMASZ compile-time option to change this default. (check-in: b05340fe user: drh tags: trunk)

Changes

Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to src/main.c.

  2738   2738                    | SQLITE_LoadExtension
  2739   2739   #endif
  2740   2740   #if SQLITE_DEFAULT_RECURSIVE_TRIGGERS
  2741   2741                    | SQLITE_RecTriggers
  2742   2742   #endif
  2743   2743   #if defined(SQLITE_DEFAULT_FOREIGN_KEYS) && SQLITE_DEFAULT_FOREIGN_KEYS
  2744   2744                    | SQLITE_ForeignKeys
         2745  +#endif
         2746  +#if defined(SQLITE_REVERSE_UNORDERED_SELECTS)
         2747  +                 | SQLITE_ReverseOrder
  2745   2748   #endif
  2746   2749         ;
  2747   2750     sqlite3HashInit(&db->aCollSeq);
  2748   2751   #ifndef SQLITE_OMIT_VIRTUALTABLE
  2749   2752     sqlite3HashInit(&db->aModule);
  2750   2753   #endif
  2751   2754