SQLite
Timeline
Not logged in

100 check-ins occurring around 1736d415d7.

2004-02-22
16:27
Rearrange the grammar some so that tokens that are used together appear together in the grammar file. This reduces the size of the parser tables and some of the jump tables in switch statements. (CVS 1262) check-in: d372c16e user: drh tags: trunk
00:08
Do not sort terminal symbols by name. The terminals remain in the same order that they are encountered in the grammar file. This results in parse tables that are 25% smaller. (CVS 1261) check-in: f36b122d user: drh tags: trunk
2004-02-21
19:41
Test cases for printf of double overflows. (CVS 1260) check-in: 96a6d2d3 user: drh tags: trunk
19:17
Fix a long-standing memory leak that the new last_insert_rowid() tests brought to light. (CVS 1259) check-in: 7d5ede5b user: drh tags: trunk
19:02
Cleanup the printf code to make it smaller and more modular. Fix a memory leak in the new OP_ContextPush opcode. (CVS 1258) check-in: 2756f7af user: drh tags: trunk
14:00
Flag pragmas like vdbe_trace now return their current setting if they are called with no arguments. (CVS 1257) check-in: 6a5fb5b8 user: drh tags: trunk
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