[FB-Tracker] Created: (DNET-707) Invalid SQL generated for migration if changing a column from null to not null

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

[FB-Tracker] Created: (DNET-707) Invalid SQL generated for migration if changing a column from null to not null

JIRA tracker@firebirdsql.org
Invalid SQL generated for migration if changing a column from null to not null
------------------------------------------------------------------------------

                 Key: DNET-707
                 URL: http://tracker.firebirdsql.org/browse/DNET-707
             Project: .NET Data provider
          Issue Type: Bug
          Components: Entity Framework support
    Affects Versions: 5.5.0.0
         Environment: Windows 7, VS 2015 Enterprise, EF 6.1.3, EntityFramework.Firebird 5.5.0, FirebirdSql.Data.FirebirdClient 5.5.0, Firebird 3.0.0.32485
            Reporter: Charles J Christie II
            Assignee: Jiri Cincura


I changed a column's type and null constraint during development of a new application. I found out later that Firebird doesn't support that through the ALTER TABLE ALTER COLUMN syntax, and that other options are available here: http://www.firebirdfaq.org/faq103/

Here's the line that was generated by migrations when I changed the data type on a property from Nullable<int> to long:

ALTER TABLE "Booklets" ALTER COLUMN "File_Size" TYPE BIGINT NOT NULL
;

Apparently, according to that page, all admin tools change the value on the system table. Maybe we should do that here too.

--
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

       

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
_______________________________________________
Firebird-net-provider mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider