[Libreoffice-bugs] [Bug 143413] LO 7.2.0.1 'AutoField' won't be saved (gtk3)

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #4 from Julien Nabet <serval2412 at yahoo.fr> ---
On pc Debian x86-64 with master sources updated today + gtk3 rendering, here's
what I got:
Create a table in design view => OK
First field "ID", Field Type INTEGER  => OK
Second field "Name", Filed Type could be Text (default)  => OK
Go to first field an set Field Properties → AutoValue → 'Yes'  => OK

Field "ID" will show primary key => KO
There's no the key image indicating it's a primary key)

Save table
=> it proposes to create a primary key
1) if Yes: Error
SQL Status: S0011
Error code: -24

Attempt to define a second primary key in statement [CREATE TABLE "Table3"
("ID1" INTEGER NOT NULL,"ID" INTEGER IDENTITY,"Name" VARCHAR(100), PRIMARY KEY 
("ID1")]
/home/julien/lo/libreoffice/connectivity/source/drivers/jdbc/Object.cxx:174

2) if No
Table is saved
AutoValue is still at Yes with no primary key

I'll continue with option 2)
Close table => OK
Open table for edition => first field has still the autovalue at Yes but this
time it has also primary key indicated

BTW, I'm not sure it's expected LO to set automatically "primary key" when
setting autovalue at yes

What a mess...

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210719/d2e27b76/attachment.htm>