Debian Codegraph @

mysql-test/suite/binlog/r/binlog_set_require_primary_key_only_on_ddl.result

raw
1 FLUSH BINARY LOGS;
2 #
3 # TC1. Check `CREATE TABLE` has `Q_SQL_REQUIRE_PRIMARY_KEY` flag set
4 # ------------------------------------------------------------------
5 SET @@session.sql_require_primary_key=0;
6 CREATE TABLE tnopk (col1 INT, col2 INT);
7 include/assert_grep.inc ['CREATE TABLE' with no PK has 'Q_SQL_REQUIRE_PRIMARY_KEY' flag set and with value '0']
8 SET @@session.sql_require_primary_key=1;
9 CREATE TABLE tpk (col1 INT PRIMARY KEY, col2 INT);
10 include/assert_grep.inc ['CREATE TABLE' with PK has 'Q_SQL_REQUIRE_PRIMARY_KEY' flag set and with value '1']
11 #
12 # TC2. Check DML `INSERT`, `UPDATE` and `DELETE` do not have the flag set
13 # -----------------------------------------------------------------------
14 INSERT INTO tnopk VALUES (1, 0), (2, 0); INSERT INTO tpk VALUES (1, 0), (2, 0);
15 include/assert_grep.inc ['INSERT' statements do not have 'Q_SQL_REQUIRE_PRIMARY_KEY' flag set]
16 UPDATE tnopk SET col2 = 1 WHERE col1 = 1; UPDATE tpk SET col2 = 1 WHERE col1 = 1;
17 include/assert_grep.inc ['UPDATE' statements do not have 'Q_SQL_REQUIRE_PRIMARY_KEY' flag set]
18 DELETE FROM tnopk where col1 = 2; DELETE FROM tpk where col1 = 2;
19 include/assert_grep.inc ['DELETE' statements do not have 'Q_SQL_REQUIRE_PRIMARY_KEY' flag set]
20 #
21 # TC3. Check `ALTER TABLE` has `Q_SQL_REQUIRE_PRIMARY_KEY` flag set
22 # ------------------------------------------------------------------
23 SET @@session.sql_require_primary_key=0;
24 ALTER TABLE tnopk ADD COLUMN (col3 INT);
25 include/assert_grep.inc ['ALTER TABLE' in table with no PK has 'Q_SQL_REQUIRE_PRIMARY_KEY' flag set and with value '0']
26 SET @@session.sql_require_primary_key=1;
27 ALTER TABLE tpk ADD COLUMN (col3 INT);
28 include/assert_grep.inc ['ALTER TABLE' in table with PK has 'Q_SQL_REQUIRE_PRIMARY_KEY' flag set and with value '1']
29 #
30 # TC4. Check `DROP TABLE` do not has `Q_SQL_REQUIRE_PRIMARY_KEY` flag set
31 # -----------------------------------------------------------------------
32 SET @@session.sql_require_primary_key=0;
33 DROP TABLE tnopk;
34 include/assert_grep.inc ['DROP TABLE' statements, of table with no PK, do not have 'Q_SQL_REQUIRE_PRIMARY_KEY' flag set]
35 SET @@session.sql_require_primary_key=1;
36 DROP TABLE tpk;
37 include/assert_grep.inc ['DROP TABLE' statements, of table with PK, do not have 'Q_SQL_REQUIRE_PRIMARY_KEY' flag set]