https://bugs.documentfoundation.org/show_bug.cgi?id=120245
Bug ID: 120245
Summary: LibreOffice forms refuses to insert empty field with
'not null' database constraint (but filled by trigger
or default value)
Product: LibreOffice
Version: 6.1.2.1 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
Description:
I use debian packaged libreoffice with libreoffice-sdbc-postgresql driver.
I do not know where the bug is.
I have simple form based on postgresql table.
In this table there is a column
name type nullable default
value
utw timestamp without time zone not null now()
This column does not have its field in form.
With package:
Package: libreoffice-base
Version: 1:6.1.2-1
Package: libreoffice-sdbc-postgresql
Version: 1:6.1.2-1
I cannot save filled form to database, because
"required utw field has no value"
When I drop "not null" from column, and restart libreoffice - form could
be saved to database.
When I tried with version: 1:6.1.1~rc1-2 of libreoffice packages its
works as expected.
PostgreSQL 10.5 (Debian 10.5-1) on x86_64-pc-linux-gnu, compiled by gcc (Debian
8.2.0-3) 8.2.0, 64-bit
Steps to Reproduce:
1. in postgres do "create table x (id serial primary key, x text, u timestamp
with time zone not null default now());"
2. confgure connection to database with sdbc-postgresql driver
3. prepare form based on this table WITHOUT u field (example will be attached)
4. fill form
5. try to save record
Actual Results:
message: Input required in field 'u'. Please enter a value.
Expected Results:
insert a record
Reproducible: Always
User Profile Reset: No
Additional Info:
--
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
