[Libreoffice-bugs] [Bug 101230] EDITING: Embedded Firebird - Creating relationship in GUI doesn' t show existing relations

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=101230

Julien Nabet  changed:

   What|Removed |Added

 Status|NEEDINFO|RESOLVED
   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=10
   ||7196
 Resolution|--- |FIXED

--- Comment #17 from Julien Nabet  ---
(In reply to robert from comment #16)
...
> ... but doesn't work with 
> Version: 5.3.3.2
> Build-ID: 3d9a8b4b4e538a85e0782bd6c2d430bafe583448
> CPU-Threads: 4; BS-Version: Linux 4.1; UI-Render: Standard; VCL: kde4;
> Layout-Engine: neu; 
> Gebietsschema: de-DE (de_DE.UTF-8); Calc: group
> 
> Don't know if we should set this to WORKSFORME, because it isn't fixed in
> the actual fresh release.
The fix is initially for tdf#107196 put in See Also.
It's been cherry-picked on 5.3 branch and will be available in 5.3.4.
Let's put this one to FIXED too.
Of course, don't hesitate to reopen this tracker if you still reproduce this
with 5.3.4

-- 
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 101230] EDITING: Embedded Firebird - Creating relationship in GUI doesn' t show existing relations

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=101230

--- Comment #16 from rob...@familiegrosskopf.de ---
Semms it works with
Version: 5.4.0.0.alpha1+
Build ID: c0968aa4673a8ac9a8a09a0e291b58b94bdbb35e
CPU threads: 4; OS: Linux 4.1; UI render: default; VCL: kde4; 
TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time:
2017-05-13_09:11:52
Locale: de-DE (de_DE.UTF-8); Calc: group

... but doesn't work with 
Version: 5.3.3.2
Build-ID: 3d9a8b4b4e538a85e0782bd6c2d430bafe583448
CPU-Threads: 4; BS-Version: Linux 4.1; UI-Render: Standard; VCL: kde4;
Layout-Engine: neu; 
Gebietsschema: de-DE (de_DE.UTF-8); Calc: group

Don't know if we should set this to WORKSFORME, because it isn't fixed in the
actual fresh release.

-- 
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 101230] EDITING: Embedded Firebird - Creating relationship in GUI doesn' t show existing relations

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=101230

Julien Nabet  changed:

   What|Removed |Added

 Status|NEW |NEEDINFO

--- Comment #15 from Julien Nabet  ---
Let's put this one to NEEDINFO by waiting for Robert's 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 101230] EDITING: Embedded Firebird - Creating relationship in GUI doesn' t show existing relations

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=101230

--- Comment #14 from Julien Nabet  ---
Created attachment 133157
  --> https://bugs.documentfoundation.org/attachment.cgi?id=133157=edit
test file from scratch with Firebird 3

On pc Debian x86-64 with master sources updated some days ago with
experimental, I could see the relationships only after having opened a table.
If I don't do this, relationships window opens but never see tables with
relationships with hourglass spinning.
I wonder if this symptom could be due to the migration between Firebird 2 and
3.

I recreated the same file as you and didn't reproduce the problem.
But perhaps I missed something.

-- 
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 101230] EDITING: Embedded Firebird - Creating relationship in GUI doesn' t show existing relations

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=101230

rob...@familiegrosskopf.de changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=10
   ||7653

-- 
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 101230] EDITING: Embedded Firebird - Creating relationship in GUI doesn' t show existing relations

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=101230

rob...@familiegrosskopf.de changed:

   What|Removed |Added

 Status|RESOLVED|NEW
 Resolution|DUPLICATE   |---

--- Comment #13 from rob...@familiegrosskopf.de ---
(In reply to Terrence Enger from comment #12)
> Bug 45257 looks like this one.  Setting this bug RESOLVED DUPLICATE.
> 
> *** This bug has been marked as a duplicate of bug 45257 ***

Isn't the same. Bug 45257 is for special relations of PostgreSQl and LO 3.5.
This one is for embedded Firebird and LO 5.3. With embedded Firebird the
relations won't be shown in any way.

-- 
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 101230] EDITING: Embedded Firebird - Creating relationship in GUI doesn' t show existing relations

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=101230

Terrence Enger  changed:

   What|Removed |Added

 Status|NEW |RESOLVED
 CC||lo_b...@iseries-guru.com
 Resolution|--- |DUPLICATE

--- Comment #12 from Terrence Enger  ---
Bug 45257 looks like this one.  Setting this bug RESOLVED DUPLICATE.

*** This bug has been marked as a duplicate of bug 45257 ***

-- 
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 101230] EDITING: Embedded Firebird - Creating relationship in GUI doesn' t show existing relations

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=101230

--- Comment #11 from Gerhard Schaber  ---
I can confirm the issue with the relationships editor in 5.3.0 beta 2.

-- 
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 101230] EDITING: Embedded Firebird - Creating relationship in GUI doesn' t show existing relations

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=101230

--- Comment #10 from Alex Thurgood  ---
(In reply to robert from comment #9)
> Created attachment 129051 [details]
> Same Testdocument, created with Firebird 3.0, LO 5.3

Yes, and AFAIK it requires the user to download and install the whole FB2.5
server packages, which is simply not going to be an option for the majority of
users.

-- 
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 101230] EDITING: Embedded Firebird - Creating relationship in GUI doesn' t show existing relations

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=101230

--- Comment #9 from rob...@familiegrosskopf.de ---
Created attachment 129051
  --> https://bugs.documentfoundation.org/attachment.cgi?id=129051=edit
Same Testdocument, created with Firebird 3.0, LO 5.3

-- 
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 101230] EDITING: Embedded Firebird - Creating relationship in GUI doesn' t show existing relations

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=101230

--- Comment #8 from thack...@nexgo.de ---
Hello Julien, *,
(In reply to Julien Nabet from comment #7)
> (In reply to thackert from comment #6)
> > firebird_sdbc error:
> > *unsupported on-disk structure for file
> > /tmp/lu22832xvqq8v.tmp/lu22832xvqq8z.tmp/firebird.fdb; found 11.2, support
> > 12.0
> > caused by
> > 'isc_attach_database'
> > 
> > 
> > Does this happen to you, too?
>
> The test file has been create with a Firebird version < 3.
> You must convert the file for Firebird 3.0. You can take a look here:
> https://bugs.documentfoundation.org/show_bug.cgi?id=70506#c15

thank you for this information :) But would that not be too much of a hassle
for a normal user?
Have a nice evening
Thomas.

-- 
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 101230] EDITING: Embedded Firebird - Creating relationship in GUI doesn' t show existing relations

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=101230

--- Comment #7 from Julien Nabet  ---
(In reply to thackert from comment #6)
> Hello Robert, *,
> ...
> firebird_sdbc error:
> *unsupported on-disk structure for file
> /tmp/lu22832xvqq8v.tmp/lu22832xvqq8z.tmp/firebird.fdb; found 11.2, support
> 12.0
> caused by
> 'isc_attach_database'
> 
> 
> Does this happen to you, too?
> Have a nice afternoon
> Thomas.
The test file has been create with a Firebird version < 3.
You must convert the file for Firebird 3.0. You can take a look here:
https://bugs.documentfoundation.org/show_bug.cgi?id=70506#c15

-- 
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 101230] EDITING: Embedded Firebird - Creating relationship in GUI doesn' t show existing relations

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=101230

--- Comment #6 from thack...@nexgo.de ---
Hello Robert, *,
when I retest your bug with your attached ODB file on

OS: Debian Testing AMD64
LO: Version: 5.3.0.0.beta1
Build-ID: 690f553ecb3efd19143acbf01f3af4e289e94536
CPU-Threads: 4; BS-Version: Linux 4.5; UI-Render: Standard; VCL: gtk2;
Layout-Engine: neu; 
Gebietsschema: de-DE (de_DE.UTF-8); Calc: group
(parallel installed, following the instructions from
https://wiki.documentfoundation.org/Installing_in_parallel/Linux)

I now get


Error code: 1

firebird_sdbc error:
*unsupported on-disk structure for file
/tmp/lu22832xvqq8v.tmp/lu22832xvqq8z.tmp/firebird.fdb; found 11.2, support 12.0
caused by
'isc_attach_database'


Does this happen to you, too?
Have a nice afternoon
Thomas.

-- 
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 101230] EDITING: Embedded Firebird - Creating relationship in GUI doesn' t show existing relations

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=101230

--- Comment #5 from rob...@familiegrosskopf.de ---
Have tested this again with 
Version: 5.3.0.0.alpha0+
Build ID: e7324c5705eaa38a2c9aa0636f01a73f033ba4d6
CPU Threads: 4; OS Version: Linux 4.1; UI Render: default; VCL: kde4; 
TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time:
2016-10-20_06:12:58
Locale: de-DE (de_DE.UTF-8); Calc: group

and the new Firebird 3.0

Same buggy behavior: 
The relation won't be shown while editing.
Input of wrong data would be forbidden by the relation, so the relation exists.
Opening tools - relationship again shows a connection between the headers of
the table, not between the connected fields.

-- 
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 101230] EDITING: Embedded Firebird - Creating relationship in GUI doesn' t show existing relations

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=101230

thack...@nexgo.de changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEW
 Ever confirmed|0   |1

--- Comment #4 from thack...@nexgo.de ---
Hello Robert, *,
thanks for your information :)

Retested it with
OS: Debian Testing AMD64
LO: Version: 5.3.0.0.alpha0+
Build-ID: f9f090d0d0f2b454d6c1dd14fe735e7e83fda9da
CPU-Threads: 4; BS-Version: Linux 4.5; UI-Render: Standard; 
TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time:
2016-07-24_06:28:54
Gebietsschema: de-DE (de_DE.UTF-8); Calc: group
(parallel installed, following the instructions from
https://wiki.documentfoundation.org/Installing_in_parallel/Linux)
and can confirm your bug, so setting the status to "New".
Have a nice afternoon
Thomas

-- 
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 101230] EDITING: Embedded Firebird - Creating relationship in GUI doesn' t show existing relations

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=101230

--- Comment #3 from rob...@familiegrosskopf.de ---
Hi Thomas,

Tools > Relationsships works for internal Firebird only with daily build. It
will be available in 5.3.0 and 5.2.1. See 
https://bugs.documentfoundation.org/show_bug.cgi?id=71009#c8
https://bugs.documentfoundation.org/show_bug.cgi?id=71009#c11

Regards

Robert

-- 
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 101230] EDITING: Embedded Firebird - Creating relationship in GUI doesn' t show existing relations

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=101230

--- Comment #2 from thack...@nexgo.de ---
Hello Robert, *,
(In reply to robert from comment #0)

> Try the following with the attached database:
> 1. Open table "Name".
> 2. Write down in first row '1','Bob','1'
> > Entry could be saved, because there isn't any foreignkey.
> 3. Delete the crated row.

Up to this point I can follow the steps, but ...

> 4. Enter Tools > Relationships

Here I get the message

LibreOffice Base Relation Design

The database does not support relations.


Tested with
OS: Debian Testing AMD64
LO: Version: 5.2.0.4
Build ID: 066b007f5ebcc236395c7d282ba488bca6720265
CPU Threads: 4; OS Version: Linux 4.5; UI Render: default; 
Locale: de-DE (de_DE.UTF-8)
(parallel installed, following the instructions from
https://wiki.documentfoundation.org/Installing_in_parallel/Linux)

As a side note:

LO: Version: 5.1.5.1
Build-ID: 1:5.1.5~rc1-1
CPU-Threads: 4; BS-Version: Linux 4.5; UI-Render: GL; 
Gebietsschema: de-DE (de_DE.UTF-8); Calc: group
(Debian's own version)

does not do anything, if I try to click on "Tables" (or open it via "View -
Database Objects - Tables" ... :(
HTH
Thomas.

-- 
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 101230] EDITING: Embedded Firebird - Creating relationship in GUI doesn' t show existing relations

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=101230

Julien Nabet  changed:

   What|Removed |Added

 CC||serval2...@yahoo.fr

--- Comment #1 from Julien Nabet  ---
About Firebird, I suppose (I might be wrong) that we're waiting for 3.0
Firebird upgrade with this patch https://gerrit.libreoffice.org/#/c/27642/
For the moment, the upgrade works for Linux and the author is working on
Windows integration. After this, there'll be MacOs integration.

-- 
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 101230] EDITING: Embedded Firebird - Creating relationship in GUI doesn' t show existing relations

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=101230

rob...@familiegrosskopf.de changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=71
   ||009

-- 
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