[MDEV-26008] spider/bugfix.delete_with_float_column_mysql fails in bb, error in your SQL syntax Created: 2021-06-24  Updated: 2021-06-24

Status: Open
Project: MariaDB Server
Component/s: Tests
Affects Version/s: 10.4
Fix Version/s: 10.4

Type: Bug Priority: Major
Reporter: Alice Sherepa Assignee: Sergei Golubchik
Resolution: Unresolved Votes: 0
Labels: None


 Description   

http://buildbot.askmonty.org/buildbot/builders/kvm-fulltest/builds/30857/steps/mtr_ps/logs/stdio

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

probably after this merge - https://github.com/MariaDB/server/commit/d3e4fae797b9467828c33c89b55a991067e8bcde


Generated at Thu Feb 08 09:42:03 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.