Bug 122815 - HSQL to Firebird migration fails, but file open anyway
Summary: HSQL to Firebird migration fails, but file open anyway
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
6.1.0.0.alpha1+
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Database-Firebird-Migration
  Show dependency treegraph
 
Reported: 2019-01-19 13:20 UTC by Joao Farias
Modified: 2023-07-12 06:24 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
Database attachment (34.59 KB, application/vnd.oasis.opendocument.database)
2019-01-19 13:20 UTC, Joao Farias
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Joao Farias 2019-01-19 13:20:11 UTC
Description:
When a SQL error -152 happens due a column long name, LO warns about the problem, but allows the user to proceed.

Steps to Reproduce:
1. Open the attachment
2. Go to Reports
3. Try to open the Geschlecht_Diagramm
   3.1. LO prompts about the Firebird migration
4. Proceed with the migration
   4.1 LO warns about a SQL error -104: "Name linger than database column size caused by 'isc_dsql_prepare' "
5. Click on OK

Actual Results:
1 - The following error is displayed on the terminal: https://gist.github.com/JoaoGFarias/84672ce2c4650d67b35499d86d9a6372
2 - The file opens anyway

Expected Results:
TBD - Not sure if the SQL error causes a problem in the migration process


Reproducible: Always


User Profile Reset: Yes



Additional Info:
Version: 6.3.0.0.alpha0+
Build ID: 16fffbe869785dffeda9ae0d9f7c18a6559a2093
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; 
TinderBox: Linux-rpm_deb-x86_64@86-TDF, Branch:master, Time: 2019-01-19_01:39:11
Locale: en-GB (en_GB.UTF-8); UI-Language: en-US
Calc: threaded
Comment 1 Joao Farias 2019-01-19 13:20:57 UTC
Created attachment 148436 [details]
Database attachment
Comment 2 MM 2019-01-19 18:43:34 UTC
Unconfirmed on mint 19.1 with Version: 6.3.0.0.alpha0+
Build ID: 16fffbe869785dffeda9ae0d9f7c18a6559a2093
CPU threads: 2; OS: Linux 4.15; UI render: default; VCL: gtk3; 
TinderBox: Linux-rpm_deb-x86_64@86-TDF, Branch:master, Time: 2019-01-19_01:39:11
Locale: en-US (en_US.UTF-8); UI-Language: en-US
Calc: threaded
Comment 3 Robert Großkopf 2019-01-20 15:27:05 UTC
Could confirm the behaviour. The view (named with more than 30 characters, see bug116987), isn't created. It is the problem of table-names, not of columns-names.
Comment 4 Xisco Faulí 2019-01-21 18:03:22 UTC
Also reproduced in

Version: 6.1.0.0.alpha1+
Build ID: 3a801799536e6870f2fb111b1cc00b9575a35a39
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; 
Locale: ca-ES (ca_ES.UTF-8); Calc: group
Comment 5 Xisco Faulí 2019-07-11 13:45:10 UTC
Still reproducible in

Version: 6.4.0.0.alpha0+
Build ID: 7a0164f0d82d91e2ac481d74cdacfe9a7ad6080f
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; 
Locale: ca-ES (ca_ES.UTF-8); UI-Language: en-US
Calc: threaded
Comment 6 QA Administrators 2021-07-11 03:39:43 UTC Comment hidden (obsolete)
Comment 7 Robert Großkopf 2021-07-11 06:23:15 UTC
Bug still reproducible with LO 7.1.5.1 on OpenSUSE 15.2 64bit rpm Linux.
Comment 8 QA Administrators 2023-07-12 03:14:32 UTC Comment hidden (obsolete)
Comment 9 Robert Großkopf 2023-07-12 06:24:07 UTC
Bug still the same in LO 7.5.5.2 on OpenSUSE 15.4 64bit rpm Linux.

File shouldn't be created. 
Reason for the error (Name of view has too much characters) should be shown.
Then the user could solve this problem and try to migrate again.