Debian Codegraph @

mysql-test/suite/rpl/r/default_row_format_01.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 USE test;
7 CREATE TABLE tab(empno INT,ename VARCHAR(30),sal NUMERIC(3))
8 ENGINE=InnoDB PARTITION BY HASH(empno) (PARTITION p0,PARTITION p1 );
9 CREATE TABLE tab1(a INT PRIMARY KEY, b VARCHAR(5000),KEY idx1(b(3070)))
10 ENGINE= InnoDB
11 DEFAULT CHARACTER SET latin1;
12 INSERT INTO tab VALUES (100,'VISWANATH',100);
13 INSERT INTO tab VALUES (300,'VISWANATH',200);
14 INSERT INTO tab1(a,b) VALUES(1,'Check with max prefix');
15 include/sync_slave_sql_with_master.inc
16 SELECT @@innodb_default_row_format;
17 @@innodb_default_row_format
18 dynamic
19 SELECT * FROM tab ORDER BY empno;
20 empno ename sal
21 100 VISWANATH 100
22 300 VISWANATH 200
23 SELECT * FROM tab1 ORDER BY a;
24 a b
25 1 Check with max prefix
26 CHECK TABLE tab;
27 Table Op Msg_type Msg_text
28 test.tab check status OK
29 CHECK TABLE tab1;
30 Table Op Msg_type Msg_text
31 test.tab1 check status OK
32 === information_schema.innodb_tables and innodb_tablespaces ===
33 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
34 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
35 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
36 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
37 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
38 test/tab#p#p0 test/tab#p#p0 33 6 Dynamic 0 Single
39 test/tab#p#p1 test/tab#p#p1 33 6 Dynamic 0 Single
40 test/tab1 test/tab1 33 5 Dynamic 0 Single
41 DROP TABLE tab,tab1;
42 SET GLOBAL innodb_default_row_format=Compact;
43 CREATE TABLE tab(a INT PRIMARY KEY, b VARCHAR(5000),KEY idx1(b(768)))
44 ENGINE= InnoDB
45 DEFAULT CHARACTER SET latin1;
46 ERROR HY000: Index column size too large. The maximum column size is 767 bytes.
47 include/sync_slave_sql_with_master.inc
48 SELECT @@innodb_default_row_format;
49 @@innodb_default_row_format
50 dynamic
51 SHOW CREATE TABLE tab;
52 ERROR 42S02: Table 'test.tab' doesn't exist
53 SET GLOBAL innodb_default_row_format=Dynamic;
54 CREATE TABLE tab(a INT PRIMARY KEY, b VARCHAR(5000),KEY idx1(b(767)))
55 ENGINE= InnoDB ROW_FORMAT=COMPACT
56 DEFAULT CHARACTER SET latin1;
57 INSERT INTO tab(a,b) VALUES(1,'Check with max prefix');
58 ALTER TABLE tab ROW_FORMAT=COMPRESSED;
59 === information_schema.innodb_tables and innodb_tablespaces ===
60 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
61 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
62 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
63 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
64 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
65 test/tab test/tab 41 5 Compressed 8192 Single
66 include/sync_slave_sql_with_master.inc
67 SELECT @@innodb_default_row_format;
68 @@innodb_default_row_format
69 dynamic
70 === information_schema.innodb_tables and innodb_tablespaces ===
71 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
72 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
73 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
74 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
75 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
76 test/tab test/tab 41 5 Compressed 8192 Single
77 DROP TABLE tab;
78 include/rpl_end.inc