Problems updating federated table
Scenario:
Server A: create view federated_view as SELECT ....
Server B: create table tabela_federada (A, B, C) ENGINE=FEDERATED CONNECTION='mysql://user:paswd@:3306/database/federated_view';
When i perform a update on federated table, mysql return
OK, but the value was not updated:
mysql> update tabela_federada set incidentes_utilizados = 1 where customer_id = 'teste' and incidentes_utilizados = 10;
Query OK, 1 row affected (0.17 sec)
mysql> select * from tabela_federada where customer_id = 'teste'\G
incidentes_utilizados: 10
bugs_qualificados: 3
requisicoes_utilizadas: 2
horas_disponiveis: 4.00
Subject
Views
Written By
Posted
Problems updating federated table
2671
June 21, 2017 10:31AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.