Doctrine 1
  1. Doctrine 1
  2. DC-322

Data dump fails on tables with quoted identifiers

    Details

    • Type: Bug Bug
    • Status: Open
    • Priority: Major Major
    • Resolution: Unresolved
    • Affects Version/s: 1.2.0
    • Fix Version/s: None
    • Component/s: Data Fixtures
    • Labels:
      None
    • Environment:
      linux, apache 2, mysql 5.1, php 5.2

      Description

      While dumping a table with a quoted identifier `numeric`, doctrine failed because the constructed query had an invalid alias the field: c__`numeric`.

      Output:
      SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`numeric`, c.alpha3 AS c_alpha3, c.alpha2 AS calpha2 FROM country_codes c' at line 1. Failing Query: "SELECT c.country AS ccountry, c.`numeric` AS c`numeric`, c.alpha3 AS calpha3, c.alpha2 AS c_alpha2 FROM country_codes c"

      I know that using quoted identifiers is discouraged but I think this could be easily solvable.

      Thanks.

        Activity

        Massimiliano Torromeo created issue -

          People

          • Assignee:
            Jonathan H. Wage
            Reporter:
            Massimiliano Torromeo
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated: