Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History of test/intpkey.test
|
2017-11-28
| ||
| 02:47 | Add the "PRAGMA table_ipk(TABLE)" command for evaluation purposes. file: [21290ef8] check-in: [2494132a] user: drh branch: pragma-table-ipk, size: 17096 | |
|
2016-05-07
| ||
| 12:15 | Fix typo in the intpkey-17.2 test. file: [ac71107a] check-in: [a45fda65] user: drh branch: trunk, size: 14753 | |
|
2016-05-06
| ||
| 20:23 | Simplification to the logic used to decide between OP_Seek and OP_NotExists. Use OP_NotExists for both DELETE and UPDATE. file: [890cc2df] check-in: [3a695263] user: drh branch: trunk, size: 14758 | |
| 16:06 | In the WHERE generator, when building code for a DELETE operation, make sure that seeks to the main table are not deferred. This is a better fix for the [16c9801ceba49] bug than the previous. file: [bd821464] check-in: [150dd09e] user: drh branch: ticket-16c9801ce, size: 14524 | |
| 11:31 | Do not scan indexes that have the integer primary key as their left-most column. This fixes the crash of ticket [16c9801ceba] but it seems like the wrong fix. More investigation needed. file: [18ec1f3f] check-in: [50312273] user: drh branch: ticket-16c9801ce, size: 14265 | |
|
2016-04-18
| ||
| 15:46 | Remove quotes from identifiers used as datatype names in a CREATE TABLE statement. Fix for ticket [7d7525cb01b68] file: [153b70e3] check-in: [eba27d4d] user: drh branch: trunk, size: 13642 | |
|
2016-03-16
| ||
| 18:26 | Fix the query planner so that it is able to use the integer primary key from an index as part of a multi-column constraint. file: [70aab097] check-in: [96ea9909] user: drh branch: trunk, size: 13294 | |
|
2013-11-05
| ||
| 13:33 | Standardize the error messages generated by constraint failures to a format of "$TYPE constraint failed: $DETAIL". This involves many changes to the expected output of test cases. file: [7506090f] check-in: [54b22192] user: drh branch: omit-rowid, size: 13294 | |
|
2013-06-03
| ||
| 22:08 | Remove more vestiges of sqlite_query_plan from the test cases. file: [a9674fc6] check-in: [eb27086e] user: drh branch: nextgen-query-plan-exp, size: 13290 | |
|
2012-09-15
| ||
| 18:45 | Attempt to use a covering index even on a full table scan, under the theory that the index will be smaller and require less disk I/O and thus be faster. file: [7af30f6a] check-in: [cfaa7bc1] user: drh branch: fullscan-covering-index, size: 13228 | |
|
2007-11-29
| ||
| 17:43 | When using an index to scan a database table, read column data from the index in preference to the table. This increases the likelihood that the table will not be required at all. (CVS 4580) file: [537669fd] check-in: [061608c7] user: danielk1977 branch: trunk, size: 13213 | |
|
2005-07-21
| ||
| 03:48 | Add comments to test cases. Improvements to the query plan test variable. (CVS 2555) file: [af4fd826] check-in: [ef3a157f] user: drh branch: trunk, size: 13205 | |
|
2005-03-31
| ||
| 18:40 | Make sure integer primary keys larger than 2^31 are handled properly. Ticket #1188. (CVS 2436) file: [aaee5325] check-in: [1d04c2ab] user: drh branch: trunk, size: 13145 | |
|
2005-02-22
| ||
| 09:47 | Fix bug reported on the mailing list for WHERE clauses like (rowid<'2'). (CVS 2357) file: [ce2a5d91] check-in: [b323f0f2] user: danielk1977 branch: trunk, size: 12253 | |
|
2004-11-03
| ||
| 13:59 | More work on optionally removing unused features at compile-time. (CVS 2049) file: [b57cf523] check-in: [a82980fd] user: drh branch: trunk, size: 11446 | |
|
2004-10-18
| ||
| 21:34 | Fix typos in the names of some regression tests. Ticket #962. (CVS 2023) file: [3956a34c] check-in: [77542beb] user: drh branch: trunk, size: 11412 | |
|
2004-06-30
| ||
| 04:02 | Improve test coverage of util.c (CVS 1773) file: [c8efd06d] check-in: [68ac3221] user: drh branch: trunk, size: 11412 | |
| 02:29 | Some extra tests for the OP_MustBeInt opcode. (CVS 1769) file: [8b9590b2] check-in: [b9d5858c] user: drh branch: trunk, size: 11317 | |
|
2004-06-12
| ||
| 09:25 | (1) Modifications to the user-function interface and (2) Internal changes to automatically created indices. (CVS 1575) file: [e6e0d7cc] check-in: [5903f538] user: danielk1977 branch: trunk, size: 10713 | |
|
2004-05-27
| ||
| 17:22 | Remove the COPY command. (CVS 1477) file: [e93d739c] check-in: [287f8673] user: drh branch: trunk, size: 10702 | |
|
2003-06-15
| ||
| 23:42 | Enhance the "PRAGMA integrity_check" command to verify that all indices are correctly constructed. New calls to integrity_check are made in the test suite. These changes are intended to prevent any future problems such as seen in ticket #334. (CVS 1024) file: [9320af48] check-in: [c9734c27] user: drh branch: trunk, size: 10561 | |
|
2003-03-07
| ||
| 19:50 | Do not allow an empty string to be inserted into an INTEGER PRIMARY KEY. (CVS 877) file: [39f49fd9] check-in: [2aba40be] user: drh branch: trunk, size: 10531 | |
|
2003-01-29
| ||
| 18:46 | Better error messages on constraint violations. Additional tests and bug fixes for the callback-free API. (CVS 854) file: [e0e283b0] check-in: [ccc82f1a] user: drh branch: trunk, size: 10386 | |
|
2002-08-15
| ||
| 01:26 | Fixes and test improvements resulting from code coverage testing. (CVS 716) file: [f3620158] check-in: [66a0f6a8] user: drh branch: trunk, size: 10377 | |
|
2002-06-19
| ||
| 20:32 | Fix for ticket #75: Autoincrement INTEGER PRIMARY KEY fields on an INSERT even if the data is coming from a SELECT statement. (CVS 630) file: [69a6a9b4] check-in: [d599f75b] user: drh branch: trunk, size: 10100 | |
|
2002-03-31
| ||
| 18:29 | When an attempt is made to insert an explicit NULL into an INTEGER PRIMARY KEY column, automatically convert the NULL value into a unique integer key. This was already happening when an implied NULL was inserted - when the INTEGER PRIMARY KEY column was omitted from the list of columns being inserted. Patches from Christian Werner. (CVS 510) file: [31b5f28b] check-in: [9e3cf4aa] user: drh branch: trunk, size: 9964 | |
|
2002-02-19
| ||
| 22:42 | New ROWIDs are numbered sequentially. (CVS 383) file: [101ec266] check-in: [1686196a] user: drh branch: trunk, size: 9622 | |
|
2002-01-29
| ||
| 23:07 | The new ON CONFLICT logic is in and passes the legacy tests. But the new capabilities have not been tested and are likely broken. (CVS 356) file: [ce3de832] check-in: [ac8a4189] user: drh branch: trunk, size: 9622 | |
|
2002-01-16
| ||
| 21:00 | Added the last_insert_rowid API function. Improved documentation of the random ROWID algorithm. (CVS 349) file: [d6c7f426] check-in: [f74d61aa] user: drh branch: trunk, size: 9621 | |
|
2002-01-14
| ||
| 02:56 | Fix a bug that could cause UPDATE to fail for a table that contains both an INTEGER PRIMARY KEY and an index. (CVS 346) file: [c9f427cb] check-in: [96cd07a8] user: drh branch: trunk, size: 9544 | |
|
2001-12-22
| ||
| 21:48 | Bug fix in the out-of-order INSERT. (CVS 336) file: [c5776456] check-in: [a26d0880] user: drh branch: trunk, size: 9089 | |
| 19:27 | Update documentation for the 2.2.0 release. (CVS 335) file: [3f765f69] check-in: [14392258] user: drh branch: trunk, size: 9018 | |
| 14:49 | Bug fixing in the new integer primary key code. (CVS 334) file: [1f3b36bc] check-in: [29cab124] user: drh branch: trunk, size: 8078 | |
|
2001-12-21
| ||
| 14:30 | Added support for the INTEGER PRIMARY KEY column type. (CVS 333) file: [79be8360] check-in: [236a54d2] user: drh branch: trunk, size: 2858 Added | |