mmsql - changes
===============

1.2 (November 2026) - needs MMBasic 8.00.00b1 or later (b2 recommended)
-------------------------------------------------------------------------
New:
- Editor at the prompt over up to 20 lines with a status line: F3 new
  line, F2 run, Esc discard. Pasted lines are recognised and kept
  together. New options enter and paste.
- One rule for input: one line runs with Enter; several lines are a
  block, every statement ends with ;. Dot commands run along, the first
  error stops the rest.
- Statements and queries over 255 characters, with results - at the
  prompt, in blocks and in scripts.
- History of statements of any length, also after a restart; PgUp/PgDn.
- .read takes statements over several lines, shows query results and
  knows dot commands (.print, .mode, .once ...).
- Database in memory (:memory:); mmsql starts without a file.
- .mode markdown, .mode json, .set blob.
- New commands .width, .print, .version, .restore; .set screen,
  .set width 0.
- Search patterns for .tables, .schema, .indexes, .triggers.
- .import without limits for columns and long fields; .insert up to
  64 columns.
- .dump writes every value with its real type.
- Shorter prompt: [retro.db]> instead of mmsql[retro.db]>.
- Terminal and screen show exactly the same.
- .set sorted by topic.

Changed:
- .read needs ; at the end of every statement (as sqlite3). Scripts
  without ; no longer run correctly - add a ; at the end of each line.
- Error messages show the statement as it was typed, over several lines
  line by line.
- The hint "commands start with a dot" only appears when the error is
  at the first word.
- -- comments end at the end of the line.

Fixed:
- A SELECT of more than 239 characters could end mmsql with an error.
- .schema shows statements over several lines without a "staircase" in
  the terminal.
- .dump writes a REAL such as 2.0 as 2.0 (it stays REAL) and infinity
  as 1e999 (SQLite can read it back).
- Very large integers (above 2^53) are shown and exported exactly, no
  longer rounded as a float.

1.1 (November 2026) - needs MMBasic 8.00.00b1 or later
-------------------------------------------------------
New:
- Ctrl-C stops a running SQL statement and mmsql goes on. It tells you
  exactly what SQLite has undone: the statement, or (after an interrupted
  change inside a transaction) the whole transaction.
- Transactions are watched: the prompt shows a star while one is open
  (mmsql[club.db]*>). .quit, .close and .open ask: [C] commit,
  [R] rollback, [Esc] cancel. They report "Closed: file".
- Several statements in one line, separated by ;, run one after the
  other, each with its own result. The first error stops the rest.
- Long texts and BLOBs over 255 characters: shown (start in table mode,
  in full in .mode line), exported, dumped, read back with .read and
  imported with .import. New option maxtext (default 32768 bytes).
  Marks in table mode: ~ = shortened, ~! = longer than maxtext.
- New commands .files [pattern] and .kill file.
- .read and .import stop cleanly after Ctrl-C; .dump reports an
  incomplete file.

Changed:
- Needs firmware 8; on older firmware mmsql says to use 1.0.1.
- mmsql sets OPTION CRLF CR (no more double Enter on firmware 8).
- Hint at the start if OPTION BREAK is 0.
- ",help" (comma instead of dot) gives "Did you mean .help?".
- .info shows the real encoding; sizes in .files, .info and .vacuum are
  exact bytes below 10000, else KB.
- The banner shows G1, G2 or G3.
- LGETSTR$ is never used with 255 characters (bug in 8.00.00b1, fixed in
  the next firmware).
- Help files: short forms, .help h, new commands and options.
- Fixes from 1.0.1.

1.0.1 (November 2026) - for MMBasic 7.00.00RC6
-----------------------------------------------
- Fixed: a value of exactly 255 characters ending with a quote character
  crashed .mode csv, .mode insert and .dump ("256 is invalid").
- Fixed: line breaks inside a value in .mode line gave a "staircase" on
  a terminal; they now start a new, indented line.
- If the firmware knows OPTION CRLF, mmsql sets it to CR.

1.0 (November 2026) - first release
