summaryrefslogtreecommitdiff
path: root/mysql-test/r/binlog_unsafe.result
blob: 624c7feec1f95d1052efbde38d6b7e869c284f1b (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
SET BINLOG_FORMAT=STATEMENT;
CREATE TABLE t1 (a CHAR(40));
CREATE TABLE t2 (a INT AUTO_INCREMENT PRIMARY KEY);
CREATE TABLE t3 (b INT AUTO_INCREMENT PRIMARY KEY);
CREATE VIEW v1(a,b) AS SELECT a,b FROM t2,t3;
INSERT INTO t1 SELECT UUID();
Warnings:
Warning	1589	Statement is not safe to log in statement format.
SHOW WARNINGS;
Level	Warning
Code	1589
Message	Statement is not safe to log in statement format.
DROP TABLE t1,t2,t3;