python / python/cpython

`sqlite3` help message shows wrong EOF key on Windows

Open
#139,105 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

stdlib topic-sqlite3 type-bug
Dominant language
Python
Stars
77.2k
Forks
36k
PR merge metrics
PR metrics pending

Description

Bug report

Bug description:
# enter the interactive sqlite3 console
python -m sqlite3
# print the help message
>> .help
  • expect on Windows
Enter SQL code or one of the below commands, and press enter.

.version    Print underlying SQLite library version
.help       Print this help message
.quit       Exit the CLI, equivalent to CTRL-Z
  • what we get now
Enter SQL code or one of the below commands, and press enter.

.version    Print underlying SQLite library version
.help       Print this help message
.quit       Exit the CLI, equivalent to CTRL-D

This issue is actually found by @yihong0618

CPython versions tested on:

CPython main branch

Operating systems tested on:

Windows

Linked PRs
  • gh-139106

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start with the python -m sqlite3 entry point and reproduce .help on Windows. Trace the path that formats the .quit help line, then verify the message says CTRL-Z on Windows while preserving the other displayed commands.

Written by the indexing model from the issue text.

Assessment

Tech stack
python, sqlite
Domain
cli
Issue type
Bug
Difficulty
1/5
Estimated time
Under an hour
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.