Bug 147792 - MySQL/MariaDB direct connection: Autoincrement won't be saved by table editor
Summary: MySQL/MariaDB direct connection: Autoincrement won't be saved by table editor
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
7.2.0.4 release
Hardware: x86-64 (AMD64) All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: regression
Depends on:
Blocks:
 
Reported: 2022-03-06 07:19 UTC by Robert Großkopf
Modified: 2023-03-19 00:08 UTC (History)
4 users (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 2022-03-06 07:19:40 UTC 
Open any direct connection to MySQL.
Create a table and set an INTEGER field as AutoValue.
Save this table.

AutoValue won't be saved since
Version: 7.2.0.4 / LibreOffice Community
Build ID: 9a9c6381e3f7a62afc1329bd359cc48accb6435b
CPU threads: 6; OS: Linux 5.3; UI render: default; VCL: kf5 (cairo+xcb)
Locale: de-DE (de_DE.UTF-8); UI: de-DE
Calc: threaded

Works right with LO 7.1.5.2 on OpenSUSE 15.3 64bit rpm Linux.
Comment 1 Julien Nabet 2022-03-06 09:37:19 UTC 
Just for the record, on pc Debian x86-64 with master sources updated today, I don't reproduce this.

I created a table with:
id INTEGER primary key autovalue yes
test Text[VARCHAR]

Would it be possible you give a try on a daily master build?
Indeed, I made quite some changes in Mysql/Mariadb (see https://cgit.freedesktop.org/libreoffice/core/log/?qt=grep&q=maria)
Comment 2 Robert Großkopf 2022-03-06 14:17:57 UTC 
(In reply to Julien Nabet from comment #1)
> Just for the record, on pc Debian x86-64 with master sources updated today,
> I don't reproduce this.

You are right:
Version: 7.4.0.0.alpha0+ / LibreOffice Community
Build ID: 7ac19fbce8a35f559eebb879cd0f232bfc95e703
CPU threads: 6; OS: Linux 5.3; UI render: default; VCL: kf5 (cairo+xcb)
Locale: de-DE (de_DE.UTF-8); UI: en-US
Calc: threaded

This version will have AutoValue set after I have saved the table. So it's a problem in LO 7.2 and 7.3 at this moment.

See this post:
https://ask.libreoffice.org/t/auto-increment-is-not-enabled-in-table-after-creating-a-table-in-base-with-direct-connection-to-mysql/74870
Comment 3 Alex Thurgood 2022-03-28 09:38:33 UTC 
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

regression
Comment 4 Alex Thurgood 2022-03-28 09:42:36 UTC 
Also confirmed with 

Version: 7.3.1.3 / LibreOffice Community
Build ID: a69ca51ded25f3eefd52d7bf9a5fad8c90b87951
CPU threads: 8; OS: Mac OS X 12.2.1; UI render: default; VCL: osx
Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR
Calc: threaded
Comment 5 Jean-Paul 2022-09-08 08:53:18 UTC 
The problem does not occur with : 
Version: 7.4.0.3 (x64) / LibreOffice Community
Build ID: f85e47c08ddd19c015c0114a68350214f7066f5a
CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win
Locale: nl-BE (en_BE); UI: en-US
Calc: threaded
Comment 6 Robert Großkopf 2022-12-13 16:36:36 UTC 
Had a look at this bug again.
Bug still exists in LO 7.3.6.2, but won't appear in LO 7.4.3.2 on OpenSUSE 15.3 64bit rpm Linux.

I will close this one as WORKSFORME.