pali

Unfortunately simple workaround does not work, needs lot of more changes, explanation is in the pull request #196. This issue should be really fixed in the MariaDB client library (C...

Here is an update: https://github.com/perl5-dbi/DBD-MariaDB/pull/190 This pull request implements a new connection parameter `mariadb_auth_plugin` which forces client to use specified authentication method when connecting to mysql server. New mysql 8.x...

Above mentioned pull request add an option `mariadb_auth_plugin` for setting password authentication method (plugin) and it does it via `mysql_options(sock, MYSQL_DEFAULT_AUTH, auth_plugin)` call. But unfortunately MySQL 8.x client library is...

As here is modified patch for the MySQL 8.0.26+: ```diff --- mysql8/sql-common/client.cc 2023-07-23 15:52:40.715822119 +0200 +++ mysql8/sql-common/client.cc 2023-07-23 15:54:02.628415270 +0200 @@ -5759,8 +5759,13 @@ static mysql_state_machine_status authsm if (ctx->auth_plugin_name ==...

This mysql bug is already tracked in mysql issue tracker: https://bugs.mysql.com/bug.php?id=90994

After discussion with MySQL developers, this MySQL 8 client library issue should be fixed in the upcoming October MySQL 8.0.35 release (I guess in the next week). With that fixed...

Could you please show exact code which triggered this error?

Well, that test t/rt122541-decimals.t checks that bugs https://rt.cpan.org/Ticket/Display.html?id=122541 https://github.com/perl5-dbi/DBD-mysql/issues/170 were fixed and ZEROFILL_FLAG (appending trailing zeros) works in DBD::MariaDB correctly. Therefore removal of trailing zeros from expected result is wrong...

@xnox Could you please run this command against your MySQL server? ``` mysql --column-type-info -e 'SELECT round(degrees(0.00043) * 69, 2);' ``` Argument `--column-type-info` is important as it prints type information...

@maxbarry: Maybe you could help here too to provide output from above command?