Details

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

      Description

      SQLite doesn't support ENUMS!

      But when I try create the schema of the following Entity Doctrine generates this "CREATE TABLE" - Statement:

      CREATE TABLE Entity ([...] NOT NULL, taxation ENUM('incl', 'excl'), maxNumbe[...]
      
      class Entity {
      ...
      
          /**
           * @var string
           *
           * @ORM\Column(type="string", columnDefinition="ENUM('incl', 'excl')")
           */
          private $taxation = self::TAXATION_INCL;
      
      ...
      }
      

      Produces this error:

      SQLSTATE[HY000]: General error: 1 near "'incl'": syntax error'

        Activity

        Hide
        Marco Pivetta added a comment -

        Usage of

        columnDefinition

        in annotations or generally metadata mappings is all about vendor specific syntax. `columnDefinition` is designed to allow overriding the default ORM column generated DDL to build vendor specific syntax/types, therefore the issue is invalid

        Show
        Marco Pivetta added a comment - Usage of columnDefinition in annotations or generally metadata mappings is all about vendor specific syntax. `columnDefinition` is designed to allow overriding the default ORM column generated DDL to build vendor specific syntax/types, therefore the issue is invalid

          People

          • Assignee:
            Marco Pivetta
            Reporter:
            Andy Rosslau
          • Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: