Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
200 most recent check-ins using file test/null.test version 69c62daf
2005-09-08
| ||
02:00 | Changes to comments only in sqliteInt.h. No changes to code. (CVS 2668) (check-in: cc2a6165 user: drh tags: trunk) | |
01:58 | Optimizations and refinements. Improvements to test coverage. (CVS 2667) (check-in: 7283f7c2 user: drh tags: trunk) | |
00:13 | All regression tests now pass. But I am sure there must still be problems. New tests need to be added. (CVS 2666) (check-in: bcc7d722 user: drh tags: trunk) | |
2005-09-07
| ||
23:05 | More bug fixes. All of the "quick" tests pass. The full test suite still shows problems. (CVS 2665) (check-in: a1b6d910 user: drh tags: trunk) | |
22:48 | More bug fixes. But there are still tests that fail. (CVS 2664) (check-in: 7e85a162 user: drh tags: trunk) | |
22:09 | Bug fixes in aggregate processing. Fewer tests fail. (CVS 2663) (check-in: c3ac5859 user: drh tags: trunk) | |
21:22 | Rewrite the aggregate handling logic so that it runs in O(1) space. This is the first cut at the code. Many regression tests fail. (CVS 2662) (check-in: 17039ec3 user: drh tags: trunk) | |
2005-09-06
| ||
21:40 | Changes to reduce the amount of stack space required. (CVS 2661) (check-in: b86bd70f user: drh tags: trunk) | |
20:36 | Cleanup the processing of MEM_Agg elements. (CVS 2660) (check-in: 7ecf3654 user: drh tags: trunk) | |
10:26 | Fix ANALYZE so that it works even if the empty_result_callbacks pragma is enabled. Ticket #1409. (CVS 2659) (check-in: bfdaef12 user: drh tags: trunk) | |
2005-09-05
| ||
20:35 | Make due with "sub()" instead of "gsub()" in awk scripts so that builds will work on Solaris which will runs an archiac version of AWK. (CVS 2658) (check-in: 449a7895 user: drh tags: trunk) | |
20:06 | Fix bugs introduced by checkin (2656) and do some modest code enhancements. (CVS 2657) (check-in: 7b56763a user: drh tags: trunk) | |
19:08 | Use the unicode API to win32 where available. Tickets #1407, #1396, #1331, #1243, #1206 (CVS 2656) (check-in: 3ec58c67 user: drh tags: trunk) | |
2005-09-01
| ||
17:47 | Fix over-aggressive optimization of ORDER BY as reported on the mailing list. (CVS 2655) (check-in: efbb4bc8 user: drh tags: trunk) | |
12:16 | All regression tests now pass with the new bounded-memory sort code. There is still lots of opportunity for optimization, however. (CVS 2654) (check-in: 81259a01 user: drh tags: trunk) | |
03:07 | Sorting is now done using a sorting index rather than loading the entire result set into memory and doing a merge sort. The old merge sort technique was a carry-over from SQLite version 1. The new method uses a bounded amount of memory and scales to much larger result sets. There are still errors: some 39 regression tests fail. (CVS 2653) (check-in: 09db0a24 user: drh tags: trunk) | |
2005-08-31
| ||
18:20 | {quote: KeyInfo} generation moved to a common subroutine. (CVS 2652) (check-in: a25801df user: drh tags: trunk) | |
13:48 | Updates to the query optimizer overview document. (CVS 2651) (check-in: b1dceef0 user: drh tags: trunk) | |
13:13 | Explicit typecasts to silence nuisance compiler warnings. Ticket #1398. (CVS 2650) (check-in: 90712ea7 user: drh tags: trunk) | |
03:13 | Refinements to the optimizer overview and integration into the website. (CVS 2649) (check-in: ccd12e9e user: drh tags: trunk) | |
02:46 | Update the FAQ to include an entry about binary versus decimal numbers. (CVS 2648) (check-in: 0bbe73fc user: drh tags: trunk) | |
01:49 | Adding the first cut of the optimizer overview document. (CVS 2647) (check-in: 4c8d0a4c user: drh tags: trunk) | |
2005-08-30
| ||
22:44 | Adjust the makefile for new optimizer documentation. (CVS 2646) (check-in: 14668c85 user: drh tags: trunk) | |
22:44 | Initial work on documentation describing the optimizer. (CVS 2645) (check-in: 5cebd7ba user: drh tags: trunk) | |
20:12 | The CSV output mode does not sign-extend bytes where the high-order bit is set. Ticket #1397. (CVS 2644) (check-in: 528df777 user: drh tags: trunk) | |
19:30 | Fix printf.c so that it handles 10.0 correctly. (CVS 2643) (check-in: 0f7a53f7 user: drh tags: trunk) | |
00:54 | Minor code enhancements. (CVS 2642) (check-in: 4ab994a8 user: drh tags: trunk) | |
00:10 | Update the home page to brag about 150KiB code footprint when optional features are omitted. (CVS 2641) (check-in: 0e1ac128 user: drh tags: trunk) | |
2005-08-29
| ||
23:06 | Make the shell aware of SQLITE_OMIT_MEMORYDB. Ticket #1395. (CVS 2640) (check-in: 71a71cef user: drh tags: trunk) | |
23:00 | Increase resolution of time-of-day on unix. Add an experimental sqlite3_profile() API. (CVS 2639) (check-in: ed2ca087 user: drh tags: trunk) | |
16:40 | Initialize a local variable to avoid a nuisance compiler warning. Ticket #1394. (CVS 2638) (check-in: 9b914901 user: drh tags: trunk) | |
2005-08-28
| ||
17:00 | The LIKE optimization does the right thing when collating sequences are present. LIKE expressions where the left-hand side has COLLATE NOCASE are optimized in the default case. (CVS 2637) (check-in: ef84ff79 user: drh tags: trunk) | |
01:38 | Improvements to the formatting and layout of the code in the previous checkin. (CVS 2636) (check-in: 73b430de user: drh tags: trunk) | |
01:34 | Add an assert to verify that floating point values and integers use the same byte order. Add a comment to the SELECT code generator. (CVS 2635) (check-in: 07b48921 user: drh tags: trunk) | |
2005-08-27
| ||
17:23 | Version 3.2.5 (CVS 2634) (check-in: b2415a74 user: drh tags: trunk) | |
17:22 | Change the wording of the news line for release 3.2.5. (CVS 2633) (check-in: 70db46d3 user: drh tags: trunk) | |
17:19 | Get the date right. Today is the 27th, not the 25th or the 28th. (CVS 2632) (check-in: 905b9d6c user: drh tags: trunk) | |
17:06 | Increase the version number and update web pages for the next release. (CVS 2631) (check-in: e6039e90 user: drh tags: trunk) | |
16:36 | Disable synchronous writes to the master journal when PRAGMA synchronous=OFF for all database files. Ticket #1375. (CVS 2630) (check-in: 644b96aa user: drh tags: trunk) | |
13:16 | Fix comment in vdbeapi.c. Remove unused structure definition from func.c. (CVS 2629) (check-in: 51a38134 user: drh tags: trunk) | |
13:11 | Remove the words "statically linked" from the description of the shell on the download page. Ticket #1391. (CVS 2628) (check-in: ecb96044 user: drh tags: trunk) | |
09:07 | Remove GNUmake extensions from the makefile. Ticket #1390. (CVS 2627) (check-in: d0691fed user: drh tags: trunk) | |
01:51 | Do not change fields of stale sqlite3 handles. Ticket #1384. (CVS 2626) (check-in: 7e05b7ca user: drh tags: trunk) | |
01:50 | Widen the opcode column of explain output in the shell. (CVS 2625) (check-in: dd3b00aa user: drh tags: trunk) | |
2005-08-25
| ||
12:45 | When the left-hand side of an IN operator is constant and the right-hand side is a SELECT, recognize that the IN operator is not constant. Ticket #1380. (CVS 2624) (check-in: fc9e0460 user: drh tags: trunk) | |
2005-08-24
| ||
18:04 | Fix the --enable-threadsafe option to the configure script. Ticket #1378. (CVS 2623) (check-in: 76ec0b3d user: drh tags: trunk) | |
17:07 | Additional defense against the rowid-fifo overflow problem. (CVS 2622) (check-in: 881dcf5f user: drh tags: trunk) | |
16:54 | Remove a stray C++ style comment causing problems for some compilers. (CVS 2621) (check-in: aa7dd3f2 user: drh tags: trunk) | |
16:13 | Fix a bug in DELETE that might cause a segfault when deleting more than 40940 rows of data all at once. (CVS 2620) (check-in: 7c599bae user: drh tags: trunk) | |
11:14 | Version 3.2.4 (CVS 2619) (check-in: 8cef2c1a user: drh tags: trunk) | |
11:07 | Increase the version number and update the change log prior to release. (CVS 2618) (check-in: 139a28d2 user: drh tags: trunk) | |
03:52 | After calling realloc() on an array to resize it, be sure not to use pointers into the old array. Ticket #1376. (CVS 2617) (check-in: 9f9a2571 user: drh tags: trunk) | |
2005-08-23
| ||
11:31 | Allow floating point literals to being or end with a decimal point. Ticket #1371. (CVS 2616) (check-in: a715e700 user: drh tags: trunk) | |
11:17 | Handle empty blob constants correctly. Ticket #1373. (CVS 2615) (check-in: 5cada745 user: drh tags: trunk) | |
11:03 | Fix another documentation typo. (CVS 2614) (check-in: 55f4b14e user: drh tags: trunk) | |
11:00 | Fix typos in syntax documentation. Ticket #1374 and a report on the mailing list. (CVS 2613) (check-in: 990d1f3a user: drh tags: trunk) | |
2005-08-22
| ||
02:10 | Update the download page of the website to handle TEA builds and starkits. (CVS 2612) (check-in: 1fab599b user: drh tags: trunk) | |
2005-08-21
| ||
21:45 | Clean up possible locking problem in multithreaded applications that take a malloc failure. (CVS 2611) (check-in: 545e702a user: drh tags: trunk) | |
18:54 | Version 3.2.3 (CVS 2610) (check-in: f620319b user: drh tags: trunk) | |
18:40 | Increase the version number and adjust documentation prior to the next release. (CVS 2609) (check-in: b15ed7db user: drh tags: trunk) | |
18:21 | Disable malloc tests when not compiled with SQLITE_DEBUG. (CVS 2608) (check-in: f372682f user: drh tags: trunk) | |
17:48 | Do not create an error message if there is no error. (CVS 2607) (check-in: 3aa47c55 user: drh tags: trunk) | |
16:54 | Do not overwrite small files (less than 1024 bytes) that are not databases. Ticket #1370. (CVS 2606) (check-in: 7f430268 user: drh tags: trunk) | |
2005-08-20
| ||
13:47 | More test coverage improvements. (CVS 2605) (check-in: e559e810 user: drh tags: trunk) | |
03:03 | Increased test coverage. Some malloc tests now fail though this is believed to be an instrumentation problem not a real error. (CVS 2604) (check-in: f786f37a user: drh tags: trunk) | |
2005-08-19
| ||
19:14 | Increase test coverage of alter.c to 100%. Fix bugs found in the process. (CVS 2603) (check-in: b550d04d user: drh tags: trunk) | |
03:03 | Additional tests for better coverage. (CVS 2602) (check-in: 4281a838 user: drh tags: trunk) | |
02:26 | Increased test coverage on trigger.c and printf.c. (CVS 2601) (check-in: 842a80bd user: drh tags: trunk) | |
01:07 | More test coverage enhancements. (CVS 2600) (check-in: 0b6cd5ac user: drh tags: trunk) | |
00:14 | Bring testing coverage of the analyze.c file up to 100%. Bugs found and fixed in the process. (CVS 2599) (check-in: 2fe0ac4f user: drh tags: trunk) | |
2005-08-18
| ||
18:15 | Comment fixes. No changes to the underlying code. (CVS 2598) (check-in: b865e243 user: drh tags: trunk) | |
2005-08-16
| ||
14:44 | Fix typo in documentation. (CVS 2597) (check-in: 32efcd24 user: drh tags: trunk) | |
11:11 | Null-terminate the strings array passed to Tcl_GetIndexFromObj. Bug reported on the mailing list. (CVS 2596) (check-in: 3a7918a6 user: drh tags: trunk) | |
2005-08-14
| ||
20:47 | General code cleanup resulting in smaller footprint. (CVS 2595) (check-in: 98338abf user: drh tags: trunk) | |
17:53 | Split the sqlite3_complete() API out into a separate source file so that in static links where it is not used it will not take up space in the resulting binary. (CVS 2594) (check-in: 62b87751 user: drh tags: trunk) | |
01:34 | Declare local-use functions as static. Ticket #1363. (CVS 2593) (check-in: 94efd790 user: drh tags: trunk) | |
01:20 | The case_sensitive_like pragma added. Test cases added for the LIKE optimization. (CVS 2592) (check-in: 72ee21c0 user: drh tags: trunk) | |
2005-08-13
| ||
18:15 | Provide grave accent quoting of identifiers for MySQL compatibility. Ticket #1337. (CVS 2591) (check-in: 6b7a4e97 user: drh tags: trunk) | |
17:17 | Give the same access permissions to journal files as is given to databases. (CVS 2590) (check-in: 7961ec0c user: drh tags: trunk) | |
16:13 | Disable an overzealous optimization the omitted sorting on a join if the first table gave a unique result. The sort can only be omitted if all tables in the join are unique. Ticket #1358. (CVS 2589) (check-in: 4f076612 user: drh tags: trunk) | |
13:40 | Fix a comment in printf. (CVS 2588) (check-in: 1054685f user: drh tags: trunk) | |
13:39 | Additional cleanup and optimization of the printf function. (CVS 2587) (check-in: 240bb049 user: drh tags: trunk) | |
12:59 | Add the "!" flag to the "%g" mprintf conversion parameter to force a decimal point. This prevents floating point values from appearing as integers. Use this flag when converting floating point to text. Ticket #1362. (CVS 2586) (check-in: 4b98dace user: drh tags: trunk) | |
03:07 | Make the round() function work correctly on numbers with very large exponents. Ticket #1340. (CVS 2585) (check-in: 4f47c3c8 user: drh tags: trunk) | |
00:56 | Fix a memory leak that occurs when a CREATE TABLE that contains a DEFAULT VALUE fails due to a name conflict. Tickets #1356 and #1357. (CVS 2584) (check-in: 25cfe939 user: drh tags: trunk) | |
2005-08-12
| ||
23:20 | 3rd argument to sqlite3Error() should always be a format string, never user-supplied error message text. Ticket #1354. (CVS 2583) (check-in: d6146a54 user: drh tags: trunk) | |
22:58 | Improved error message when a #NNN parameter appears on user input. Additional coverage testing. (CVS 2582) (check-in: 3c00f598 user: drh tags: trunk) | |
22:56 | Optimize LIKE and GLOB operators in the WHERE clause. Code passes all regression tests but still needs additional tests. (CVS 2581) (check-in: 3edbe8d6 user: drh tags: trunk) | |
2005-08-11
| ||
02:10 | Improve the error message associated with SQLITE_FULL. Ticket #1353. Also remove error messages for obsolete error codes SQLITE_INTERNAL, SQLITE_NOTFOUND, and SQLITE_TOOBIG. (CVS 2580) (check-in: fa7403c7 user: drh tags: trunk) | |
01:25 | Add 2005 open source award badge and news announcement. (CVS 2579) (check-in: 8e007f8c user: drh tags: trunk) | |
2005-08-05
| ||
18:50 | Make sure the .import command strips newlines off the end of the last field in each line imported. Ticket #1348 (CVS 2578) (check-in: 73fafd21 user: drh tags: trunk) | |
2005-08-02
| ||
21:42 | Comment out the use of memory high-water marks when not compiling with SQLITE_MEMDEBUG. (CVS 2577) (check-in: fb7a258f user: drh tags: trunk) | |
17:48 | Minor refactoring of the new optimizer code. (CVS 2576) (check-in: 868322f7 user: drh tags: trunk) | |
17:38 | Update the documentation for the new transaction method on the TCL interface. (CVS 2575) (check-in: 3dc823a0 user: drh tags: trunk) | |
17:15 | Tests and bug fixes on the new transaction method in the TCL interface. (CVS 2574) (check-in: 68dd0ed5 user: drh tags: trunk) | |
17:13 | Fix a bug in the btree balancer. ticket #1346. (CVS 2573) (check-in: 3af69a49 user: drh tags: trunk) | |
12:21 | Add the "transaction" coommand to the TCL interface. Untested. (CVS 2572) (check-in: a5ce6c58 user: drh tags: trunk) | |
2005-07-29
| ||
19:43 | Fix problems caused by over-agressive optimization of ORDER BY in joins. Lots more testing needed. (CVS 2571) (check-in: 1a4e526d user: drh tags: trunk) | |
15:36 | Fix authentication so that it works with AS aliases. Ticket #1338. (CVS 2570) (check-in: cc7ae73e user: drh tags: trunk) | |
15:10 | Optimizer now converts OR-connected WHERE-clause terms into an IN operator so that they can be used with indices. There are known problems with the ORDER BY optimization in this and in several prior check-ins. This check-in is not recommended for production use. (CVS 2569) (check-in: d23c8bf8 user: drh tags: trunk) | |
2005-07-28
| ||
23:12 | The BETWEEN operator in a WHERE clause is now able to use indices. (CVS 2568) (check-in: cdf8c958 user: drh tags: trunk) | |
20:51 | Test cases and tuning of the new optimizer code. (CVS 2567) (check-in: 4b02703d user: drh tags: trunk) | |
16:51 | The new optimizer now passes all regression tests. (CVS 2566) (check-in: a2121284 user: drh tags: trunk) | |
2005-07-27
| ||
20:41 | More work on the new optimizer. Fewer tests fail now. (CVS 2565) (check-in: ee3a08e3 user: drh tags: trunk) | |
2005-07-23
| ||
22:59 | A new optimizer that breaks a lot of tests. But none of them critically, I think. Nevertheless, there is a lot of work ahead to stabilize the code. (CVS 2564) (check-in: 86ce56cc user: drh tags: trunk) | |
14:52 | Store the total number of rows as part of the ANALYZE statistics. (CVS 2563) (check-in: 868279c7 user: drh tags: trunk) | |
03:18 | The results of ANALYZE are now loaded into internal data structures where they can be used. But they are not actually used yet. (CVS 2562) (check-in: 1996bacf user: drh tags: trunk) | |
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: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) | |