spider/bugfix.delete_with_float_column_mysql fails in bb, error in your SQL syntax

spider/bugfix.delete_with_float_column_mysql w2 [ fail ]

        Test ended at 2021-06-21 09:13:19

CURRENT_TEST: spider/bugfix.delete_with_float_column_mysql

mysqltest: In included file "/mnt/buildbot/build/mariadb-10.4.20/storage/spider/mysql-test/spider/bugfix/t/delete_with_float_column.inc": 

included from /mnt/buildbot/build/mariadb-10.4.20/storage/spider/mysql-test/spider/bugfix/t/delete_with_float_column_mysql.test at line 3:

At line 25: query '$CHILD2_1_CREATE_TABLES' failed: 1064: 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 'CREATE FUNCTION to_float(a decimal(20,6)) RETURNS float RETURN cast(a as double)' at line 6

The result from queries just before the failure was:

< snip >

connection master_1;

set @old_binlog_format= @@binlog_format;

set session binlog_format= 'ROW';

drop and create databases

connection master_1;

CREATE DATABASE auto_test_local;

USE auto_test_local;

connection slave1_1;

CREATE DATABASE auto_test_local;

USE auto_test_local;

connection child2_1;

SET @old_log_output = @@global.log_output;

SET GLOBAL log_output = 'TABLE,FILE';

CREATE DATABASE auto_test_remote;

USE auto_test_remote;

create table and insert

connection child2_1;

CHILD2_1_CREATE_TABLES

More results from queries before failure can be found in /mnt/buildbot/build/mariadb-10.4.20/mysql-test/var/2/log/delete_with_float_column_mysql.log