Open a PostgreSQL-database with direct connection. Connect to database through click on the Tables pane. Start Tools → SQL. Execute CREATE TABLE public.distributors ( did integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY, name varchar(40) NOT NULL ); Close Tools → SQL Refresh tables and you could see the table. Open the table for input data. No AutoValue appears. Type something in column "name" and set to next row. '0' appears as "did". You could input a lot of content and always '0' appears. You have to reload the table and the values would appear. Direct connection couldn't handle autovalue created by "Generated by default as identity". Direct connection doesn't save autovalue through GUI (another bug 60643). Direct connection will only show autovalue when created as "serial". This is a second (special) way to create such a field in PostgreSQL.
Confirming with Version: 7.2.6.2 / LibreOffice Community Build ID: b0ec3a565991f7569a5a7f5d24fed7f52653d754 CPU threads: 8; OS: Mac OS X 10.16; UI render: default; VCL: osx Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR Calc: threaded Isn't this a regression though ? I thought that this used to work OK (but maybe I'm wrong), because it was one of the recommended workarounds to the limitations of bug 60643.
(In reply to Alex Thurgood from comment #1) > > Isn't this a regression though ? > > I thought that this used to work OK (but maybe I'm wrong), because it was > one of the recommended workarounds to the limitations of bug 60643. There are two methods to create autovalue fields. One is directly with datatype SERIAL, the other with PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY . The second expression has been added in PostgreSQL 10, so end of 2017. It had been added because it will be used in other database engines in the same way. AutoValue created by SERIAL will be shown in direct connected PostgreSQL table.
This buggy behavior also will appear when trying to get such an AutoValue by stNID = oForm.getString(oForm.findColumn("ID")) in a macro. So I have to switch macros to stNID = oForm.getString(oForm.findColumn("ID")) IF stNID = 0 THEN oForm.reload() stNID = oForm.getString(oForm.findColumn("ID")) END IF This will work when form is sorted by "ID" DESC
Dear Robert Großkopf, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
Bug still exists in Version: 25.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 59cb37a210675d4269c2fcd48feeffe942538891 CPU threads: 6; OS: Linux 6.4; UI render: default; VCL: kf5 (cairo+xcb) Locale: de-DE (de_DE.UTF-8); UI: de-DE Calc: threaded