Migration Sql generate for AddColumn operation for non nullable Guid field is 
wrong
-----------------------------------------------------------------------------------

                 Key: DNET-700
                 URL: http://tracker.firebirdsql.org/browse/DNET-700
             Project: .NET Data provider
          Issue Type: Bug
          Components: Entity Framework support
    Affects Versions: 5.1.1.0
         Environment: Firebird 3, Windows 10, 64 bits
            Reporter: Fabiano Rezende
            Assignee: Jiri Cincura


The Migration below

public partial class MyMigration : DbMigration
{
        public override void Up()
        {
                AddColumn("dbo.TableName", "Id", c => c.Guid(nullable: false));
        }
}

Generats the Sql:
ALTER TABLE "TableName" ADD "Id" CHAR(16) CHARACTER SET OCTETS DEFAULT 
CHAR_TO_UUID('00000000-0000-0000-0000-000000000000') NOT NULL

Firebird does not recognize DEFAULT 
CHAR_TO_UUID('00000000-0000-0000-0000-000000000000')


-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

------------------------------------------------------------------------------
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Reply via email to