Bug 138463 - EDITING table: Auto value doesn't set the field automatically as primary key
Summary: EDITING table: Auto value doesn't set the field automatically as primary key
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
7.0.3.1 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: regression
Depends on:
Blocks:
 
Reported: 2020-11-24 14:45 UTC by Robert Großkopf
Modified: 2021-07-12 09:59 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
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)
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.