Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.3(EOL), 10.4(EOL), 10.5
-
None
Description
Point in time recovery of binary log fails when sql_mode=ORACLE
--source include/have_log_bin.inc
|
--source include/have_innodb.inc
|
|
|
let $MYSQLD_DATADIR= `select @@datadir`;
|
SET @@SQL_MODE = 'ORACLE';
|
CREATE TABLE t(f INT) ENGINE=INNODB;
|
INSERT INTO t VALUES (10);
|
DROP TABLE t;
|
FLUSH LOGS;
|
--exec $MYSQL_BINLOG $MYSQLD_DATADIR/master-bin.000001 > $MYSQLTEST_VARDIR/tmp/test.sql
|
|
|
--exec $MYSQL < $MYSQLTEST_VARDIR/tmp/test.sql
|
Output:
======
MariaDB Version 10.3.24-MariaDB-debug
|
- SSL connections supported
|
- binaries are debug compiled
|
- binaries built with wsrep patch
|
Collecting tests...
|
Installing system database...
|
|
|
==============================================================================
|
|
|
TEST RESULT TIME (ms) or COMMENT
|
--------------------------------------------------------------------------
|
|
|
worker[1] Using MTR_BUILD_THREAD 301, with reserved ports 16020..16039
|
SET @@SQL_MODE = 'ORACLE';
|
CREATE TABLE t(f INT) ENGINE=INNODB;
|
INSERT INTO t VALUES (10);
|
DROP TABLE t;
|
FLUSH LOGS;
|
binlog.binlog_ptr_fails_oracle_mode1 'innodb,mix' [ fail ]
|
Test ended at 2020-07-07 13:43:57
|
|
|
CURRENT_TEST: binlog.binlog_ptr_fails_oracle_mode1
|
ERROR 1064 (42000) at line 42: 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 '' at line 1
|
Syntax error is reported for "BEGIN" statement.
27 use `test`/*!*/;
|
28 SET TIMESTAMP=1594109637/*!*/;
|
29 SET @@session.pseudo_thread_id=10/*!*/;
|
30 SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1, @@session.check_constraint_checks=1/*!*/;
|
31 SET @@session.sql_mode=8858427918/*!*/;
|
32 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
|
33 /*!\C latin1 *//*!*/;
|
34 SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/;
|
35 SET @@session.lc_time_names=0/*!*/;
|
36 SET @@session.collation_database=DEFAULT/*!*/;
|
37 CREATE TABLE t(f INT) ENGINE=INNODB
|
38 /*!*/;
|
39 # at 473
|
40 #200707 13:43:57 server id 1 end_log_pos 515 CRC32 0xa823c787 GTID 0-1-2 trans
|
41 /*!100001 SET @@session.gtid_seq_no=2*//*!*/;
|
42 BEGIN
|