[DBAL-115] SchemaManager doesn't quote table names for MySQL Created: 28/Apr/11  Updated: 19/Jun/11  Resolved: 19/Jun/11

Status: Resolved
Project: Doctrine DBAL
Component/s: Schema Managers
Affects Version/s: 2.0.4
Fix Version/s: None

Type: Bug Priority: Major
Reporter: Zoran Zaric Assignee: Benjamin Eberlei
Resolution: Duplicate Votes: 1
Labels: None
Environment:

Linux Kernel 2.6.38
MySQL 5.5.11
PHP 5.3.6



 Description   

Using a reserved word as a table name only works for schema creation not dropping.

Example Enity:
/**

  • @Entity
  • @Table(name="`call`")
    */

class Call {
/**

  • @Column(name="id", type="integer", nullable=false)
  • @Id
  • @GeneratedValue(strategy="IDENTITY")
  • @var integer $id
    */
    private $id;
    }

The table name is quoted. creation works, dropping doesn't even after changing the table name to a not reserved word.



 Comments   
Comment by Benjamin Eberlei [ 19/Jun/11 ]

This problem is a little more complicated, it will be fixed in DBAL-96 probably for 2.2

Generated at Wed Sep 03 05:37:48 UTC 2014 using JIRA 6.2.3#6260-sha1:63ef1d6dac3f4f4d7db4c1effd405ba38ccdc558.