sqlite3 CLI does not recognize dot commands with trailing spaces

[tanloong]

Bug report

Bug description:

Dot commands with trailing spaces are mistaken for multi-line sqlite3 statements.

$ python -m sqlite3↵
sqlite> .version↵
3.49.1
sqlite> .version␣↵
    ... ↵
    ... ↵

CPython versions tested on:

3.14

Operating systems tested on:

Linux

Linked PRs

• gh-133439: Fix dot commands with trailing spaces are mistaken for multi-line sqlite statements in the sqlite3 command-line interface #133440
• [3.14] gh-133439: Fix dot commands with trailing spaces are mistaken for multi-line sqlite statements in the sqlite3 command-line interface (GH-133440) #133738
• [3.13] gh-133439: Fix dot commands with trailing spaces are mistaken for multi-line sqlite statements in the sqlite3 command-line interface (GH-133440) #133765
• gh-133439: Fix the error message in the sqlite3 CLI #133807
• [3.14] gh-133439: Fix the error message in the sqlite3 CLI (GH-133807) #135708

[picnixz]

Does the sqlite3 cli (not python one) ignore trailing whitespaces?

[tanloong]

Yes. The sqlite3 cli works normally on sql statements with trailing or leading whitespaces.

[tanloong]

Trailing whitespaces for dot commands are also ignored, although leading ones are not.

$ sqlite3↵
sqlite> .quit␣↵
$ 

$ sqlite3↵
sqlite> ␣.quit↵
    ... ↵
    ... ↵