8000 sqlite3 CLI does not recognize dot commands with trailing spaces · Issue #133439 · python/cpython · GitHub
[go: up one dir, main page]
Skip to content

sqlite3 CLI does not recognize dot commands with trailing spaces #133439

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom
Closed
tanloong opened this issue May 5, 2025 · 3 comments
Closed

sqlite3 CLI does not recognize dot commands with trailing spaces #133439

tanloong opened this issue May 5, 2025 · 3 comments
Labels
stdlib Python modules in the Lib dir topic-sqlite3 type-bug An unexpected behavior, bug, or error

Comments

@tanloong
Copy link
Contributor
tanloong commented May 5, 2025 •
edited by bedevere-app bot
Loading

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
@tanloong tanloong added the type-bug An unexpected behavior, bug, or error label May 5, 2025
tanloong added a commit to tanloong/cpython that referenced this issue May 5, 2025
@tanloong
pythongh-133439: fix dot commands with trailing spaces are not recogn…
80af071 
…ized in sqlite3 CLI
@tanloong tanloong mentioned this issue May 5, 2025
Merged
@picnixz picnixz added stdlib Python modules in the Lib dir topic-sqlite3 labels May 5, 2025
@picnixz
Copy link
Member
picnixz commented May 5, 2025

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

@tanloong
Copy link
Contributor Author
tanloong commented May 5, 2025 •
edited
Loading

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

@tanloong
Copy link
Contributor Author
tanloong commented May 6, 2025 •
edited
Loading

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

$ sqlite3↵
sqlite> .quit␣↵
$ 

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

tanloong added a commit to tanloong/cpython that referenced this issue May 9, 2025
@tanloong
pythongh-133439: fix dot commands with trailing spaces are not recogn…
080d0c8 
…ized in sqlite3 CLI
serhiy-storchaka pushed a commit that referenced this issue May 9, 2025
@tanloong
gh-133439: Fix dot commands with trailing spaces are mistaken for mul…
ebd4881 
…ti-line sqlite statements in the sqlite3 command-line interface (GH-133440)
miss-islington pushed a commit to miss-islington/cpython that referenced this issue May 9, 2025
@tanloong @miss-islington
pythongh-133439: Fix dot commands with trailing spaces are mistaken f…
42599d5 
…or multi-line sqlite statements in the sqlite3 command-line interface (pythonGH-133440)

(cherry picked from commit ebd4881)

Co-authored-by: Tan Long <tanloong@foxmail.com>
@bedevere-app bedevere-app bot mentioned this issue May 9, 2025
Merged
@tanloong tanloong closed this as completed May 9, 2025
serhiy-storchaka pushed a commit that referenced this issue May 9, 2025
@miss-islington @tanloong
[3.14] gh-133439: Fix dot commands with trailing spaces are mistaken …
beb8a50 
…for multi-line sqlite statements in the sqlite3 command-line interface (GH-133440) (GH-133738)

(cherry picked from commit ebd4881)

Co-authored-by: Tan Long <tanloong@foxmail.com>
7B9E @bedevere-app bedevere-app bot mentioned this issue May 9, 2025
Open
tanloong added a commit to tanloong/cpython that referenced this issue May 9, 2025
@tanloong
pythongh-133439: Fix dot commands with trailing spaces are mistaken f…
771f617 
…or multi-line sqlite statements in the sqlite3 command-line interface (pythonGH-133440)

(cherry picked from commit ebd4881)
@bedevere-app bedevere-app bot mentioned this issue May 10, 2025
Open
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
stdlib Python modules in the Lib dir topic-sqlite3 type-bug An unexpected behavior, bug, or error
Projects
sqlite3 issues
Status: Done
Milestone
No milestone
Development

No branches or pull requests
2 participants
@picnixz @tanloong
0