Comment 16 for bug 585688

Revision history for this message
Arjen Lentz (arjen-lentz) wrote : Re: [Bug 585688] Re: maridb crashes in federatedx code

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,
Arjen.
--
Arjen Lentz, Exec.Director @ Open Query (http://openquery.com)
Exceptional Services for MySQL at a fixed budget.

Follow our blog at http://openquery.com/blog/
OurDelta: packages for MySQL and MariaDB @ http://ourdelta.org