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

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

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

JIRA tracker@firebirdsql.org
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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider