40 lines
2.6 KiB
Plaintext
40 lines
2.6 KiB
Plaintext
include/master-slave.inc
|
|
Warnings:
|
|
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
|
|
Note #### Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
|
|
[connection master]
|
|
call mtr.add_suppression('Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT.');
|
|
create table tm (b int auto_increment, a int, primary key (a,b)) engine= myisam;
|
|
set @@binlog_format=statement;
|
|
*** autoincrement field is not the first in PK warning must be there: ***
|
|
insert into tm set b=null, a=1;
|
|
Warnings:
|
|
Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. INSERT into autoincrement field which is not the first part in the composed primary key is unsafe.
|
|
show warnings;
|
|
Level Code Message
|
|
Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. INSERT into autoincrement field which is not the first part in the composed primary key is unsafe.
|
|
create function multi_part_pk_with_autoinc (arg int)
|
|
returns int
|
|
begin
|
|
insert into tm set b=null, a=arg;
|
|
return arg;
|
|
end//
|
|
select multi_part_pk_with_autoinc (3);
|
|
multi_part_pk_with_autoinc (3)
|
|
3
|
|
Warnings:
|
|
Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it invokes a trigger or a stored function that inserts into an AUTO_INCREMENT column. Inserted values cannot be logged correctly.
|
|
Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. INSERT into autoincrement field which is not the first part in the composed primary key is unsafe.
|
|
*** autoincrement field is not the first in PK warning must be there: ***
|
|
show warnings;
|
|
Level Code Message
|
|
Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it invokes a trigger or a stored function that inserts into an AUTO_INCREMENT column. Inserted values cannot be logged correctly.
|
|
Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. INSERT into autoincrement field which is not the first part in the composed primary key is unsafe.
|
|
set @@binlog_format=mixed;
|
|
insert into tm set b=null, a=2;
|
|
include/sync_slave_sql_with_master.inc
|
|
drop table tm;
|
|
drop function multi_part_pk_with_autoinc;
|
|
include/sync_slave_sql_with_master.inc
|
|
include/rpl_end.inc
|