Repository navigation
sqlite3 CLI keeps part of previous commands when scrolling history #135883
Description
Bug report
Bug description:
Enter the sqlite3 CLI on the main branch, type SELECT * FROM sqlite_master; , press enter. Then press <Up>, the history command SELECT * FROM sqlite_master; is displayed. And then press <Down>, the current line will be partially cleared, the SELECT * FR is left on the screen.
$ ./python -m sqlite3
sqlite> SELECT * FROM sqlite_master;
sqlite> |
simplescreenrecorder-2025-06-24_17.33.25.mp4
CPython versions tested on:
CPython main branch
Operating systems tested on:
Linux
Activity
LamentXU123 commentedon Jun 25, 2025
When did the line
SELECT * FRget input? Could you please provide the complete keyboard input to reproduce this? TiAtanloong commentedon Jun 25, 2025
SELECT * FRisn't an actual input. That's the crux of the problem. It's part of a previous command that got left on the screen when you scroll through the history using the<up>and<down>keys.The keys shown in the bottom area of the screen recording are all the keyboard inputs. There's nothing else. Try it and you will be able reproduce the issue.
gh-135883: Fix sqlite3 CLI history scrolling with colored prompts (#1…
erlend-aasland commentedon Mar 3, 2026
The fix has landed in main, but I'll keep the issue open until the backports have landed.
erlend-aasland commentedon Mar 4, 2026
No backports needed; marking as completed.
pythongh-135883: Fix sqlite3 CLI history scrolling with colored promp…