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
|
