[DDC-2269] Mysql supports cross database DDL's and JOIN's, but is ignored by Doctrine Created: 02/Feb/13  Updated: 02/Feb/13  Resolved: 02/Feb/13

Status: Resolved
Project: Doctrine 2 - ORM
Component/s: Mapping Drivers, ORM, Tools
Affects Version/s: 2.3.2
Fix Version/s: None
Security Level: All

Type: Bug Priority: Major
Reporter: Marcos Passos Assignee: Benjamin Eberlei
Resolution: Invalid Votes: 0
Labels: None

PHP 5.4.10
Mysql: 5.5.25 Source distribution
Doctrine 2.2


Currently, MySQL supports cross database DDL and JOIN's, but the MySQLPlataform returns false for supportsSchemas() and canEmulateSchemas(), so the foreign keys and create's statements are removed. Just commenting these following lines works perfectly:

if ( ! $this->platform->supportsSchemas() && ! $this->platform->canEmulateSchemas() ) {
$schema->visit(new RemoveNamespacedAssets());

The only issue is that the table diff does not take into account the cross database structure. So, using the schema tool to update the database is always considered that the database was not created yet, throwing an exception.

Comment by Benjamin Eberlei [ 02/Feb/13 ]

Schemas is something different, it is what PostgreSQL and Oracle have.

Generated at Tue Sep 01 10:15:09 EDT 2015 using JIRA 6.4.10#64025-sha1:5b8b74079161cd76a20ab66dda52747ee6701bd6.