https://bugs.documentfoundation.org/show_bug.cgi?id=117376
Bug ID: 117376
Summary: Firebird: Migration: Migration function should not mix
the HSQLdb and Firebird schemas in the same altered
ODB file
Product: LibreOffice
Version: 6.1.0.0.alpha1+ Master
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
Description:
Currently the auto-migrate function works by adding a firebird db into the ODB
content and leaving the existing HSQLdb db files intact. This was presented as
a good way not to loose data during the migration in that it would be easy to
revert back to the hsqldb:sdbc driver by just updating the settings in the ODB
content.
However also as part of the auto migration the function may alter items
external to the db (schema) to account for differences between database engines
and stored in ODB file content.
For very simple migrations just setting the sdbc setting would be make the ODB
usable, however the migration function also supports changes whih would make
using the ODB problematic at best, broken at worst.
Possible changes include:
changes to SQL select statements which could be in a querydef, form, report or
macros.
Table, View, Column names may need to be shortened during the migration and
again that ripples out through the objects above.
Steps to Reproduce:
1. Open any hsql based ODB
2. Start the migration
3. save the file
Actual Results:
Firebird database file is included in the ODB, ODB set to use firebird:sdbc;
necessary fixups to querydefs, reports etc are done, hsqldb data files remain
in file.
Expected Results:
not sure.
Reproducible: Always
User Profile Reset: No
Additional Info:
User-Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like
Gecko) Ubuntu Chromium/65.0.3325.181 Chrome/65.0.3325.181 Safari/537.36
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
