Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History of test/index.test
|
2019-05-02
| ||
| 17:45 | Ensure that the typeof() function always returns SQLITE_FLOAT for floating point values even when the value is stored as an integer to save space. file: [a2e948ed] check-in: [48889530] user: drh branch: trunk, size: 20396 | |
|
2019-05-01
| ||
| 19:01 | Add a test case for ticket [ae0f637bddc5290b44669e066a]. file: [05414fc7] check-in: [ece48169] user: drh branch: trunk, size: 20184 | |
| 15:32 | Avoid unwelcomed side effects on the input operands in the OP_Concat operator. Fix for ticket [3be1295b264be2fac49b681] file: [58d6fba7] check-in: [713caa38] user: drh branch: trunk, size: 19889 | |
|
2018-11-07
| ||
| 02:17 | Add the SQLITE_DEFAULT_DEFENSIVE compile-time option. Fix up test cases so that they work with DEFENSIVE enabled. file: [df4cddf4] check-in: [3212733c] user: drh branch: read-only-shadow, size: 19538 | |
|
2018-11-03
| ||
| 17:31 | Correct the internal logic for SQLITE_DBCONFIG_DEFENSIVE. file: [5131c010] check-in: [76094345] user: drh branch: dbconfig-defensive, size: 19573 | |
|
2015-08-25
| ||
| 16:57 | Add code to maintain indexes with expression arguments across DELETE, INSERT, and UPDATE statements. Legacy tests pass, but the new code paths are still largely untested. The query planner currently makes no effort to use expression indexes. file: [fe3c7a1a] check-in: [efaabdb7] user: drh branch: index-expr, size: 19371 | |
|
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: [4d990005] check-in: [54b22192] user: drh branch: omit-rowid, size: 19402 | |
|
2013-08-01
| ||
| 22:27 | Fix the CREATE INDEX statement so that trying to create a TEMP index on a non-TEMP table throws an error rather than segfaulting. file: [f2abacfb] check-in: [e3c8935f] user: drh branch: trunk, size: 19386 | |
|
2011-03-09
| ||
| 22:09 | Backport the OP_Next and OP_Prev for UNIQUE indices patch from checkin [f000c9b2b7] on the trunk. file: [7c104b61] check-in: [2d55234e] user: drh branch: branch-3.7.2, size: 18672 | |
| 21:02 | Omit unnecessary OP_Next and OP_Prev operators when uniqueness constraints guarantee that the code will only make one pass through the loop. file: [b5429732] check-in: [f000c9b2] user: drh branch: trunk, size: 18994 | |
|
2010-09-30
| ||
| 17:33 | Do correct affinity transformations on floating point values which have a decimal point at the beginning or end of the mantissa. Ticket [3998683a16a7076e08f5]. file: [df7c00c6] check-in: [ca154f97] user: drh branch: experimental, size: 18994 | |
|
2008-01-16
| ||
| 18:20 | Use 1<<$x instead of pow(2,$x) in the test suite code. (CVS 4715) file: [cbf301cd] check-in: [3a289b6d] user: danielk1977 branch: trunk, size: 18672 | |
|
2006-03-29
| ||
| 00:24 | Properly record the names of triggers even if the name is quoted. Ticket #1737. (CVS 3158) file: [e65df12b] check-in: [4ba280dd] user: drh branch: trunk, size: 18682 | |
|
2006-01-17
| ||
| 09:35 | Test suite fixes for builds that define OMIT symbols. (CVS 2962) file: [c4784596] check-in: [3a54a33d] user: danielk1977 branch: trunk, size: 18584 | |
|
2006-01-04
| ||
| 15:54 | Add support for CREATE INDEX IF NOT EXISTS and DROP INDEX IF EXISTS. (CVS 2855) file: [c90ab389] check-in: [551cdd6c] user: drh branch: trunk, size: 18435 | |
|
2005-11-14
| ||
| 22:29 | Create separate affinities for INTEGER and REAL. (CVS 2766) file: [3871c47e] check-in: [ce06c123] user: drh branch: trunk, size: 18090 | |
|
2005-11-01
| ||
| 15:48 | Omit the SQLITE_AFF_INTEGER type affinity. All numeric values are now of type real, though an integer representation is still sometimes used internally for efficiency. (CVS 2753) file: [83449483] check-in: [e0d6f61c] user: drh branch: trunk, size: 18086 | |
|
2005-01-21
| ||
| 03:12 | Modify test scripts to work when SQLITE_OMIT_SUBQUERY (along with other OMIT macros) is defined. (CVS 2251) file: [51e01a09] check-in: [bb0254ab] user: danielk1977 branch: trunk, size: 18134 | |
|
2004-11-22
| ||
| 08:43 | Modify test suite to work when SQLITE_OMIT_VIEW is defined. (CVS 2132) file: [1294997b] check-in: [711e8d76] user: danielk1977 branch: trunk, size: 18013 | |
|
2004-11-07
| ||
| 13:01 | Reindex tests added and bugs fixed. (CVS 2075) file: [5776a3eb] check-in: [ad433ec2] user: drh branch: trunk, size: 17968 | |
|
2004-11-04
| ||
| 04:42 | All tests pass even if OMIT_TRIGGER is defined. (CVS 2053) file: [4098cd02] check-in: [c33b3a61] user: drh branch: trunk, size: 17735 | |
|
2004-11-03
| ||
| 16:27 | Update tests to work even if some features of the library are disabled. (CVS 2050) file: [83f5c232] check-in: [b11fc9b3] user: drh branch: trunk, size: 17701 | |
|
2004-08-20
| ||
| 18:34 | Tcl interface transfers values directly between SQLite and Tcl_Objs, without at translation to strings. (CVS 1898) file: [31ed90af] check-in: [e97c3313] user: drh branch: trunk, size: 17671 | |
|
2004-07-20
| ||
| 00:52 | Add test for creating indices with quoted names. Ticket #695. (CVS 1831) file: [6db94446] check-in: [7e72c5b7] user: drh branch: trunk, size: 17631 | |
| 00:50 | Fix the handling of indices with quoted names. Ticket #695. (CVS 1830) file: [491d721e] check-in: [46730997] user: drh branch: version_2, size: 13801 | |
|
2004-06-19
| ||
| 00:16 | Change the name of the TCL command from "sqlite" to "sqlite3" so that both SQLite version 2 and SQLite version 3 can be used by Tcl at the same time. (CVS 1626) file: [b6941dd5] check-in: [d705d051] user: drh branch: trunk, size: 17414 | |
|
2004-06-17
| ||
| 06:13 | Handle conflicting ON CONFLICT clauses in table definitions. (CVS 1611) file: [4bd370c6] check-in: [12e77e75] user: danielk1977 branch: trunk, size: 17419 | |
|
2004-06-12
| ||
| 09:25 | (1) Modifications to the user-function interface and (2) Internal changes to automatically created indices. (CVS 1575) file: [4d2e7364] check-in: [5903f538] user: danielk1977 branch: trunk, size: 16389 | |
|
2004-05-28
| ||
| 12:33 | Allow CREATE and DROP VIEW on attached databases. (CVS 1485) file: [ad3f479a] check-in: [ad879a95] user: danielk1977 branch: trunk, size: 13711 | |
|
2004-05-16
| ||
| 22:55 | Fix a bug meant real numbers with a negative sign were being stored as strings by default (instead of IEEE floats). (CVS 1388) file: [3d50e198] check-in: [9321e742] user: danielk1977 branch: trunk, size: 13706 | |
|
2004-05-14
| ||
| 11:00 | Implement type affinity for table and index records (CVS 1375) file: [231ff7a4] check-in: [dbfe6e93] user: danielk1977 branch: trunk, size: 13702 | |
|
2003-09-27
| ||
| 00:41 | Do all WHERE clauses tests, even if an index is used for lookup so that we know the test cannot be FALSE. The test might end up being NULL in which case it would need to be treated as false. Ticket #461. (CVS 1103) file: [9295deef] check-in: [5aea8148] user: drh branch: trunk, size: 13579 | |
|
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: [1962dbc8] check-in: [c9734c27] user: drh branch: trunk, size: 13587 | |
|
2003-04-16
| ||
| 02:17 | Simplify the number processing code. Fix for ticket #281. (CVS 910) file: [90ef4c42] check-in: [4326b52a] user: drh branch: trunk, size: 13317 | |
|
2003-03-30
| ||
| 00:19 | Fix a memory leak in triggers and update tests to show the latest error message text. (CVS 886) file: [faeb1bcf] check-in: [b90d9de3] user: drh branch: trunk, size: 12680 | |
|
2002-08-13
| ||
| 23:02 | Make the distinction between text and numeric data. (CVS 710) file: [2a5a1b65] check-in: [310ac4fb] user: drh branch: trunk, size: 12692 | |
|
2002-07-18
| ||
| 00:34 | Fix for ticket #107: Fix a design defect in indices that was causing queries to fail when using an index on a column containing an empty string. This fix is an incompatible file-format change. (CVS 681) file: [7503d903] check-in: [20d152fc] user: drh branch: trunk, size: 12664 | |
|
2002-07-13
| ||
| 03:11 | Fix for ticket #95: Do not allow automatically created indices (associated with UNIQUE or PRIMARY KEY constraints) to be dropped. (CVS 671) file: [1a69532e] check-in: [0603eb74] user: drh branch: trunk, size: 11462 | |
|
2001-11-24
| ||
| 00:31 | Fix comparison functions so that they are consistent with the order of elements in indices. Fix the handling of large integers. (CVS 317) file: [c8a47124] check-in: [fc2aae04] user: drh branch: trunk, size: 10693 | |
|
2001-11-23
| ||
| 00:24 | Fix a bug in DROP TABLE that could cause SQLITE_MASTER table corruption. The root problem was that the sequence of BTree operations (Delete, Next) would not always leave the cursor pointing at the first entry after the entry that was deleted. A consequence of this error was that a DROP TABLE on a table with indices would not always remove every index associated with that table from the SQLITE_MASTER table. Subsequent attempts to open the database will fail when the index for the missing table was parsed. Changes have also been made to ignore extra indices in the SQLITE_MASTER table so that a database previously corrupted by this bug is once again readable. (CVS 316) file: [c2c30886] check-in: [8a984667] user: drh branch: trunk, size: 9389 | |
|
2001-11-08
| ||
| 00:45 | The new code for taking advantage of inequalities in WHERE clauses is in place. It appears to work. (CVS 305) file: [c5882908] check-in: [262bcd17] user: drh branch: trunk, size: 9115 | |
|
2001-09-27
| ||
| 15:11 | Fixed the support of UNIQUE and PRIMARY KEY. (CVS 268) file: [6076f29d] check-in: [116fdad0] user: drh branch: trunk, size: 9065 | |
|
2001-09-17
| ||
| 20:25 | Add a new column in the SQLITE_MASTER table to record the root page number of primary key indices. (CVS 252) file: [e43e952b] check-in: [602ea4f9] user: drh branch: trunk, size: 9065 | |
|
2001-09-16
| ||
| 00:13 | Disclaimed copyright. Preparing for release 2.0. (CVS 250) file: [9a03f194] check-in: [4e926efe] user: drh branch: trunk, size: 9062 | |
|
2001-09-13
| ||
| 21:53 | Many problems fixed. Many problems yet to go. (CVS 242) file: [73f34cae] check-in: [62c7bd11] user: drh branch: trunk, size: 9605 | |
|
2001-08-19
| ||
| 18:19 | Add index access methods to the DBBE in preparation for adding a new DBBE for the btree.c module. (CVS 236) file: [266474cd] check-in: [c15f6ffc] user: drh branch: trunk, size: 10143 | |
|
2001-04-04
| ||
| 11:48 | Added transaction support (CVS 196) file: [b189ac11] check-in: [35a8feed] user: drh branch: trunk, size: 10142 | |
|
2000-10-19
| ||
| 14:10 | Added the "memory:" driver (CVS 158) file: [ee060ef8] check-in: [54d60c68] user: drh branch: trunk, size: 9795 | |
|
2000-08-02
| ||
| 13:47 | file format change (CVS 122) file: [950be611] check-in: [b7b90237] user: drh branch: trunk, size: 9668 | |
| 12:26 | file format change (CVS 120) file: [e5f4e7ad] check-in: [67f8af37] user: drh branch: trunk, size: 9478 | |
|
2000-06-17
| ||
| 13:12 | :-) (CVS 101) file: [620ceab7] check-in: [6ed35a1d] user: drh branch: trunk, size: 8580 | |
|
2000-06-08
| ||
| 16:54 | :-) (CVS 83) file: [79550e86] check-in: [2e5786d1] user: drh branch: trunk, size: 8575 | |
|
2000-06-03
| ||
| 18:06 | added default values (CVS 46) file: [9f99dca2] check-in: [27c06786] user: drh branch: trunk, size: 7924 | |
|
2000-05-30
| ||
| 03:12 | :-) (CVS 12) file: [8d4f2690] check-in: [20f2811f] user: drh branch: trunk, size: 6593 | |
|
2000-05-29
| ||
| 23:58 | :-) (CVS 9) file: [37cd05c5] check-in: [84333008] user: drh branch: trunk, size: 6599 Added | |