Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History for test/intpkey.test
2025-04-10
| ||
10:18 | [7d54711acf] part of check-in [20acd630b9] Remove unnecessary "www." prefixes on domain names in URLs. (check-in: [20acd630b9] user: drh branch: trunk, size: 14739) | |
2021-03-20
| ||
15:11 | [aee694afed] part of check-in [50fbd53260] Revise tests cases to align with the new EXPLAIN QUERY PLAN output. (check-in: [50fbd53260] user: drh branch: eqp-improvements, size: 14747) | |
2017-11-28
| ||
02:47 | [21290ef810] part of check-in [2494132a2b] Add the "PRAGMA table_ipk(TABLE)" command for evaluation purposes. (check-in: [2494132a2b] user: drh branch: pragma-table-ipk, size: 17096) | |
2016-05-07
| ||
12:15 | [ac71107a49] part of check-in [a45fda657d] Fix typo in the intpkey-17.2 test. (check-in: [a45fda657d] user: drh branch: trunk, size: 14753) | |
2016-05-06
| ||
20:23 | [890cc2df52] part of check-in [3a69526318] Simplification to the logic used to decide between OP_Seek and OP_NotExists. Use OP_NotExists for both DELETE and UPDATE. (check-in: [3a69526318] user: drh branch: trunk, size: 14758) | |
16:06 | [bd82146463] part of check-in [150dd09ebd] 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. (check-in: [150dd09ebd] user: drh branch: ticket-16c9801ce, size: 14524) | |
11:31 | [18ec1f3f39] part of check-in [50312273ff] 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. (check-in: [50312273ff] user: drh branch: ticket-16c9801ce, size: 14265) | |
2016-04-18
| ||
15:46 | [153b70e32d] part of check-in [eba27d4d17] Remove quotes from identifiers used as datatype names in a CREATE TABLE statement. Fix for ticket [7d7525cb01b68] (check-in: [eba27d4d17] user: drh branch: trunk, size: 13642) | |
2016-03-16
| ||
18:26 | [70aab09756] part of check-in [96ea990942] 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. (check-in: [96ea990942] user: drh branch: trunk, size: 13294) | |
2013-11-05
| ||
13:33 | [7506090fc0] part of check-in [54b2219297] 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. (check-in: [54b2219297] user: drh branch: omit-rowid, size: 13294) | |
2013-06-03
| ||
22:08 | [a9674fc619] part of check-in [eb27086e8a] Remove more vestiges of sqlite_query_plan from the test cases. (check-in: [eb27086e8a] user: drh branch: nextgen-query-plan-exp, size: 13290) | |
2012-09-15
| ||
18:45 | [7af30f6ae8] part of check-in [cfaa7bc128] 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. (check-in: [cfaa7bc128] user: drh branch: fullscan-covering-index, size: 13228) | |
2007-11-29
| ||
17:43 | [537669fd53] part of check-in [061608c72a] 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) (check-in: [061608c72a] user: danielk1977 branch: trunk, size: 13213) | |
2005-07-21
| ||
03:48 | [af4fd826c4] part of check-in [ef3a157f46] Add comments to test cases. Improvements to the query plan test variable. (CVS 2555) (check-in: [ef3a157f46] user: drh branch: trunk, size: 13205) | |
2005-03-31
| ||
18:40 | [aaee5325ee] part of check-in [1d04c2ab29] Make sure integer primary keys larger than 2^31 are handled properly. Ticket #1188. (CVS 2436) (check-in: [1d04c2ab29] user: drh branch: trunk, size: 13145) | |
2005-02-22
| ||
09:47 | [ce2a5d9112] part of check-in [b323f0f283] Fix bug reported on the mailing list for WHERE clauses like (rowid<'2'). (CVS 2357) (check-in: [b323f0f283] user: danielk1977 branch: trunk, size: 12253) | |
2004-11-03
| ||
13:59 | [b57cf5236f] part of check-in [a82980fd70] More work on optionally removing unused features at compile-time. (CVS 2049) (check-in: [a82980fd70] user: drh branch: trunk, size: 11446) | |
2004-10-18
| ||
21:34 | [3956a34cc8] part of check-in [77542beb31] Fix typos in the names of some regression tests. Ticket #962. (CVS 2023) (check-in: [77542beb31] user: drh branch: trunk, size: 11412) | |
2004-06-30
| ||
04:02 | [c8efd06db6] part of check-in [68ac322137] Improve test coverage of util.c (CVS 1773) (check-in: [68ac322137] user: drh branch: trunk, size: 11412) | |
02:29 | [8b9590b2db] part of check-in [b9d5858ca1] Some extra tests for the OP_MustBeInt opcode. (CVS 1769) (check-in: [b9d5858ca1] user: drh branch: trunk, size: 11317) | |
2004-06-12
| ||
09:25 | [e6e0d7cca0] part of check-in [5903f53828] (1) Modifications to the user-function interface and (2) Internal changes to automatically created indices. (CVS 1575) (check-in: [5903f53828] user: danielk1977 branch: trunk, size: 10713) | |
2004-05-27
| ||
17:22 | [e93d739c8a] part of check-in [287f86731c] Remove the COPY command. (CVS 1477) (check-in: [287f86731c] user: drh branch: trunk, size: 10702) | |
2003-06-15
| ||
23:42 | [9320af4841] part of check-in [c9734c2707] 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) (check-in: [c9734c2707] user: drh branch: trunk, size: 10561) | |
2003-03-07
| ||
19:50 | [39f49fd993] part of check-in [2aba40bea5] Do not allow an empty string to be inserted into an INTEGER PRIMARY KEY. (CVS 877) (check-in: [2aba40bea5] user: drh branch: trunk, size: 10531) | |
2003-01-29
| ||
18:46 | [e0e283b0cb] part of check-in [ccc82f1ab4] Better error messages on constraint violations. Additional tests and bug fixes for the callback-free API. (CVS 854) (check-in: [ccc82f1ab4] user: drh branch: trunk, size: 10386) | |
2002-08-15
| ||
01:26 | [f3620158fd] part of check-in [66a0f6a8e2] Fixes and test improvements resulting from code coverage testing. (CVS 716) (check-in: [66a0f6a8e2] user: drh branch: trunk, size: 10377) | |
2002-06-19
| ||
20:32 | [69a6a9b41e] part of check-in [d599f75b65] Fix for ticket #75: Autoincrement INTEGER PRIMARY KEY fields on an INSERT even if the data is coming from a SELECT statement. (CVS 630) (check-in: [d599f75b65] user: drh branch: trunk, size: 10100) | |
2002-03-31
| ||
18:29 | [31b5f28b2c] part of check-in [9e3cf4aa2c] 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) (check-in: [9e3cf4aa2c] user: drh branch: trunk, size: 9964) | |
2002-02-19
| ||
22:42 | [101ec26622] part of check-in [1686196a8a] New ROWIDs are numbered sequentially. (CVS 383) (check-in: [1686196a8a] user: drh branch: trunk, size: 9622) | |
2002-01-29
| ||
23:07 | [ce3de83260] part of check-in [ac8a4189e2] 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) (check-in: [ac8a4189e2] user: drh branch: trunk, size: 9622) | |
2002-01-16
| ||
21:00 | [d6c7f42679] part of check-in [f74d61aaf3] Added the last_insert_rowid API function. Improved documentation of the random ROWID algorithm. (CVS 349) (check-in: [f74d61aaf3] user: drh branch: trunk, size: 9621) | |
2002-01-14
| ||
02:56 | [c9f427cb7b] part of check-in [96cd07a881] Fix a bug that could cause UPDATE to fail for a table that contains both an INTEGER PRIMARY KEY and an index. (CVS 346) (check-in: [96cd07a881] user: drh branch: trunk, size: 9544) | |
2001-12-22
| ||
21:48 | [c577645677] part of check-in [a26d0880b2] Bug fix in the out-of-order INSERT. (CVS 336) (check-in: [a26d0880b2] user: drh branch: trunk, size: 9089) | |
19:27 | [3f765f69c3] part of check-in [14392258c5] Update documentation for the 2.2.0 release. (CVS 335) (check-in: [14392258c5] user: drh branch: trunk, size: 9018) | |
14:49 | [1f3b36bcf7] part of check-in [29cab124b4] Bug fixing in the new integer primary key code. (CVS 334) (check-in: [29cab124b4] user: drh branch: trunk, size: 8078) | |
2001-12-21
| ||
14:30 | Added: [79be8360e6] part of check-in [236a54d289] Added support for the INTEGER PRIMARY KEY column type. (CVS 333) (check-in: [236a54d289] user: drh branch: trunk, size: 2858) | |