/ File History
Login

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

History of test/index.test

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