Hi MySQL Engineers,
While implementing foreign keys for the PBXT storage engine I have
come across the following problem:
--- Background:
PBXT requires a table to be open by MySQL in order to perform any
operations on it. This is because PBXT uses the MySQL index
description and charset information to compare key values and it uses
'class Field' to load and store rows.
--- The problem:
Of course, MySQL opens tables before they are used so this is
normally not a problem, but foreign keys require an engine to perform
operations on _other_ (referenced) tables. So PBXT requires all
referenced tables to be opened as well.
--- Question:
Is there a way to tell MySQL to open the other referenced tables
before the operation starts?
Any other suggestions/solutions would be greatly appreciated!
Thanks,
Paul
