polardbxengine/mysql-test/r/binlog_partial_json_warning...

27 lines
2.2 KiB
Plaintext

call mtr.add_suppression("When binlog_format=STATEMENT, the option binlog_row_value_options=PARTIAL_JSON");
call mtr.add_suppression("When binlog_row_image=FULL, the option binlog_row_value_options=PARTIAL_JSON");
call mtr.add_suppression("When binlog_row_value_options=PARTIAL_JSON, the option log_bin_use_v1_row_events=1");
call mtr.add_suppression("When the binary log is disabled, the option binlog_row_value_options=PARTIAL_JSON");
call mtr.add_suppression("You need to use --log-bin to make --binlog-format work.");
# binlog-format=stmt is not compatible with partial json
# restart: --log-bin --binlog-format=statement --binlog-row-value-options=PARTIAL_JSON --binlog-row-image=MINIMAL
include/assert_grep.inc [There shall be a warning when binlog_format=STATEMENT]
SET @@GLOBAL.BINLOG_ROW_VALUE_OPTIONS= PARTIAL_JSON;
Warnings:
Warning 3645 When binlog_format=STATEMENT, the option binlog_row_value_options=PARTIAL_JSON will be ignored and updates will be written in full format to binary log.
# binlog-row-image=full causes partial json to be used only in after image
# restart: --log-bin --binlog-format=row --binlog-row-value-options=PARTIAL_JSON --binlog-row-image=FULL
include/assert_grep.inc [There shall be a warning when binlog_row_image=FULL]
# log-bin-use-v1-row-events is not compatible with partial json
# restart: --log-bin --log-bin-use-v1-row-events=TRUE --binlog-row-value-options=PARTIAL_JSON --binlog-row-image=MINIMAL
include/assert_grep.inc [There shall be a warning when log_bin_use_v1_row_events=1]
SET @@GLOBAL.BINLOG_ROW_VALUE_OPTIONS= PARTIAL_JSON;
Warnings:
Warning 3646 When binlog_row_value_options=PARTIAL_JSON, the option log_bin_use_v1_row_events=1 will be ignored and row events will be written in new format to binary log.
# the binlog is disabled
# restart: --binlog-row-value-options=PARTIAL_JSON --binlog-row-image=MINIMAL --skip-log-bin --skip-log-slave-updates
include/assert_grep.inc [There shall be a warning when when the binary log is disabled]
SET @@GLOBAL.BINLOG_ROW_VALUE_OPTIONS= PARTIAL_JSON;
Warnings:
Warning 3645 When the binary log is closed, the option binlog_row_value_options=PARTIAL_JSON will be ignored and updates will be written in full format to binary log.