mirror of
https://github.com/MariaDB/server.git
synced 2025-02-12 00:15:35 +01:00
4547c6f283
Mark the JSON_TABLE function as SBR-unsafe. It is not unsafe for the current implementation. But we still mark it as such in order to be future-proof and keep it possible to change JSON data representation in the future.
25 lines
834 B
Text
25 lines
834 B
Text
--source include/have_binlog_format_mixed.inc
|
|
|
|
--echo #
|
|
--echo # MDEV-25154: JSON_TABLE: Queries involving ordinality columns are unsafe for statement binlog and should be marked as such
|
|
--echo #
|
|
|
|
create table t1 (a int);
|
|
|
|
call mtr.add_suppression("Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT");
|
|
set binlog_format='statement';
|
|
insert into t1
|
|
select *
|
|
from json_table('[1,2,3]', '$[*]' columns (a for ordinality)) as T ;
|
|
|
|
set binlog_format='mixed';
|
|
let $binlog_start= query_get_value(SHOW MASTER STATUS, Position, 1);
|
|
let $binlog_file= LAST;
|
|
|
|
insert into t1
|
|
select *
|
|
from json_table('[1,2,3]', '$[*]' columns (a for ordinality)) as T ;
|
|
|
|
--echo # This must show Annotate_rows, Write_rows_v1 events. Not the statement event
|
|
--source include/show_binlog_events.inc
|
|
drop table t1;
|