SQLite

Timeline
Login

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

100 check-ins occurring around 3c796de8d1af5594.

2004-02-21
13:31
More code cleanup and size reduction. (CVS 1256) (check-in: 8e3eda2a user: drh tags: trunk)
03:28
Enhance date/time functions to work with negative years. Ticket #617. (CVS 1255) (check-in: ffa97193 user: drh tags: trunk)
2004-02-20
23:34
Turn the short_column_names pragma off by default - for the time being. (CVS 1254) (check-in: 6954d2c3 user: drh tags: trunk)
22:55
Add sqlite.def file required for correct operation of "make implib" option in Makefile.in (CVS 1253) (check-in: b1b23c41 user: rdc tags: trunk)
22:54
Fixed behaviour of last_insert_rowid() with triggers and add last_statement_change_count() function that works correctly with triggers. (CVS 1252) (check-in: 6734c923 user: rdc tags: trunk)
22:53
Fixed behaviour of last_insert_rowid() with triggers and add last_statement_change_count() function that works correctly with triggers. (CVS 1251) (check-in: 3383413a user: rdc tags: trunk)
14:50
The name of a result column is now the name of column it originated from, by default. This can be turned off with PRAGMA short_column_names=OFF. This is to be more like PostgreSQL. More testing needed. (CVS 1250) (check-in: 574dd444 user: drh tags: trunk)
2004-02-19
18:41
Fix a bug in the parser table compression algorithm of lemon. (CVS 1249) (check-in: 8d3e9249 user: drh tags: trunk)
2004-02-18
16:57
Fix a memory leak that occurs if you call sqlite_interrupt() on a query using aggregate functions where the aggregate function returns a string longer than 32 characters. (CVS 1248) (check-in: 2c1e74e5 user: drh tags: trunk)
16:56
Begin updating the architecture description to better describe how things are currently put together. (CVS 1247) (check-in: 062ecc13 user: drh tags: trunk)
01:31
Add more tests of the sqlite_interrupt() logic - looking for a reported memory leak. (Didn't find it.) (CVS 1246) (check-in: e4c8b1c3 user: drh tags: trunk)
2004-02-17
18:26
Avoid line endings munging by Cygwin; ticket #370 (CVS 1245) (check-in: 50e67948 user: dougcurrie tags: trunk)
2004-02-16
03:44
Remove the NullCallback opcode. Handle the empty_result_set pragma inside the sqlite_exec() function. (CVS 1244) (check-in: f7213485 user: drh tags: trunk)
2004-02-14
23:59
Eliminate obsolete code associated with the older callback functionality. (CVS 1243) (check-in: 2dbc4593 user: drh tags: trunk)
23:05
Eliminate the use of callbacks during schema initialization. (CVS 1242) (check-in: af5c2be4 user: drh tags: trunk)
17:35
Fix problems with malloc-failure handling. (CVS 1241) (check-in: 398bc294 user: drh tags: trunk)
16:31
The sqlite_exec() function is now implemented using sqlite_compile() and sqlite_step(). This opens up lots of opportunity to remove old code. (CVS 1240) (check-in: 9771ad1e user: drh tags: trunk)
01:39
Disable the malloc.test tests if not compiled with -DMEMORY_DEBUG (CVS 1239) (check-in: 41b6ad78 user: drh tags: trunk)
2004-02-13
20:09
Fix an uninitialized variable in shell.c that would cause a crash if you specified SQL on the command-line. (CVS 1238) (check-in: 5a56090d user: drh tags: trunk)
16:30
Begin the process over converting sqlite_exec() over to use sqlite_compile() and sqlite_step(). The new sqlite_exec() is still commented out. (CVS 1237) (check-in: b8f2ba78 user: drh tags: trunk)
16:22
Fix a bug in the query flattener when trying to find the datatype of the rowid of a view. Also fix a problem with sqlite_compile() and authorization failures. (CVS 1236) (check-in: aa0490cc user: drh tags: trunk)
14:07
Fix an uninitialized variable introduced by check-in (1202). (CVS 1235) (check-in: 9f149fdc user: drh tags: trunk)
2004-02-12
20:49
Add a new parameter to the (unimplemented) encryption API. (CVS 1234) (check-in: 5fe8f023 user: drh tags: trunk)
19:01
Add the SQLITE_NOTADB return code for cases when you try to open a file that does not even remotely resemble an SQLite database file. (CVS 1233) (check-in: 0c77cee7 user: drh tags: trunk)
18:46
Add hooks on each attached database connection for storing auxiliary information. Add the USING clause to ATTACH. (CVS 1232) (check-in: 800c11f4 user: drh tags: trunk)
17:28
All REPLACE INTO syntax inside of triggers. Ticket #610. (CVS 1231) (check-in: a6b862a9 user: drh tags: trunk)
15:32
Remove unused variable. (CVS 1230) (check-in: 74b23426 user: drh tags: trunk)
15:31
Always reload the schema after a rollback. Ticket #594. (CVS 1229) (check-in: 12c7a83f user: drh tags: trunk)
13:02
VACUUM returns SQLITE_INTERRUPT when interrupted. Ticket #593. (CVS 1228) (check-in: 2fe9f510 user: drh tags: trunk)
2004-02-11
16:38
Only define _FILE_OFFSET_BITS if it is not already defined. Ticket #605. (CVS 1227) (check-in: 300c5543 user: drh tags: trunk)
10:37
Fix the shells so that they always enable the codec if it is available, even if no key is supplied. (CVS 1226) (check-in: 95989717 user: drh tags: trunk)
10:35
Fix an uninitialized variable in expr.c. Ticket #604. (CVS 1225) (check-in: 1673bf7c user: drh tags: trunk)
09:46
Refactor the interface to the randomness generator. (CVS 1224) (check-in: f2bdccf4 user: drh tags: trunk)
02:18
Pass all (relevant) regression tests when using the codec. (CVS 1223) (check-in: 5200e9ed user: drh tags: trunk)
2004-02-10
23:51
Adjustments to the codec in the pager. (CVS 1222) (check-in: be5122e9 user: drh tags: trunk)
13:41
Perform updates in search order. Ticket #602. (CVS 1221) (check-in: cf1cec74 user: drh tags: trunk)
13:19
Fix for ticket #603. (CVS 1220) (check-in: d0624d25 user: drh tags: trunk)
02:57
Make the pager accessible from the btree structure always, not just during debugging. (CVS 1219) (check-in: 9c6b4758 user: drh tags: trunk)
02:27
Move the file-format-2 to file-format-3 conversion into sqliteInit(). (CVS 1218) (check-in: dcbe2800 user: drh tags: trunk)
01:54
Allow SQLITE_PAGE_SIZE to be redefined on the compiler command-line. (CVS 1217) (check-in: 4c7bf714 user: drh tags: trunk)
2004-02-09
14:37
After code is generated for a subquery, delete the Select structure in order to force the temporary table to be used and to prevent the subquery from being evaluated a second time. Ticket #601. (CVS 1216) (check-in: 1cff1886 user: drh tags: trunk)
14:35
Add test case for ticket #601. (CVS 1215) (check-in: 096312da user: drh tags: trunk)
01:20
Add an optional codec to the pager layer. (CVS 1214) (check-in: 2f0c122c user: drh tags: trunk)
2004-02-08
18:10
Version 2.8.12 (CVS 1213) (check-in: 1736d415 user: drh tags: trunk)
18:07
Perpare for the 2.8.12 release. (CVS 1212) (check-in: 93ccd1b1 user: drh tags: trunk)
06:17
Fix a bug in the VDBE that occurs when a CreateTable or CreateIndex fails. (CVS 1211) (check-in: 42cfd541 user: drh tags: trunk)
06:06
Add the crashtest1.c program used to test the ability of the database to survive a program crash or power failure. Ticket #599. (CVS 1210) (check-in: 597a59a7 user: drh tags: trunk)
06:05
Fix inaccuracies and add details to comments in the pager. Change the name of one function to make its purpose clearer. Ticket #599. (CVS 1209) (check-in: 48832d35 user: drh tags: trunk)
00:40
Preliminary fix for ticket #599. More testing and analysis needed. (CVS 1208) (check-in: dc5be2c8 user: drh tags: trunk)
2004-02-02
12:29
Remove undocumented extensions from sqlite_mprintf() and friends in order to make it about 10% smaller. (CVS 1207) (check-in: 0b3f552b user: drh tags: trunk)
2004-02-01
01:22
Fix the handling of -init option to the sqlite shell. Ticket #568. Also add hooks for encrypting the database. (CVS 1206) (check-in: 3c796de8 user: drh tags: trunk)
2004-01-31
20:40
Fix a bug introduced by the previous check-in. (CVS 1205) (check-in: 04cf2278 user: drh tags: trunk)
20:20
A few more optimizations to the VDBE. (CVS 1204) (check-in: 06e7ff4c user: drh tags: trunk)
19:22
Rework internal data structures to make the VDBE about 15% smaller. (CVS 1203) (check-in: 8273c74b user: drh tags: trunk)
2004-01-30
14:49
Rework the VDBE data structures to combine string representations into the same structure with integer and floating point. This opens the door to significant optimizations. (CVS 1202) (check-in: c0faa1c6 user: drh tags: trunk)
02:01
Make sure min() and max() optimizations work for subqueries. Ticket #587. (CVS 1201) (check-in: af73fbca user: drh tags: trunk)
2004-01-27
17:46
Change permissions on the install-sh file to be executable. Ticket #582. (CVS 1200) (check-in: eafa714d user: drh tags: trunk)
15:58
Add a web page describing when it is appropriate to use SQLite and when it is not. (CVS 1199) (check-in: d77e4776 user: drh tags: trunk)
2004-01-25
22:44
Modularize the column name resolution code so that it is smaller, faster, and ready for some enhancements that will fix long-standing name resolutions problems. (CVS 1198) (check-in: d3648034 user: drh tags: trunk)
2004-01-24
20:18
Add the ability to group FROM terms using parentheses. Names of columns in a join no longer include the table name. (CVS 1197) (check-in: 3626f6d4 user: drh tags: trunk)
2004-01-22
23:38
Fix typo. Ticket #577. (CVS 1196) (check-in: 3dc95195 user: drh tags: trunk)
2004-01-21
13:35
In test programs, an SQLITE_SCHEMA return is retried repeatedly, not just once. (CVS 1195) (check-in: df3509e1 user: drh tags: trunk)
2004-01-20
11:54
Make ATTACH and DETACH work with the non-callback API. Ticket #574. (CVS 1194) (check-in: c32a80fe user: drh tags: trunk)
2004-01-19
05:09
documented pragma foreign_key_list(). updated docs for removed behavior: Oracle join syntax and temp indexes. (CVS 1193) (check-in: 06bd5070 user: jplyon tags: trunk)
04:57
comment typos (CVS 1192) (check-in: 7972ee32 user: jplyon tags: trunk)
04:55
comment typos (CVS 1191) (check-in: de35c36e user: jplyon tags: trunk)
04:54
coment typo (CVS 1190) (check-in: 0d2683dc user: jplyon tags: trunk)
04:53
coment typo (CVS 1189) (check-in: 8210b2d8 user: jplyon tags: trunk)
04:52
comment (CVS 1188) (check-in: fa55c986 user: jplyon tags: trunk)
2004-01-17
01:16
Do not use strcpy() on overlapping buffers. (CVS 1187) (check-in: ed6bd2eb user: drh tags: trunk)
2004-01-16
20:01
Access to free()ed memory problem fixed. Found by electric fence. Only an issue when doing an EXPLAIN of a CREATE INDEX. (CVS 1186) (check-in: 6604e5f7 user: drh tags: trunk)
19:11
See ticket #569; eliminates warnings for Cygwin v1.5 and above. (CVS 1185) (check-in: a0f8b1f3 user: dougcurrie tags: trunk)
16:42
More compaction of expr.c. (CVS 1184) (check-in: 92e7f780 user: drh tags: trunk)
15:55
Incremental code compaction in expr.c. Now about 4% smaller. Lots more work to do. (CVS 1183) (check-in: d292ba51 user: drh tags: trunk)
13:58
Fix a buffer-overflow problem in the randStr function (used only for testing). (CVS 1182) (check-in: 42c79edc user: drh tags: trunk)
2004-01-15
13:29
More aggressive retry schedule in sqlite_busy_timeout(). (CVS 1181) (check-in: 5e85025b user: drh tags: trunk)
03:30
Allow "expr IN table" as a shorthand for "expr IN (SELECT * FROM table)" (CVS 1180) (check-in: 01874d25 user: drh tags: trunk)
02:44
Reinsert the experimental sqlite_commit_hook() API. (CVS 1179) (check-in: 72bc84f2 user: drh tags: trunk)
2004-01-14
21:59
Fix comparisons of ROWID against floating point numbers so that they work correctly. Ticket #377 and #567. (CVS 1178) (check-in: c9ac3db8 user: drh tags: trunk)
13:50
Version 2.8.11 (CVS 1177) (check-in: a9f25347 user: drh tags: trunk)
13:43
Bump the version number for the next release. (CVS 1176) (check-in: 2812dd5f user: drh tags: trunk)
13:38
Ignore NULLs in a subquery as the right operand of IN. Ticket #565. (CVS 1175) (check-in: c9e7996f user: drh tags: trunk)
03:49
Version 2.8.10 (CVS 1174) (check-in: 8bef75ab user: drh tags: trunk)
03:32
Move some files around and bump the version number in preparation for the release of 2.8.10. (CVS 1173) (check-in: 74c66185 user: drh tags: trunk)
03:12
Remove an incomplete comment that somehow snuck into the sources. (CVS 1172) (check-in: ea1ad465 user: drh tags: trunk)
2004-01-12
00:39
On unix, embargo close() operations until all locks have cleared from the file. Ticket #561. (CVS 1171) (check-in: 1ebe5fc7 user: drh tags: trunk)
00:38
Previous commit of changes to the in-memory backend was not quite right. This check-in should square things away. (CVS 1170) (check-in: 75d91e3b user: drh tags: trunk)
00:21
Make sure the in-memory database can handle malloc failures. (CVS 1169) (check-in: ba92af18 user: drh tags: trunk)
2004-01-08
02:17
Remove unused code and tighten existing code to make the library a little smaller. (CVS 1168) (check-in: 34a6b741 user: drh tags: trunk)
2004-01-07
20:37
Rework the fix to ticket #461 so that we do not have to do redundant tests of WHERE clause terms looking for NULLs. See also check-in (1103). (CVS 1167) (check-in: 5fd58178 user: drh tags: trunk)
19:24
Permit sqlite_exec() to be called from within user-defined functions. (CVS 1166) (check-in: 03636c94 user: drh tags: trunk)
18:52
Defer the {quote: MoveTo} opcode in VDBE until the data is actually needed. Sometimes the data is never needed, resulting in a performance increase. On an indexed order search with a large OFFSET, queries times can be an order of magnitude faster. (CVS 1165) (check-in: d3e96da2 user: drh tags: trunk)
03:41
Make it safe to call sqliteMalloc() with a request for 0 bytes. Ticket #534. (CVS 1164) (check-in: 6c858db2 user: drh tags: trunk)
03:29
Preserve the HH:MM:SS for most date/time modifiers. Ticket #551. (CVS 1163) (check-in: 70df32b7 user: drh tags: trunk)
03:04
Use "long double" to hold intermediate values when doing ascii to binary and binary to ascii conversions of floating point numbers. (CVS 1162) (check-in: 8371f662 user: drh tags: trunk)
02:52
Add a typecast to work around a bug in the Metrowerks Code Warrior compiler. Ticket #553. (CVS 1161) (check-in: 4146f8cc user: drh tags: trunk)
2004-01-06
02:23
Version 2.8.9 (CVS 1160) (check-in: d8ae6bdd user: drh tags: trunk)
01:52
Additional integer overflow boundary case tests. (CVS 1159) (check-in: 532170d4 user: drh tags: trunk)
01:27
Increase the version number and update the change log prior to the next release. (CVS 1158) (check-in: b99b68d0 user: drh tags: trunk)
01:13
Fix problem in the code generator were incorrect code was being created if the SQL source contained a negative integer that was too large to fit in a 32-bit signed integer variable. Ticket #552. (CVS 1157) (check-in: b8381d9f user: drh tags: trunk)