Bug 138463

Summary:	EDITING table: Auto value doesn't set the field automatically as primary key
Product:	LibreOffice	Reporter:	Robert Großkopf <robert>
Component:	Base	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED WORKSFORME
Severity:	normal	CC:	xiscofauli
Priority:	medium	Keywords:	regression
Version:	7.0.3.1 release
Hardware:	x86-64 (AMD64)
OS:	Linux (All)
Whiteboard:
Crash report or crash signature:		Regression By:

Description Robert Großkopf 2020-11-24 14:45:11 UTC

Open a internal HSQLDB database.
Create a table with GUI.
Set the first field "ID" and in the field properties "AutoValue".
The field will be set automatically as primary key for the table.

This works up to LO 6.4.6.2, fails with LO 7.0.3.1.
In LO 7.0.3.1 the field won't be set automatically as primary key.

My system: OpenSUSE 15.1 64bit rpm Linux with different LO versions.

Comment 1 Xisco Faulí 2021-02-23 08:47:06 UTC

Hello Robert,
Not sure if I'm following the steps correctly.

Steps:
1. Open any HSQLDB database
2. Table - Use Wizard to create a table
3. Move TaskId to the right - click on next
4. Autovalue - yes
5. Finish

Is this correct ?

Comment 2 Robert Großkopf 2021-02-23 09:05:57 UTC

Don't use the table wizard.
Use "Create Table in Design View…"
Set first field "ID" → "Integer"
Set AutoValue → Yes.

Could be this is, as many other bugs, a special gtk3-bug.
I don't use gtk3 any more so I can't reproduce the behavior here with VCL: kf5

My system at this moment: OpenSUSE 15.2 64bit rpm Linux, KDE, no gtk3 installed.

Comment 3 QA Administrators 2021-02-24 04:06:33 UTC Comment hidden (obsolete)

[Automated Action] NeedInfo-To-Unconfirmed

Comment 4 Robert Großkopf 2021-07-12 09:59:04 UTC

(In reply to Robert Großkopf from comment #2)
> Don't use the table wizard.
> Use "Create Table in Design View…"
> Set first field "ID" → "Integer"
> Set AutoValue → Yes.
> 
> Could be this is, as many other bugs, a special gtk3-bug.
> I don't use gtk3 any more so I can't reproduce the behavior here with VCL:
> kf5
> 
> My system at this moment: OpenSUSE 15.2 64bit rpm Linux, KDE, no gtk3
> installed.

Will set this one to WORKSFORME. Couldn't reproduce it with LO 7.1.5.1 with VCL:kf5 on OpenSUSE 15.2 64bit rpm Linux.