Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Migration concatenates strings that are escaped #23518

Closed
nicolaeburnariu opened this issue Nov 28, 2020 · 4 comments
Closed

Migration concatenates strings that are escaped #23518

nicolaeburnariu opened this issue Nov 28, 2020 · 4 comments
Assignees
Labels
area-migrations-seeding closed-fixed The issue has been fixed and is/will be included in the release indicated by the issue milestone. customer-reported regression Servicing-approved type-bug
Milestone

Comments

@nicolaeburnariu
Copy link

Hi,

Recently we made the upgrade to EF 5.0. After the upgrade the migration is no working anymore and we get the error message "The concat function requires 2 to 254 arguments.". After some investigation we discover that at some point in the early migrations we had for seed data some escaped strings. From the logs we realise that the strings are split (by \n) and concatenated.

In the seed json we have something like:

[
 {
  "Id": 1,
  "Data": "{\r\n \"property\": \"value\" \r\n}" 
 }
]

In the migration file we will have something like:

migrationBuilder.InsertData(
                table: "TableName",
                columns: new[] { "Id", "Data" },
                values: new object[,]
                {
                    { 1, @"{ 
                    ""property"" : ""value""
                               }" },
                });

The sql code will look similar to:

INSERT INTO [TableName] ([Id],[Data])
VALUES (1, CONCAT(N'{', NCHAR(13), NCHAR(10), N'                  "property": "value", NCHAR(13), NCHAR(10), N'                }' )

For complex and long data we can easy reach the limit from error.

@sergtk
Copy link

sergtk commented Nov 28, 2020

I got the same error after update to .NET 5.0. As a workaround I replaced new lines with spaces in my seed data.
I also have json on input.

Anyway this is workaround which not always applicable, and it would be good to have a fix of the bug.

@ajcvickers
Copy link
Member

@nicolaeburnariu Do you need the newlines in the inserted data? If not, the best thing to do is to strip them out while generating the C# code from the JSON? Also, we are curious what you have in the seed data that results in more than 254 concat arguments? Is this because you are storing large formatted JSON objects in the database?

@nicolaeburnariu
Copy link
Author

@nicolaeburnariu Do you need the newlines in the inserted data? If not, the best thing to do is to strip them out while generating the C# code from the JSON?

No, we don't need the newlines, actually since that migration we already updated the seed data to not have any escaped characters. The migration file that is causing this error is an old migration that was generated long time ago. Probably we will try to remove the newlines from the autogenerated migration file, hope there will be no side effects.

Also, we are curious what you have in the seed data that results in more than 254 concat arguments? Is this because you are storing large formatted JSON objects in the database?

Yes, we have a fairly large JSON stored in the database and we use the migration the seed the default value.

@smitpatel smitpatel assigned smitpatel and unassigned smitpatel Dec 8, 2020
@smitpatel
Copy link
Contributor

CONCAT(NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), CONCAT(NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), CONCAT(NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), CONCAT(NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), CONCAT(NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), CONCAT(NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), CONCAT(NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), CONCAT(NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10), NCHAR(13), NCHAR(10)))))))))

@smitpatel smitpatel assigned smitpatel and unassigned bricelam Dec 9, 2020
@smitpatel smitpatel added the closed-fixed The issue has been fixed and is/will be included in the release indicated by the issue milestone. label Dec 9, 2020
@ajcvickers ajcvickers modified the milestones: 6.0.0, 5.0.2 Dec 10, 2020
This was referenced Mar 15, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
area-migrations-seeding closed-fixed The issue has been fixed and is/will be included in the release indicated by the issue milestone. customer-reported regression Servicing-approved type-bug
Projects
None yet
Development

No branches or pull requests

6 participants