[Libreoffice-bugs] [Bug 116965] EDITING: firebird: migration: Relationships lost when database converted to firebird

2018-04-18 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=116965

--- Comment #4 from Drew Jensen  ---
Created attachment 141455
  --> https://bugs.documentfoundation.org/attachment.cgi?id=141455&action=edit
clean test file used to verify relationship migration

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs


[Libreoffice-bugs] [Bug 116965] EDITING: firebird: migration: Relationships lost when database converted to firebird

2018-04-18 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=116965

Drew Jensen  changed:

   What|Removed |Added

 Status|RESOLVED|VERIFIED

--- Comment #3 from Drew Jensen  ---
The migration routine does move relationships.

The test file I uploaded originally is a bad example, as it is one of those
with a errant firebird.gbk in it (still not sure how all the ways are to get
that to happen) and that generates problems with migration.

So - I'll attach the clean file used to verify this. 
4 tables, fk relations for same, 1 view and 1 query, all migrate.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs


[Libreoffice-bugs] [Bug 116965] EDITING: firebird: migration: Relationships lost when database converted to firebird

2018-04-16 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=116965

Tamas Bunth  changed:

   What|Removed |Added

 Status|NEW |RESOLVED
 Resolution|--- |FIXED

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs


[Libreoffice-bugs] [Bug 116965] EDITING: firebird: migration: Relationships lost when database converted to firebird

2018-04-15 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=116965

--- Comment #2 from Commit Notification 
 ---
Tamas Bunth committed a patch related to this issue.
It has been pushed to "master":

http://cgit.freedesktop.org/libreoffice/core/commit/?id=05b03813779922110bc9d31c922f906b4920c603

tdf#116965 dbahsql: migrate relationgships

It will be available in 6.1.0.

The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
http://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs


[Libreoffice-bugs] [Bug 116965] EDITING: firebird: migration: Relationships lost when database converted to firebird

2018-04-15 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=116965

Commit Notification  changed:

   What|Removed |Added

 Whiteboard||target:6.1.0

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs


[Libreoffice-bugs] [Bug 116965] EDITING: firebird: migration: Relationships lost when database converted to firebird

2018-04-12 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=116965

rob...@familiegrosskopf.de changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEW
 CC||rob...@familiegrosskopf.de
 Ever confirmed|0   |1

--- Comment #1 from rob...@familiegrosskopf.de ---
Could confirm the buggy behavior.

When starting the database under 
Version: 6.1.0.0.alpha0+
Build-ID: dc823f5fa4a5d2eca56297b9045e5962536c00f9
CPU-Threads: 4; BS: Linux 4.4; UI-Render: Standard; VCL: kde4; 
TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time:
2018-04-10_23:32:35

I get this error:

firebird_sdbc error:
*unsuccessful metadata update
*CREATE TABLE Products failed
*Table Products already exists
caused by
'CREATE TABLE "Products" ( "LeadTime" VARCHAR(50), "ProductID" INTEGER NOT NULL
PRIMARY KEY, "UnitPrice" DECIMAL(17), "CategoryID" INTEGER, "SupplierID"
INTEGER, "ProductName" VARCHAR(50), "Discontinued" BOOLEAN, "ReorderLevel"
INTEGER, "Serialnumber" VARCHAR(50), "UnitsInStock" INTEGER, "UnitsOnOrder"
INTEGER, "ProductDescription" VARCHAR(250))'

... but the tables appear, when switching to the "Tables"-section.
Then I opened the relationship and see two tables without any connection. Seems
the GUI has recognized there are two tables for the relationship, but doesn't
know the relation. Created the relation, saved and closed the database -
reopened and the relation has gone again. I have to close the database after
the migration and have to reopen it again. Then I could create the relation
without loosing it.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs


[Libreoffice-bugs] [Bug 116965] EDITING: firebird: migration: Relationships lost when database converted to firebird

2018-04-12 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=116965

Lionel Elie Mamane  changed:

   What|Removed |Added

 Blocks|51780   |


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=51780
[Bug 51780] [META] Default to Firebird not HSQLDB in Base
-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs


[Libreoffice-bugs] [Bug 116965] EDITING: firebird: migration: Relationships lost when database converted to firebird

2018-04-12 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=116965

Lionel Elie Mamane  changed:

   What|Removed |Added

 Blocks||116968


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=116968
[Bug 116968] (Database-Firebird-Migration) - [META] Migrating existing embedded
HSQLDB databases to Firebird
-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs


[Libreoffice-bugs] [Bug 116965] EDITING: firebird: migration: Relationships lost when database converted to firebird

2018-04-12 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=116965

V Stuart Foote  changed:

   What|Removed |Added

 CC||btom...@gmail.com,
   ||lio...@mamane.lu,
   ||vstuart.fo...@utsa.edu
 Blocks||51780


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=51780
[Bug 51780] [META] Default to Firebird not HSQLDB in Base
-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs