Tests FAIL when sql_mode=ANSI

[Tux]

When /etc/my.cnf is set to ANSI mode:

[mysqld]
sql_mode=ANSI

(IMHO the only sensible way to use a MariaDB or MySQL database), the test fail on DBD::MariaDB

.cpan/build/DBD-MariaDB-1.24-0 509 🐧 mariadb --version
mariadb from 11.8.2-MariaDB, client 15.2 for Linux (x86_64) using  EditLine wrapper

🐧 rpm -qa | grep -i mariadb | sort
libmariadb3-3.4.5-2.1.x86_64
libmariadbd19-11.8.2-1.1.x86_64
libmariadbd-devel-11.8.2-1.1.x86_64
libmariadb-devel-3.4.5-2.1.x86_64
mariadb-11.8.2-1.1.x86_64
mariadb-bench-11.8.2-1.1.x86_64
mariadb-client-11.8.2-1.1.x86_64
mariadb-connector-odbc-3.2.5-1.1.x86_64
mariadb-errormessages-11.8.2-1.1.noarch
mariadb-tools-11.8.2-1.1.x86_64

Test Summary Report
-------------------
t/35limit.t                           (Wstat: 65280 (exited 255) Tests: 119 Failed: 0)
  Non-zero exit status: 255
  Parse errors: Bad plan.  You planned 124 tests but ran 119.
t/40server_prepare.t                  (Wstat: 65280 (exited 255) Tests: 26 Failed: 0)
  Non-zero exit status: 255
  Parse errors: Bad plan.  You planned 29 tests but ran 26.
t/77max_allowed_packet.t              (Wstat: 256 (exited 1) Tests: 4 Failed: 1)
  Failed test:  4
  Non-zero exit status: 1
Files=94, Tests=4132, 58 wallclock secs ( 0.38 usr  0.13 sys +  6.68 cusr  1.00 csys =  8.19 CPU)
Result: FAIL
Failed 3/94 test programs. 1/4132 subtests failed.

.cpan/build/DBD-MariaDB-1.24-0 🐧 prove -vwb t/35limit.t
t/35limit.t ..
1..124
ok 1 - Connected to database
ok 2 - making slate clean
ok 3 - creating table
ok 4
:
:
ok 119
DBD::MariaDB::db do failed: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '"9","0","1") )' at line 1 at t/35limit.t line 82.
Issuing rollback() due to DESTROY without explicit disconnect() of DBD::MariaDB::db handle test;mariadb_connect_timeout=120;mariadb_read_timeout=120;mariadb_write_timeout=120 at t/35limit.t line 82.
# Looks like your test exited with 255 just after 119.
Dubious, test returned 255 (wstat 65280, 0xff00)
Failed 5/124 subtests

Test Summary Report
-------------------
t/35limit.t (Wstat: 65280 (exited 255) Tests: 119 Failed: 0)
  Non-zero exit status: 255
  Parse errors: Bad plan.  You planned 124 tests but ran 119.
Files=1, Tests=119,  0 wallclock secs ( 0.02 usr  0.00 sys +  0.07 cusr  0.01 csys =  0.10 CPU)
Result: FAIL

t/40server_prepare.t ..
1..29
ok 1 - connecting
ok 2 - making slate clean
:
:
ok 25
ok 26 - Non-preparable statement 'PREPARE stmt FROM "SELECT 1"' is not supported with mariadb_server_prepare_disable_fallback=1
DBD::MariaDB::db prepare failed: Unknown column 'SELECT 1' in 'PREPARE..FROM' at t/40server_prepare.t line 88.
Issuing rollback() due to DESTROY without explicit disconnect() of DBD::MariaDB::db handle test;mariadb_connect_timeout=120;mariadb_read_timeout=120;mariadb_write_timeout=120;mariadb_server_prepare=1;mariadb_server_prepare_disable_fallback=1 at t/40server_prepare.t line 88.
# Looks like your test exited with 255 just after 26.
Dubious, test returned 255 (wstat 65280, 0xff00)
Failed 3/29 subtests

Test Summary Report
-------------------
t/40server_prepare.t (Wstat: 65280 (exited 255) Tests: 26 Failed: 0)
  Non-zero exit status: 255
  Parse errors: Bad plan.  You planned 29 tests but ran 26.
Files=1, Tests=26,  0 wallclock secs ( 0.01 usr  0.00 sys +  0.07 cusr  0.00 csys =  0.08 CPU)
Result: FAIL

.cpan/build/DBD-MariaDB-1.24-0 🐧 prove -vwb t/77max_allowed_packet.t
t/77max_allowed_packet.t ..
1..4
ok 1 - mariadb_max_allowed_packet is correct
ok 2 - Statement bigger then maximal packet size is not accepted
ok 3 - mariadb_max_allowed_packet is correct
not ok 4 - Statement smaller then maximal packet size is accepted

#   Failed test 'Statement smaller then maximal packet size is accepted'
#   at t/77max_allowed_packet.t line 25.
# Looks like you failed 1 test of 4.
Dubious, test returned 1 (wstat 256, 0x100)
Failed 1/4 subtests

Test Summary Report
-------------------
t/77max_allowed_packet.t (Wstat: 256 (exited 1) Tests: 4 Failed: 1)
  Failed test:  4
  Non-zero exit status: 1
Files=1, Tests=4,  1 wallclock secs ( 0.01 usr  0.01 sys +  0.06 cusr  0.01 csys =  0.09 CPU)
Result: FAIL