Debian Codegraph @

mysql-test/suite/rpl/r/rpl_sql_require_primary_key.result

raw
1 include/master-slave.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection master]
6 CREATE TABLE t1 (c1 INT, c2 TEXT);
7 include/sync_slave_sql_with_master.inc
8 SHOW CREATE TABLE t1;
9 Table Create Table
10 t1 CREATE TABLE `t1` (
11 `c1` int DEFAULT NULL,
12 `c2` text
13 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
14 CREATE TABLE t2 (c1 INT, c2 TEXT);
15 ERROR HY000: Unable to create or change a table without a primary key, when the system variable 'sql_require_primary_key' is set. Add a primary key to the table or unset this variable to avoid this message. Note that tables without a primary key can cause performance problems in row-based replication, so please consult your DBA before changing this setting.
16 [connection master]
17 DROP TABLE t1;
18 include/rpl_end.inc