libreoffice base/postgres - null columns with trigger/default values

users
#1

(This is also described at
https://lists.debian.org/debian-user/2018/09/msg01107.html)

I use 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:

--8<---------------cut here---------------start------------->8---
Package: libreoffice-base
Version: 1:6.1.2-1
Package: libreoffice-sdbc-postgresql
Version: 1:6.1.2-1
--8<---------------cut here---------------end--------------->8---

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.

Should I fill a bug? On debian's page or here? Aginst which
package/module?
KJ

#2

Hi,

You would want to open an issue in the LibreOffice bug tracker and the
module would be Base.
postgreSQL should be in the summary of course.

I know you said this form works with LibreOffice 6.1.1 rc, but I'm curious
how long it was working in your production environment. Was it working in
6.0 for instance?

Best wishes,

Drew.

#3

Also,

In the issue be sure to show which version of PostgreSQL you are using?

Thanks

#4

Hi Kamil,

I use 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:

I can reproduce this with :

MacOS 10.13.6
postgres 9.5
LibreOffice 6.1.2.1
sdbc built-in postgres driver

If I enter the data in Table data edit mode, then the date is added
automatically.

However, like you, filling in a simple form including the timestamp
field and leaving the timestamp field blank always throws an error when
I try to move to either a new record, or back to a previous record. What
should happen is that the timestamp value should be generated and the
record validated (as in Table data edit mode).

Alex

#5

BTW

Currently the native MySQL ( MariaDB) sdbc has a setting '
FormsCheckrequiredFields' which can turn that function on or off.
Checking just now the PostgreSQL sdbc code does not currently have that
option.
Yeah, that needs to go into the issue tracker for sure.

Drew

#6

Drew Jensen <drewjensen.inbox@gmail.com> writes:

Also,

In the issue be sure to show which version of PostgreSQL you are using?

Thanks

--8<---------------cut here---------------start------------->8---
$psql
Pager usage is off.
Border style is 0.
psql (10.5 (Debian 10.5-1))
Type "help" for help.

kjonca=> select version();
                                               version

#7

Drew Jensen <drewjensen.inbox@gmail.com> writes:

Hi,

You would want to open an issue in the LibreOffice bug tracker and the
module would be Base.
postgreSQL should be in the summary of course.

I know you said this form works with LibreOffice 6.1.1 rc, but I'm curious
how long it was working in your production environment. Was it working in
6.0 for instance?

I never have registered such probolem, and I use my "application" for
years.

KJ

#8

Hi,

I would not be surprised if a change in behavior happened recently, there
was some reworking of the sdbc drivers recently which I think had the
chance to touch basically all of them. NOTE: I'm not a developer of that
code but I try to follow along with the generalities through the QA group.

Given two folks seeing the same problem with the latest 6.1.2 build then
whether the postgreSQL driver should be updated for that option or needs
fixing I can't say, but the step right now is to open an issue and get it
started whichever way.

Best way, IMO, since you noticed it first here would be to go ahead and do
that yourself.
This URL assumes you have an account in the bug tracking system.
https://bugs.documentfoundation.org/enter_bug.cgi?product=LibreOffice;component=Base
If you don't have one and register then submit it you will get
notifications as it is worked.

Otherwise, if you really would rather not than one of us in the QA group
can do it.

Let us know.

Thanks

Drew

#9

Drew Jensen <drewjensen.inbox@gmail.com> writes:

Best way, IMO, since you noticed it first here would be to go ahead and do
that yourself.
This URL assumes you have an account in the bug tracking system.
https://bugs.documentfoundation.org/enter_bug.cgi?product=LibreOffice;component=Base
If you don't have one and register then submit it you will get
notifications as it is worked.

Otherwise, if you really would rather not than one of us in the QA group
can do it.

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

KJ

#10

kjonca@o2.pl (Kamil Jońca) writes:

Drew Jensen <drewjensen.inbox@gmail.com> writes:

[...]

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

Today I upgraded my debian packages and in:

Version: 1:6.1.3~rc1-1

there is no mentioned bug.

Thank you!
KJ