Test failures with MySQL 9.6

[dveeden]

Container:

podman run -d --rm \
-e MYSQL_ALLOW_EMPTY_PASSWORD=1 \
-e MYSQL_ROOT_HOST='%' \
--name mysql \
-p 3306:3306 \
-it \
container-registry.oracle.com/mysql/community-server:9.6

OS: Fedora Linux 43 with Perl 5.42.0

This is with the 1.24 tag. With both the client library and the server on 9.6.0

Test Summary Report
-------------------
t/40server_prepare_crash.t            (Wstat: 2816 (exited 11) Tests: 37 Failed: 0)
  Non-zero exit status: 11
  Parse errors: Bad plan.  You planned 43 tests but ran 37.
t/44limit_placeholder.t               (Wstat: 2816 (exited 11) Tests: 13 Failed: 0)
  Non-zero exit status: 11
  Parse errors: Bad plan.  You planned 32 tests but ran 13.
t/90utf8_params.t                     (Wstat: 2816 (exited 11) Tests: 36 Failed: 0)
  Non-zero exit status: 11
  Parse errors: No plan found in TAP output
t/92ssl_backronym_vulnerability.t     (Wstat: 512 (exited 2) Tests: 4 Failed: 2)
  Failed tests:  1-2
  Non-zero exit status: 2
t/92ssl_optional.t                    (Wstat: 256 (exited 1) Tests: 2 Failed: 1)
  Failed test:  2
  Non-zero exit status: 1
t/92ssl_riddle_vulnerability.t        (Wstat: 256 (exited 1) Tests: 4 Failed: 1)
  Failed test:  2
  Non-zero exit status: 1

t/90utf8_params.t ....................... 1/? DBD::MariaDB::db do failed: Incorrect arguments to COM_STMT_EXECUTE at t/90utf8_params.t line 61.
# Tests were run but no plan was declared and done_testing() was not seen.
# Looks like your test exited with 11 just after 36.
t/90utf8_params.t ....................... Dubious, test returned 11 (wstat 2816, 0xb00)

t/92ssl_backronym_vulnerability.t ....... 1/4 
#   Failed test 'DBD::MariaDB refused connection to non-SSL server with mariadb_ssl=1 and correct user and password'
#   at t/92ssl_backronym_vulnerability.t line 19.

#   Failed test 'DBD::MariaDB error message is SSL related'
#   at t/92ssl_backronym_vulnerability.t line 20.
#          got: undef
#     expected: '2026'
# Error message: unknown
# Looks like you failed 2 tests of 4.
t/92ssl_backronym_vulnerability.t ....... Dubious, test returned 2 (wstat 512, 0x200)

t/92ssl_optional.t ...................... 1/2 
#   Failed test 'DBD::MariaDB supports mariadb_ssl_optional=1 and connect via plain text protocol when SSL is not supported by server even with mariadb_ssl_ca_file'
#   at t/92ssl_optional.t line 22.
# Error code: 2026
# Error message: SSL connection error: SSL_CTX_set_default_verify_paths failed
# Looks like you failed 1 test of 2.
t/92ssl_optional.t ...................... Dubious, test returned 1 (wstat 256, 0x100)

t/92ssl_riddle_vulnerability.t .......... 1/4 
#   Failed test 'DBD::MariaDB error message is SSL related'
#   at t/92ssl_riddle_vulnerability.t line 22.
#          got: '1045'
#     expected: '2026'
# Error message: Access denied for user '4yZ73s9qeECdWi'@'192.168.1.219' (using password: YES)
# Looks like you failed 1 test of 4.
t/92ssl_riddle_vulnerability.t .......... Dubious, test returned 1 (wstat 256, 0x100)

t/40server_prepare_crash.t .............. 1/43 DBD::MariaDB::db do failed: Incorrect arguments to COM_STMT_EXECUTE at t/40server_prepare_crash.t line 76.
Issuing rollback() due to DESTROY without explicit disconnect() of DBD::MariaDB::db handle test:127.0.0.1;mariadb_connect_timeout=120;mariadb_read_timeout=120;mariadb_write_timeout=120 at t/40server_prepare_crash.t line 76.
# Looks like your test exited with 11 just after 37.
t/40server_prepare_crash.t .............. Dubious, test returned 11 (wstat 2816, 0xb00)

t/44limit_placeholder.t ................. 1/32 DBD::MariaDB::db do failed: Incorrect arguments to COM_STMT_EXECUTE at t/44limit_placeholder.t line 32.
Issuing rollback() due to DESTROY without explicit disconnect() of DBD::MariaDB::db handle test:127.0.0.1;mariadb_connect_timeout=120;mariadb_read_timeout=120;mariadb_write_timeout=120 at t/44limit_placeholder.t line 32.
# Looks like your test exited with 11 just after 13.
t/44limit_placeholder.t ................. Dubious, test returned 11 (wstat 2816, 0xb00)

t/90utf8_params.t ....................... 1/? DBD::MariaDB::db do failed: Incorrect arguments to COM_STMT_EXECUTE at t/90utf8_params.t line 61.
# Tests were run but no plan was declared and done_testing() was not seen.
# Looks like your test exited with 11 just after 36.
t/90utf8_params.t ....................... Dubious, test returned 11 (wstat 2816, 0xb00)

[choroba]

Aren't the connection errors related to #227?

[dveeden]

Aren't the connection errors related to #227?

I think that happens only when building against MariaDB Connector/C and I'm building against MySQL 9.6.0 instead.

And the container I use does support TLS:

$ mysql -h 127.0.0.1 --ssl-mode=REQUIRED -u root
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 10
Server version: 9.6.0 MySQL Community Server - GPL

Copyright (c) 2000, 2026, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql-9.6.0 [(none)]> SHOW STATUS LIKE 'Ssl_cipher';
+---------------+------------------------+
| Variable_name | Value                  |
+---------------+------------------------+
| Ssl_cipher    | TLS_AES_128_GCM_SHA256 |
+---------------+------------------------+
1 row in set (0.017 sec)