<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - LO 7.2.0.1 'AutoField' won't be saved (gtk3)" href="https://bugs.documentfoundation.org/show_bug.cgi?id=143413#c4">Comment # 4</a> on <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - LO 7.2.0.1 'AutoField' won't be saved (gtk3)" href="https://bugs.documentfoundation.org/show_bug.cgi?id=143413">bug 143413</a> from <a class="email" href="mailto:serval2412@yahoo.fr" title="Julien Nabet <serval2412@yahoo.fr>"> Julien Nabet</a> <pre>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...</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>