[Firebird-net-provider] [FB-Tracker] Created: (DNET-700) Migration Sql generate for AddColumn operation for non nullable Guid field is wrong

[Fabiano R. (JIRA) <tr...@fi...>]

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