/ Check-in [6674814a]

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

Comment:Fix typo in comment. No changes to code.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
User & Date: mistachkin 2017-05-02 01:30:44
Move terms of the HAVING clause that reference only columns in the GROUP BY clause over to the WHERE clause, resulting in a faster query plan. check-in: 47cbb471 user: drh tags: trunk
Fix typo in comment. No changes to code. check-in: 6674814a user: mistachkin tags: trunk
Enhance "PRAGMA integrity_check" to detect duplicate rowids within a leaf page. check-in: adcad37b user: dan tags: trunk
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to src/sqlite.h.in.

   853    853   ** anti-virus programs.  By default, the windows VFS will retry file read,
   854    854   ** file write, and file delete operations up to 10 times, with a delay
   855    855   ** of 25 milliseconds before the first retry and with the delay increasing
   856    856   ** by an additional 25 milliseconds with each subsequent retry.  This
   857    857   ** opcode allows these two values (10 retries and 25 milliseconds of delay)
   858    858   ** to be adjusted.  The values are changed for all database connections
   859    859   ** within the same process.  The argument is a pointer to an array of two
   860         -** integers where the first integer i the new retry count and the second
          860  +** integers where the first integer is the new retry count and the second
   861    861   ** integer is the delay.  If either integer is negative, then the setting
   862    862   ** is not changed but instead the prior value of that setting is written
   863    863   ** into the array entry, allowing the current retry settings to be
   864    864   ** interrogated.  The zDbName parameter is ignored.
   865    865   **
   866    866   ** <li>[[SQLITE_FCNTL_PERSIST_WAL]]
   867    867   ** ^The [SQLITE_FCNTL_PERSIST_WAL] opcode is used to set or query the