On 08/06/2010, at 7:54 PM, John Rosauer wrote:
> Yes, we are using Federated tables; they point to different tables
> in schema
> within the same database (there is a good reason).
I figure by the word "database" in this context you actually mean
"database server instance", i.e. the same running mysqld ?
If I read the above correctly, you're essentially doing a federated
connection back to the same server. While there's still an indication
that there is a bug, if this what you're doing, there might be a
workaround: use a VIEW instead. In MySQL/MariaDB, regular views are
updateable.
> The data is being migrated from another database, so the Federated
> table
> will, at some point, have no data (during migration).
Regards,
Arjen.
--
Arjen Lentz, Exec.Director @ Open Query (http://openquery.com)
Exceptional Services for MySQL at a fixed budget.
Hi John
On 08/06/2010, at 7:54 PM, John Rosauer wrote:
> Yes, we are using Federated tables; they point to different tables
> in schema
> within the same database (there is a good reason).
I figure by the word "database" in this context you actually mean
"database server instance", i.e. the same running mysqld ?
If I read the above correctly, you're essentially doing a federated
connection back to the same server. While there's still an indication
that there is a bug, if this what you're doing, there might be a
workaround: use a VIEW instead. In MySQL/MariaDB, regular views are
updateable.
> The data is being migrated from another database, so the Federated
> table
> will, at some point, have no data (during migration).
Regards, openquery. com)
Arjen.
--
Arjen Lentz, Exec.Director @ Open Query (http://
Exceptional Services for MySQL at a fixed budget.
Follow our blog at http:// openquery. com/blog/ ourdelta. org
OurDelta: packages for MySQL and MariaDB @ http://