Commits

Breadcrumbs

History for

onmaster

User selector

All users

Datepicker

All time

Commit History

Commits on Mar 16, 2015

• Another test case for the planner change on this branch.

  danielk-1977

  committed
  4dc199d

Commits on Mar 14, 2015

• When estimating the number of rows visited by a range scan for which the keys consist of more than one field, consider prefixes of stat4 samples as well as the full samples.

  danielk-1977

  committed
  33aa3c3

Commits on Aug 25, 2014

• In cases where stat4 data is available but cannot be used because the rhs of a range constraint is too complex a expression, fall back to using the default estimates for number of rows scanned.

  danielk-1977

  committed
  686181c

Commits on Jul 22, 2014

• Enhance the sqlite_stat1.stat parsing to allow additional text parameters

  Show description for 5503698
  

  D. Richard Hipp

  committed
  5503698

Commits on Jul 1, 2014

• Add another test to verify that SQLite is using stat4 data for composite primary keys on WITHOUT ROWID tables.

  danielk-1977

  committed
  b6adf92

• Ensure that all fields are loaded from the stat4 table for records that correspond to indexes on WITHOUT ROWID tables with composite primary keys.

  danielk-1977

  committed
  62f8a9d

Commits on Jun 30, 2014

• Fix a problem in where.c with using the stat4 sample data of an index on a WITHOUT ROWID table.

  danielk-1977

  committed
  4b387d2

Commits on Apr 28, 2014

• Add an extra column to a table in analyze9.test to give the planner a little more reason to select an index.

  danielk-1977

  committed
  fe88c43

Commits on Apr 24, 2014

• Changes to the way the planner calculates the costs of various table and index scans. Some test cases still failing.

  danielk-1977

  committed
  cf3d4af

Commits on Feb 28, 2014

• Update some test cases that deal with corrupt databases.

  danielk-1977

  committed
  513b4f4

Commits on Nov 20, 2013

• Further performance tweaks to OP_Column.

  

  D. Richard Hipp

  committed
  e55a136

Commits on Sep 11, 2013

• Tweaks to the index selection logic.

  

  D. Richard Hipp

  committed
  1be68ee

Commits on Sep 10, 2013

• Merge trunk fixes into the unlikely-func branch.

  

  D. Richard Hipp

  committed
  d49ae07

• Deterministically initialize the PRNG used as a tie-breaker in the ANALYZE

  Show description for dda0001
  

  D. Richard Hipp

  committed
  dda0001

Commits on Sep 6, 2013

• Initial implementation of the unlikely() SQL function used as a hint to

  Show description for 7afba13
  

  D. Richard Hipp

  committed
  7afba13

Commits on Sep 3, 2013

• Fix another problem in stat4 sample selection.

  danielk-1977

  committed
  9a4e293

Commits on Sep 2, 2013

• Further stat4 related tests.

  danielk-1977

  committed
  ce69716

• Add tests to check if ANALYZE is choosing common non-periodic samples for the stat4 table.

  danielk-1977

  committed
  c46b67b

• Fix a problem with using stat4 data to estimate the number of rows scanned by a range constraint on the second or subsequent column of any index where an affinity transformation must be applied to …

  Show description for 7a3d57a
  danielk-1977

  committed
  7a3d57a

Commits on Aug 31, 2013

• Fix a problem causing SQLite not to use stat4 or stat3 data to analyze constraints of the form "column = expr COLLATE collation" (those with an explicit COLLATE on the non-column side of the compar…

  Show description for 512b395
  danielk-1977

  committed
  512b395

Commits on Aug 16, 2013

• Add a test for the problem fixed by [91733bc485].

  danielk-1977

  committed
  a648fee

• Fixes for test code that was not working with utf16 databases. Run the analyze*.test scripts as part of the 'utf16' permutation test.

  danielk-1977

  committed
  30f2538

• Add extra tests. No code changes.

  danielk-1977

  committed
  b479727

• Avoid buffer overreads and false OOM error reports that could be caused by corrupted sample records in the sqlite_stat4 table.

  danielk-1977

  committed
  baa499f

Commits on Aug 15, 2013

• Fix a crash that can occur if the sqlite_stat3 or sqlite_stat4 table is corrupt.

  danielk-1977

  committed
  0bac772

• Fix a crash that can occur following an OOM fault.

  danielk-1977

  committed
  bb0198d

• Change some assert() statements in vdbe.c to ensure that a memory cell used to store a VdbeCursor object is not also used for some other purpose.

  danielk-1977

  committed
  c258cbc

• Add tests for sqlite_stat4 sample selection. And a fix for the same.

  danielk-1977

  committed
  5f5ff93

Commits on Aug 12, 2013

• Re-enable reading from the sqlite_stat3 table (as well as sqlite_stat4).

  danielk-1977

  committed
  930aa14

Commits on Aug 10, 2013

• Add the rowid field to the end of sample records stored in the sqlite_stat4 table.

  danielk-1977

  committed
  5260921

Commits on Aug 6, 2013

• Fixes for builds without SQLITE_ENABLE_STAT4.

  danielk-1977

  committed
  58f78b8

Commits on Aug 5, 2013

• Use N separate cursors when scanning an index with N columns to collect sqlite_stat4 data. This fixes a problem with collecting incorrect nEq values from multi-column indexes.

  danielk-1977

  committed
  f70a7da

• Fix a couple of problems in code related to sqlite_stat4.

  danielk-1977

  committed
  e10db14

Commits on Aug 3, 2013

• Begin adding experimental sqlite_stat4 table. This commit is buggy.

  danielk-1977

  committed
  5d582a4

Loading