I'm having issues with the script that is being generated when I use Update-Database -script. The problem is, that when I run the script via an external SQL IDE for DB2 it fails when trying to insert into the Model field of MigrationHistory__.
The issue is that the script generated uses string concatenation which has a limitation of 32,700 bytes in length.The length resulting from "CONCAT" is greater than "0000032700".
Code: Select all
INSERT INTO MigrationHistory__ (MigrationId, ContextKey, Model, ProductVersion) VALUES ('201707070625113_Init', 'DB.DB2Migrations.Migrations.Configuration', CAST(X'1F8B' || X'273F76' AS BLOB(66820)), '6.1.3-40302');
My questions:
- is this normal behavior of the SQL generator?
- if yes, is there an "automatic" workaround (not having to do this manually every time)?
- if this is a bug, is there an estimate on how soon it can be fixed?