[Libreoffice-bugs] [Bug 31398] RFE: LibreOffice Base should allow update/insert/drop query in sql-editor with hsqldb access controls

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=31398

--- Comment #16 from collura at ieee.org ---
repeated test, some improvement.

LibreO_6.1.5.2 (tested on linux) has same results as described in comment9
where update query fails to run and embedded hsqldb database is not updated.

however repeating the test with an embedded firebird_db is an improvement as
described below. 

LibreO_6.1.6.3 (tested on macos) using an embedded firebird_db (instead of
hsqldb)
still gives errors, BUT the Table Gets Updated :')

(as before the query wont save unless select "Run SQL command Directly" button 
on the far right of query toolbar)

the error generated by running the saved update query is

    "The data content could not be loaded."
    "Error code: 1"
    "firebird_sdbc error: Cursor is not open
         caused by isc_dsql_fetch"

despite the error, the saved update query did indeed update the table
which is confirmed by running the select query
(or by then opening the table to verify that the fields had changed 
in case you were in surprised disbelief).

I didnt have time to test other modification query types or read up on possible
parallel bugs of the firebird error so I am leaving this bug open.

-- 
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/20190524/d98a4535/attachment.html>