Uploaded image for project: 'Doctrine 2 - ORM'
  1. Doctrine 2 - ORM
  2. DDC-24

text type not portable (works only on MySQL)

    Details

    • Type: Bug
    • Status: Closed
    • Priority: 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

        itoijala Ismo Toijala created issue -
        romanb 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 ]
        romanb Roman S. Borschel made changes -
        Status Open [ 1 ] In Progress [ 3 ]
        romanb Roman S. Borschel made changes -
        Status In Progress [ 3 ] Closed [ 6 ]
        Resolution Fixed [ 1 ]
        romanb Roman S. Borschel made changes -
        Component/s ORM [ 10012 ]
        Component/s DBAL [ 10011 ]
        beberlei Benjamin Eberlei made changes -
        Workflow jira [ 10127 ] jira-feedback [ 15419 ]
        beberlei Benjamin Eberlei made changes -
        Workflow jira-feedback [ 15419 ] jira-feedback2 [ 17283 ]
        beberlei Benjamin Eberlei made changes -
        Workflow jira-feedback2 [ 17283 ] jira-feedback3 [ 19540 ]

          People

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

            Dates

            • Created:
              Updated:
              Resolved: