Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Incomplete
-
None
-
GKE
Description
When rewrite_src matches constant data in the SQL, it also gets rewritten. For example, with rewrite_src=db.tree the data in the following SQL gets modified as the regex matches the data:
INSERT INTO db.tree VALUES (1, 'Cigartree'); |
Original description and title:
data dependency of the replicated data on the meta data
|
|
MariaDB [(none)]> select list_replications();
|
+------------------------------------------------------------------------------------------------------------------------+
|
| list_replications() |
|
+------------------------------------------------------------------------------------------------------------------------+
|
|
|
=== replication_filter ===
|
table: customers
|
source database: source_customers
|
target database: target_customers
|
|
|
|
|
+------------------------------------------------------------------------------------------------------------------------+
|
1 row in set (0.002 sec)
|
|
|
|
|
|
MariaDB [(none)]> insert into source_customers.customers values ( 6 , ' source_customers') ;
Query OK, 1 row affected (0.006 sec)
MariaDB [(none)]> insert into source_customers.customers values (7 , ' target_customers') ;
Query OK, 1 row affected (0.005 sec)
MariaDB [(none)]> select * from target_customers.customers ;
-------------------------+
| a | b |
-------------------------+
| 1 | internal_customers |
| 2 | external_customers |
| 3 | unknown_customers |
| 4 | vip_customers |
| 5 | back_customers |
| 6 | target_customers |
| 7 | target_customers |
-------------------------+
7 rows in set (1.066 sec)
|
Attachments
Issue Links
- relates to
-
MXS-2846 Binlogfilter: Add syntactic identifier replacement
-
- Closed
-