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
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
