https://bugs.freedesktop.org/show_bug.cgi?id=67546
Priority: medium
Bug ID: 67546
Assignee: [email protected]
Summary: EDITING: related fields not shown if key is set as
"bigint unsigned" on mysql
Severity: normal
Classification: Unclassified
OS: Linux (All)
Reporter: [email protected]
Hardware: x86-64 (AMD64)
Status: UNCONFIRMED
Version: 4.1.0.4 release
Component: Database
Product: LibreOffice
With the 4.1 version base no longer shows related fields of 1:n relationships
in subforms of a mysql (native) db. A little experimenting showed that this
happens only when the primary key is set to "bigint unsigned". "bigint" alone
works, as do "int unsigned".
Steps to reproduce:
1. create a simple mysql database
CREATE TABLE `series` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
)
CREATE TABLE `episode` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`series_id` bigint unsigned DEFAULT NULL,
`title` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
)
2. link this db to LibreOffice base and create a simple form with the wizard
Table "series", add subform, Table "episode", join "series_id" and "id"
3. you can enter data in both tables, but stored data in the "episode" table is
not shown once you change the active record in the "series" table.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
