Debian Codegraph @

mysql-test/suite/rpl/r/rpl_virtual_gcol.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 [connection slave]
7 set @saved_slave_rows_search_algorithms= @@global.slave_rows_search_algorithms;
8 Warnings:
9 Warning 1287 '@@slave_rows_search_algorithms' is deprecated and will be removed in a future release.
10 SET GLOBAL slave_rows_search_algorithms= 'INDEX_SCAN,HASH_SCAN';
11 Warnings:
12 Warning 1287 '@@slave_rows_search_algorithms' is deprecated and will be removed in a future release.
13 [connection master]
14 CREATE TABLE gtable (doc JSON);
15 INSERT INTO gtable (doc) VALUES
16 ('{"id": 1, "name": "abcd efgh"}'),
17 ('{"id": 2, "name": "abcd ijk"}');
18 ALTER TABLE gtable ADD COLUMN gtext JSON
19 GENERATED ALWAYS AS (JSON_EXTRACT(doc, '$.name')) VIRTUAL;
20 include/sync_slave_sql_with_master.inc
21 [connection master]
22 UPDATE gtable SET doc = JSON_SET(doc, '$.name', 'abcd lmnopqrstuvxz')
23 WHERE JSON_EXTRACT(doc, '$.id') = 2;
24 include/sync_slave_sql_with_master.inc
25 [connection master]
26 INSERT INTO gtable(doc) VALUES (NULL);
27 include/sync_slave_sql_with_master.inc
28 [connection master]
29 UPDATE gtable SET doc = '{ "id": 4, "name": "abc aba" }' where doc IS NULL;
30 include/sync_slave_sql_with_master.inc
31 [connection master]
32 UPDATE gtable SET doc = NULL WHERE JSON_EXTRACT(doc, '$.id') = 4;
33 include/sync_slave_sql_with_master.inc
34 [connection master]
35 DROP TABLE gtable;
36 include/sync_slave_sql_with_master.inc
37 [connection master]
38 CREATE TABLE gtable(id INT, doc JSON, gcol JSON AS (JSON_ARRAY(id, doc)));
39 INSERT INTO gtable(id, doc) VALUES(10, '{"a": 1}');
40 include/sync_slave_sql_with_master.inc
41 [connection master]
42 UPDATE gtable SET doc = JSON_REPLACE(gcol, '$[0].a',"a");
43 include/sync_slave_sql_with_master.inc
44 [connection master]
45 DROP TABLE gtable;
46 include/sync_slave_sql_with_master.inc
47 [connection master]
48 CREATE TABLE gtable (doc TEXT);
49 INSERT INTO gtable (doc) VALUES ('point(1 1)'), ('point(2 2)');
50 ALTER TABLE gtable ADD COLUMN gtext GEOMETRY
51 GENERATED ALWAYS AS (ST_GEOMFROMTEXT(doc)) VIRTUAL;
52 UPDATE gtable SET doc = 'POINT(3 3)' WHERE ST_X(ST_GEOMFROMTEXT(doc)) = 2;
53 INSERT INTO gtable(doc) VALUES (NULL);
54 UPDATE gtable SET doc = 'POINT(4 4)' where doc IS NULL;
55 UPDATE gtable SET doc = NULL WHERE ST_X(ST_GEOMFROMTEXT(doc)) = 4;
56 include/sync_slave_sql_with_master.inc
57 [connection master]
58 DROP TABLE gtable;
59 include/sync_slave_sql_with_master.inc
60 [connection master]
61 CREATE TABLE gtable(a DOUBLE,
62 b DOUBLE AS (a * a));
63 INSERT INTO gtable (a) VALUES (1);
64 include/sync_slave_sql_with_master.inc
65 [connection master]
66 UPDATE gtable SET a= 2;
67 include/sync_slave_sql_with_master.inc
68 [connection master]
69 DROP TABLE gtable;
70 include/sync_slave_sql_with_master.inc
71 [connection master]
72 CREATE TABLE gtable(geo GEOMETRY, gcol GEOMETRY AS (GEOMETRYCOLLECTION(geo, geo)));
73 INSERT INTO gtable (geo) VALUES (POINT(1, 1));
74 include/sync_slave_sql_with_master.inc
75 [connection master]
76 UPDATE gtable SET geo = LINESTRING(POINT(1, 1), POINT(2, 2));
77 include/sync_slave_sql_with_master.inc
78 [connection master]
79 DROP TABLE gtable;
80 include/sync_slave_sql_with_master.inc
81 SET @replica_parallel_type_saved= @@GLOBAL.REPLICA_PARALLEL_TYPE;
82 Warnings:
83 Warning 1287 '@@replica_parallel_type' is deprecated and will be removed in a future release.
84 SET @replica_parallel_workers_saved= @@GLOBAL.REPLICA_PARALLEL_WORKERS;
85 SET @slave_preserver_commit_order_saved= @@GLOBAL.REPLICA_PRESERVE_COMMIT_ORDER;
86 include/stop_slave.inc
87 SET GLOBAL replica_parallel_type= 'LOGICAL_CLOCK';
88 Warnings:
89 Warning 1287 '@@replica_parallel_type' is deprecated and will be removed in a future release.
90 SET GLOBAL replica_parallel_workers= 4;
91 SET GLOBAL replica_preserve_commit_order= ON;
92 include/start_slave.inc
93 CALL mtr.add_suppression("This version of MySQL doesn't yet support 'sorting of non-scalar JSON values'");
94 [connection master]
95 CREATE TABLE gtable(id INT, jd JSON, td TEXT,
96 gcol JSON AS (JSON_OBJECT(id,jd,JSON_KEYS(jd),td)));
97 INSERT INTO gtable(id,jd,td) VALUES(100, '{"a":1}', 'characters');
98 include/sync_slave_sql_with_master.inc
99 include/diff_tables.inc [master:gtable, slave:gtable]
100 [connection master]
101 UPDATE gtable SET jd = JSON_REPLACE(jd, '$[0].a',"a");
102 include/sync_slave_sql_with_master.inc
103 include/diff_tables.inc [master:gtable, slave:gtable]
104 [connection master]
105 UPDATE gtable SET jd= JSON_SET(jd, '$.key', '["h","e","l","l","o"]');
106 include/sync_slave_sql_with_master.inc
107 include/diff_tables.inc [master:gtable, slave:gtable]
108 [connection master]
109 DROP TABLE gtable;
110 include/sync_slave_sql_with_master.inc
111 SET @@global.slave_rows_search_algorithms= @saved_slave_rows_search_algorithms;
112 Warnings:
113 Warning 1287 '@@slave_rows_search_algorithms' is deprecated and will be removed in a future release.
114 include/stop_slave.inc
115 SET @@GLOBAL.REPLICA_PARALLEL_TYPE= @replica_parallel_type_saved;
116 Warnings:
117 Warning 1287 '@@replica_parallel_type' is deprecated and will be removed in a future release.
118 SET @@GLOBAL.REPLICA_PARALLEL_WORKERS= @replica_parallel_workers_saved;
119 SET @@GLOBAL.REPLICA_PRESERVE_COMMIT_ORDER= @slave_preserver_commit_order_saved;
120 include/start_slave.inc
121 include/rpl_end.inc