Hello, I am using mysql server 8.0.28 64bit, libroffice base 7.2.5.2 64bit and win 10 64bit. Auto increment is not enabled in the table after creating a table in base with direct connection to mysql. From mysql workbench I am able to apply the change to auto increment. Does anyone know why this happens? So far it seems to be consistent. On my laptop I am using libreoffice but a very slightly newer version and the same thing happens but not with every table. I was using the odbc connection previously because it only shows one schema and I thought it might resolve this by using the direct connection instead. At this point I am willing to move over to the jdbc connection and give it a try. Thanks in advance.
Create the AutoIncrement in MySQL workbench or something else. It will work in direct connection.
Write a bug description for this behavior. Isn’t the only connection with problems to create a AutoValue.
Have written the bug-description: bug 147792. Bug appears new in LO 7.2, works well in LO 7.1.5.2 here.