Summary: | RFE: LibreOffice Base should allow update/insert/drop query in sql-editor with hsqldb access controls | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | collura |
Component: | Base | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | NEW --- | ||
Severity: | enhancement | CC: | collura, hhajni, iplaw67, lionel, lo, ribotb, robert |
Priority: | medium | ||
Version: | unspecified | ||
Hardware: | x86-64 (AMD64) | ||
OS: | All | ||
Whiteboard: | |||
Crash report or crash signature: | Regression By: | ||
Bug Depends on: | |||
Bug Blocks: | 120255, 137043 | ||
Attachments: |
sample database for query testing
MySQL-native-connector with possibility to update data through query |
Description
collura
2010-11-04 17:04:38 UTC
*** Bug 37599 has been marked as a duplicate of this bug. *** [This is an automated message.] This bug was filed before the changes to Bugzilla on 2011-10-16. Thus it started right out as NEW without ever being explicitly confirmed. The bug is changed to state NEEDINFO for this reason. To move this bug from NEEDINFO back to NEW please check if the bug still persists with the 3.5.0 beta1 or beta2 prereleases. Details on how to test the 3.5.0 beta1 can be found at: http://wiki.documentfoundation.org/QA/BugHunting_Session_3.5.0.-1 more detail on this bulk operation: http://nabble.documentfoundation.org/RFC-Operation-Spamzilla-tp3607474p3607474.html hi, yes it still seems to be there as of 3.5.0beta2 Build ID: 8589e48-760cc4d-f39cf3d-1b2857e-60db978 where trying to run the test in section2 of original comment as update query still gives: The data content could not be loaded. SQL Status: 00000 Error code: -155 Statement does not generate a result set The SQL command leading to this error is: UPDATE "Table1" SET "Table1"."fld-flag" = FALSE WHERE "Table1"."fld-flag" = TRUE; while running the same sql code through the tools-sql-execute produces the change and gives no errors. setting status to 'unconfirmed' to clear the 'needinfo' flag. sorry misread, setting status from 'unconfirmed' to 'new' to clear the 'needinfo' flag. status is still the same as in comment#3 as of LibreOffice 3.5.4.2 Build ID: 350m1(Build:2) (as in fedora package libreoffice-base-1:3.5.4.2-1.fc17.x86_64) Please read this message in its entirety before responding. Your bug was confirmed at least 1 year ago and has not had any activity on it for over a year. Your bug is still set to NEW which means that it is open and confirmed. It would be nice to have the bug confirmed on a newer version than the version reported in the original report to know that the bug is still present -- sometimes a bug is inadvertently fixed over time and just never closed. If you have time please do the following: 1) Test to see if the bug is still present on a currently supported version of LibreOffice (preferably 4.2 or newer). 2) If it is present please leave a comment telling us what version of LibreOffice and your operating system. 3) If it is NOT present please set the bug to RESOLVED-WORKSFORME and leave a short comment telling us your version and Operating System Please DO NOT 1) Update the version field 2) Reply via email (please reply directly on the bug tracker) 3) Set the bug to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + LibreOffice is powered by a team of volunteers, every bug is confirmed (triaged) by human beings who mostly give their time for free. We invite you to join our triaging by checking out this link: https://wiki.documentfoundation.org/QA/BugTriage There are also other ways to get involved including with marketing, UX, documentation, and of course developing - http://www.libreoffice.org/get-help/mailing-lists/. Lastly, good bug reports help tremendously in making the process go smoother, please always provide reproducible steps (even if it seems easy) and attach any and all relevant material Hi, With Version: 4.3.3.1 Build ID: 7d55112667c8fcddb67bc3803796b46c93aa56b0 under Win7/x86 I create and populate Table1. I execute query: UPDATE "Table1" set "Table1"."fld-flag" = False where "Table1"."fld-flag" = True; - in Tools > SQL: "Command successfully executed" and result is good; - in Query > Create a SQL Query: "Syntax error". Bernard Adding self to CC if not already on Created attachment 124891 [details] 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. 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 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. *** Bug 112272 has been marked as a duplicate of this bug. *** *** Bug 112272 has been marked as a duplicate of this bug. *** 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). Created attachment 138143 [details]
MySQL-native-connector with possibility to update data through query
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. |