https://bugs.documentfoundation.org/show_bug.cgi?id=168512
Bug ID: 168512
Summary: There is no sqlite3 module in embedded Python
distribution
Product: LibreOffice
Version: 25.8.1.1 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: LibreOffice
Assignee: [email protected]
Reporter: [email protected]
Description:
--
Steps to Reproduce:
1. Open console window
2. Create a working folder for a new project, change to that folder:
mkdir proj && cd proj
3. Add (prepend) "C:\Program Files\LibreOffice\program" to the PATH:
set PATH=C:\Program Files\LibreOffice\program;%PATH%
4. Verify the python.exe to be executed is the one from LibreOffice:
where python
5. Provided that venv bug is resolved, or a workaround applied (see ticket
#168215, create a virtual environment for the project:
python -m venv venv
6. Activate virtual environment with command:
venv\Scripts\activate
7. Test that "import sqlite3" works, or some package that depends on sqlite3
could be installed (for example, pip install spyder)
Actual Results:
a) Import statement fails
b) Package cannot be installed
Expected Results:
a) Import statement fails
b) Package cannot be installed
Reproducible: Always
User Profile Reset: Yes
Additional Info:
There is no easy workaround for this issue. The standard sqlite3 module is
implemented as a binary library (_sqlite3.pyd) and cannot be copied from
another Python distribution, due to its dependency on Python3.dll. The latter
one existed in LibreOffice is incompatible with the DLL existed in the official
distribution.
--
You are receiving this mail because:
You are the assignee for the bug.
