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

[b***@bugs.documentfoundation.org]

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

--- Comment #9 from ***@ieee.org ---
Created attachment 124891
--> https://bugs.documentfoundation.org/attachment.cgi?id=124891&action=edit
sample database for query testing


status is still same as in comment#3 as of

LibreOffice 5
Version: 5.0.6.2
Build ID: 5.0.6.2-3.fc23

(as in fedora package libreoffice-base-1:5.0.6.2-3.fc23.x86_64)


0) observation on comment#7

- in Tools > SQL: "Command successfully executed" and result is good;
- in Query > Create a SQL Query: "Syntax error".

in order to get the query to save from sql view
you have to select Edit-"Run SQL command directly"
otherwise it wont let you save but just gives syntax error:

SQL Status: HY000
Error code: 1000

Syntax error in SQL statement

syntax error, unexpected $end,
expecting BETWEEN or IN or SQL_TOKEN_LIKE


1) run the saved update query
doesnt make any changes to table and still gives the error:

The data content could not be loaded.

SQL Status: 00000
Error code: -155

Statement does not generate a result set

2) input sql of update query into tools-sql-menu of main base window

running the same sql code through the tools-sql-execute still works

sets the true flagged records to be false flagged and gives no errors:

1: Command successfully executed.

[b***@bugs.documentfoundation.org]

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

--- Comment #10 from ***@ieee.org ---

distantly related bug as testing embedded_firebird replacement for this hsql
rfe:

error when try open a database:

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

[b***@bugs.documentfoundation.org]

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

--- Comment #11 from Peter Toye <***@ptoye.com> ---
I would suggest that it would be even netter to provide update and delete
queries directly through the IDE rather than expecting the user to enter SQL
commands.

[b***@bugs.documentfoundation.org]

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

Alex Thurgood <***@tuta.io> changed:

What |Removed |Added
----------------------------------------------------------------------------
CC| |***@ptoye.com

--- Comment #12 from Alex Thurgood <***@tuta.io> ---
*** Bug 112272 has been marked as a duplicate of this bug. ***

[b***@bugs.documentfoundation.org]

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

Korrawit Pruegsanusak <***@gmail.com> changed:

What |Removed |Added
----------------------------------------------------------------------------
Attachment #124891|application/octet-stream |application/vnd.oasis.opend
mime type| |ocument.database

[b***@bugs.documentfoundation.org]

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

--- Comment #13 from Xisco Faulí <***@libreoffice.org> ---
*** Bug 112272 has been marked as a duplicate of this bug. ***

[b***@bugs.documentfoundation.org]

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

***@familiegrosskopf.de changed:

What |Removed |Added
----------------------------------------------------------------------------
CC| |***@familiegrosskopf.de

--- Comment #14 from ***@familiegrosskopf.de ---
One hint: At this moment it is possible to update tables through the
query-editor if using MySQL/MariaDB and the native connector. There won't
appear any error, only a blank page of the query if query is created in direct
SQL and executed in directly.

Problem: The "query" will be executed every time you go to "Queries" if you
change at the right 'none' to 'document' (which should show the content of the
query when the query is chosen).

[b***@bugs.documentfoundation.org]

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

--- Comment #15 from ***@familiegrosskopf.de ---
Created attachment 138143
--> https://bugs.documentfoundation.org/attachment.cgi?id=138143&action=edit
MySQL-native-connector with possibility to update data through query