care not to generate column name headers if the output is an intermediate table.
Otherwise the column headers are not generated correctly if a compound SELECT
statement appears as an expression in part of the WHERE clause. (CVS 543)
FossilOrigin-Name: a06d9acdd5af0dc69b3a4d024de082631254aead
can not find the users home directory. Instead, just report that we could
not find the home directory. (CVS 540)
FossilOrigin-Name: 8a50c57cc3342de9c6eca6c2567d3aa42b407f10
can be overridden. This way, a developer can change the LIKE operator to
be case sensitive, for example. (CVS 537)
FossilOrigin-Name: 51572bf71774d7631c7083be90b806e621bc9bee
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)
FossilOrigin-Name: e751338c468cdad79efcc5cd5b924eb2c1eb3c3a
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)
FossilOrigin-Name: 9e3cf4aa2cb44932015b8bd3fd800d7678cb09b6
Increased the default cache size from 100 to 2000 and made the "cache_size"
pragma persistent. (CVS 418)
FossilOrigin-Name: 414da4af1f4aebc3936ca339fbc7932add081912
entered. This works around the problem of what to do if a table is deleted
that a view refers to. (CVS 415)
FossilOrigin-Name: 6121e5ab9328c90c64d40ade3de73ad11d4aaf4e
a 2x performance gain for large INSERTs and a 5x performance gain for
large DELETEs. (CVS 410)
FossilOrigin-Name: cf1ebcfb741786f84a596c406f4c492f68cbe881
We still need to add addition tests to the suite to further exercise
the flattener, however. (CVS 408)
FossilOrigin-Name: d5d3e79cc58da5bd315cc1fea1f7cbf46274da16
