DDC-589: Doctrine\Tests\ORM\Functional\DatabaseDriverTest failures #5094

Closed
doctrinebot opened this Issue May 15, 2010 · 3 comments

2 participants

@doctrinebot

Jira issue originally created by user @beberlei:

5) Doctrine\Tests\ORM\Functional\DatabaseDriverTest::testCreateSimpleYamlFromDatabase
Exception: [Doctrine\ORM\Mapping\MappingException] Property "other2" in "MultiSelfReference" was already declared, but it must be declared only once

With queries:
213. SQL: 'SHOW INDEX FROM MultiSelfReference' Params: 
212. SQL: 'SELECT DISTINCT k.`CONSTRAINT*NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON k.`CONSTRAINT_NAME` = c.constraint_name AND   c.constraint_name = k.constraint_name AND   c.table_name = 'MultiSelfReference' */ WHERE k.table_name = 'MultiSelfReference' AND table_schema = 'doctrine_tests' AND `REFERENCED_COLUMN*NAME` is not NULL' Params: 
211. SQL: 'DESCRIBE MultiSelfReference' Params: 
210. SQL: 'SHOW INDEX FROM LifecycleCallbackTestUser' Params: 
209. SQL: 'SELECT DISTINCT k.`CONSTRAINT*NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON k.`CONSTRAINT_NAME` = c.constraint_name AND   c.constraint_name = k.constraint_name AND   c.table_name = 'LifecycleCallbackTestUser' */ WHERE k.table_name = 'LifecycleCallbackTestUser' AND table_schema = 'doctrine_tests' AND `REFERENCED_COLUMN*NAME` is not NULL' Params: 
208. SQL: 'DESCRIBE LifecycleCallbackTestUser' Params: 
207. SQL: 'SHOW INDEX FROM EntitySubClass' Params: 
206. SQL: 'SELECT DISTINCT k.`CONSTRAINT*NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON k.`CONSTRAINT_NAME` = c.constraint_name AND   c.constraint_name = k.constraint_name AND   c.table_name = 'EntitySubClass' */ WHERE k.table_name = 'EntitySubClass' AND table_schema = 'doctrine_tests' AND `REFERENCED_COLUMN*NAME` is not NULL' Params: 
205. SQL: 'DESCRIBE EntitySubClass' Params: 
204. SQL: 'SHOW INDEX FROM CTIRelated2_CTIChild' Params: 
203. SQL: 'SELECT DISTINCT k.`CONSTRAINT*NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON k.`CONSTRAINT_NAME` = c.constraint_name AND   c.constraint_name = k.constraint_name AND   c.table_name = 'CTIRelated2_CTIChild' */ WHERE k.table_name = 'CTIRelated2_CTIChild' AND table_schema = 'doctrine_tests' AND `REFERENCED_COLUMN*NAME` is not NULL' Params: 
202. SQL: 'DESCRIBE CTIRelated2_CTIChild' Params: 
201. SQL: 'SHOW INDEX FROM CTIRelated2' Params: 
200. SQL: 'SELECT DISTINCT k.`CONSTRAINT*NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON k.`CONSTRAINT_NAME` = c.constraint_name AND   c.constraint_name = k.constraint_name AND   c.table_name = 'CTIRelated2' */ WHERE k.table_name = 'CTIRelated2' AND table_schema = 'doctrine_tests' AND `REFERENCED_COLUMN*NAME` is not NULL' Params: 
199. SQL: 'DESCRIBE CTIRelated2' Params: 
198. SQL: 'SHOW INDEX FROM CTIRelated' Params: 
197. SQL: 'SELECT DISTINCT k.`CONSTRAINT*NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON k.`CONSTRAINT_NAME` = c.constraint_name AND   c.constraint_name = k.constraint_name AND   c.table_name = 'CTIRelated' */ WHERE k.table_name = 'CTIRelated' AND table_schema = 'doctrine_tests' AND `REFERENCED_COLUMN*NAME` is not NULL' Params: 
196. SQL: 'DESCRIBE CTIRelated' Params: 
195. SQL: 'SHOW INDEX FROM type' Params: 
194. SQL: 'SELECT DISTINCT k.`CONSTRAINT*NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON k.`CONSTRAINT_NAME` = c.constraint_name AND   c.constraint_name = k.constraint_name AND   c.table_name = 'type' */ WHERE k.table_name = 'type' AND table_schema = 'doctrine_tests' AND `REFERENCED_COLUMN*NAME` is not NULL' Params: 
193. SQL: 'DESCRIBE type' Params: 
192. SQL: 'SHOW INDEX FROM serialize_model' Params: 
191. SQL: 'SELECT DISTINCT k.`CONSTRAINT*NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON k.`CONSTRAINT_NAME` = c.constraint_name AND   c.constraint_name = k.constraint_name AND   c.table_name = 'serialize_model' */ WHERE k.table_name = 'serialize_model' AND table_schema = 'doctrine_tests' AND `REFERENCED_COLUMN*NAME` is not NULL' Params: 
190. SQL: 'DESCRIBE serialize_model' Params: 

Trace:
/home/benny/code/php/wsnetbeans/doctrine2/lib/Doctrine/ORM/Mapping/ClassMetadataInfo.php:1064
/home/benny/code/php/wsnetbeans/doctrine2/lib/Doctrine/ORM/Mapping/ClassMetadataInfo.php:1017
/home/benny/code/php/wsnetbeans/doctrine2/lib/Doctrine/ORM/Mapping/ClassMetadataInfo.php:1040
/home/benny/code/php/wsnetbeans/doctrine2/lib/Doctrine/ORM/Mapping/Driver/DatabaseDriver.php:136
/home/benny/code/php/wsnetbeans/doctrine2/tests/Doctrine/Tests/ORM/Functional/DatabaseDriverTest.php:93
/home/benny/code/php/wsnetbeans/doctrine2/tests/Doctrine/Tests/ORM/Functional/DatabaseDriverTest.php:36


/home/benny/code/php/wsnetbeans/doctrine2/tests/Doctrine/Tests/OrmFunctionalTestCase.php:275

6) Doctrine\Tests\ORM\Functional\DatabaseDriverTest::testCreateYamlWithForeignKeyFromDatabase
Exception: [Doctrine\ORM\Mapping\MappingException] Property "other2" in "MultiSelfReference" was already declared, but it must be declared only once

With queries:
222. SQL: 'SHOW INDEX FROM MultiSelfReference' Params: 
221. SQL: 'SELECT DISTINCT k.`CONSTRAINT*NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON k.`CONSTRAINT_NAME` = c.constraint_name AND   c.constraint_name = k.constraint_name AND   c.table_name = 'MultiSelfReference' */ WHERE k.table_name = 'MultiSelfReference' AND table_schema = 'doctrine_tests' AND `REFERENCED_COLUMN*NAME` is not NULL' Params: 
220. SQL: 'DESCRIBE MultiSelfReference' Params: 
219. SQL: 'SHOW INDEX FROM LifecycleCallbackTestUser' Params: 
218. SQL: 'SELECT DISTINCT k.`CONSTRAINT*NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON k.`CONSTRAINT_NAME` = c.constraint_name AND   c.constraint_name = k.constraint_name AND   c.table_name = 'LifecycleCallbackTestUser' */ WHERE k.table_name = 'LifecycleCallbackTestUser' AND table_schema = 'doctrine_tests' AND `REFERENCED_COLUMN*NAME` is not NULL' Params: 
217. SQL: 'DESCRIBE LifecycleCallbackTestUser' Params: 
216. SQL: 'SHOW INDEX FROM EntitySubClass' Params: 
215. SQL: 'SELECT DISTINCT k.`CONSTRAINT*NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON k.`CONSTRAINT_NAME` = c.constraint_name AND   c.constraint_name = k.constraint_name AND   c.table_name = 'EntitySubClass' */ WHERE k.table_name = 'EntitySubClass' AND table_schema = 'doctrine_tests' AND `REFERENCED_COLUMN*NAME` is not NULL' Params: 
214. SQL: 'DESCRIBE EntitySubClass' Params: 
213. SQL: 'SHOW INDEX FROM CTIRelated2_CTIChild' Params: 
212. SQL: 'SELECT DISTINCT k.`CONSTRAINT*NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON k.`CONSTRAINT_NAME` = c.constraint_name AND   c.constraint_name = k.constraint_name AND   c.table_name = 'CTIRelated2_CTIChild' */ WHERE k.table_name = 'CTIRelated2_CTIChild' AND table_schema = 'doctrine_tests' AND `REFERENCED_COLUMN*NAME` is not NULL' Params: 
211. SQL: 'DESCRIBE CTIRelated2_CTIChild' Params: 
210. SQL: 'SHOW INDEX FROM CTIRelated2' Params: 
209. SQL: 'SELECT DISTINCT k.`CONSTRAINT*NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON k.`CONSTRAINT_NAME` = c.constraint_name AND   c.constraint_name = k.constraint_name AND   c.table_name = 'CTIRelated2' */ WHERE k.table_name = 'CTIRelated2' AND table_schema = 'doctrine_tests' AND `REFERENCED_COLUMN*NAME` is not NULL' Params: 
208. SQL: 'DESCRIBE CTIRelated2' Params: 
207. SQL: 'SHOW INDEX FROM CTIRelated' Params: 
206. SQL: 'SELECT DISTINCT k.`CONSTRAINT*NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON k.`CONSTRAINT_NAME` = c.constraint_name AND   c.constraint_name = k.constraint_name AND   c.table_name = 'CTIRelated' */ WHERE k.table_name = 'CTIRelated' AND table_schema = 'doctrine_tests' AND `REFERENCED_COLUMN*NAME` is not NULL' Params: 
205. SQL: 'DESCRIBE CTIRelated' Params: 
204. SQL: 'SHOW INDEX FROM type' Params: 
203. SQL: 'SELECT DISTINCT k.`CONSTRAINT*NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON k.`CONSTRAINT_NAME` = c.constraint_name AND   c.constraint_name = k.constraint_name AND   c.table_name = 'type' */ WHERE k.table_name = 'type' AND table_schema = 'doctrine_tests' AND `REFERENCED_COLUMN*NAME` is not NULL' Params: 
202. SQL: 'DESCRIBE type' Params: 
201. SQL: 'SHOW INDEX FROM serialize_model' Params: 
200. SQL: 'SELECT DISTINCT k.`CONSTRAINT*NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON k.`CONSTRAINT_NAME` = c.constraint_name AND   c.constraint_name = k.constraint_name AND   c.table_name = 'serialize_model' */ WHERE k.table_name = 'serialize_model' AND table_schema = 'doctrine_tests' AND `REFERENCED_COLUMN*NAME` is not NULL' Params: 
199. SQL: 'DESCRIBE serialize_model' Params: 

Trace:
/home/benny/code/php/wsnetbeans/doctrine2/lib/Doctrine/ORM/Mapping/ClassMetadataInfo.php:1064
/home/benny/code/php/wsnetbeans/doctrine2/lib/Doctrine/ORM/Mapping/ClassMetadataInfo.php:1017
/home/benny/code/php/wsnetbeans/doctrine2/lib/Doctrine/ORM/Mapping/ClassMetadataInfo.php:1040
/home/benny/code/php/wsnetbeans/doctrine2/lib/Doctrine/ORM/Mapping/Driver/DatabaseDriver.php:136
/home/benny/code/php/wsnetbeans/doctrine2/tests/Doctrine/Tests/ORM/Functional/DatabaseDriverTest.php:93
/home/benny/code/php/wsnetbeans/doctrine2/tests/Doctrine/Tests/ORM/Functional/DatabaseDriverTest.php:72


/home/benny/code/php/wsnetbeans/doctrine2/tests/Doctrine/Tests/OrmFunctionalTestCase.php:275
@doctrinebot

Comment created by romanb:

This should be fixed for beta2.

@doctrinebot

Issue was closed with resolution "Fixed"

@doctrinebot

Comment created by @jwage:

This is fixed but the test for DDC-214 is failing for me under mysql. Is this failing for anyone else or is it just me?

@jwage jwage was assigned by doctrinebot Dec 6, 2015
@doctrinebot doctrinebot added this to the 2.0-BETA2 milestone Dec 6, 2015
@doctrinebot doctrinebot closed this Dec 6, 2015
@doctrinebot doctrinebot added the Bug label Dec 7, 2015
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment