Details

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

        Issue Links

          Activity

          Hide
          ocramius 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
          ocramius 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:
              ocramius Marco Pivetta
              Reporter:
              rosslau@my-hammer.de Andy Rosslau
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: