* dlenev@stripped <dlenev@stripped> [08/04/22 19:46]:
> ChangeSet@stripped, 2008-04-22 19:37:18+04:00, dlenev@stripped +3 -0
> Fix for bug #35528 "Foreign keys: inconsistent error if partitions".
>
> In --foreign-key-all-engines attempt to create partitioned table
> (with non-automatic partitioning) with foreign key constraints
> resulted in error. This contradicts LLD for WL148 "Foreign keys"
> and is not consistent with behavior for column foreign keys in
> the same situation.
>
> The fix for this problem is to avoid check that was causing
> this error in --foreign-key-all-engines mode.
>
> Note that once we implement one of the later milestones of WL148
> we may start emitting error in such cases again. But this behavior
> should be consistent for table and column constraints and will go
> away once WL4246 "Foreign Keys & Partitioning: Implement Storage
> Engine API for foreign key support" is complete.
OK to push, but isn't it a good time to move this check to
mysql_prepare_create_table()?
--
Konstantin Osipov Moscow, Russia
MySQL Server Runtime Team Lead Database Group, Sun Microsystems