SQLite

Timeline
Login

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

100 check-ins occurring around becd64d3615fc573.

2007-05-15
14:34
Relax the restriction on using bytes 0x80 through 0xbf as the first character of an identifier. Enhancements to ALTER TABLE tests for tables with strange names or stange column names. (CVS 4008) (check-in: 262a3e63 user: drh tags: trunk)
14:17
Change the documentation to clearly state that the result of sqlite3_column_type() is undefined following a type conversion. (CVS 4007) (check-in: 960be575 user: drh tags: trunk)
14:10
Fix to check-in (4005). A call to sqlite3_column_blob() should not make subsequent calls to sqlite3_column_type() return SQLITE_BLOB. Sqlite3_column_type() returns the initial type. (CVS 4006) (check-in: b5e85deb user: drh tags: trunk)
13:27
Clarification on the best practices for using the _bytes() APIs. Change sqlite3_value_blob() to force the representation to be purely a BLOB and not a dual BLOB/String. Ticket #2360. (CVS 4005) (check-in: cf2dd45b user: drh tags: trunk)
11:55
A new approach for UTF-8 translation. (CVS 4004) (check-in: 6c8ad279 user: drh tags: trunk)
09:00
Do not allow bytes 0x80 through 0xBF to be the first character of an identifer because no valid UTF-8 character can begin with those bytes. If we allowed an identifier to begin with one of those bytes, then the substr() function in ALTER TABLE will not work correctly. (CVS 4003) (check-in: 25281042 user: drh tags: trunk)
07:14
Fix some test script errors in fuzz.test. (CVS 4002) (check-in: 51eeae7b user: danielk1977 tags: trunk)
07:00
A fix for queries that used correlated, compound sub-queries in the HAVING clause. Also update fuzz.test some more. (CVS 4001) (check-in: da0c1ab4 user: danielk1977 tags: trunk)
03:56
Fix problems in ALTER TABLE that occur when column or table names are invalid UTF encodings. (CVS 4000) (check-in: 9ff382f4 user: drh tags: trunk)
02:45
Fix a typo in a comment. Ticket #2359. (CVS 3999) (check-in: 1fbbc108 user: drh tags: trunk)
02:34
Fix a bug in sqlite3_mprintf() which could have caused a buffer overrun if malloc() failed. (CVS 3998) (check-in: 5af49a57 user: drh tags: trunk)
01:13
The built-in substr() function applied to a BLOB counts bytes, not characters. (CVS 3997) (check-in: 75d57308 user: drh tags: trunk)
00:09
Make sure the parser aborts quickly following a syntax error. (CVS 3996) (check-in: d07cdd3c user: drh tags: trunk)
2007-05-14
16:50
Fix a problem with ORDER BY and compound SELECT queries. (CVS 3995) (check-in: af76928f user: danielk1977 tags: trunk)
15:49
Fix a bug in "flattening" optimization. Occured if the parent of the flattened sub-query is also the parent of a sub-query that uses a compound op (i.e. UNION, INTERSECT etc.). (CVS 3994) (check-in: 1c33829c user: danielk1977 tags: trunk)
14:05
Prevent sub-queries with "LIMIT 0" from leaving an extra value on the vdbe stack. Also updates to fuzz.test. (CVS 3993) (check-in: b1d1b16e user: danielk1977 tags: trunk)
12:12
In the windows driver, reacquire the shared lock if an exclusive lock fails. Ticket #2354. (CVS 3992) (check-in: fc489b53 user: drh tags: trunk)
11:34
Remove terms with operator TK_AS from the expression tree. Ticket #2356. (CVS 3991) (check-in: 5627ff74 user: drh tags: trunk)
2007-05-12
15:00
Make REINDEX robust in the face of malloc() errors. (CVS 3990) (check-in: dbe41774 user: drh tags: trunk)
12:08
Make the ANALYZE command robust in the face of malloc() failures. (CVS 3989) (check-in: c08658e1 user: drh tags: trunk)
10:41
Fix another variant of the "IN (...)" b-tree problem. (CVS 3988) (check-in: 260338c4 user: danielk1977 tags: trunk)
09:30
Fix an obscure b-tree bug that applied to transient trees used for IN(...) expressions. (CVS 3987) (check-in: 96c7232f user: danielk1977 tags: trunk)
06:11
Bugfixes for assert() failures found by fuzz.test. (CVS 3986) (check-in: 2e80736d user: danielk1977 tags: trunk)
2007-05-11
16:58
Check in some changes to fuzz.test. Still failing. (CVS 3985) (check-in: 6f346a6b user: danielk1977 tags: trunk)
12:30
Avoid multiple storage class specifiers ("static extern") in the amalagmation. (CVS 3984) (check-in: 2f70159b user: drh tags: trunk)
10:10
Expand the expressions tested by fuzz.test. Fix for (CAST zeroblob() AS text). (CVS 3983) (check-in: 4e1bb41f user: danielk1977 tags: trunk)
07:08
Fix a problem with inserting zeroblob() into an indexed column. (CVS 3982) (check-in: ccef5d2d user: danielk1977 tags: trunk)
01:44
Additional parsing bugs fixed. (CVS 3981) (check-in: d12a8924 user: drh tags: trunk)
00:20
Make sure that the REGISTER token generates a valid Expr. REGISTER will cause the tokenizer to abort, but the parser might do several reduce actions prior to that abort and those reduce actions sometimes need a valid Expr. (CVS 3980) (check-in: d146f01a user: drh tags: trunk)
2007-05-10
21:31
Backport the stack-size reduction patch in (3673) to version 3.3.13. (CVS 3979) (Leaf check-in: e91012b6 user: drh tags: branch_3_3_13)
21:14
When converting literal BLOBs to text using the encoding of the main database. Ticket #2349. (CVS 3975) (check-in: a57afaff user: drh tags: trunk)
17:38
Simplify failing case in fuzz.test. (CVS 3974) (check-in: a54c7499 user: danielk1977 tags: trunk)
17:32
Add cases to fuzz.test. Some tests in this file fail at the moment. (CVS 3973) (check-in: 1e8fcb3f user: danielk1977 tags: trunk)
17:23
Add some UTF-8 test infrastructure. Treat NaN as NULL. The printf routines print infinity as "Inf" not as "NaN". Ticket #2345. (CVS 3972) (check-in: ffe615a7 user: drh tags: trunk)
15:37
Add new test file fuzz.test, to test SQLite with fuzzily generated SQL. (CVS 3971) (check-in: 1e9e6fe7 user: danielk1977 tags: trunk)
13:23
Fix a C++ism in func.c. (CVS 3970) (check-in: 9c0050a1 user: drh tags: trunk)
11:43
Another test for overflow in strftime(). It was not broken. (CVS 3969) (check-in: 5800d032 user: danielk1977 tags: trunk)
10:46
Add code to enforce the MAX_EXPR_DEPTH limit. (CVS 3968) (check-in: 2c9c94a2 user: danielk1977 tags: trunk)
2007-05-09
22:56
Make sure compound queries inside a subquery only return a single result column. Ticket #2347. (CVS 3967) (check-in: 66954bdd user: drh tags: trunk)
20:35
Fix a typo in a comment. Ticket #2348. (CVS 3966) (check-in: c0dbac46 user: drh tags: trunk)
20:31
Fix a problem with strange expressions being fed to an ATTACH or DETACH statement. (CVS 3965) (check-in: 0c91dc9e user: drh tags: trunk)
15:56
Fix an obscure cache corruption that could occur after an SQLITE_FULL error. (CVS 3964) (check-in: e8e879ac user: danielk1977 tags: trunk)
11:37
Add further test cases for compile time limits. (CVS 3963) (check-in: 9bf2c594 user: danielk1977 tags: trunk)
08:24
Fix enforcement of the LIKE_PATTERN limit. (CVS 3962) (check-in: 8819617b user: danielk1977 tags: trunk)
2007-05-08
21:56
Remove a keyword from the header comment in date.c (CVS 3961) (check-in: 03349ec0 user: drh tags: trunk)
21:45
Remove compiler warnings in the amalgamation. (CVS 3960) (check-in: c5754530 user: drh tags: trunk)
20:59
Disable tracing pragmas when not in debug mode. This eliminates an external dependency on stdout. (CVS 3959) (check-in: 5a0fe985 user: drh tags: trunk)
20:37
Fix the amalgamation generator so that all non-API functions have file scope. (CVS 3958) (check-in: e9f56ead user: drh tags: trunk)
18:30
Update the release builder script. (CVS 3957) (check-in: 21299b91 user: drh tags: trunk)
18:04
Fix a null-pointer dereference that follows a malloc() failure introduced in (3954). (CVS 3956) (check-in: 251ba198 user: danielk1977 tags: trunk)
17:59
Update the amalgamation builder for the latest changes. (CVS 3955) (check-in: becd64d3 user: drh tags: trunk)
17:54
Add a few more tests to sqllimit1.test. (CVS 3954) (check-in: eeee6b71 user: danielk1977 tags: trunk)
16:13
Add a test case that uses a trigger to insert many rows to sqllimits1.test. (CVS 3953) (check-in: 63682225 user: danielk1977 tags: trunk)
15:59
Add new test file sqllimits1.test. (CVS 3952) (check-in: c8974603 user: danielk1977 tags: trunk)
15:46
Do not allocate so much surplus memory in the implementation of the replace() function. (CVS 3951) (check-in: 0cf518ce user: drh tags: trunk)
15:34
Limit the length of the patterns on LIKE and GLOB to avoid problems with deep recursion and N^2 behavior. (CVS 3950) (check-in: 42e6c826 user: drh tags: trunk)
15:15
Introduce the (experimental) sqlite3_result_error_toobig() API that function implementations can use to signal SQLite that the function result is too big to represent. (CVS 3949) (check-in: 17c4235c user: drh tags: trunk)
14:51
Add the max_page_count pragma used to limit the maximum size of a database file. Untested. (CVS 3948) (check-in: b1b74f06 user: drh tags: trunk)
14:39
Fix a potential buffer overrun in the replace() function. (CVS 3947) (check-in: b0fb4a3c user: danielk1977 tags: trunk)
13:58
Add more code to enforce the limits specified in limits.h. (CVS 3946) (check-in: c59d4360 user: drh tags: trunk)
13:57
Avoid evaluating (INT_MIN/-1) with 32 bit signed numbers. It can cause SIGFPE. (CVS 3945) (check-in: 2f186e91 user: danielk1977 tags: trunk)
12:37
Do not crash in the internal functions sqlite_rename_table() or sqlite_rename_trigger() if they are somehow passed unexpected input. (CVS 3944) (check-in: c2f90b46 user: danielk1977 tags: trunk)
12:12
Begin adding code to explicitly limit the size of strings and blobs. (CVS 3943) (check-in: 031a5915 user: drh tags: trunk)
11:27
Fix a bug in the test logic introduced by check-in (3928). (CVS 3942) (check-in: 47d1678d user: drh tags: trunk)
01:08
Begin implementing a new system of upper bounds on the capabilities of SQLite. By clearly defining the upper bounds, we make those upper bounds explicitly testable. This check-in is just infrastructure. The upper bounds are not yet enforced. (CVS 3941) (check-in: 93b623b2 user: drh tags: trunk)
2007-05-07
19:31
Fix an NULL deref in the randomblob() function following a malloc failure. (CVS 3940) (check-in: 011e7db2 user: drh tags: trunk)
16:58
Add a version of the LIKE operator to the icu extension. Requires optimisation. (CVS 3939) (check-in: 3e96105c user: danielk1977 tags: trunk)
14:58
Change the name of create_collation_x() to create_collation_v2(). Also add some tests for it. (CVS 3938) (check-in: ddc4e479 user: danielk1977 tags: trunk)
13:11
Fix typo in Makefile.in. Ticket #2343 (CVS 3937) (check-in: db51f59a user: drh tags: trunk)
11:53
Add interface to configure SQLite to use ICU collation functions. (CVS 3936) (check-in: b29a81b4 user: danielk1977 tags: trunk)
11:24
Change sqlite3_snprintf() so that it does not write a zero-terminator if the buffer size argument is less than 1. Ticket #2341. Added documentation about the sqlite3_snprintf() function. (CVS 3935) (check-in: f3ae4ac5 user: drh tags: trunk)
09:32
Add the experimental create_collation_x() api. (CVS 3934) (check-in: ff49d48f user: danielk1977 tags: trunk)
2007-05-06
21:20
Fix missing word in the copyright.html web page. (CVS 3933) (check-in: 2d1348dd user: drh tags: trunk)
20:04
Do not flatten subqueries that are part of a compound SELECT and which have both an ORDER BY and a LIMIT clause. Ticket #2339. (CVS 3932) (check-in: 9600a998 user: drh tags: trunk)
16:04
Add the start of the ICU extension. (CVS 3931) (check-in: f473e852 user: danielk1977 tags: trunk)
2007-05-05
22:45
Add "Powered By SQLite" logo contributed by Alberto Simoes. (CVS 3930) (check-in: 25cfa774 user: drh tags: trunk)
18:49
Fix a header problem introduced in the previous check-in. (CVS 3929) (check-in: bece7a6b user: drh tags: trunk)
18:39
Factor out btree test logic into a separate test_btree.c file. (CVS 3928) (check-in: d51274f1 user: drh tags: trunk)
12:06
Fix a sprintf() problem introduced by (3916). (CVS 3927) (check-in: 54a1d275 user: drh tags: trunk)
11:48
Refactoring. Split btreeInt.h off from btree.c. Split malloc.c off from util.c. Expect much more to follow. (CVS 3926) (check-in: ad549a40 user: drh tags: trunk)
11:48
Refactoring. Split btreeInt.h off from btree.c. Split malloc.c off from util.c. Expect much more to follow. (CVS 3925) (check-in: 16041116 user: drh tags: trunk)
2007-05-04
19:16
Add documentation on the incremental vacuum feature. (CVS 3924) (check-in: b3e2cdae user: drh tags: trunk)
19:03
Fix compilation and testing with OMIT_INCRBLOB defined. (CVS 3923) (check-in: a0f8adc6 user: danielk1977 tags: trunk)
18:36
Test interaction of incremental io and other database writes. (CVS 3922) (check-in: 4516416b user: danielk1977 tags: trunk)
18:30
Change incremental vacuum to be triggered by a pragma rather than a command. We have a lot to learn about this yet and we do not want to paint ourselves into a corner by commiting to specific syntax too early. (CVS 3921) (check-in: b13e497a user: drh tags: trunk)
17:07
Tighter compression of the keyword hash table. (CVS 3920) (check-in: 68121676 user: drh tags: trunk)
16:14
Optional parameter in the INCREMENTAL VACUUM statement specifies how many pages to vacuum from the database. (CVS 3919) (check-in: ed713f9c user: drh tags: trunk)
14:36
Get tests working with SQLITE_OMIT_AUTOVACUUM=1. (CVS 3918) (check-in: b94d39e4 user: drh tags: trunk)
14:14
Make "incremental" a fallback token so that you can set "auto_vacuum=incremental" without having to quote the "incremental". (CVS 3917) (check-in: 9d7a2e2b user: drh tags: trunk)
13:15
Eliminate all uses of sprintf() and strcpy(). These were not being misused. But getting rid of them removes a library dependency. And it avoids warnings from the OpenBSD compiler. Ticket #2336. (CVS 3916) (check-in: ba4845b3 user: drh tags: trunk)
12:05
Test cases and corrections to IO and malloc() error handling in incremental blob IO functions. (CVS 3915) (check-in: 641e5528 user: danielk1977 tags: trunk)
12:01
Fix a formatting errror in I/O logging. (CVS 3914) (check-in: 2d37687a user: drh tags: trunk)
11:59
Add compile-time option -DSQLITE_MIXED_ENDIAN_64BIT_FLOAT=1 that uses mixed-endian doubles. This is needed on ARM7 to make database file formats compatible with all other processors. Tickets #2278 and #2335. (CVS 3913) (check-in: 2a178d0c user: drh tags: trunk)
08:32
Rework accessPayload() function for clarity. (CVS 3912) (check-in: 42d07c70 user: danielk1977 tags: trunk)
2007-05-03
20:06
fix from Gentoo for allowing TCLLIBDIR to be overridden in env (CVS 3911) (check-in: e54a49e2 user: vapier tags: trunk)
18:14
Test some more incremental IO error cases. (CVS 3910) (check-in: 64705410 user: danielk1977 tags: trunk)
17:18
Improvements to I/O tracing output. Require -DSQLITE_ENABLE_IOTRACE when compiling shell.c in order to link in the I/O tracing capability. (CVS 3909) (check-in: 8a43e167 user: drh tags: trunk)
16:55
Get the amalgamation builder working with incremental I/O. (CVS 3908) (check-in: 92b53601 user: drh tags: trunk)
16:31
Test cases and minor bugfixes for incremental blob APIs. (CVS 3907) (check-in: e12c5223 user: danielk1977 tags: trunk)
13:11
Fix a bug where accessPayload() was calling PagerWrite() on the wrong page handle. Ticket #2332. (CVS 3906) (check-in: cf9eeba7 user: danielk1977 tags: trunk)