[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 | ||
| Environment: |
PHP 5.4.10 |
||
| Description |
|
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. |
| Comments |
| Comment by Benjamin Eberlei [ 02/Feb/13 ] |
|
Schemas is something different, it is what PostgreSQL and Oracle have. |