sqlite3 CLI keeps part of previous commands when scrolling history

[tanloong]

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

Linked PRs

• gh-135883: Fix sqlite3 CLI keeps part of previous commands when scrolling history #135884

[LamentXU123]

When did the line SELECT * FR get input? Could you please provide the complete keyboard input to reproduce this? TiA

[tanloong]

SELECT * FR isn'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.

[erlend-aasland]

The fix has landed in main, but I'll keep the issue open until the backports have landed.

[erlend-aasland]

No backports needed; marking as completed.