SQLite

Timeline
Login

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

50 check-ins occurring around 5ae7efd87f.

2002-04-21
19:06
Fix for ticket #21 (I think): Do not return an "out of memory" error if we can not find the users home directory. Instead, just report that we could not find the home directory. (CVS 540) (check-in: 8a50c57cc3 user: drh tags: trunk)
2002-04-20
14:45
Version 2.4.8 (CVS 538) (check-in: d703a2c5c4 user: drh tags: trunk)
14:44
Update the change log for the 2.4.8 release. (CVS 539) (check-in: c01bc2d19e user: drh tags: trunk)
14:24
Fix for ticket #1: Implement the GLOB and LIKE operators as functions that can be overridden. This way, a developer can change the LIKE operator to be case sensitive, for example. (CVS 537) (check-in: 51572bf717 user: drh tags: trunk)
2002-04-19
12:34
Add support for saving the sqlite shell command-line history across sessions. (CVS 536) (check-in: ca4abf3fe1 user: drh tags: trunk)
01:00
Added rights release for Matthew O. Persico (CVS 535) (check-in: 6c32c07e82 user: persicom tags: trunk)
2002-04-18
12:39
Change shell.c so that it will compile under windows. Shorten the help command somewhat. Add the state of ".header" to the output of ".show". (CVS 534) (check-in: 0582168b8b user: drh tags: trunk)
02:53
Updated to match new shell.c functionality. (CVS 533) (check-in: ff67ad4010 user: persicom tags: trunk)
02:53
Mistake in help text. Spurious trailing whitespace removed. (CVS 532) (check-in: 4bdd040e48 user: persicom tags: trunk)
02:46
General: o Added global static chars mainPrompt and continuePrompt. o Moved Argv0 declaration to head of file. Needed in do_meta_command, previously found below that. o Added struct previous_mode_data to support new .explain toggle functionality. o Added nullvalue, explainPrev and outfile members to struct callback_data. o Added modeDescr array for number/text translation ofdisplay modes. o Modified zHelp to match new functionality.

callback(): o Added support for .nullvalue

do_meta_command(): o Output filename is now saved to callback struct. If using stdout, then the string "stdout" is saved. o Explain is now a toggle. When it is turned on, the current values of mode, header and colWidth are saved if not already in explain mode. When turned off, those values are restored. o Allow .mode plurals columns and lines and dot command plural .headers. o Added processing for new keywords .quit, .nullvalue, .show, .prompt.

main(): o Added -init as an option to override .sqliterc. o Added -nullvalue as a command line option. o Processes .sqliterc.

main_init(): o Genesis. Moved some initialization code here from inside main() so that it can be called initially by main and again if -init is specified.

one_input_line(): o Now takes prompts from settable values.

process_sqliterc(): o Genesis. Read .sqliterc from user's home directory and pass it to process_input(). File should contain meta commands for setups. (CVS 531) (check-in: e751338c46 user: persicom tags: trunk)

01:56
Fix for ticket #19: Do not call sqliteOsSync() if the only changes were changes to TEMP tables. (CVS 530) (check-in: 33da20b9c1 user: drh tags: trunk)
2002-04-13
23:42
When doing a ".dump" command in the command-line shell, make sure VIEWs are created after TABLEs. (CVS 529) (check-in: 7edd13468e user: drh tags: trunk)
2002-04-12
13:12
Version 2.4.7 (CVS 528) (check-in: 977abbaebe user: drh tags: trunk)
13:11
Add tests to prevent a recurrance of bug #16. Also: put a hyperlink to the new ticket screen on the main page of the website. (CVS 527) (check-in: cdab6dad32 user: drh tags: trunk)
10:08
Fix for bug #15: Add the sqlite_changes() API function for retrieving the number of rows that changed in the previous operation. (CVS 526) (check-in: 6e71493b9d user: drh tags: trunk)
03:55
Fix for bug #16: Check for invalid functions in the VALUES clause of an INSERT statement. (CVS 525) (check-in: 43a77f019d user: drh tags: trunk)
2002-04-09
03:28
Fix for bug #11: Output the correct row count when and INSERT does an IGNORE action. (CVS 524) (check-in: bb83642e9a user: drh tags: trunk)
03:15
Fix for bug #10: Pop the stack by the right amount on an IGNORE so that the stack does not grow without bound. (CVS 523) (check-in: f46acfc3b8 user: drh tags: trunk)
2002-04-08
02:42
Add a -column option to the sqlite command-line utility. Patch from Matthew O. Persico. (CVS 522) (check-in: 760bf568c8 user: drh tags: trunk)
2002-04-06
14:10
Added the last_insert_rowid() SQL function. (CVS 521) (check-in: 6aca3f86bc user: drh tags: trunk)
13:57
Make the FROM clause on a SELECT optional. If omitted, the result of the SELECT is a single row consisting of the values in the expression list. (CVS 520) (check-in: 28ce42f787 user: drh tags: trunk)
2002-04-04
15:10
Add an fflush() call to shell.c to insure that all output has been written before we prompt for a new line of input. (CVS 519) (check-in: 932274187e user: drh tags: trunk)
02:10
Fix for bug #2: Add support for TABLE.* in SELECT statements. (CVS 518) (check-in: c2320eabfe user: drh tags: trunk)
2002-04-03
20:50
Added a hyperlink to the SQLite-PHP project. (CVS 517) (check-in: ffdeec3087 user: drh tags: trunk)
2002-04-02
13:27
Version 2.4.6 (CVS 516) (check-in: 5ae7efd87f user: drh tags: trunk)
13:26
Fix for bug #8: Correctly handle terms of a WHERE clause in a join where the term does not use a comparison operator. (CVS 515) (check-in: abb12259a0 user: drh tags: trunk)
02:00
Version 2.4.5 (CVS 514) (check-in: b18a7b777c user: drh tags: trunk)
01:58
Fix for bug #6: Correctly handle functions in the WHERE clause of a join. (CVS 513) (check-in: bdd8ce584e user: drh tags: trunk)
01:44
Fix for bug #7: Correctly display the P3 operand in a VDBE trace when the operand is really a pointer to a structure. (CVS 512) (check-in: 734dde765b user: drh tags: trunk)
2002-04-01
12:15
Remove from the index page of the website hyperlinks that are not directly related to SQLite. (CVS 511) (check-in: 0cb5cfa814 user: drh tags: trunk)
2002-03-31
18:29
When an attempt is made to insert an explicit NULL into an INTEGER PRIMARY KEY column, automatically convert the NULL value into a unique integer key. This was already happening when an implied NULL was inserted - when the INTEGER PRIMARY KEY column was omitted from the list of columns being inserted. Patches from Christian Werner. (CVS 510) (check-in: 9e3cf4aa2c user: drh tags: trunk)
2002-03-30
15:32
Version 2.4.4 (CVS 509) (check-in: c4b6c0be00 user: drh tags: trunk)
15:27
Update the change log to include the previous commit. (CVS 508) (check-in: 81c4b74961 user: drh tags: trunk)
15:26
Fix for bug #3: Allow VIEW as a column name. Also allow COPY. (CVS 507) (check-in: d2bdc0feeb user: drh tags: trunk)
14:15
Describe the difference between the binary RPMs in the download.html file. (CVS 506) (check-in: 8ce9a1fad2 user: drh tags: trunk)
2002-03-29
18:16
Combine the homerpm.sh file in with publish.sh. Update the website files to refer to the new RPMs that are now being built. Fix a small problem with the spec file. (CVS 505) (check-in: 57d4c77047 user: drh tags: trunk)
01:29
added a section to create a spec file and build the rpm files (CVS 504) (check-in: e529143967 user: doughenry tags: trunk)
01:28
these files are needed by publish.sh to build rpms (CVS 503) (check-in: 3c25359376 user: doughenry tags: trunk)
2002-03-28
14:20
Two typos fixed in the documentation (lang.html). (CVS 502) (check-in: f0f241e1cc user: drh tags: trunk)
2002-03-27
12:52
Update the documentation to refer the reader to the CVS server for the change log, bug lists, or the latest sources. (CVS 500) (check-in: 2478ba8666 user: drh tags: trunk)
2002-03-26
03:11
Update the change log. (CVS 438) (check-in: 9637b9aa5d user: drh tags: trunk)
2002-03-24
13:13
Added support for CASE expressions - patches from Dan Kennedy. (CVS 437) (check-in: 836b59d057 user: drh tags: trunk)
2002-03-23
01:00
Version 2.4.3 (CVS 440) (check-in: 99d6764e57 user: drh tags: trunk)
00:52
The sqlite_get_table() function now returns an error if you pass in two or more SELECT statements that return different numbers of columns. (CVS 436) (check-in: e2558c3403 user: drh tags: trunk)
00:31
Fix a bug in subquery generation when the subquery is a compound select. Also added new tests to cover this case. (CVS 435) (check-in: aaf7fd4cef user: drh tags: trunk)
2002-03-20
01:05
Version 2.4.2 (CVS 441) (check-in: 49d0323255 user: drh tags: trunk)
00:00
One more change before 2.4.2: Make the os.h header file more robust in detecting whether to use unix or windows. (CVS 434) (check-in: c2e0b79057 user: drh tags: trunk)
2002-03-19
23:51
Version 2.4.2 (CVS 433) (check-in: b0805b6069 user: drh tags: trunk)
2002-03-18
13:03
Fix an uninitialized variable in AggReset() (CVS 432) (check-in: 3dcdeae7f6 user: drh tags: trunk)
2002-03-14
14:33
Bug fix: allow ROWID as a column in SELECT statements where the FROM clause includes views which are flattened. (CVS 431) (check-in: a3a360b308 user: drh tags: trunk)