SQLite

Timeline
Login

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

50 check-ins occurring around c4b6c0be00.

2002-04-18
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)
2002-03-13
19:00
Version 2.4.1 (CVS 442) (check-in: 9f12b8805f user: drh tags: trunk)
18:54
Version 2.4.1 (CVS 430) (check-in: 9333ecca1e user: drh tags: trunk)
18:54
Fix bug in anonymous subquery in a join. Parser requires a semicolon or end-of-input before executing. (CVS 429) (check-in: c0e3f1c592 user: drh tags: trunk)
2002-03-12
23:10
Fix the return type of the xStep function in the FuncDef structure definition. (CVS 428) (check-in: 753adb789e user: drh tags: trunk)
2002-03-11
13:55
Change the way that lemon handles %extra_argument. (CVS 427) (check-in: ffc387a48a user: drh tags: trunk)
02:15
Version 2.4.0 (CVS 443) (check-in: d3f66b44e5 user: drh tags: trunk)
02:06
Preparing for the 2.4.0 release. (CVS 426) (check-in: 9f5b241cb2 user: drh tags: trunk)