Debian Codegraph @

mysql-test/suite/sys_vars/r/require_row_format_restrictions.result

raw
1 #
2 # Step 0. Create some tables for testing
3 CREATE TABLE t1 (c1 INT) Engine=InnoDB;
4 INSERT INTO t1 VALUES (1);
5 CREATE TABLE t2 (c1 INT) Engine=InnoDB;
6 INSERT INTO t2 VALUES (10);
7 CREATE TABLE t3 (text VARCHAR(20));
8 CREATE TEMPORARY TABLE temp1 (c1 INT);
9 #
10 # 1. Set require_row_format to 1 and check all restrictions are enforced.
11 SET SESSION require_row_format= 1;
12 INSERT INTO t1 VALUES (2);
13 ERROR HY000: The query does not comply with variable require_row_format restrictions.
14 UPDATE t1 SET c1 = 2 WHERE c1 = 1;
15 ERROR HY000: The query does not comply with variable require_row_format restrictions.
16 INSERT INTO t1 SELECT * FROM t2;
17 ERROR HY000: The query does not comply with variable require_row_format restrictions.
18 DELETE FROM t1 WHERE c1 = 1;
19 ERROR HY000: The query does not comply with variable require_row_format restrictions.
20 REPLACE INTO t1 (c1) VALUES(2);
21 ERROR HY000: The query does not comply with variable require_row_format restrictions.
22 REPLACE t1 SELECT * FROM t2;
23 ERROR HY000: The query does not comply with variable require_row_format restrictions.
24 LOAD DATA INFILE '../std_data_ln/words.dat' INTO TABLE t3;
25 ERROR HY000: The query does not comply with variable require_row_format restrictions.
26 DELETE t1, t2 FROM t1, t2 WHERE t1.c1 = 1;
27 ERROR HY000: The query does not comply with variable require_row_format restrictions.
28 UPDATE t1, t2 SET t1.c1=t2.c1 WHERE t1.c1 = 1;
29 ERROR HY000: The query does not comply with variable require_row_format restrictions.
30 CREATE TEMPORARY TABLE temp2 (c1 INT);
31 ERROR HY000: The query does not comply with variable require_row_format restrictions.
32 DROP TEMPORARY TABLE temp1;
33 ERROR HY000: The query does not comply with variable require_row_format restrictions.
34 include/assert.inc [Table t1 was not changed]
35 include/assert.inc [Table t3 was empty]
36 #
37 # 1.1 Test binlog updates can still update tables
38 BINLOG '
39 mV5DXQ8BAAAAeAAAAHwAAAABAAQAOC4wLjE5LXRyLWRlYnVnAAAAAAAAAAAAAAAAAAAAAAAAAAAA
40 AAAAAAAAAAAAAAAAAACZXkNdEwANAAgAAAAABAAEAAAAYAAEGggAAAAICAgCAAAACgoKKioAEjQA
41 CgHG1zdG';
42 BINLOG '
43 mV5DXRMBAAAAMAAAADACAAAAAJoAAAAAAAEABHRlc3QAAnQxAAEDAAEBAQCnZmio
44 mV5DXR4BAAAAKAAAAFgCAAAAAJoAAAAAAAEAAgAB/wACAAAAntJyow==';
45 include/assert.inc [Table t1 was changed]
46 #
47 # 2. Set require_row_format to 0 and check all restrictions are gone
48 SET SESSION require_row_format= 0;
49 INSERT INTO t1 VALUES (11);
50 UPDATE t1 SET c1 = 4 WHERE c1 = 1;
51 CREATE TEMPORARY TABLE temp2 (c1 INT);
52 BINLOG '
53 mV5DXRMBAAAAMAAAAEEDAAAAAJoAAAAAAAEABHRlc3QAAnQxAAEDAAEBAQDNxAV8
54 mV5DXR4BAAAAKAAAAGkDAAAAAJoAAAAAAAEAAgAB/wADAAAAO7EClA==';
55 include/assert.inc [Table t1 has 4 values]
56 #
57 # 3. Cleanup
58 DROP TEMPORARY TABLE temp1;
59 DROP TEMPORARY TABLE temp2;
60 DROP TABLE t1;
61 DROP TABLE t2;
62 DROP TABLE t3;