Debian Codegraph @

mysql-test/suite/rpl/r/rpl_row_view01.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 database mysqltest1;
7 CREATE TABLE mysqltest1.t1 (a INT, c CHAR(6),PRIMARY KEY(a));
8 CREATE TABLE mysqltest1.t2 (a INT, c CHAR(6),PRIMARY KEY(a));
9 CREATE TABLE mysqltest1.t3 (a INT, c CHAR(6), c2 CHAR(6), PRIMARY KEY(a));
10 CREATE TABLE mysqltest1.t4 (a INT, qty INT, price INT,PRIMARY KEY(a));
11 CREATE TABLE mysqltest1.t5 (qty INT, price INT, total INT, PRIMARY KEY(qty));
12 INSERT INTO mysqltest1.t1 VALUES (1,'Thank'),(2,'it'),(3,'Friday');
13 INSERT INTO mysqltest1.t2 VALUES (1,'GOD'),(2,'is'),(3,'TGIF');
14 INSERT INTO mysqltest1.t4 VALUES(1, 3, 50),(2, 18, 3),(4, 4, 4);
15 CREATE VIEW mysqltest1.v2 AS SELECT qty, price, qty*price AS value FROM mysqltest1.t4 ORDER BY qty;
16 CREATE VIEW mysqltest1.v1 AS SELECT t1.a, t1.c, t2.c as c2 FROM mysqltest1.t1 as t1, mysqltest1.t2 AS t2 WHERE mysqltest1.t1.a = mysqltest1.t2.a ORDER BY a;
17 CREATE VIEW mysqltest1.v3 AS SELECT * FROM mysqltest1.t1;
18 CREATE VIEW mysqltest1.v4 AS SELECT * FROM mysqltest1.v3 WHERE a > 1 WITH LOCAL CHECK OPTION;
19 SELECT * FROM mysqltest1.v2;
20 qty price value
21 3 50 150
22 4 4 16
23 18 3 54
24 SELECT * FROM mysqltest1.v1;
25 a c c2
26 1 Thank GOD
27 2 it is
28 3 Friday TGIF
29 CREATE TABLE mysqltest1.t10 (a INT, PRIMARY KEY(a));
30 include/sync_slave_sql_with_master.inc
31 SELECT * FROM mysqltest1.v2;
32 qty price value
33 3 50 150
34 4 4 16
35 18 3 54
36 SELECT * FROM mysqltest1.v1;
37 a c c2
38 1 Thank GOD
39 2 it is
40 3 Friday TGIF
41 INSERT INTO mysqltest1.t5 SELECT * FROM mysqltest1.v2;
42 INSERT INTO mysqltest1.t3 SELECT * FROM mysqltest1.v1;
43 SELECT * FROM mysqltest1.t5 ORDER BY qty;
44 qty price total
45 3 50 150
46 4 4 16
47 18 3 54
48 SELECT * FROM mysqltest1.t3 ORDER BY a;
49 a c c2
50 1 Thank GOD
51 2 it is
52 3 Friday TGIF
53 include/sync_slave_sql_with_master.inc
54 SELECT * FROM mysqltest1.t5 ORDER BY qty;
55 qty price total
56 3 50 150
57 4 4 16
58 18 3 54
59 SELECT * FROM mysqltest1.t3 ORDER BY a;
60 a c c2
61 1 Thank GOD
62 2 it is
63 3 Friday TGIF
64 INSERT INTO mysqltest1.v4 VALUES (4,'TEST');
65 SELECT * FROM mysqltest1.t1 ORDER BY a;
66 a c
67 1 Thank
68 2 it
69 3 Friday
70 4 TEST
71 SELECT * FROM mysqltest1.v4 ORDER BY a;
72 a c
73 2 it
74 3 Friday
75 4 TEST
76 include/sync_slave_sql_with_master.inc
77 SELECT * FROM mysqltest1.t1 ORDER BY a;
78 a c
79 1 Thank
80 2 it
81 3 Friday
82 4 TEST
83 SELECT * FROM mysqltest1.v4 ORDER BY a;
84 a c
85 2 it
86 3 Friday
87 4 TEST
88 DROP VIEW IF EXISTS mysqltest1.v1;
89 DROP VIEW IF EXISTS mysqltest1.v2;
90 DROP VIEW IF EXISTS mysqltest1.v3;
91 DROP VIEW IF EXISTS mysqltest1.v4;
92 DROP TABLE IF EXISTS mysqltest1.t3;
93 DROP TABLE IF EXISTS mysqltest1.t1;
94 DROP TABLE IF EXISTS mysqltest1.t2;
95 DROP TABLE IF EXISTS mysqltest1.t4;
96 DROP TABLE IF EXISTS mysqltest1.t10;
97 DROP DATABASE mysqltest1;
98 include/sync_slave_sql_with_master.inc
99 include/rpl_end.inc