/ File History
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

History of test/index.test

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