https://bugs.documentfoundation.org/show_bug.cgi?id=168061
Bug ID: 168061
Summary: LibreOffice Base not creating tables, and is crashing
Product: LibreOffice
Version: 25.2.5.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
Description:
Google Gemini and I have been chasing an apparent bug in Base. Gemini has
summarized our efforts as follows:
Here is a summary of all the steps we took to troubleshoot the problem, which
you could use to help fill out a bug report:
Initial Attempt: You ran the original CREATE TABLE script. It completed without
any reported errors, but no new tables were created in the database.
Confirming the Problem: We ran SELECT * FROM INFORMATION_SCHEMA.SYSTEM_TABLES;
to confirm that the tables did not exist. This command showed only the built-in
system tables.
Testing for File Corruption: You created a new, empty LibreOffice Base file and
re-ran the script. The result was the same: no errors, but no tables were
created. This indicated the problem was not with a corrupted database file.
Pinpointing the Issue (Part 1): You ran just the first CREATE TABLE statement
by itself. This produced a syntax error: "Unexpected token: in statement..."
This was the first major breakthrough, as it showed a hidden, non-standard
character was being introduced somewhere in the process.
Pinpointing the Issue (Part 2): We removed all comments and extra line breaks
from the script, but the same error appeared. We then discovered that pasting
the script into Notepad and then copying it from Notepad to the SQL window
allowed the script to run without the "unexpected token" error. This proved
that the issue was a problematic character in the clipboard data being pasted
into the SQL window.
The Lock-up: After the tables were successfully created, we attempted to run
the INSERT statements. The database locked up because the SQL window could not
handle the multiple INSERT statements in a single batch.
In short, the two main issues were an invisible character in the paste buffer
that caused a silent failure for CREATE TABLE and the inability of the SQL
window to execute multiple INSERT statements in a single run, which led to a
database lock-up.
Steps to Reproduce:
1.Create an empty database.
2.Execute the following script:
CREATE TABLE "data_dictionary_tables" (
"table_id" IDENTITY,
"table_name" VARCHAR(255) NOT NULL,
"description" VARCHAR(5000),
"date_created" TIMESTAMP NOT NULL
);
CREATE TABLE "data_dictionary_columns" (
"column_id" IDENTITY,
"table_id" INTEGER NOT NULL,
"column_name" VARCHAR(255) NOT NULL,
"data_type" VARCHAR(50),
"description" VARCHAR(5000),
"properties" VARCHAR(1000),
FOREIGN KEY ("table_id") REFERENCES "data_dictionary_tables"("table_id")
);
3.If the script is found to execute with no errors, no tables are created.
Subsequent operations in Base may cause crash.
Actual Results:
No errors are reported and no tables are created. Base may go unresponsive to
further commands.
Expected Results:
Tables are created, and Base does not lock-up.
Reproducible: Always
User Profile Reset: Yes
Additional Info:
Version: 25.2.5.2 (X86_64) / LibreOffice Community
Build ID: 03d19516eb2e1dd5d4ccd751a0d6f35f35e08022
CPU threads: 12; OS: Windows 11 X86_64 (10.0 build 26100); UI render:
Skia/Vulkan; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
