Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
50 descendants and 50 ancestors of 9844269b3d3729972ccd31c1cb61cb69ae693a9e
|
2013-07-30
| ||
| 15:16 | Disable an expensive assert() routine in lsm_sorted.c unless LSM_EXPENSIVE_DEBUG is defined. check-in: c84d1b37c1 user: dan tags: trunk | |
| 14:34 | Enhanced comments and logic clarification in the OP_MakeIdxKey implementation. check-in: 2054b8483b user: drh tags: trunk | |
| 14:16 | Checked in untested changes by mistake. Closed-Leaf check-in: 3fe22bbdf0 user: drh tags: mistake | |
| 13:22 | Remove unused P4 parameter type codes. Other cleanup of P4. check-in: 3fa3e910e2 user: drh tags: trunk | |
| 12:14 | Simplification of the ORDER BY code generator logic, requiring fewer calls to OP_Column. check-in: eddeadfc27 user: drh tags: trunk | |
| 11:55 | Reenable fts5 hooks in where.c. check-in: c748d90f94 user: dan tags: trunk | |
| 02:47 | Update the sorter logic to eliminate the need for pseudo-tables and remove the code that implemented them. check-in: b9e5f3c6df user: drh tags: trunk | |
| 02:11 | Provide more detail in the P4 column in EXPLAIN output. check-in: 34abc4149f user: drh tags: trunk | |
| 01:30 | Combine the OP_IdxInsert, OP_SorterInsert, and OP_Insert opcodes into the single OP_Insert opcode. check-in: 3b7caafe8c user: drh tags: trunk | |
|
2013-07-29
| ||
| 20:26 | Change the name of Column.isPrimKey to Column.iPrimKey, make it a u16, and make it hold the integer column number of the column within the primary key. check-in: 6d33ce14cd user: drh tags: trunk | |
| 19:31 | Remove the unused OP_InsertInt opcode from the VDBE. check-in: 3e371e1a44 user: drh tags: trunk | |
| 18:07 | Remove some rowid-related dead code from where.c. Fix other code issues in the same file. check-in: 4856f08944 user: dan tags: trunk | |
| 17:57 | Code clarifications: Do not overload the "nField" variable (in the OP_MakeRecord opcode) to mean something other than the number of fields to be encoded. check-in: 20962f1a72 user: drh tags: trunk | |
| 17:15 | Improved EXPLAIN output for the OP_Permutation and OP_Blob opcodes. check-in: 753ffb5857 user: drh tags: trunk | |
| 12:31 | Fix an typo affecting virtual WHERE clause terms made in [3f4a1c7648]. check-in: 736b5e6a1a user: dan tags: trunk | |
|
2013-07-27
| ||
| 18:52 | Fixes for sqlite_stat3 related functionality. Also EXPLAIN QUERY PLAN. check-in: 2fbe583868 user: dan tags: trunk | |
|
2013-07-26
| ||
| 21:13 | Remove unused fields from KeyInfo. Enhancement the EXPLAIN output for KeyInfo P4 columns. check-in: 9eb585660b user: drh tags: trunk | |
| 20:04 | Update where.c with patches from sqlite3. src4 where.c is now based on sqlite3 artifact 1a26c37b7b. check-in: 3f4a1c7648 user: dan tags: trunk | |
| 19:13 | Fix some issues with assigning costs to loops in where.c. check-in: faac50a266 user: dan tags: trunk | |
| 16:59 | Fix minor errors in the key encoder. check-in: 0a923f20d2 user: drh tags: trunk | |
| 16:20 | Change the data encoding (again) to make content-in-key use fewer bytes, since one suspects that this will become a common encoding. FILE FORMAT CHANGE. check-in: 0275ee48db user: drh tags: trunk | |
| 15:30 | Add decoder logic to facilitate extracting column values from the key of a key/value pair for a row. check-in: 30167422e4 user: drh tags: trunk | |
|
2013-07-25
| ||
| 23:26 | Add the kvreplace(K,V) pragma for use in testing. check-in: b5ceafc26f user: drh tags: trunk | |
| 20:02 | Partially reenable automatic indexes. Six legacy tests cases in autoindex1.test are still failing as of this commit. check-in: 2244abfac2 user: dan tags: trunk | |
| 15:13 | Reenable the whereShortCut() optimization. check-in: 97c7b5580f user: dan tags: trunk | |
| 14:18 | Update test file eval.test to account for caching in the RowDecoder. check-in: 3bbe9e80b8 user: dan tags: trunk | |
| 12:12 | Fixes to sqlite4FindInIndex so as to handle WHERE clauses of the form "x IN (SELECT a FROM tbl)" where there are usable indexes on both "a" and "x". check-in: 856ed13e06 user: dan tags: trunk | |
| 02:52 | Update comments on OP_MakeRecord. No changes to code. check-in: 70d85ff051 user: drh tags: trunk | |
| 01:12 | Fix the RowDecoder caching logic by adding new cache clears to opcodes that move the cursor. check-in: d5abe1bca0 user: drh tags: trunk | |
| 00:55 | Enhance the RowDecoder object so that it persists on a VdbeCursor and can be reused for multiple OP_Column operations. This opens the possibility of adding caching of header information and/or values in a later check-in. check-in: 6ed358511b user: drh tags: trunk | |
|
2013-07-24
| ||
| 21:38 | Move all VdbeCursor methods into the vdbecursor.c source file. check-in: 5d08b14478 user: drh tags: trunk | |
| 20:07 | Rename the ValueDecoder object to RowDecoder, in anticipation of enhancing it to be able to extract content from both the key and the value. Simplifications and cleanup of the VdbeCursor object. check-in: 6c7c9133d7 user: drh tags: trunk | |
| 19:25 | Replace test file distinct.test with the version from sqlite3. This version accounts for NGQP related changes. check-in: 41fc47c1cd user: dan tags: trunk | |
| 18:56 | Remove routines related to sqlite3 varint format. check-in: a30bf1665b user: dan tags: trunk | |
| 18:47 | Remove the (non-working) xfer-optimization code. check-in: edd188471c user: drh tags: trunk | |
| 18:30 | Reenable covering index support in NGQP. check-in: 9e99914519 user: dan tags: trunk | |
|
2013-07-23
| ||
| 16:50 | Change where.c to read values from covering indexes instead of tables whenever possible. Modify OP_SeekPk to defer seeks (as OP_Seek does in sqlite3). check-in: 7f6b4708c2 user: dan tags: trunk | |
|
2013-07-22
| ||
| 20:12 | Add two new value-encoding header codes to represent REAL-IN-KEY and NONREAL-IN-KEY. This is an incompatible file format change. check-in: b7ac369ba7 user: drh tags: trunk | |
| 19:49 | Fix compiler warnings. check-in: 610033d7f5 user: drh tags: trunk | |
| 18:38 | Add the COVERING clause to CREATE INDEX statements. Does not work yet, this commit just adds parser support. check-in: 1710627ec6 user: dan tags: trunk | |
| 13:24 | Disable automatic indices at all times. They do not currently work. Needs to be fixed. check-in: 446fbd37d1 user: drh tags: trunk | |
| 12:50 | Merge the NGQP branch back into trunk. Currently 12 tests are failing in src4.test (all errors are artifacts of the test code). check-in: 4af30d63ec user: dan tags: trunk | |
|
2013-07-20
| ||
| 20:20 | Fix for optimization of DISTINCT. Leaf check-in: ed333d20c7 user: dan tags: nextgen-query-planner | |
| 16:32 | Update test script e_fkey.test. check-in: dd9849225b user: dan tags: nextgen-query-planner | |
| 16:10 | Another problem with LIKE optimization. check-in: 3eaf921c5b user: dan tags: nextgen-query-planner | |
|
2013-07-19
| ||
| 20:03 | Update a couple of test case files. check-in: 3b9ae7c6db user: dan tags: nextgen-query-planner | |
| 19:20 | Fix a bug to do with ORDER BY and collation sequences. check-in: 57b8ae848c user: dan tags: nextgen-query-planner | |
| 18:33 | Fix some problems to do with optimizing ORDER BY queries. check-in: cc7bc86da5 user: dan tags: nextgen-query-planner | |
|
2013-07-18
| ||
| 19:53 | Fix some problems with the LIKE optimization. check-in: 8330a46831 user: dan tags: nextgen-query-planner | |
|
2013-07-17
| ||
| 20:03 | Fix a bug preventing the planner from finding sorting indexes. check-in: 6f06ebee56 user: dan tags: nextgen-query-planner | |
| 18:49 | Further updates to ngqp code. check-in: 9844269b3d user: dan tags: nextgen-query-planner | |
|
2013-07-16
| ||
| 20:01 | Updates to use the next-generation-query-planner from the SQLite3 project. This branch is largely broken. check-in: bc9c9f73c5 user: dan tags: nextgen-query-planner | |
|
2013-07-06
| ||
| 23:14 | Add tests for sqlite4_num_sub with inf and nan. check-in: ed79d6f7fa user: peterreid tags: trunk | |
| 23:07 | Change some repetitive num tests into loops. check-in: abaf3f1abd user: peterreid tags: trunk | |
| 22:55 | Remove unused variables from sqlite4_num_mul. check-in: 1d4a5055fa user: peterreid tags: trunk | |
| 22:43 | Multiplying NaN*Inf returns NaN, as Inf*NaN already did. Add related test cases. check-in: 04dad0b7c9 user: peterreid tags: trunk | |
| 04:15 | Remove no-longer-used P4_REAL type for VdbeOp, which has been replaced by P4_NUM. check-in: 960d38f214 user: peterreid tags: trunk | |
| 03:59 | Display sqlite4_nums correctly when explaining query plans. check-in: 40b76362c9 user: peterreid tags: trunk | |
|
2013-07-04
| ||
| 18:44 | Copy the new version of script "like.test" from sqlite3 to this project. Then tweak it to work. check-in: 1468464069 user: dan tags: trunk | |
| 17:17 | Fix a problem with reading utf-8 encoded text values from the database when the first byte of the text is 0x02. check-in: 2711bdb5fd user: dan tags: trunk | |
|
2013-06-29
| ||
| 20:12 | Also run legacy scripts index.test and laststmtchanges.test. check-in: de90289df1 user: dan tags: trunk | |
| 18:46 | Run further legacy tests. Fixes for bugs brought to light by the same. check-in: cb7a8b464e user: dan tags: trunk | |
|
2013-06-27
| ||
| 20:23 | Run some more legacy tests. Fix some issues with converting between text and numeric values. check-in: d6d0e21ad2 user: dan tags: trunk | |
| 17:40 | Run some more legacy test cases. check-in: 731841907a user: dan tags: trunk | |
|
2013-06-26
| ||
| 20:29 | Further fixes for legacy test cases. check-in: 22365cae27 user: dan tags: trunk | |
| 16:46 | Reintroduce pragma command "database_list". Fix a bug in MakeIdxKey. Fix some legacy test case scripts. check-in: 13f06a9fbe user: dan tags: trunk | |
|
2013-06-25
| ||
| 20:07 | Fixes for ALTER TABLE functionality. check-in: c23ed5d08f user: dan tags: trunk | |
| 16:22 | Also run analyze8.test as part of src4.test. check-in: 21b5123716 user: dan tags: trunk | |
| 15:28 | Fix comments and a memory leak in analyze.c. check-in: 8a25008dfe user: dan tags: trunk | |
| 14:47 | Have the planner always consider the PK index, even when it does not serve to satisfy any contraints or ordering requirements. check-in: 95933bb7ca user: dan tags: trunk | |
| 11:58 | Run test files analyze5.test, analyze6.test and analyze7.test as part of src4.test. check-in: 8eb90b6647 user: dan tags: trunk | |
|
2013-06-24
| ||
| 20:06 | Fix another bug in sqlite_stat3 related code. check-in: bad9060b5b user: dan tags: trunk | |
| 19:03 | Fixes for the sqlite_stat3 related ANALYZE functionality. check-in: f93e75f2b1 user: dan tags: trunk | |
|
2013-06-22
| ||
| 19:57 | Fixes for SQLITE4_ENABLE_STAT3 builds. check-in: d5d0e93a57 user: dan tags: trunk | |
|
2013-06-17
| ||
| 20:15 | Modifications to make the ANALYZE command work (sqlite_stat1 only). check-in: 7d8efac62f user: dan tags: trunk | |
| 05:35 | Remove the sqlite4_progress_handler interface. Change the documentation of load_extension() to say that it sets the db handle error message and code. check-in: 02ec769ae0 user: dan tags: trunk | |
|
2013-06-15
| ||
| 19:47 | Add destructors to the sqlite4_trace and sqlite4_profile routines. check-in: fd63f9cb75 user: dan tags: trunk | |
| 17:45 | Add tests to ensure that the collation_needed destructor is invoked as required. check-in: 6e0b04adb9 user: dan tags: trunk | |
|
2013-06-14
| ||
| 20:03 | Add a destructor function to the collation_needed() API. check-in: 577089fa36 user: dan tags: trunk | |
| 18:28 | Have sqlite4_authorizer_push() invoke any destructor passed to it if an error (i.e. a malloc failure) occurs. check-in: cb28262fc8 user: dan tags: trunk | |
| 17:16 | Update create_collation() documentation. Have the create_collation() function invoke the destructor (if one was specified) before returning if it fails. check-in: bcf7a78f8b user: dan tags: trunk | |
|
2013-06-13
| ||
| 20:20 | Remove the encoding argument from sqlite4_create_collation(). Pass sqlite4_value objects to the collation sequence callbacks instead. check-in: 7f314c9a71 user: dan tags: trunk | |
| 16:32 | Remove the no longer required FuncDestructor object. check-in: e5d82c92f0 user: dan tags: trunk | |
| 15:24 | Remove the 'encoding' argument from sqlite4_create_function(). check-in: f88d080127 user: dan tags: trunk | |
|
2013-06-12
| ||
| 19:20 | Add file selectF.test. check-in: 9678daa99f user: dan tags: trunk | |
|
2013-06-11
| ||
| 17:27 | Add a note to www/porting.wiki describing the changes to utf-16 support. check-in: 5cd50e225c user: dan tags: trunk | |
| 16:48 | Remove legacy API functions: complete16(), errmsg16(), column_name16(), column_database_name16(), column_table_name16(), column_origin_name16(), column_decltype16(), create_function16() and collation_needed16(). check-in: c7c533dddc user: dan tags: trunk | |
| 15:18 | Add tests and minor fixes for the sqlite4_translate() API. check-in: 211c1baef7 user: dan tags: trunk | |
|
2013-06-10
| ||
| 19:52 | Add the sqlite4_translate() API, for translating between utf-8 and utf-16 text encodings. Also the sqlite4_buffer object. check-in: f56bc22c9e user: dan tags: trunk | |
|
2013-06-07
| ||
| 19:29 | Allow collation sequence comparison functions to return errors. check-in: 596c1f3869 user: dan tags: trunk | |
| 14:36 | Change the order of the parameters passed to sqlite4_collation_needed() and needed16() to be consistent with other callback APIs. check-in: 22b6bdf65a user: dan tags: trunk | |
| 14:22 | Remove the error message output parameter from sqlite4_exec(). check-in: 6833c6df33 user: dan tags: trunk | |
| 02:00 | Replace placeholder sqlite4_num_to_int32. Change API to be analogous sqlite4_num_to_int64. Add tests. check-in: 762134b4a8 user: peterreid tags: trunk | |
| 00:51 | Correct comments in header of num test check-in: 8cb787fa4a user: peterreid tags: trunk | |
| 00:49 | Coverting an approximate sqlite4_num to int64 is flagged as lossy. check-in: b667dab56b user: peterreid tags: trunk | |
|
2013-06-06
| ||
| 17:18 | Change the names of some API functions to make their purposes clearer: "get_auxdata" -> "auxdata_fetch", "set_auxdata" -> "auxdata_store", "get_autocommit" -> "db_transaction_status", and "sql" -> "stmt_sql". check-in: c8d956ad1a user: dan tags: trunk | |
| 16:43 | Add documentation for sqlite4_kvstore_methods.xGetMethod. Use the lsm pragmas in various tests instead of the file-controls. check-in: c39156d2b8 user: dan tags: trunk | |
|
2013-06-05
| ||
| 20:25 | Allow key-value stores to intercept pragma commands. check-in: 0e6201380c user: dan tags: trunk | |
|
2013-06-04
| ||
| 15:16 | Fix a few warnings relating to unused variables and functions. check-in: 424d39678b user: dan tags: trunk | |
|
2013-06-03
| ||
| 19:25 | Remove the use of type 'double' from date.c. check-in: fa869b0982 user: dan tags: trunk | |
| 15:23 | Merge overflow and rounding fixes for sqlite4_num_to_int64(). check-in: e8db1e81a4 user: dan tags: trunk | |