aboutsummaryrefslogtreecommitdiff
path: root/src
Commit message (Collapse)AuthorAge
...
* An SQLITE_PROTOCOL error counts as a locking error for verificationdrh2011-02-19
| | | | | purposes. FossilOrigin-Name: e87d499a4f8a456111c1f96ca6da31d0810fb7c8
* Change a testcase() added by the previous checkin into an assert().drh2011-02-19
| | | FossilOrigin-Name: 6f3dad32aa0e1e9ee374302c82bea9bd60d5854b
* Add testcase macros to verify that all return values fromdrh2011-02-19
| | | | | walTryBeginRead() are tested. FossilOrigin-Name: 262b6fca0b7a251c02604c684a9f7e7a1434d630
* Changes to make WAL more robust against SQLITE_PROTOCOL errors.drh2011-02-19
| | | FossilOrigin-Name: fd578a32f8e9f04957359e73f244a60f02afe08c
* Fix the sqlite3ValueFromExpr() routine so that it returns SQLITE_NOMEMdrh2011-02-18
| | | | | on an OOM when trying to extract a NULL. FossilOrigin-Name: 1061e94fa983a441b289753b873559163ab849e6
* Remove a no-op code path from sqlite3ExprIsInteger(). Replace it with andrh2011-02-17
| | | | | assert() that proves it always does nothing. FossilOrigin-Name: 7af66d1bd53fd5973281646511e4e1d3b16601a3
* Remove an assert() that was made redundant by the previous checkin.drh2011-02-17
| | | FossilOrigin-Name: 21db719156deef9fb26aff27a01e324da255c825
* Add an ALWAYS() around a always-true test in where.c.drh2011-02-17
| | | FossilOrigin-Name: 8123283ee1a360586a1721a56b4db15718c25ee0
* Fix harmless compiler warnings in the query planner.drh2011-02-16
| | | FossilOrigin-Name: 31fc4ba66e76876b2e7b6b2b74c07f47571938ce
* Add a NEVER() around a test that is believed to always be false.drh2011-02-11
| | | FossilOrigin-Name: f7e2ea33d5b37e5b133d96e96a11d2842504355c
* Skip flattening if subquery has LIMIT and outer query is DISTINCT. Fix for ↵shaneh2011-02-11
| | | | | ticket 752e1646fc. FossilOrigin-Name: 559739998833643f589fa76d8360080691f83c18
* Fix a bug in the new WHERE-clause processing that tries to use andrh2011-02-11
| | | | | | | | index to resolve IS NOT NULL constraints when SQLITE_ENABLE_STAT2 is defined. The bug could cause memory overruns and segfaults. The bug was new to the code and has not appeared in an official release. Found during structural testing. FossilOrigin-Name: a5c36b9f39ab9629b857ec9c550f3892c0d94fb4
* Allow an index paired with a NOT NULL constraint to be used for sortingdrh2011-02-11
| | | | | under the condition that the index be treated as a non-unique index. FossilOrigin-Name: d78949fc93077e1aa7f05cf9f7e947727939cc96
* Disable unused NULL tests when SQLITE_ENABLE_STAT2 is not in use.drh2011-02-11
| | | FossilOrigin-Name: 5ecd11788269e78dc26639b2503a10b7e25b2483
* Add .testctrl option to CLI.shaneh2011-02-10
| | | FossilOrigin-Name: f85afa0ecc7b31d32659ae53e70771cd42abda38
* Split the documentation for sqlite3_wal_checkpoint_v2() and its constantsdrh2011-02-10
| | | | | onto separate pages. No changes to code. FossilOrigin-Name: 0ef8ffd12fce47c3c89e851e5116e2777ea9f435
* Prevent a segfault when automatic indices try to use a column with andrh2011-02-10
| | | | | | unknown collating function. Ticket [77aa3b1e6592582e38605d36]. This check-in also removes some stray \r characters unrelated to the problem. FossilOrigin-Name: f01030a0df4f94f886ab209ee8766b095da28c1e
* Refactor the cost function in the query planner. Give extra cost (thusdrh2011-02-10
| | | | | reduce likelihood of selection) to full table scans. FossilOrigin-Name: 878da276ebf643b716ddd650d4d0ca3595fe5bf2
* Make sure code *compiles* with each OMIT and ENABLE option. Mostly changes ↵shaneh2011-02-09
| | | | | to test modules. FossilOrigin-Name: 7cc515edc9cade2bc6c74699b3e4153bf2b74ebb
* Do not report corruption if the the db size header field is greater than the ↵dan2011-02-09
| | | | | file size on disk unless the two change-counter header fields are identical. Fix for ticket [89b8c9ac54]. FossilOrigin-Name: 00c4596f0b270120848ab8d06dcdec7813a9a315
* Use macros to define the relative costs of search and seek operations whendrh2011-02-09
| | | | | | | computing costs in the query planner. Current constants seems wrong and need to be fixed, but doing so will alter test results. Need more experimentation to determine accurate relative costs. FossilOrigin-Name: 5f2ec44b22062ee9d31e20806fcec0101675aced
* Simplifications to the sqlite3_wal_checkpoint_v2() logic.drh2011-02-09
| | | FossilOrigin-Name: 652b8835c58fc9d474c9837fc966d8857bec4a91
* Cleanup to the OP_Checkpoint opcode.drh2011-02-07
| | | FossilOrigin-Name: f611a5a879b7dec1ed1d8bf32413c8a6b81c3172
* Change blocking-checkpoint tests so that they run once using "PRAGMA ↵dan2011-02-07
| | | | | wal_checkpoint" and once using calls to sqlite3_wal_checkpoint_v2(). Also fix edge cases surrounding the output variables set by wal_checkpoint_v2(). FossilOrigin-Name: 5a4b6652cf3780ffed6fe0fe669e8090b0b71e81
* Merge the stat2 query planner enhancements into the trunk.drh2011-02-04
|\ | | | | FossilOrigin-Name: 499edcbc8ab70fcf35431d4e672c68dbcb6c5aad
| * Change the weighting of binary searches on tables to 1/10th the cost of adrh2011-01-28
| | | | | | | | | | | | | | search on an index. Change the assumed reduction in search space from a indexed range constraint from 1/3rd to 1/4th. Do not let the estimated number of rows drop below 1. FossilOrigin-Name: 4847c6cb71423248b186ab7842b97c83e2f5fefd
| * Change the cost estimator in the query planner to take into account thedrh2011-01-24
| | | | | | | | | | logN rowid lookup cost when going from an index to a table. FossilOrigin-Name: b442525b0ba642bb8d57b87b7b9e373b6046454a
| * Add the ability to use indices for constraints of the form "x IS NOT NULL"drh2011-01-22
| | | | | | | | | | when sqlite_stat2 is available and most entries for column x are NULL. FossilOrigin-Name: 5d5bddd290e71a7b03bcc23ff29881c23233cbff
| * Adjustments to the result row estimator for the IN operator so that it givesdrh2011-01-21
| | | | | | | | | | the same estimates as the equivalent OR operator. Test cases for the same. FossilOrigin-Name: c82cb9c028b3ba5463ae50c30196dbf157a7a305
| * Make use of histogram data to make better estimates for the number of rowsdrh2011-01-21
| | | | | | | | | | that will be returned from "x IN (v1,v2,v3,...)" constraints. FossilOrigin-Name: fd3977a27ae68e694df12a4713e55515c1e87c5d
| * Add the ability to use indices when a range contraint is bounded ondrh2011-01-21
| | | | | | | | | | the lower end by NULL. FossilOrigin-Name: f73a167b434fadcbbd15e3891c4b7f4f87f6363c
| * Use histogram data to improve the row-count estimates on equality constraints.drh2011-01-20
| | | | | | FossilOrigin-Name: 6bfc5c69eb22938972bbf4e60179952dc215f770
| * The first of a planned series of enhancements to the query planner thatdrh2011-01-20
| | | | | | | | | | | | enable it to make better use of sqlite_stat2 histograms when the table has many repeated values. FossilOrigin-Name: 2cd374cd23fa2fd38f49090d6eeb9b1e521d51d5
* | If a deferred foreign key constraint fails on a statement that is not partdrh2011-02-04
|\ \ | | | | | | | | | | | | | | | | | | | | | of a larger transation, make sure that the statement fully ends so that subsequent invocations of the same statement will not pass the constraint because they think the transaction is not closed. This is a merge of the deferred-fk-quirk branch together with a test case. FossilOrigin-Name: 2f94d4623f9aae1b5bc7041bd85f4e3a7462c60e
| * | Ensure that if a deferred FK constraint is violated by a statement that ↵dan2011-01-24
| | | | | | | | | | | | | | | creates its own implicit transaction, the statement is not an "active-write" after sqlite3_step() returns. FossilOrigin-Name: 8063197ef141c0c62ba710efdd2b3421fbee4e5d
* | | Fix the ATTACH command so that the filename argument can be any expressiondrh2011-02-04
| | | | | | | | | | | | | | | | | | | | | and so that if authorizer callback gets a NULL pointer for the filename if the filename argument is anything other than a string literal. Ticket [9013e13dba5b58c7] FossilOrigin-Name: e64e1453a9c204d93de1af92dc0b3ca26762b024
* | | Fix minor problems with the output of "PRAGMA wal_checkpoint". In both code ↵dan2011-02-02
| | | | | | | | | | | | | | | and tests. FossilOrigin-Name: aef61036b31963e4c3ff4e8acf8c1734dc9394af
* | | Merge in the blocking-checkpoint enhancement, including the newdrh2011-02-02
|\ \ \ | | | | | | | | | | | | | | | | | | | | sqlite3_wal_checkpoint_v2() interface and the PRAGMA wal_checkpoint(full) statement. FossilOrigin-Name: bac7342c368a7c4f5f2878e08d9581dcbf57dd58
| * \ \ Merge the checkpoint_fullfsync pragma and the superlock demonstration intodrh2010-11-19
| |\ \ \ | | | | | | | | | | | | | | | | | | | | the checkpoint-v2 experimental branch. FossilOrigin-Name: ebf74015f09fe241c1c6902dc8954f2b59ab41ec
| * | | | Fixes for SQLITE_BUSY handling in blocking checkpoint code.dan2010-11-18
| | | | | | | | | | | | | | | FossilOrigin-Name: 4c663a4dcc77e00558edd94f58410605b95db33a
| * | | | Merge with latest trunk changes.dan2010-11-18
| |\ \ \ \ | | | | | | | | | | | | FossilOrigin-Name: e376480f0855c598c91529abacbd73e31d9f4713
| * | | | | Modify the interface to the blocking wal-checkpoint functionality.dan2010-11-18
| | | | | | | | | | | | | | | | | | FossilOrigin-Name: 72787c010c8944e8fcf9c98aa4482f129142d8e9
| * | | | | Add experimental command "PRAGMA wal_blocking_checkpoint", which uses the ↵dan2010-11-16
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | busy-handler to block until all readers have finished in order to ensure the next writer will be able to wrap around to the start of the log file. FossilOrigin-Name: 7e3fc2c833a5baa08820c499867b6902bdc2ed5a
* | | | | | Remove extra instances of the text "checked out." from sqlite.h.in. Also add ↵dan2011-02-01
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | new file fts3_aux.c to mksqlite3c.tcl. FossilOrigin-Name: 9897da22c5b51611597350efbe8d5dcaf39d748b
* | | | | | Fix a problem causing builds with SQLITE_OMIT_WAL defined to fail.dan2011-02-01
| | | | | | | | | | | | | | | | | | FossilOrigin-Name: b9b48dd8ddceec009b5a22a3699e1524542c004a
* | | | | | Change pager_truncate() to a different method for extending files whiledrh2011-01-28
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | also ensuring that writes are page-size and page-aligned. FossilOrigin-Name: 874bc8844f6494cdbf700bd884dee67d40f11fc0
* | | | | | When extending a database file, do so by writing one or more page-size ↵dan2011-01-28
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | chunks of data to the file, instead of just a single byte to the end. FossilOrigin-Name: 58577135a81d3f19667b1de6167d2e3f1b74cd53
* | | | | | Update all built-in VFSes to return SQLITE_OK for thedrh2011-01-26
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | SQLITE_FCNTL_SYNC_OMITTED file-control operation. Also change the xFileControl methods to return SQLITE_NOTFOUND for unrecognized operation codes. FossilOrigin-Name: 6f2c72a0f6579db3f40c079436ca40e3e52bd6d9
* | | | | | More mutexes around another sqlite3StatusAdd() call.drh2011-01-26
| | | | | | | | | | | | | | | | | | FossilOrigin-Name: e3b500fb5d93d98e6e1ddf6d494a841274d1b68d
* | | | | | Add a mutex around an sqlite3StatusAdd() call to prevent the pagecountdrh2011-01-26
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | overflow measurements from getting off in multithreaded applications. FossilOrigin-Name: 3d8b298dc24fe13a3f390da41f79b8613a6f25a7