DBD::mysql doesn't build with MySQL 9.0.0

[dveeden]

DBD::mysql version

5.007

MySQL client version

9.0.0

Server version

9.0.0

Operating system version

No response

What happened?

https://dev.mysql.com/doc/relnotes/mysql/9.0/en/news-9-0-0.html

Other information

No response

[dveeden]

This fails with a 9.0.0 server and 9.0.0 client libraries. The same test works fine with a 8.4 server.

t/51bind_type_guessing.t ................ 1/98 DBD::mysql::st execute failed: Incorrect DOUBLE value: '5e' for column 'dd' at row 1 at t/51bind_type_guessing.t line 136.
t/51bind_type_guessing.t ................ 43/98 
#   Failed test 'update double val 5e id 7'
#   at t/51bind_type_guessing.t line 138.
#                   'DBD::mysql::st execute failed: Incorrect DOUBLE value: '5e' for column 'dd' at row 1 at t/51bind_type_guessing.t line 136.
# '
#     doesn't match '(?^:Data truncated for column)'
DBD::mysql::st execute failed: Data truncated for column 'nn' at row 1 at t/51bind_type_guessing.t line 114.
DBD::mysql::st execute failed: Incorrect DOUBLE value: '1+' for column 'dd' at row 1 at t/51bind_type_guessing.t line 136.

#   Failed test 'update double val 1+ id 8'
#   at t/51bind_type_guessing.t line 138.
#                   'DBD::mysql::st execute failed: Incorrect DOUBLE value: '1+' for column 'dd' at row 1 at t/51bind_type_guessing.t line 136.
# '
#     doesn't match '(?^:Data truncated for column)'
DBD::mysql::st execute failed: Incorrect integer value: '+' for column 'nn' at row 1 at t/51bind_type_guessing.t line 114.
DBD::mysql::st execute failed: Incorrect DOUBLE value: '+' for column 'dd' at row 1 at t/51bind_type_guessing.t line 136.

#   Failed test 'update double val + id 9'
#   at t/51bind_type_guessing.t line 138.
#                   'DBD::mysql::st execute failed: Incorrect DOUBLE value: '+' for column 'dd' at row 1 at t/51bind_type_guessing.t line 136.
# '
#     doesn't match '(?^:Data truncated for column)'
DBD::mysql::st execute failed: Incorrect integer value: '.' for column 'nn' at row 1 at t/51bind_type_guessing.t line 114.
DBD::mysql::st execute failed: Incorrect DOUBLE value: '.' for column 'dd' at row 1 at t/51bind_type_guessing.t line 136.

#   Failed test 'update double val . id 10'
#   at t/51bind_type_guessing.t line 138.
#                   'DBD::mysql::st execute failed: Incorrect DOUBLE value: '.' for column 'dd' at row 1 at t/51bind_type_guessing.t line 136.
# '
#     doesn't match '(?^:Data truncated for column)'
DBD::mysql::st execute failed: Incorrect integer value: 'e5' for column 'nn' at row 1 at t/51bind_type_guessing.t line 114.
DBD::mysql::st execute failed: Incorrect DOUBLE value: 'e5' for column 'dd' at row 1 at t/51bind_type_guessing.t line 136.

#   Failed test 'update double val e5 id 11'
#   at t/51bind_type_guessing.t line 138.
#                   'DBD::mysql::st execute failed: Incorrect DOUBLE value: 'e5' for column 'dd' at row 1 at t/51bind_type_guessing.t line 136.
# '
#     doesn't match '(?^:Data truncated for column)'
# Looks like you failed 5 tests of 98.
t/51bind_type_guessing.t ................ Dubious, test returned 5 (wstat 1280, 0x500)
Failed 5/98 subtests 

[dveeden]

mysql-9.0.0> create table t1(id int primary key, dd double);
Query OK, 0 rows affected (0.03 sec)

mysql-9.0.0> insert into t1 values(1,'5e');
ERROR 1366 (HY000): Incorrect DOUBLE value: '5e' for column 'dd' at row 1

mysql-8.4.0> create table t1(id int primary key, dd double);
Query OK, 0 rows affected (0.02 sec)

mysql-8.4.0> insert into t1 values(1,'5e');
ERROR 1265 (01000): Data truncated for column 'dd' at row 1