[Libreoffice-bugs] [Bug 91814] Problem when copying large table with floating-point values from Calc to Base (HSQLDB)

[bugzilla-daemon]

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

--- Comment #14 from QA Administrators  ---
Dear christian_kuhn,

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 91814] Problem when copying large table with floating-point values from Calc to Base (HSQLDB)

[bugzilla-daemon]

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

--- Comment #13 from christian_k...@gmx.net ---
Hello,

I have copied the table of this example to an external SQLite database
successfully (via ODBC driver, duration approx. 45 minutes).

Best regards,
Christian

-- 
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 91814] Problem when copying large table with floating-point values from Calc to Base (HSQLDB)

[bugzilla-daemon]

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

--- Comment #12 from christian_k...@gmx.net ---
Hello,

I have downloaded the example and have tested it with

Version: 6.3.0.0.alpha1
Build-ID: 1:6.3.0~alpha1-2
CPU-Threads: 2; BS: Linux 4.19; UI-Render: Standard; VCL: kde5; 
Gebietsschema: de-DE (de_DE.UTF-8); UI-Sprache: de-DE
Calc: threaded

I have got the following results:

1) I have created a new database with internal HSQLDB (skipping question for
migration to Firebird DB). After starting the copy process, the same error
occurred, the bug is still present.

2) I have created a new database with the internal Firebird DB. Nothing
happens, I could not start the copy process.

3) I have used LO Base with an external SQLite database connected by an ODBC
driver. It seems to work, but it takes a long time (I have interrupted the copy
process after several hours).

Best regards,
Christian

-- 
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 91814] Problem when copying large table with floating-point values from Calc to Base (HSQLDB)

[bugzilla-daemon]

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

--- Comment #11 from QA Administrators  ---
Dear christian_kuhn,

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 91814] Problem when copying large table with floating-point values from Calc to Base (HSQLDB)

[bugzilla-daemon]

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

--- Comment #10 from christian_k...@gmx.net ---
Hello,

the bug is still present in Base using HSQLDB:

Version: 6.0.5.2
Build-ID: 54c8cbb85f300ac59db32fe8a675ff7683cd5a16
CPU-Threads: 4; BS: Windows 6.3; UI-Render: Standard; 
Gebietsschema: de-DE (de_DE); Calc: Group.


Best regards,
Christian

-- 
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 91814] Problem when copying large table with floating-point values from Calc to Base (HSQLDB)

[bugzilla-daemon]

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

--- Comment #9 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 91814] Problem when copying large table with floating-point values from Calc to Base (HSQLDB)

[bugzilla-daemon]

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

--- Comment #8 from christian_k...@gmx.net ---
I have tested it with LibreOffice 5.2.1.2 under Windows 10. The bug is still
present.

Best regards,
Christian

-- 
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 91814] Problem when copying large table with floating-point values from Calc to Base (HSQLDB)

[bugzilla-daemon]

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

--- Comment #7 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.1.5 or 5.2.1  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-20160920

-- 
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 91814] Problem when copying large table with floating-point values from Calc to Base (HSQLDB)

[bugzilla-daemon]

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

--- Comment #6 from christian_k...@gmx.net ---
I could copy the Calc table to a SQLite database (via ODBC), but not to a
Firebird database.

-- 
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 91814] Problem when copying large table with floating-point values from Calc to Base (HSQLDB)

[bugzilla-daemon]

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

--- Comment #5 from rob...@familiegrosskopf.de ---
Base and the internal HSQLDB (and also I myself) doesn't know what kind of
numbers that are. So there is created a varcharfield for every columns and
reserved a length of 65535 characters for every field.
Base recognizes the fields as varchar-fields also when connecting the
Calc-table directly to Base.
Have tried to import the first 1000 rows - works without any error. If I try to
import the whole table at one time it doesn't work.

Don't know how the wizard works. But expected behavior would be: Every row must
be copied and inserted to the new table. If there will appear an error all
rows, which had been copied before, must be part of the new table. The new
table hasn't to be empty.
Copying of the Calc-table to Base at once shows such an empty table.

-- 
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 91814] Problem when copying large table with floating-point values from Calc to Base (HSQLDB)

[bugzilla-daemon]

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

rob...@familiegrosskopf.de changed:

   What|Removed |Added

 OS|Mac OS X (All)  |All

-- 
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 91814] Problem when copying large table with floating-point values from Calc to Base (HSQLDB)

[bugzilla-daemon]

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

Alex Thurgood ipla...@yahoo.co.uk changed:

   What|Removed |Added

 CC||lio...@mamane.lu,
   ||rob...@familiegrosskopf.de,
   ||serval2...@yahoo.fr
 OS|Windows (All)   |Mac OS X (All)

-- 
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 91814] Problem when copying large table with floating-point values from Calc to Base (HSQLDB)

[bugzilla-daemon]

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

--- Comment #2 from Alex Thurgood ipla...@yahoo.co.uk ---
Eventually, I get the same error message as in the original report :
Statut SQL: S1000
Code d'erreur: 98

java.io.IOException: java.lang.NullPointerException in statement [INSERT INTO
Table ( ID,Column 1,Column 2,Column 3,Column 4,Column 5,Column
6,Column 7,Column 8,Column 9,Column 10,Column 11,Column 12,Column
13,Column 14,Column 15,Column 16,Column 17,Column 18,Column
19,Column 20,Column 21,Column 22,Column 23,Column 24,Column
25,Column 26,Column 27,Column 28,Column 29,Column 30,Column
31,Column 32,Column 33,Column 34,Column 35,Column 36,Column
37,Column 38,Column 39,Column 40,Column 41,Column 42,Column
43,Column 44,Column 45,Column 46,Column 47,Column 48,Column
49,Column 50,Column 51,Column 52,Column 53,Column 54,Column
55,Column 56,Column 57,Column 58,Column 59,Column 60,Column
61,Column 62,Column 63,Column 64) VALUES (
?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)]

-- 
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 91814] Problem when copying large table with floating-point values from Calc to Base (HSQLDB)

[bugzilla-daemon]

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

Alex Thurgood ipla...@yahoo.co.uk changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEW
 Ever confirmed|0   |1

--- Comment #1 from Alex Thurgood ipla...@yahoo.co.uk ---
On 

Version: 4.4.3.2
Build ID: 88805f81e9fe61362df02b9941de8e38a9b5fd16
Locale : fr_

OSX 10.10.3

if I choose to check the parameters of the fields before import I can cause
screen corruption in the import dialog, with multiple selected column ids, two
PK ID columns (whereas only one should appear) and a refusal for the wizard to
go any further, even clicking Create cause nothing to happen, the wizard just
seems to give up.

If I just click on Create in the wizard, OSX goes straight into spinning
beachball mode...

Aparrently, the wizard / import / copy code can not handle an array that big


Confirming.

-- 
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 91814] Problem when copying large table with floating-point values from Calc to Base (HSQLDB)

[bugzilla-daemon]

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

--- Comment #3 from Alex Thurgood ipla...@yahoo.co.uk ---
If you decide to click on continue (several times) when you get the error
message, you end up with a table in the new ODB file that can not display any
data, with a new error message :

Statut SQL: S1000
Code d'erreur: 40

S1000 General error java.lang.NullPointerException in statement [SELECT * FROM
Table]

-- 
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 91814] Problem when copying large table with floating-point values from Calc to Base (HSQLDB)

[bugzilla-daemon]

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

--- Comment #4 from Alex Thurgood ipla...@yahoo.co.uk ---
In 

Version: 5.1.0.0.alpha1+
Build ID: 55431a84c264a8bcca593b9207aae0ad81d10f30
Locale : fr-FR (fr.UTF-8)

performance is noticeably worse when loading the Calc referenced ODB.

The array is 64*26432*representation of number, whatever that might be, but
that seems to be quite a big ask of the wizard / copy code.

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