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 -
        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 ]

          People

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

            Dates

            • Created:
              Updated:
              Resolved: