Doctrine 2 - ORM
  1. Doctrine 2 - ORM
  2. DDC-24

text type not portable (works only on MySQL)

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Blocker Blocker
    • Resolution: Fixed
    • Affects Version/s: 2.0-ALPHA2
    • Fix Version/s: 2.0-ALPHA2
    • Component/s: ORM
    • Security Level: All
    • Labels:
      None

      Description

      The text type is not portable to other RDBMS than MySQL. To support the text type, a platform must implement the method getClobDeclarationSql(array $field). Currently only MySqlPlatform has this method. This means that attempting to use the CLI tool to create a schema with a text column using another RDBMS fails with the following error:

      Fatal error: Call to undefined method Doctrine\DBAL\Platforms\SqlitePlatform::getClobDeclarationSql() in D:\Projects\Test\tools\sandbox\lib\Doctrine\DBAL\Types\TextType.php on line 15

      I believe at least Sqlite supports the CLOB type.

      Either the text type should be supported by all platforms or the documentation should be revised. Currently it says:

      "All Doctrine Mapping Types that ship with Doctrine are fully portable between different RDBMS."

      This makes easy testing of models using sqlite with minimum configuration impossible with the text type.

        Activity

        Ismo Toijala created issue -
        Hide
        Roman S. Borschel added a comment -

        Thanks. We will try to address this as soon as possible. This is just an oversight in the implementation. The text type can definitely be made portable across all platforms.

        Show
        Roman S. Borschel added a comment - Thanks. We will try to address this as soon as possible. This is just an oversight in the implementation. The text type can definitely be made portable across all platforms.
        Roman S. Borschel made changes -
        Field Original Value New Value
        Fix Version/s 2.0-ALPHA2 [ 10028 ]
        Affects Version/s 2.0-ALPHA2 [ 10028 ]
        Priority Major [ 3 ] Blocker [ 1 ]
        Roman S. Borschel made changes -
        Status Open [ 1 ] In Progress [ 3 ]
        Roman S. Borschel made changes -
        Status In Progress [ 3 ] Closed [ 6 ]
        Resolution Fixed [ 1 ]
        Roman S. Borschel made changes -
        Component/s ORM [ 10012 ]
        Component/s DBAL [ 10011 ]
        Benjamin Eberlei made changes -
        Workflow jira [ 10127 ] jira-feedback [ 15419 ]
        Benjamin Eberlei made changes -
        Workflow jira-feedback [ 15419 ] jira-feedback2 [ 17283 ]
        Benjamin Eberlei made changes -
        Workflow jira-feedback2 [ 17283 ] jira-feedback3 [ 19540 ]

        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=DDC-24, expand=changesets[0:20].revisions[0:29],reviews}, methodType=GET}] : Received status code 503 (Service Temporarily Unavailable)

          People

          • Assignee:
            Roman S. Borschel
            Reporter:
            Ismo Toijala
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: