[Libreoffice-bugs] [Bug 119431] New: External database jdbc hsqldb, Crash in the case of SELECT, SQL query, access to the database
bugzilla-daemon at bugs.documentfoundation.org
bugzilla-daemon at bugs.documentfoundation.org
Wed Aug 22 20:57:17 UTC 2018
https://bugs.documentfoundation.org/show_bug.cgi?id=119431
Bug ID: 119431
Summary: External database jdbc hsqldb, Crash in the case of
SELECT, SQL query, access to the database
Product: LibreOffice
Version: 6.1.0.3 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: libreoffice-bugs at lists.freedesktop.org
Reporter: christo123 at poczta.onet.pl
This bug was filed from the crash reporting server and is
br-aae507c3-49a0-4cc0-9ded-90f140bf7dfb.
=========================================
I'm creating a new, clean database.
I enter SQL queries:
CREATE ROLE "normal_user";
CREATE USER "U1" PASSWORD "12345";
CREATE CACHED TABLE "Test2" ("ID" INTEGER GENERATED BY DEFAULT AS IDENTITY
(START WITH 0) NOT NULL PRIMARY KEY, "name" VARCHAR (100) NOT NULL,
"addDateTime" TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,
"updateDateTime" TIMESTAMP NULL);
CREATE TRIGGER PUBLIC. "Test2_TRG" BEFORE UPDATE ON PUBLIC. "Test2" REFERENCING
OLD ROW AS OLDROW NEW ROW AS NEWROW FOR EACH ROW SET NEWROW. "UpdateDateTime" =
CURRENT_TIMESTAMP;
GRANT SELECT (ID, "name"), UPDATE (ID, "name"), INSERT (ID, "name") ON TABLE
"Test2" TO "normal_user";
GRANT "normal_user" TO "U1";
The commands were completed successfully.
We log in as U1, open the "Test2" table. Total crash Libreoffice.
Crash in: rtl_string_newFromStr
--
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180822/eececc72/attachment.html>
More information about the Libreoffice-bugs
mailing list