/ Timeline
Login

100 check-ins occurring around 0e190e9d91.

2005-07-23
02:17
Full-coverage testing and documentation for the ANALYZE command. The results of analysis are still not loaded or used, however. (CVS 2561) check-in: bd7583a5 user: drh tags: trunk
00:41
First code for the ANALYZE command. Mostly untested. The analysis is not loaded into the symbol tables and is not used by the optimizer. (CVS 2560) check-in: a4886b11 user: drh tags: trunk
2005-07-22
23:56
Clarify the meaning of the TEMP keyword on CREATE TABLE. (CVS 2559) check-in: 1a573619 user: drh tags: trunk
22:53
Correct the documentation to show that sqlite3_column_text() returns a NULL pointer (not an empty string) when the column value is NULL. The same goes for sqlite3_column_blob(). Ticket #1334. (CVS 2558) check-in: fd1e013a user: drh tags: trunk
00:31
Begin adding code to support multiple IN constraints on the same index. (CVS 2557) check-in: 103f8ccb user: drh tags: trunk
2005-07-21
18:23
Split the OP_Integer opcode into OP_Integer and OP_Int64. This allows comments to be added to OP_Integer. Cleanup in the optimizer. Allow terms of the FROM clause to be reordered automatically. (CVS 2556) check-in: e2f822ac user: drh tags: trunk
03:48
Add comments to test cases. Improvements to the query plan test variable. (CVS 2555) check-in: ef3a157f user: drh tags: trunk
03:15
In where.c, split out the code that selects an index into a separate subroutine. (CVS 2554) check-in: c30cbba9 user: drh tags: trunk
2005-07-20
14:31
Extra memory usage instrumentation added. (CVS 2553) check-in: ac669f56 user: drh tags: trunk
2005-07-19
22:22
More refactoring in where.c. (CVS 2552) check-in: a35bd50a user: drh tags: trunk
17:38
Refactoring of the query optimizer in advance of adding better optimization. (CVS 2551) check-in: 57c6bd37 user: drh tags: trunk
2005-07-16
13:33
Allow an unlimited number of terms in the WHERE clause. The old limit was 100. (CVS 2550) check-in: ca69f368 user: drh tags: trunk
2005-07-15
23:24
Fix bugs in the new query plan instrumention logic. (CVS 2549) check-in: 578490c9 user: drh tags: trunk
13:05
Add test instrumentation that will be needed during the development of forthcoming optimizer enhancements. (CVS 2548) check-in: dfd5fd77 user: drh tags: trunk
2005-07-09
23:11
Add remark in the changelog that mentions 64-bit alignment fixes in 3.2.2. (CVS 2547) check-in: ead583cf user: drh tags: trunk
02:39
Fix a comment error. No changes to code. Ticket #1320. (CVS 2546) check-in: e050af70 user: drh tags: trunk
02:38
Use the internal sqlite3_snprintf function instead of sprintf to avoid cross-platform incompatibilities. Ticket #1316. (CVS 2545) check-in: 431999da user: drh tags: trunk
02:23
Patch to Makefile.in so that it works with OS X. Ticket #1292. (CVS 2544) check-in: 0dfabca6 user: drh tags: trunk
02:16
Make sure there is only one busy counter. Ticket #1315. (CVS 2543) check-in: af2a0ba4 user: drh tags: trunk
2005-07-08
18:25
Allow the IN operator to take a list of arbitrary expressions on its right-hand side. The expressions no longer need to be constant. The current implementation seems to work but needs more testing and optimization. (CVS 2542) check-in: ba56478d user: drh tags: trunk
17:13
Change the name of the OpenTemp opcode to OpenVirtual which is more descriptive of what it does. (CVS 2541) check-in: 3bb9ce5f user: drh tags: trunk
14:14
Add the EP_OptOnly flag on expressions for WHERE clause terms that are added by the optimizer but should not be coded. (CVS 2540) check-in: f4a66ed0 user: drh tags: trunk
13:53
Add the SQLITE_CASE_SENSITIVE_LIKE compile-time option. (CVS 2539) check-in: b72bff81 user: drh tags: trunk
13:08
Replace OP_List with OP_Fifo. This is the first step toward allowing recursive delete triggers and later foreign keys with cascading deletes. (CVS 2538) check-in: 94c120bb user: drh tags: trunk
12:13
Add infrastructure for the ANALYZE command. Does not yet actually do anything. (CVS 2537) check-in: 05b6ac9a user: drh tags: trunk
2005-07-06
13:51
Fix a quoting problem in the configure script. (CVS 2536) check-in: b34647a2 user: drh tags: trunk
2005-07-01
11:38
Fix typos in comments. No changes to code. (CVS 2535) check-in: d3b03495 user: drh tags: trunk
2005-06-30
17:04
Allow the DEFAULT value of a column to be obtained by calling a function that has constant arguments, such as julianday('now'). (CVS 2534) check-in: d273766e user: drh tags: trunk
2005-06-29
17:24
Check for zero-byte allocations in sqlite3MallocRaw. (CVS 2533) check-in: 78cb8a9a user: drh tags: trunk
15:33
Make sqlite3Malloc always return NULL when the number of bytes to allocate is 0. (CVS 2532) check-in: 657d74eb user: drh tags: trunk
2005-06-26
20:00
Update SQL syntax documentation to describe the new CAST expressions. (CVS 2531) check-in: d5392866 user: drh tags: trunk
17:55
Tcl interface uses Tcl_Objs to implement user-defined functions, thus allowing BLOB values to be transferred correctly. Ticket #1304. (CVS 2530) check-in: 514aaab3 user: drh tags: trunk
2005-06-25
19:42
Documentation fixes. Ticket #1306. (CVS 2529) check-in: 3dcdb794 user: drh tags: trunk
19:31
The TCL interface binds variables as BLOB only if they have a bytearray representation but no text representation. Ticket #1287. (CVS 2528) check-in: 8c99dca6 user: drh tags: trunk
18:42
Remove the blob(), text() and numeric() functions added in (2524) and replace them with the standard CAST operator. Ticket #1287. (CVS 2527) check-in: 17631785 user: drh tags: trunk
2005-06-24
03:53
NULL values in a row of a unique index cause the row to be distinct. Ticket #1301. More testing and optimization needs to be done on this before closing the ticket. (CVS 2526) check-in: 06a71b16 user: drh tags: trunk
2005-06-23
03:15
Make sure the String8 opcode always has a non-null P3 argument in the foreign_key_list pragma. Ticket #1297. (CVS 2525) check-in: bcf62dc7 user: drh tags: trunk
2005-06-22
10:53
Add built-in functions numeric(), text(), and blob() that coerce types. Ticket #1287. (CVS 2524) check-in: affb0fa2 user: drh tags: trunk
08:48
Allow parameters to be introduced by characters ':', '$' and '#'. This is an experimental change. (CVS 2523) check-in: f3427a13 user: drh tags: trunk
02:36
Fix a bug in an assert found while investigating ticket #1287 but otherwise unrelated to that problem. (CVS 2522) check-in: 60f752ed user: drh tags: trunk
2005-06-16
19:48
Change the documentation to explain that a database handle can only be used in the same thread in which it was created. Ticket #1272. (CVS 2521) check-in: 59c95731 user: drh tags: trunk
18:47
Fix the THREADSAFE macro in Makefile.in. We really need to rework the whole autoconf build system.... (CVS 2520) check-in: 98a4de76 user: drh tags: trunk
16:51
Change to Makefile.in to fix a problem with the Borland linker. Ticket #1291. (CVS 2519) check-in: bc253977 user: drh tags: trunk
2005-06-15
18:07
Fix to the "make doc" makefile target. Ticket #1289. (CVS 2518) check-in: 4713b1e1 user: drh tags: trunk
17:47
Changes to the unix OS layer aimed at finding and fixing tickets #1272 and #1285. (CVS 2517) check-in: 006dda31 user: drh tags: trunk
2005-06-14
17:47
Fix an NDEBUG versus SQLITE_DEBUG confusion issue. (CVS 2516) check-in: 833c0160 user: drh tags: trunk
16:04
Provide the SQLITE_FILE_HEADER command-line option for changing the text that appears at the beginning of databases. (CVS 2515) check-in: 3d7ee5b9 user: drh tags: trunk
02:24
Fix a bug in the default busy handler for systems that lack usleep(). Ticket #1284. (CVS 2514) check-in: a42cb81d user: drh tags: trunk
02:12
Do not record existance the sqlite_sequence table until it is actually created. Ticket #1283. (CVS 2513) check-in: 95256d95 user: drh tags: trunk
2005-06-13
00:48
Fix documentation typo. Ticket #1282. (CVS 2512) check-in: ce6b62fa user: drh tags: trunk
2005-06-12
23:17
Version 3.2.2 (CVS 2511) check-in: 0e190e9d user: drh tags: trunk
23:16
Update the EXPORT definitions list to include the latest additions to the API. (CVS 2510) check-in: 44e54b13 user: drh tags: trunk
22:23
Updates in preparation for the release of version 3.2.2. (CVS 2509) check-in: e9602c4a user: drh tags: trunk
22:12
Fix documentation typos. (CVS 2508) check-in: 41049062 user: drh tags: trunk
22:01
Documentation updates (ticket #1279). Add the sqlite3_db_handle API. (ticket #1275). (CVS 2507) check-in: 21d44fa5 user: drh tags: trunk
21:35
Update older opcode names to be more meaningful in light of the latest code design. (CVS 2506) check-in: 36f2da1f user: drh tags: trunk
12:01
Elminiate a VM opcode that was no longer needed. (CVS 2505) check-in: 97b348a5 user: drh tags: trunk
2005-06-07
22:22
Changes to support linking without a parser and without a disk I/O interface. (CVS 2504) check-in: 62a7353d user: drh tags: trunk
20:07
In the documentation, amplify the fact that encodings cannot be changed on a database that already exists. Ticket #1277. (CVS 2503) check-in: 4704f3a1 user: drh tags: trunk
09:21
Remove SSE vacuum hook. (CVS 2502) check-in: 59960a59 user: danielk1977 tags: trunk
07:58
Add "#ifndef OMIT_DISKIO" condition around sqlite3_opentemp_count variable in test interface code. (CVS 2501) check-in: f2ce662e user: danielk1977 tags: trunk
02:12
Add tests to make sure statement journals are only opened when necessary. (CVS 2500) check-in: 914d6e65 user: drh tags: trunk
01:43
Do not open a statement journal unless absolutely necessary. (CVS 2499) check-in: 989573a5 user: drh tags: trunk
2005-06-06
21:19
Reference count Table structures so that they are not deallocated too soon. Ticket #1210. (CVS 2498) check-in: e73d25c7 user: drh tags: trunk
17:54
Return SQLITE_MISUSE when passing a NULL pointer into sqlite3_bind routines. Ticket #1219. (CVS 2497) check-in: 12c32f13 user: drh tags: trunk
17:27
Any non-zero value is considered TRUE in a WHERE clause. Ticket #1211. (CVS 2496) check-in: 0f7af623 user: drh tags: trunk
17:11
Avoid ambiguous column name errors when the column name is in the USING clause of a join. Ticket #743. (CVS 2495) check-in: 6a51bdee user: drh tags: trunk
16:59
Naming the join columns in the result set of a natural join does not result in an "ambiguous column name" error. Ticket #1217. (CVS 2494) check-in: 265fb607 user: drh tags: trunk
16:34
Honor the full_column_names pragma on * results. Ticket #1263. (CVS 2493) check-in: 0d57f851 user: drh tags: trunk
15:32
Do not allow parameters in VIEW definitions. Ticket #1270. (CVS 2492) check-in: 0d46289f user: drh tags: trunk
15:07
Handle failures of getcwd() without segfaulting. Ticket #1274. (CVS 2491) check-in: c1bd0a15 user: drh tags: version_2
15:06
Handle failures of getcwd() without segfaulting. Ticket #1274. (CVS 2490) check-in: c1691004 user: drh tags: trunk
14:45
Fix a bug in the malloc2 tests introduced by checkin (2473). (CVS 2489) check-in: fafaa18e user: drh tags: trunk
2005-05-29
14:23
Omit a couple of test cases if the library is compiled without subqueries. (CVS 2488) check-in: 6bc37297 user: danielk1977 tags: trunk
2005-05-27
09:41
Minor changes to help build and test SSE. (CVS 2487) check-in: 3ac4a212 user: danielk1977 tags: trunk
2005-05-26
16:23
Add an experimental sqlite3_get_autocommit() API used to test whether or not changes are committed automatically. (CVS 2486) check-in: 4a7f1275 user: drh tags: trunk
15:20
Add a -cleanup option to Tcl test proc do_ioerr_test. (CVS 2485) check-in: b0a898c0 user: danielk1977 tags: trunk
14:41
If SSE is enabled, set the P1 field of OP_AggInit instructions to the number of arguments that will be passed to the aggregate function. (CVS 2484) check-in: 7f67b9f0 user: danielk1977 tags: trunk
12:37
Fix minor problems with the SSE hooks. (CVS 2483) check-in: 3516ca29 user: danielk1977 tags: trunk
2005-05-25
10:45
Rearrange code so that SSE can invoke the collation factory. (CVS 2482) check-in: ea061d2e user: danielk1977 tags: trunk
04:11
Split main.c into two files to make building without the parser easier. (CVS 2481) check-in: d50915fa user: danielk1977 tags: trunk
2005-05-24
20:19
Remove the config.h file from the build. Ticket #1224. (CVS 2480) check-in: 3e64f1ab user: drh tags: trunk
12:01
Move a few things around to make building without the parser easier. (CVS 2479) check-in: 5fadb464 user: danielk1977 tags: trunk
2005-05-23
17:26
The REGEXP operator is recognized. It tries to invoke a function named regexp() which does not exist in the native build. But users who want to can add an appropriate regexp() function using sqlite3_create_function(). (CVS 2478) check-in: 42a626ac user: drh tags: trunk
15:06
Make sure that the use of a double-quoted string literal does not trick the optimizer into using a correlated subquery when a static subquery would suffice. (CVS 2477) check-in: ef4059e3 user: drh tags: trunk
13:00
Retain the error string if an error is generated by SSE during a VACUUM. (CVS 2476) check-in: f7b76d02 user: danielk1977 tags: trunk
04:51
Add pFetch variable (used by SSE) to sqlite3 structure. (CVS 2475) check-in: 2a8ac869 user: danielk1977 tags: trunk
2005-05-22
20:30
The cache_size pragma should not reset the synchronous pragma. Ticket #1260. (CVS 2474) check-in: 2db2b32f user: drh tags: trunk
20:12
Never user a pointer to standard library routines malloc() and free(). This rule is to work around limitations of MSVC and the _fastcall calling convention. Ticket #1256. (CVS 2473) check-in: a39c4467 user: drh tags: trunk
19:21
Fix a memory leak. Ticket #1259. (CVS 2472) check-in: 254ac221 user: drh tags: trunk
10:44
Add hook to register SSE user-functions. (CVS 2471) check-in: 20bd303e user: danielk1977 tags: trunk
06:49
Allow schema objects beginning with sqlite_ to be created if the SQLITE_WriteSchema flag is set. (CVS 2470) check-in: afc8ce42 user: danielk1977 tags: trunk
2005-05-21
18:32
Speed improvements as described by tickets #1257 and #1258. These changes help some but are nowhere near the 23% claimed in the tickets. (CVS 2469) check-in: 3fa177c5 user: drh tags: trunk
02:48
More structure rearrangements for additional size reductions. Ticket #1253. (CVS 2468) check-in: 6b6e525b user: drh tags: trunk
2005-05-20
20:11
Reorder structure fields to reduce code footprint. Ticket #1253. Need to do more of this. (CVS 2467) check-in: 27025613 user: drh tags: trunk
20:01
Do not allow the pagesize of :memory: databases to be changed. Silently ignore PRAGMA page_size=N requests for :memory: databases. Ticket #1144 and #1252. (CVS 2466) check-in: f29a1d88 user: drh tags: trunk
19:36
Comment changes in vdbeapi.c (CVS 2465) check-in: ab7805fb user: drh tags: trunk
09:40
Fix memory leaks in Tcl user function interface. (CVS 2464) check-in: f5d9a806 user: danielk1977 tags: trunk
2005-05-19
08:43
Always use a more specific type (P3_FUNCDEF) instead of P3_POINTER as the P3 type of a vdbe instruction. (CVS 2463) check-in: 79a41674 user: danielk1977 tags: trunk
01:26
Fix an array index that is out of bounds. Ticket #1251. (CVS 2462) check-in: bcf87e4d user: drh tags: trunk