Joe Wilson <[EMAIL PROTECTED]> wrote: > --- John Stanton <[EMAIL PROTECTED]> wrote: > > Sqlite3 will get into a tangle with certain sequences where it does not > > accept a semicolon as a terminator or obey a CTL c. > > To reproduce: > > 1. build sqlite3 without readline support. > 2. run sqlite3 in an xterm > 3. at the prompt, press cursor up > 4. hit return > > Nothing you do at this point will work except for Ctrl-\ to kill the process. > > SQLite version 3.4.1 > Enter ".help" for instructions > sqlite> ^[[A > ...> .q > ...> ; > ...> select 1;
SQLite allows identifiers to be quoted using square brackets. Like this: CREATE TABLE [alpha]([beta],[gamma]); In the input above, SQLite sees the beginning of a quoted identifier in the "[A" but it never sees the terminating "]" so it keeps asking for more input. It things the semicolons you are feeding it are part of the identifier. To break out of the loop, enter "];". Works as designed.... -- D. Richard Hipp <[EMAIL PROTECTED]> ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------