[Libreoffice-bugs] [Bug 36546] Internal HSQLDB 1.8 fails to cascade updates through multiple paths and deletions through some cyclic structures

[bugzilla-daemon]

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

--- Comment #27 from QA Administrators  ---
Dear R.D.Nielsen,

To make sure we're focusing on the bugs that affect our users today,
LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed
bugs which have not been touched for over a year.

There have been thousands of bug fixes and commits since anyone checked on this
bug report. During that time, it's possible that the bug has been fixed, or the
details of the problem have changed. We'd really appreciate your help in
getting confirmation that the bug is still present.

If you have time, please do the following:

Test to see if the bug is still present with the latest version of LibreOffice
from https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the information
from Help - About LibreOffice.

If the bug is NOT present, please set the bug's Status field to
RESOLVED-WORKSFORME and leave a comment that includes the information from Help
- About LibreOffice.

Please DO NOT

Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular
meaning that is not 
appropriate in this case)


If you want to do more to help you can test to see if your issue is a
REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your
bug pertains to a feature added after 3.3) from
https://downloadarchive.documentfoundation.org/libreoffice/old/

2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to 'inherited from OOo';
4b. If the bug was not present in 3.3 - add 'regression' to keyword


Feel free to come ask questions or to say hello in our QA chat:
https://web.libera.chat/?settings=#libreoffice-qa

Thank you for helping us make LibreOffice even better for everyone!

Warm Regards,
QA Team

MassPing-UntouchedBug

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 36546] Internal HSQLDB 1.8 fails to cascade updates through multiple paths and deletions through some cyclic structures

[bugzilla-daemon]

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

--- Comment #26 from QA Administrators  ---
** Please read this message in its entirety before responding **

To make sure we're focusing on the bugs that affect our users today,
LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed
bugs which have not been touched for over a year.

There have been thousands of bug fixes and commits since anyone checked on this
bug report. During that time, it's possible that the bug has been fixed, or the
details of the problem have changed. We'd really appreciate your help in
getting confirmation that the bug is still present.

If you have time, please do the following:

Test to see if the bug is still present with the latest version of LibreOffice
from https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the information
from Help - About LibreOffice.

If the bug is NOT present, please set the bug's Status field to
RESOLVED-WORKSFORME and leave a comment that includes the information from Help
- About LibreOffice.

Please DO NOT

Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular
meaning that is not 
appropriate in this case)


If you want to do more to help you can test to see if your issue is a
REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your
bug pertains to a feature added after 3.3) from
http://downloadarchive.documentfoundation.org/libreoffice/old/

2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to 'inherited from OOo';
4b. If the bug was not present in 3.3 - add 'regression' to keyword


Feel free to come ask questions or to say hello in our QA chat:
https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa

Thank you for helping us make LibreOffice even better for everyone!

Warm Regards,
QA Team

MassPing-UntouchedBug

-- 
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 36546] Internal HSQLDB 1.8 fails to cascade updates through multiple paths and deletions through some cyclic structures

[bugzilla-daemon]

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

--- Comment #25 from ribotb  ---
Hi,

I redid the tests included in the attachments of the comment#2 and comment#3
with:

Version: 5.3.0.3
Build ID: 7074905676c47b82bbcfbea1aeefc84afe1c50e1
Threads CPU : 2; Version de l'OS :Windows 6.1; UI Render : par défaut; Moteur
de mise en page : nouveau; 
Locale : fr-FR (fr_FR); Calc: group

The results are identical to those described in comment#1

Bernard

-- 
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 36546] Internal HSQLDB 1.8 fails to cascade updates through multiple paths and deletions through some cyclic structures

[bugzilla-daemon]

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

--- Comment #24 from QA Administrators  ---
** Please read this message in its entirety before responding **

To make sure we're focusing on the bugs that affect our users today,
LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed
bugs which have not been touched for over a year.

There have been thousands of bug fixes and commits since anyone checked on this
bug report. During that time, it's possible that the bug has been fixed, or the
details of the problem have changed. We'd really appreciate your help in
getting confirmation that the bug is still present.

If you have time, please do the following:

Test to see if the bug is still present on a currently supported version of
LibreOffice 
(5.2.5 or 5.3.0  https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the version of
LibreOffice and 
your operating system, and any changes you see in the bug behavior

If the bug is NOT present, please set the bug's Status field to
RESOLVED-WORKSFORME and leave 
a short comment that includes your version of LibreOffice and Operating System

Please DO NOT

Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular
meaning that is not 
appropriate in this case)


If you want to do more to help you can test to see if your issue is a
REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your
bug pertains to a feature added after 3.3)

http://downloadarchive.documentfoundation.org/libreoffice/old/

2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to "inherited from OOo";
4b. If the bug was not present in 3.3 - add "regression" to keyword


Feel free to come ask questions or to say hello in our QA chat:
http://webchat.freenode.net/?channels=libreoffice-qa

Thank you for helping us make LibreOffice even better for everyone!

Warm Regards,
QA Team

MassPing-UntouchedBug-20170306

-- 
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 36546] Internal HSQLDB 1.8 fails to cascade updates through multiple paths and deletions through some cyclic structures

[bugzilla-daemon]

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

--- Comment #23 from ribotb  ---
"Intefrity violation" and "Stack overflow" occurs with embedded and standalone
HSQLDB and with HSQLDB Server 1.8.1

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 36546] Internal HSQLDB 1.8 fails to cascade updates through multiple paths and deletions through some cyclic structures

[bugzilla-daemon]

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

--- Comment #22 from ribotb  ---
Hi,

I redid the tests "Integrity constraint violation" and  "Stack overflow"
with HSQLDB Server 2.3.3
--> No problem.

It seems there is a problrm with HSQLDB 1.8 (embedded  and standalone).

I have not tested with HSQLDB Server 1.8.

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 36546] Internal HSQLDB 1.8 fails to cascade updates through multiple paths and deletions through some cyclic structures

[bugzilla-daemon]

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

--- Comment #20 from ribotb  ---
I redid the "Stack overflow" test.

With embedded HSQLDB;
-->  S1000 General error java.lang.StackOverflowError on statement "delete from
d_node;").
Same error with standalone HSQLDB 1.8:
--> java.sql.SQLException: SIOOO General error java.lang.StackOverfiowError

No problem with embedded Firebird.

Version: 5.1.0.2
Build ID: ecd3574d51754b043f865cf5bafee286d24db7cc
CPU Threads: 2; OS Version: Windows 6.1; UI Render: default; 
Locale : fr-FR (fr_FR)
on Win7/x86

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 36546] Internal HSQLDB 1.8 fails to cascade updates through multiple paths and deletions through some cyclic structures

[bugzilla-daemon]

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

--- Comment #19 from ribotb  ---
Hi,

I redid the test "Integrity constraint violation" with embedded HSQLDB:
--> Integrity constraint violation - no parent FK_SAMPLESTUDY table: D_SAMPLE

Test and also with srandalone HSQLDB 1.8:
--> java.sql.SQLException: Integrity constraint violation - no parent
FK_SAMPLESTUDY table: D_SAMPLE

No problem with embedded Firebird or Firebird Database Server 2.5 (except
Firebird does not accept NULL for field "element" in table D_SAMPLE).

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 36546] Internal HSQLDB 1.8 fails to cascade updates through multiple paths and deletions through some cyclic structures

[bugzilla-daemon]

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

--- Comment #21 from rob...@familiegrosskopf.de ---
Don't know if we should spend our time with this bug. It is a bug of the
internal HSQLDB. Nobody would ever fix it. With other database (also together
with Base as GUI) the bug doesn't appear.

Good to know about bugs of old HSQLDB 1.8 - but that's all.

Robert

-- 
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 36546] Internal HSQLDB 1.8 fails to cascade updates through multiple paths and deletions through some cyclic structures

[bugzilla-daemon]

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

--- Comment #18 from QA Administrators  ---
** Please read this message in its entirety before responding **

To make sure we're focusing on the bugs that affect our users today,
LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed
bugs which have not been touched for over a year.

There have been thousands of bug fixes and commits since anyone checked on this
bug report. During that time, it's possible that the bug has been fixed, or the
details of the problem have changed. We'd really appreciate your help in
getting confirmation that the bug is still present.

If you have time, please do the following:

Test to see if the bug is still present on a currently supported version of
LibreOffice (5.0.4 or later)  https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the version of
LibreOffice and your operating system, and any changes you see in the bug
behavior

If the bug is NOT present, please set the bug's Status field to
RESOLVED-WORKSFORME and leave a short comment that includes your version of
LibreOffice and Operating System

Please DO NOT:

- Update the version field
- Reply via email (please reply directly on the bug tracker)
- Set the bug's Status field to RESOLVED - FIXED (this status has a particular
meaning that is not appropriate in this case)

If you want to do more to help you can test to see if your issue is a
REGRESSION. To do so: 1. Download and install oldest version of LibreOffice
(usually 3.3 unless your bug pertains to a feature added after 3.3)

http://downloadarchive.documentfoundation.org/libreoffice/old/

2. Test your bug 3. Leave a comment with your results. 4a. If the bug was
present with 3.3 - set version to "inherited from OOo"; 4b. If the bug was not
present in 3.3 - add "regression" to keyword


Feel free to come ask questions or to say hello in our QA chat:
http://webchat.freenode.net/?channels=libreoffice-qa

Thank you for your help!

-- The LibreOffice QA Team This NEW Message was generated on: 2016-01-17

-- 
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 36546] Internal HSQLDB 1.8 fails to cascade updates through multiple paths and deletions through some cyclic structures

[bugzilla-daemon]

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

--- Comment #17 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 36546] Internal HSQLDB 1.8 fails to cascade updates through multiple paths and deletions through some cyclic structures

[bugzilla-daemon]

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

Popa Adrian Marius map...@gmail.com changed:

   What|Removed |Added

   See Also||https://bugs.freedesktop.or
   ||g/show_bug.cgi?id=51780

-- 
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 36546] Internal HSQLDB 1.8 fails to cascade updates through multiple paths and deletions through some cyclic structures

[bugzilla-daemon]

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

--- Comment #16 from Popa Adrian Marius map...@gmail.com ---

This can be marked as fixed once #51780 is marked as done

-- 
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 36546] Internal HSQLDB 1.8 fails to cascade updates through multiple paths and deletions through some cyclic structures

[bugzilla-daemon]

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

Popa Adrian Marius map...@gmail.com changed:

   What|Removed |Added

 Depends on||51780

-- 
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 36546] Internal HSQLDB 1.8 fails to cascade updates through multiple paths and deletions through some cyclic structures

[bugzilla-daemon]

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

--- Comment #14 from R.D.Nielsen dreas.niel...@gmail.com ---
Although Firebird does not support the null specification for
d_sample.element, this is the default behavior, and eliminating the
specification allows the table to be created without error.  With only this
change to the DDL, Firebird 2.5 successfully completed all of the tests of
cascading updates and deletions through converving and cyclic data structures.

http://splinterofthesingularity.blogspot.com/2013/08/converging-and-cyclic-cascades-with.html

-- 
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 36546] Internal HSQLDB 1.8 fails to cascade updates through multiple paths and deletions through some cyclic structures

[bugzilla-daemon]

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

--- Comment #15 from ribotb rib...@gmail.com ---
I agree.
Bernard Ribot

-- 
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 36546] Internal HSQLDB 1.8 fails to cascade updates through multiple paths and deletions through some cyclic structures

[bugzilla-daemon]

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

--- Comment #12 from ribotb rib...@gmail.com ---
Hi,

1) Test SQL for reproduce Integrity constraint violation made with a Firebird
Server 2.5 database and IBEasy+ 1.5.4 (therefore, not with LO Base) aborts in
DDL execution : Firebird does not accept NULL for field element in table
D_SAMPLE.

2) Test SQL to reproduce Stack overflow is also OK (no stack overflow) with
Firefird Server 2.5 database and IBEASY+ 1.5.4.

Bernard Ribot

-- 
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 36546] Internal HSQLDB 1.8 fails to cascade updates through multiple paths and deletions through some cyclic structures

[bugzilla-daemon]

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

--- Comment #13 from Fred Toussi fr...@users.sourceforge.net ---
Both scripts work fine with HSQLDB 2.3.0. You can use this version with
non-embedded database files.

-- 
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 36546] Internal HSQLDB 1.8 fails to cascade updates through multiple paths and deletions through some cyclic structures

[bugzilla-daemon]

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

bfoman bfo.bugm...@spamgourmet.com changed:

   What|Removed |Added

 CC||bfo.bugm...@spamgourmet.com

--- Comment #11 from bfoman bfo.bugm...@spamgourmet.com ---
Firebird will become internal database and commits start to appear in master so
this report is potential WONTFIX. Please see bug 51780 for details.

-- 
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 36546] Internal HSQLDB 1.8 fails to cascade updates through multiple paths and deletions through some cyclic structures

[bugzilla-daemon]

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

--- Comment #8 from ribotb rib...@gmail.com ---
Hi,

1) Test SQL for reproduce Integrity constraint violation made with a MariaDB
5.5 database and HeidiSQl (therefore, not with LO Base) gives same result :
Integrity constraint violation - no parent FK_SAMPLESTUDY table: D_SAMPLE).

It seems that is not the fact of LO Base but something not logical in the
example of R.D. Nielsen ?

2) Test SQL to reproduce Stack overflow is OK with MariaDB/HeidiSQL; it is
also OK with LO 4.0.0.3 and a MySQL/ODBC connection to a MariaDB database;  but
crashes with LO 4.0.0.3 (Java 1.7.0_13)  and an internal HSQLDB database.

Bernard Ribot

-- 
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 36546] Internal HSQLDB 1.8 fails to cascade updates through multiple paths and deletions through some cyclic structures

[bugzilla-daemon]

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

--- Comment #9 from rob...@familiegrosskopf.de ---
(In reply to comment #8) 
 1) Test SQL for reproduce Integrity constraint violation made with a
 MariaDB 5.5 database and HeidiSQl (therefore, not with LO Base) gives same
 result : Integrity constraint violation - no parent FK_SAMPLESTUDY table:
 D_SAMPLE).
 
 It seems that is not the fact of LO Base but something not logical in the
 example of R.D. Nielsen ?
 
 2) Test SQL to reproduce Stack overflow is OK with MariaDB/HeidiSQL; it is
 also OK with LO 4.0.0.3 and a MySQL/ODBC connection to a MariaDB database; 
 but crashes with LO 4.0.0.3 (Java 1.7.0_13)  and an internal HSQLDB database.
 
Please read
http://splinterofthesingularity.blogspot.com/2011/04/converging-and-cyclic-cascades-in.html
(description of this report)
I have tested with Base and PostgreSQL. Both attachments work well. No problem.
It is, as described in the link, a problem of the database you use, not a
problem of Base as a frontend of the database.
So I ask again: Could we say, that this is a bug of LO and Base? I don't think
so.

-- 
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 36546] Internal HSQLDB 1.8 fails to cascade updates through multiple paths and deletions through some cyclic structures

[bugzilla-daemon]

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

rob...@familiegrosskopf.de changed:

   What|Removed |Added

Summary|Fails to cascade updates|Internal HSQLDB 1.8 fails
   |through multiple paths and  |to cascade updates through
   |deletions through some  |multiple paths and
   |cyclic structures   |deletions through some
   ||cyclic structures

-- 
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