aboutsummaryrefslogtreecommitdiff
path: root/src
Commit message (Collapse)AuthorAge
* Move the tointeger() and toreal() functions out of core and make them intodrh2013-10-14
| | | | | a run-time loadable extension. FossilOrigin-Name: 9f66dd7e3790c04f0ab724419f5381bd21f9ebad
* Add implementations for the toInteger() and toReal() SQL functions.drh2013-10-14
|\ | | | | FossilOrigin-Name: a0f7cbc068416cf55b86056f2ce7ee505c6cc3ea
| * Merge updates from trunk.mistachkin2013-10-12
| |\ | | | | | | FossilOrigin-Name: a88b5be01e68b26267ff6eb05e931ef2e7fc9f99
| * \ Merge updates from trunk.mistachkin2013-09-24
| |\ \ | | | | | | | | FossilOrigin-Name: 435ce3b3fc0cffb4d7e6f2694c3100066e19f9ed
| * \ \ Merge updates from trunk.mistachkin2013-09-06
| |\ \ \ | | | | | | | | | | FossilOrigin-Name: 8922be1a3e0269552e12b87fe1e5141c38a8d3f8
| * | | | When converting from a BLOB value in the tointeger() and toreal() SQL ↵mistachkin2013-09-06
| | | | | | | | | | | | | | | | | | | | | | | | | functions, make sure that endianness of the machine does not matter. FossilOrigin-Name: 94c4cdc50d2753c859e494d53cebd09edd2e5663
| * | | | Merge updates from trunk.mistachkin2013-09-01
| |\ \ \ \ | | | | | | | | | | | | FossilOrigin-Name: 2982725e12715fba425a46ae024f317f031b6a54
| * | | | | Handle BLOBs specially, treating them as binary, in the tointeger() and ↵mistachkin2013-08-31
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | toreal() SQL functions. FossilOrigin-Name: c4c53acb985a248c89db2d75025d941e3a4899bc
| * | | | | Prevent the implementation of the toreal() SQL function from being ↵mistachkin2013-08-29
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 'optimized' by MSVC. FossilOrigin-Name: 047bd1c24553b00ccf12d7745bb4c46820b91f5e
| * | | | | Fix boundary case for the toreal() SQL function.mistachkin2013-08-29
| | | | | | | | | | | | | | | | | | FossilOrigin-Name: abe82c634ccda7d62687df5917d18a9d6e411142
| * | | | | Merge updates from trunk.mistachkin2013-08-28
| |\ \ \ \ \ | | | | | | | | | | | | | | FossilOrigin-Name: ffc6e682836cdf275189427109f8af2aeb423bcd
| * | | | | | Add test cases for tointeger() and toreal() functions. Fixes for several tests.mistachkin2013-08-20
| | | | | | | | | | | | | | | | | | | | | FossilOrigin-Name: 5e1e9fd5e4f189836442baa42244be00de13ff0f
| * | | | | | Fix compiler warnings and boundary cases for the tointeger() and toreal()drh2013-08-20
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | functions. FossilOrigin-Name: 4438b9865826446721b7aa09295fe335bf2fafb7
| * | | | | | Performance optimizations in the VDBE and especially to the OP_Next anddrh2013-08-20
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | related opcodes. FossilOrigin-Name: d78c5d89de4b840351b026c9db1952fc24e689d0
| * | | | | | Performance improvement to SQL function calls in the VDBE.drh2013-08-19
| | | | | | | | | | | | | | | | | | | | | FossilOrigin-Name: d2efea1682a7e708000c1f5d36370aaf1199b3be
| * | | | | | Additional performance improvements in sqlite3BtreeNext() anddrh2013-08-19
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | sqlite3BtreePrevious(). FossilOrigin-Name: 6f99b54aedeb91e46d52f65504d02a9cc61c0062
| * | | | | | Add tointeger() and toreal() SQL functions.mistachkin2013-08-19
| |\ \ \ \ \ \ | | | | | | | | | | | | | | | | FossilOrigin-Name: af49707211ff7c7c4d30f4f457631ea8a9fa39eb
| | * \ \ \ \ \ Merge updates from trunk.mistachkin2013-07-20
| | |\ \ \ \ \ \ | | | | | | | | | | | | | | | | | | FossilOrigin-Name: dd4b77c82af07bdcc92ed743f050e70887e5956e
| | * \ \ \ \ \ \ Merge in the latest changes from trunk. Simplify the implementation of thedrh2013-06-21
| | |\ \ \ \ \ \ \ | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | tointeger() and toreal() functions. Fix test cases and put unambiguous labels on all testcase names. FossilOrigin-Name: 9b837b0508fbfb395f0a0d8e4bd127730c80ffc5
| | * | | | | | | | Merge updates from trunk.mistachkin2013-06-21
| | |\| | | | | | | | | | | | | | | | | | | | | | | | | | | FossilOrigin-Name: fa2a91e6c631864846484d13cffdc51856953cd1
| | * | | | | | | | Merge updates from trunk.mistachkin2013-05-15
| | |\ \ \ \ \ \ \ \ | | | | | | | | | | | | | | | | | | | | | | FossilOrigin-Name: 6fbad957259eb8c15eaf7e5657240ae24aaf343e
| | * \ \ \ \ \ \ \ \ Merge updates from trunk.mistachkin2013-03-13
| | |\ \ \ \ \ \ \ \ \ | | | | | | | | | | | | | | | | | | | | | | | | FossilOrigin-Name: d63fa039a01330f5300c3a936d2f9ffb018952b9
| | * | | | | | | | | | Rename the experimental todouble() function to toreal(), update comments.mistachkin2013-03-13
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | FossilOrigin-Name: 12c318ef1b674d1ef347458ce149398885f5ba10
| | * | | | | | | | | | Increase strictness of the new experimental functions and add more tests.mistachkin2013-03-12
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | FossilOrigin-Name: 05c4463ec5f36dde50f6eb116624dc40142f2c8c
| | * | | | | | | | | | Add experimental tointeger() and todouble() SQL functions.mistachkin2013-03-11
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | FossilOrigin-Name: 465fd853d3e3544cb06b15ffa32ce25774d816c7
* | | | | | | | | | | | Fix for building with SQLITE_OMIT_FOREIGN_KEY.dan2013-10-14
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | FossilOrigin-Name: b8b5f6c8f646989bc62bb59416de9bca003a5896
* | | | | | | | | | | | Update the foreign_key_check pragma so that when a parent table is undefineddrh2013-10-14
|\ \ \ \ \ \ \ \ \ \ \ \ | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | it is treated as an empty table. FossilOrigin-Name: 208b259ad73b51e7df163fee3d7ed2bd79767597
| * | | | | | | | | | | | In "PRAGMA foreign_key_check", treat missing parent tables as empty (instead ↵dan2013-10-12
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | of as errors). FossilOrigin-Name: 8c13a7fd738e5441af370537649b0bfa97679cda
* | | | | | | | | | | | | Corrects to comments on the STAT4 implementation.drh2013-10-14
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | FossilOrigin-Name: e06f74d32d44f281dd21908d401184f35f9455a4
* | | | | | | | | | | | | Make subroutines sampleCopy() and valueFromExpr() have file scope.drh2013-10-14
| |_|_|_|_|_|_|_|_|_|_|/ |/| | | | | | | | | | | | | | | | | | | | | | | FossilOrigin-Name: 1660efbe46439734c7dc1674994ceb86a9b41d1a
* | | | | | | | | | | | Restore the index_list pragma back to its former operation. Create a newdrh2013-10-12
|/ / / / / / / / / / / | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | PRAGMA stats used to access the table and index widths and heights. FossilOrigin-Name: f0cf8c85dcbcc7778aed2816792c368d777f79cb
* | | | | | | | | | | Fix handling of "DROP TABLE" commands when "PRAGMA defer_foreign_keys=1" is set.dan2013-10-12
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | FossilOrigin-Name: 27001356ed8201529b3f31d4313f2010f1b4e1b1
* | | | | | | | | | | Identify requirements text in the SQLITE_CONFIG_ documentation. Fix a typodrh2013-10-11
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | (a duplicated word) in part of that documentation. Add some requirements marks for DETACH to the test scripts. No code changes. FossilOrigin-Name: 1be0a3adaba2914c65c46fbebc4906ae4e70f899
* | | | | | | | | | | Add requirements marks. No code changes.drh2013-10-11
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | FossilOrigin-Name: 5e0d43ab55de006b20c58cb18b938d1c7b658e51
* | | | | | | | | | | Additional test cases and requirements marks for the unlikely(),drh2013-10-11
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | likelihood() and instr() functions. FossilOrigin-Name: 5f01cd36ee8678a07b79f9e01855daffb6bb8c43
* | | | | | | | | | | Fix various harmless compiler warnings. Change the "warnings.sh" script todrh2013-10-11
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | work with STAT4 instead of STAT3. FossilOrigin-Name: 7df06684ab36bfdad9e9aca6940b7a665c2a0cb5
* | | | | | | | | | | Make sure the sqlite3.h file occurs at the very top of the sqlite3.cdrh2013-10-11
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | amalgamation. FossilOrigin-Name: 03593817ab5abdd4bbaa5e47e2e4745eef025af9
* | | | | | | | | | | Fix compilation issue for WinRT.mistachkin2013-10-11
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | FossilOrigin-Name: 7a2006ca94c458c7b1eae7b2b6df51da67546462
* | | | | | | | | | | Make sure the correct printf format is used for type tRowcnt regardlessdrh2013-10-09
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | of whether 32-bit or 64-bit row counts are specified at compile-time. FossilOrigin-Name: e97d7d3044aa6c5e21d1faab7d5e709d92faa261
* | | | | | | | | | | Move a conditional inside of an #ifdef in order to make all branchesdrh2013-10-08
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | reachable regardless of compile-time options used. FossilOrigin-Name: f7cc30d45b77f58c258b21f5823c2b39a44e2bf5
* | | | | | | | | | | Rollback some of the previous changes in the branch such that the estimateddrh2013-10-08
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | row sizes are now only used as a tie-breaker for index scans. FossilOrigin-Name: 65553ff34b41e54d129ff2fee96be714105503c4
* | | | | | | | | | | Use #ifdefs to omit unused code in the columnType() routine depending ondrh2013-10-08
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | compile-time options. FossilOrigin-Name: 3fd5e33217a91402b3499fa0977469b91618a928
* | | | | | | | | | | Further refinement of the idea of multiplying run-time cost estimates bydrh2013-10-08
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | the estimated row size. FossilOrigin-Name: 18bd6ba96d19de6047baebfa15b1f739577c9ec4
* | | | | | | | | | | Multiply all cursor step cost estimates by the estimated size of the row indrh2013-10-07
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | bytes, in order to get the query planner ot make use of estimated row sizes. This check-in uses magic numbers in a few places (for example, estimates of the size of output rows) and needs lots of refinement. Consider this a proof-of-concept only. FossilOrigin-Name: cb34cfe57c2a664fbfae8106e95114400ea222d5
* | | | | | | | | | | Merge bug fixes from trunk.drh2013-10-07
|\ \ \ \ \ \ \ \ \ \ \ | | | | | | | | | | | | | | | | | | | | | | | | FossilOrigin-Name: 1d7b2dc0eae70c0c0e523b715acf758bb4cfa9ac
| * | | | | | | | | | | Restore the hexrekey pragma which was accidently deleted during thedrh2013-10-07
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | pragma refactoring. Make sure the hexkey and hexrekey pragmas do not overflow buffers with a over-length key. FossilOrigin-Name: 0aca31e1514b3df254c049b4251bcb199831681a
| * | | | | | | | | | | Remove an incorrect debugging assert() that was accidently added during thedrh2013-10-06
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | STAT4 enhancement. FossilOrigin-Name: 2bb7f74bbd467b74581699d16b06758f9c9457dc
* | | | | | | | | | | | Accept the sz=N parameter on table-only lines of sqlite_stat1.drh2013-10-06
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | FossilOrigin-Name: e9e932aa400f217e383cda9922fbde8a4356f57a
* | | | | | | | | | | | Fix an issue in the test8.c test module that arises because of the changedrh2013-10-05
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | to PRAGMA index_list(). Remove an unused local variable. FossilOrigin-Name: 029430c503f243a34439698779db7e591cfbe126
* | | | | | | | | | | | Completely remove the iScanRatio field. The PRAGMA index_list(TABLE) commanddrh2013-10-05
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | shows the estimated row size in the forth column. It also generates a row for the table with an index name of NULL. The query planner still does not take row size estimates into account - that is the next step. FossilOrigin-Name: 8b4aa0c7a2122bbe60432edadf27e490e31ec987