Doctrine DBAL
  1. Doctrine DBAL
  2. DBAL-616

[GH-379] Fix #DBAL-615 - ALTER with reserved keywords

    Details

    • Type: Bug Bug
    • Status: Resolved
    • Priority: Major Major
    • Resolution: Invalid
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Security Level: All
    • Labels:
      None

      Description

      This issue is created automatically through a Github pull request on behalf of Thinkscape:

      Url: https://github.com/doctrine/dbal/pull/379

      Message:

      PR #302 introduced platform quoting for manipulation of PK, FK and indexes. Alter queries are left unquoted, which means that ALTER with table names that happen to be reserved platform keywords, will fail.
      For example:
      `````sql
      ALTER TABLE order DROP FOREIGN KEY FK_F5299398D5289B7F;
      ALTER TABLE set DROP FOREIGN KEY FK_E61425DC1BF22D93;
      ALTER TABLE storage ADD CONSTRAINT FK_547A1B3487068541 FOREIGN KEY (`addressId`) REFERENCES `address` (`id`);
      ````
      http://www.doctrine-project.org/jira/browse/DBAL-615

        Activity

        Doctrine Bot created issue -
        Hide
        Doctrine Bot added a comment -

        A related Github Pull-Request [GH-379] was closed:
        https://github.com/doctrine/dbal/pull/379

        Show
        Doctrine Bot added a comment - A related Github Pull-Request [GH-379] was closed: https://github.com/doctrine/dbal/pull/379
        Benjamin Eberlei made changes -
        Field Original Value New Value
        Status Open [ 1 ] Resolved [ 5 ]
        Resolution Invalid [ 6 ]

        This list may be incomplete, as errors occurred whilst retrieving source from linked applications:

        • Request to http://www.doctrine-project.org/fisheye/ failed: Error in remote call to 'FishEye 0 (http://www.doctrine-project.org/fisheye/)' (http://www.doctrine-project.org/fisheye) [AbstractRestCommand{path='/rest-service-fe/search-v1/crossRepositoryQuery', params={query=DBAL-616, expand=changesets[0:20].revisions[0:29],reviews}, methodType=GET}] : Received status code 503 (Service Temporarily Unavailable)

          People

          • Assignee:
            Benjamin Eberlei
            Reporter:
            Doctrine Bot
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: