SQLite

Timeline
Login

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

38 check-ins using file src/expr.c version e7a1e22b

2002-04-19
12:34
Add support for saving the sqlite shell command-line history across sessions. (CVS 536) (check-in: ca4abf3f user: drh tags: trunk)
01:00
Added rights release for Matthew O. Persico (CVS 535) (check-in: 6c32c07e 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: 0582168b user: drh tags: trunk)
02:53
Updated to match new shell.c functionality. (CVS 533) (check-in: ff67ad40 user: persicom tags: trunk)
02:53
Mistake in help text. Spurious trailing whitespace removed. (CVS 532) (check-in: 4bdd040e 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: e751338c 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: 33da20b9 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: 7edd1346 user: drh tags: trunk)
2002-04-12
13:12
Version 2.4.7 (CVS 528) (check-in: 977abbae 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: cdab6dad 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: 6e71493b 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: 43a77f01 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: bb83642e 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: f46acfc3 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: 760bf568 user: drh tags: trunk)
2002-04-06
14:10
Added the last_insert_rowid() SQL function. (CVS 521) (check-in: 6aca3f86 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: 28ce42f7 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: 93227418 user: drh tags: trunk)
02:10
Fix for bug #2: Add support for TABLE.* in SELECT statements. (CVS 518) (check-in: c2320eab user: drh tags: trunk)
2002-04-03
20:50
Added a hyperlink to the SQLite-PHP project. (CVS 517) (check-in: ffdeec30 user: drh tags: trunk)
2002-04-02
13:27
Version 2.4.6 (CVS 516) (check-in: 5ae7efd8 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: abb12259 user: drh tags: trunk)
02:00
Version 2.4.5 (CVS 514) (check-in: b18a7b77 user: drh tags: trunk)
01:58
Fix for bug #6: Correctly handle functions in the WHERE clause of a join. (CVS 513) (check-in: bdd8ce58 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: 734dde76 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: 0cb5cfa8 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: 9e3cf4aa user: drh tags: trunk)
2002-03-30
15:32
Version 2.4.4 (CVS 509) (check-in: c4b6c0be user: drh tags: trunk)
15:27
Update the change log to include the previous commit. (CVS 508) (check-in: 81c4b749 user: drh tags: trunk)
15:26
Fix for bug #3: Allow VIEW as a column name. Also allow COPY. (CVS 507) (check-in: d2bdc0fe user: drh tags: trunk)
14:15
Describe the difference between the binary RPMs in the download.html file. (CVS 506) (check-in: 8ce9a1fa 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: 57d4c770 user: drh tags: trunk)
01:29
added a section to create a spec file and build the rpm files (CVS 504) (check-in: e5291439 user: doughenry tags: trunk)
01:28
these files are needed by publish.sh to build rpms (CVS 503) (check-in: 3c253593 user: doughenry tags: trunk)
2002-03-28
14:20
Two typos fixed in the documentation (lang.html). (CVS 502) (check-in: f0f241e1 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: 2478ba86 user: drh tags: trunk)
2002-03-26
03:11
Update the change log. (CVS 438) (check-in: 9637b9aa user: drh tags: trunk)
2002-03-24
13:13
Added support for CASE expressions - patches from Dan Kennedy. (CVS 437) (check-in: 836b59d0 user: drh tags: trunk)