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: 2019-01-21 18:03 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