Gecko [ www.jdcpatala.org ]

Name	Size	Permission
federated_gcol.result	1.56 KB	-rw-r--r--
gcol_archive.result	579 B	-rw-r--r--
gcol_blackhole.result	581 B	-rw-r--r--
gcol_blocked_sql_funcs_innodb....	12.25 KB	-rw-r--r--
gcol_blocked_sql_funcs_myisam....	12.42 KB	-rw-r--r--
gcol_bug20746926.result	928 B	-rw-r--r--
gcol_bugfixes.result	21.67 KB	-rw-r--r--
gcol_column_def_options_innodb...	27.09 KB	-rw-r--r--
gcol_column_def_options_myisam...	23.98 KB	-rw-r--r--
gcol_csv.result	550 B	-rw-r--r--
gcol_falcon.result	544 B	-rw-r--r--
gcol_handler_innodb.result	2.19 KB	-rw-r--r--
gcol_handler_myisam.result	2.19 KB	-rw-r--r--
gcol_ins_upd_innodb.result	20.88 KB	-rw-r--r--
gcol_ins_upd_myisam.result	14.62 KB	-rw-r--r--
gcol_keys_innodb.result	53.55 KB	-rw-r--r--
gcol_keys_myisam.result	38.42 KB	-rw-r--r--
gcol_memory.result	578 B	-rw-r--r--
gcol_merge.result	631 B	-rw-r--r--
gcol_ndb.result	582 B	-rw-r--r--
gcol_non_stored_columns_innodb...	7.11 KB	-rw-r--r--
gcol_non_stored_columns_myisam...	7.11 KB	-rw-r--r--
gcol_partition_innodb.result	2.86 KB	-rw-r--r--
gcol_partition_myisam.result	5.43 KB	-rw-r--r--
gcol_rejected_innodb.result	245 B	-rw-r--r--
gcol_rejected_myisam.result	27.11 KB	-rw-r--r--
gcol_rollback.result	1.43 KB	-rw-r--r--
gcol_select_innodb.result	57.17 KB	-rw-r--r--
gcol_select_myisam.result	37.68 KB	-rw-r--r--
gcol_supported_sql_funcs_innod...	85.02 KB	-rw-r--r--
gcol_supported_sql_funcs_myisa...	85.02 KB	-rw-r--r--
gcol_trigger_sp_innodb.result	1.68 KB	-rw-r--r--
gcol_trigger_sp_myisam.result	1.68 KB	-rw-r--r--
gcol_update.result	2.05 KB	-rw-r--r--
gcol_view_innodb.result	7.74 KB	-rw-r--r--
gcol_view_myisam.result	7.74 KB	-rw-r--r--
rpl_gcol.result	2.98 KB	-rw-r--r--

Code Editor : rpl_gcol.result

SET @@session.default_storage_engine = 'InnoDB';
include/master-slave.inc
Warnings:
Note	####	Sending passwords in plain text without SSL/TLS is extremely insecure.
Note	####	Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
[connection master]
create table t1 (a int, b int generated always as (a+1) virtual);
show create table t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `a` int(11) DEFAULT NULL,
  `b` int(11) GENERATED ALWAYS AS ((`a` + 1)) VIRTUAL
) ENGINE=InnoDB DEFAULT CHARSET=latin1
insert into t1 values (1,default);
insert into t1 values (2,default);
select * from t1;
a	b
1	2
2	3
select * from t1;
a	b
1	2
2	3
drop table t1;
#
# Bug#22241015: REPLICATION SERVERS CRASHES WHILE CHANGING A
#               VALUE OF INDEXED JSON FIELD
#
CREATE TABLE gtable (doc JSON);
INSERT INTO gtable (doc) VALUES
('{"id": 1, "name": "Omar Bras"}'),
('{"id": 2, "name": "Omar Mex"}');
ALTER TABLE gtable ADD COLUMN gtext TEXT GENERATED ALWAYS AS
(JSON_UNQUOTE(JSON_EXTRACT(doc, '$.name'))) VIRTUAL,
ADD UNIQUE INDEX name_index (gtext(50));
UPDATE gtable SET doc=JSON_SET(doc,'$.name',"Omar Argentina") WHERE JSON_EXTRACT(doc, "$.id") = 2;
INSERT INTO gtable(doc) VALUES (NULL);
SELECT * FROM gtable;
doc	gtext
{"id": 1, "name": "Omar Bras"}	Omar Bras
{"id": 2, "name": "Omar Argentina"}	Omar Argentina
NULL	NULL
UPDATE gtable SET doc= '{ "id": 4, "name": "Omar Ara" }' where doc IS NULL;
SELECT * FROM gtable ORDER BY gtext;
doc	gtext
{"id": 4, "name": "Omar Ara"}	Omar Ara
{"id": 2, "name": "Omar Argentina"}	Omar Argentina
{"id": 1, "name": "Omar Bras"}	Omar Bras
UPDATE gtable SET doc= NULL WHERE JSON_EXTRACT(doc, "$.id") = 4;
SELECT * FROM gtable ORDER BY gtext;
doc	gtext
NULL	NULL
{"id": 2, "name": "Omar Argentina"}	Omar Argentina
{"id": 1, "name": "Omar Bras"}	Omar Bras
include/sync_slave_sql_with_master.inc
SHOW CREATE TABLE gtable;
Table	Create Table
gtable	CREATE TABLE `gtable` (
  `doc` json DEFAULT NULL,
  `gtext` text GENERATED ALWAYS AS (json_unquote(json_extract(`doc`,'$.name'))) VIRTUAL,
  UNIQUE KEY `name_index` (`gtext`(50))
) ENGINE=InnoDB DEFAULT CHARSET=latin1
# Connection:slave - Row with value 3 is expected on slave.
SELECT * FROM gtable ORDER BY gtext;
doc	gtext
NULL	NULL
{"id": 2, "name": "Omar Argentina"}	Omar Argentina
{"id": 1, "name": "Omar Bras"}	Omar Bras
include/diff_tables.inc [master:gtable, slave:gtable]
Warnings:
Warning	1235	This version of MySQL doesn't yet support 'sorting of non-scalar JSON values'
Warnings:
Warning	1235	This version of MySQL doesn't yet support 'sorting of non-scalar JSON values'
DROP TABLE gtable;
include/sync_slave_sql_with_master.inc
DROP VIEW  IF EXISTS v1,v2;
DROP TABLE IF EXISTS t1,t2,t3;
DROP PROCEDURE IF EXISTS p1;
DROP FUNCTION IF EXISTS f1;
DROP TRIGGER IF EXISTS trg1;
DROP TRIGGER IF EXISTS trg2;
set sql_warnings = 0;
include/rpl_end.inc

${this.title}

Code Editor : rpl_gcol.result