Bug 136637 - Firebird: Entering the sql command will cause Libreoffice to hang
Summary: Firebird: Entering the sql command will cause Libreoffice to hang
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
7.0.0.3 release
Hardware: x86-64 (AMD64) All
: medium minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: haveBacktrace
Depends on:
Blocks: Database-Queries
  Show dependency treegraph
 
Reported: 2020-09-10 06:38 UTC by avsharapov
Modified: 2020-11-28 19:26 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:
Regression By:


Attachments
bt with debug symbols (16.36 KB, text/plain)
2020-09-10 15:48 UTC, Julien Nabet
Details

Note You need to log in before you can comment on or make changes to this bug.
Description avsharapov 2020-09-10 06:38:59 UTC
Entering the sql command 

CREATE TABLE ext_log EXTERNAL FILE 'ext_log.txt' (c char(2) character set WIN1251)

will cause Libreoffice to hang

Tested on Windows7

P.S. I set the severity to minor because it is unlikely that someone will type such a command :)
Comment 1 Robert Großkopf 2020-09-10 14:31:09 UTC
Seems Firebird doesn't like the character set - definition here.

CREATE TABLE ext_log EXTERNAL FILE 'ext_log.txt' (c char(2));

seems to work with a real path. But I couldn't find the file, which has been created. Then I tried to input values into this (non existent, but listed) table. I will get this message:
firebird_sdbc error:
*Use of external file at location /home/robby/ext_log.txt is not allowed by server configuration
caused by
'INSERT INTO "EXT_LOG" ("C") VALUES ('y');'

All tested under OpenSUSE 15.1 64bit rpm Linux with LO 6.4.6.2

The original command with 
character set WIN1251
leads also to a hang of LO.
Comment 2 Julien Nabet 2020-09-10 15:48:25 UTC
Created attachment 165374 [details]
bt with debug symbols

On pc Debian x86-64 with master sources updated today, I could reproduce this.
Comment 3 Julien Nabet 2020-09-10 15:50:20 UTC
Just for the record since, according to the bt, it seems it's Firebird lib itself which aborts, I don't know how we could avoid the crash here.
Comment 4 avsharapov 2020-09-10 16:02:11 UTC
Firebird works well with this command.
And and writes characters in the specified encoding.
But apparently LO can't figure out the meta information later.
Comment 5 avsharapov 2020-09-11 16:02:43 UTC
Please note that my LO fell exactly with the CHARACTER SET option.
Is firebird still relevant? I see that when creating a new database, Firebird is missing from the selection list. This is if advanced mode is not enabled. in 6.3, it was in normal mode.
Comment 6 Robert Großkopf 2020-09-11 16:41:49 UTC
(In reply to shar from comment #5)
> Is firebird still relevant? I see that when creating a new database,
> Firebird is missing from the selection list. This is if advanced mode is not
> enabled. in 6.3, it was in normal mode.

The internal HSQLDB works better with the GUI of base than the internal Firebird. There are many special bugs only for the internal Firebird database. So it has been put back to an experimental feature.
Comment 7 avsharapov 2020-09-12 03:16:24 UTC
I didn't find any information about this in the version change texts. But this is very important. It's a pity that the built-in Firebird is again in question. I considered this a big step and a huge plus for LO Base. But nothing do.
I guess I was too hasty. So I urgently need to do a reverse conversion to Hbase and forget about the built-in Firebird. Thank you for the information.
Comment 8 Thomas Lendo QA 2020-09-12 20:04:35 UTC
For Firebird please see the meta bugs
bug 51780
bug 116968
bug 116970
Comment 9 Julien Nabet 2020-11-28 19:26:35 UTC
(In reply to avsharapov from comment #7)
> I didn't find any information about this in the version change texts. But
> this is very important. It's a pity that the built-in Firebird is again in
> question. I considered this a big step and a huge plus for LO Base. But
> nothing do.
> I guess I was too hasty. So I urgently need to do a reverse conversion to
> Hbase and forget about the built-in Firebird. Thank you for the information.

There's no automatic reverse conversion to HSQLDB. I can only propose you to use backups of your HSQLDB files.
About the lacking information, you're right, it's indeed lacking in release notes. (I put tdf#135882 on cc).