[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

Linux Kernel 2.6.38
MySQL 5.5.11
PHP 5.3.6


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.

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 Tue Dec 01 08:11:03 EST 2015 using JIRA 6.4.10#64025-sha1:5b8b74079161cd76a20ab66dda52747ee6701bd6.