Bug 127271 - Base crashes upon entering certain SQL commands with external HSQLDB 2.5.0 in split database setup
Summary: Base crashes upon entering certain SQL commands with external HSQLDB 2.5.0 in...
Status: CLOSED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
6.3.0.4 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL: https://123-hp-com.biz/
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-09-01 22:51 UTC by Fabiano Freitas
Modified: 2020-02-17 12:36 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Base crash (6.14 KB, image/png)
2019-09-01 22:51 UTC, Fabiano Freitas 		Details
Base crash (7.99 KB, image/png)
2019-09-01 22:52 UTC, Fabiano Freitas 		Details
Sample database (4.23 KB, application/zip)
2019-09-03 22:43 UTC, Fabiano Freitas 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Fabiano Freitas 2019-09-01 22:51:46 UTC 
Created attachment 153802 [details]
Base crash

When I enter some SQL statements like:

SELECT PRODUCTID FROM TBLSOURCE EXCEPT SELECT PRODUCTID FROM TBLPRODUCTS

The Base application crashes instantly. The screenshots are attached.

I'm using HSQLDB version 2.5.0 in split-mode. However, when I run simpler statements like this one:


SELECT PRODUCTID FROM TBLSOURCE WHERE PRODUCTID = 10

it works OK.


Note that in LibreOffice version 6.2.6.2 (x86) this issue *doesn't* occur at all. All SQL commands that I'm used to running always work flawlessly.


The issue is in:

Version: 6.3.0.4 (x86)
Build ID: 057fc023c990d676a43019934386b85b21a9ee99
CPU threads: 4; OS: Windows 6.3; UI render: default; VCL: win; 
Locale: pt-BR (pt_BR); UI-Language: en-US
Calc: CL
Comment 1 Fabiano Freitas 2019-09-01 22:52:45 UTC 
Created attachment 153803 [details]
Base crash
Comment 2 Alex Thurgood 2019-09-02 09:48:50 UTC 
@Fabiano : does this problem only occur with split hsqldb, or does it also occur with the default embedded hsqldb 1.8 ?

Ideally, we need a db test file with which to attempt to reproduce the problem.
Comment 3 Fabiano Freitas 2019-09-03 22:42:36 UTC 
@Alex: I don't know about the embedded database. I have never used it.


I created a sample database so you can try to reproduce the issue. You'll need to adjust the path to the database in the connection string.




Thank you.
Comment 4 Fabiano Freitas 2019-09-03 22:43:21 UTC 
Created attachment 153849 [details]
Sample database
Comment 5 QA Administrators 2019-09-04 04:30:15 UTC Comment hidden (obsolete)
Comment 6 Alex Thurgood 2019-09-04 05:25:47 UTC 
Unfortunately, for me, using a hsqldb split database on macOS is in my experience problematic because of the confusion caused by having two identically named jar files in the application path, so I am unable to test.
Comment 7 Alex Thurgood 2019-09-04 05:43:49 UTC 
No repro with embedded hsqldb 1.8 in an ODB file, using :

Version: 6.4.0.0.alpha0+
Build ID: e04b6f3c0cdacf2a3cdcd3f34bad54c8764ff1ed
CPU threads: 4; OS: Mac OS X 10.14.6; UI render: default; VCL: osx; 
Locale: fr-FR (fr_FR.UTF-8); UI-Language: en-US
Calc: threaded

so I'm guessing that this is specific to the use of the 2.5.0 version of the external hsqldb engine (split database).
Comment 8 Alex Thurgood 2019-09-04 05:47:02 UTC 
@Fabiano : as this kind of setup is fairly rarely used by most of the people doing Base QA, it may take a while to confirm.
Comment 9 Xisco Faulí 2019-09-04 10:21:56 UTC 
Hello Fabiano,
it seems to me like a duplicate of bug 126588.
Could you please try again with LibreOffice 6.3.1.2 which is going to be released tomorrow ?
Comment 10 Fabiano Freitas 2019-09-05 23:18:17 UTC 
Hi Xisco,

I can confirm it's fixed in this version. I also had to create a new database file (.odb). Apparently, .odb files created with older versions (say 2.6) of LibreOffice aren't compatible with recent versions of it.


Problem resolved!
Comment 11 QA Administrators 2019-09-06 05:03:11 UTC Comment hidden (obsolete)
Comment 12 Alex Thurgood 2019-09-06 08:01:06 UTC 
(In reply to Fabiano Freitas from comment #10)
> Hi Xisco,
> 
> I can confirm it's fixed in this version. I also had to create a new
> database file (.odb). Apparently, .odb files created with older versions
> (say 2.6) of LibreOffice aren't compatible with recent versions of it.
> 


@Fabiano : you shouldn't have to create a new ODB file, what was the error message you received ?
Comment 13 Alex Thurgood 2019-09-06 12:59:50 UTC 
Let's set this to resolved fixed, as it appears that the fix from bug 126588 has solved the crash issue.
Comment 14 Xisco Faulí 2019-09-09 23:35:58 UTC 
Setting to RESOLVED WORKSFORME as the commit fixing this issue hasn't been identified.