Lazarus 4 + ZEOSLib 8 + MariaDB 11.8.2 = Only connect in ReadOnly mode

[marsupilami79]

We have a test that newly fails with Mariadb 11.8.2 on Linux: bugreport.TZTestCompMySQLBugReport.Test981208
In that test a column is marked readonly because MariaDB doesn't give us a table name or a column name.

This test is special: It does a "select * from" from a table in another schema. Since most other tests work as expected, I can only assume, that MariaDB 11.8.2 or the Connector/C that gets delivered with MariaDB 11.8.2 has some changed behavior for that case.

[marsupilami79]

Ok, I found it. The problem was that Zeos wasn't able to detect that extended field information is supported. Zeos detected this by inspecting the client version number. The problem here is that the people at MariaDB decided at some point in the past that is is ok to restart verion numbering in libmariadb. Example: For Testing MariaDB 10 we use MariaDB Connector C version 3.1.7. mysql_get_client_version returns 10.4.3 there. The libmariadb that installs with MariaDB 11.8.2 returns version version 3.4.6 when calling mysql_get_client_version. To test for the availability of extended column inf, Zeos testes the versdion to be 4.0.0 or above - which failed for libmariadb in MariaDB 11.8.2.

Long story short: I fixted the problem in the 8.0-patches branch of Zeos. Please test and let me know if there still are problems.

Best regards,

Jan

[atieborin]

Ok, I found it. The problem was that Zeos wasn't able to detect that extended field information is supported. Zeos detected this by inspecting the client version number. The problem here is that the people at MariaDB decided at some point in the past that is is ok to restart verion numbering in libmariadb. Example: For Testing MariaDB 10 we use MariaDB Connector C version 3.1.7. mysql_get_client_version returns 10.4.3 there. The libmariadb that installs with MariaDB 11.8.2 returns version version 3.4.6 when calling mysql_get_client_version. To test for the availability of extended column inf, Zeos testes the versdion to be 4.0.0 or above - which failed for libmariadb in MariaDB 11.8.2.

Long story short: I fixted the problem in the 8.0-patches branch of Zeos. Please test and let me know if there still are problems.

Best regards,

Jan

Good evening, friends, thank you for your commitment to helping me with this issue. I will run further tests with the version modified by our colleague. However, I followed the advice of the friend who responded to my first post and ran some tests with ZQuery, and I was able to make the changes to the database records normally. Currently, I'm using ZTable to display the data and ZQuery to modify it, which I consider a waste of time and application performance.

I hope my colleague's solution works. Greetings to all.

[paweld]

Long story short: I fixted the problem in the 8.0-patches branch of Zeos. Please test and let me know if there still are problems.

@Jan: Thank you very much.