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

[bugzilla-daemon]

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

--- Comment #16 from coll...@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.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

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

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

rob...@familiegrosskopf.de changed:

   What|Removed |Added

 CC||rob...@familiegrosskopf.de

--- Comment #14 from rob...@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).

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

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

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

Korrawit Pruegsanusak  changed:

   What|Removed |Added

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

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

Alex Thurgood  changed:

   What|Removed |Added

 CC||l...@ptoye.com

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

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

--- Comment #11 from Peter Toye  ---
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.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

--- Comment #10 from coll...@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

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

--- Comment #9 from coll...@ieee.org ---
Created attachment 124891
  --> https://bugs.documentfoundation.org/attachment.cgi?id=124891=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: 0
  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.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

--- Comment #8 from Alex Thurgood ipla...@yahoo.co.uk ---
Adding self to CC if not already on

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

--- Comment #7 from ribotb rib...@gmail.com ---
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

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

--- Comment #6 from QA Administrators qa-ad...@libreoffice.org ---
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

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

--- Comment #5 from coll...@ieee.org 2012-06-12 02:40:55 PDT ---
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)

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

coll...@ieee.org changed:

   What|Removed |Added

  Component|Libreoffice |Database

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

coll...@ieee.org changed:

   What|Removed |Added

 Status|NEEDINFO|UNCONFIRMED
 Ever Confirmed|1   |0

--- Comment #3 from coll...@ieee.org 2011-12-26 00:33:40 PST ---
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: 0
  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.

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

coll...@ieee.org changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEW
 Ever Confirmed|0   |1

--- Comment #4 from coll...@ieee.org 2011-12-26 00:36:54 PST ---
sorry misread, setting status from 'unconfirmed' to 'new' to clear the
'needinfo' flag.

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs