| Summary: | UI: Relationships window does not allow adding foreign keys | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | James B. Byrne <byrnejb> |
| Component: | Base | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED WORKSFORME | ||
| Severity: | normal | CC: | iplaw67, lo_bugs, robert |
| Priority: | medium | ||
| Version: | 4.1.0.4 release | ||
| Hardware: | Other | ||
| OS: | macOS (All) | ||
| Whiteboard: | BSA | ||
| Crash report or crash signature: | Regression By: | ||
I see the expected behavior with master commit 95e95e0, fetched
2913-09-19, configured with
--enable-option-checking=fatal
--enable-dbgutil
--enable-crashdump
--without-system-postgresql
--without-myspell-dicts
--with-extra-buildid
--without-doxygen
--with-external-tar=/home/terry/lo_hacking/git/src
built on ubuntu-natty (11.04) 32-bit, executing on ubuntu-quantal
(12.10) 64-bit.
No problem here with LO 4.1.1.2 Linux 64bit rpm, also with LO 4.1.0.4 Linux 64bit rpm. Tables could be connected in Extras → Relationships. Could it be a Mac-only-bug? I have checked LO-4.1.1.2 on Linux (CentOS-6.4) and there the visual relationship window works as expected. I note that on the MacBook LO is using the last released JRE from Apple. I do not know if that might be a factor. I have checked 4.1.1.2 on Windows V7 and the relationships visual editing window works there as expected. However, I have confirmed that the problem is still evident on Mac OSX 10.8 in LO 4.1.2.2 as well. Hi James..just a ping since it's been reported months ago. Does it still happen in 4.2.5.2 or 4.3.0.2 using OSX ? If resolved please change status to RESOLVED WORKSFORME, unless UNCONFIRMED I will check. I have moved on to other issues since and worked around this one somehow. Adding self to CC if not already on This appears to be resolved in LO 4.3.5.2release. |
Problem description: In LO-4.1.1 it is not possible to add a foreign key constraint by dragging the foreign key to the primary key table. Steps to reproduce: 1. Create a table N with columns id (integer-autoincr-pk), other 2. Create a table Y with columns id (integer-autoincr-pk), n_id (integer), other2 3. Open relationships window. 4. Add tables N and Y. 5. Select column n_id in Y and drag to id in N. Current behavior: A dotted line linking the two columns is displayed while dragging but it disappears and a small box floats back to the origin (n_id). Expected behavior: A solid line between n_id in Y and id in N should appear with 1 displayed next to id and n displayed next to n_id Operating System: Mac OS X Version: 4.1.0.4 release