Bug #104919 MySQLCollateExpression.cs is causing EFCore to throw InvalidOperationException
Submitted: 13 Sep 2021 4:39 Modified: 8 Mar 1:56
Reporter: Wang Shiyao (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:Connector / NET Severity:S1 (Critical)
Version:MySql.EntityFrameworkCore 5.0.5 OS:Any
Assigned to: CPU Architecture:Any
Tags: EFCore, EntityFrameworkCore, MySql.EntityFrameworkCore, MySQLCollateExpression

File: Maximum allowed size is 50MB.
Description:
Privacy:

If the data you need to attach is more than 50MB, you should create a compressed archive of the data, split it to 50MB chunks, and upload each of them as a separate attachment.

To split a large file:

[13 Sep 2021 4:41] Wang Shiyao
1_SQLExpressionTree.png

Attachment: 1_SQLExpressionTree.png (image/png, text), 70.11 KiB.

[13 Sep 2021 4:41] Wang Shiyao
2_BuildSQL.png

Attachment: 2_BuildSQL.png (image/png, text), 30.82 KiB.

[13 Sep 2021 4:41] Wang Shiyao
3_UnknownExpression.png

Attachment: 3_UnknownExpression.png (image/png, text), 114.85 KiB.

[13 Sep 2021 4:42] Wang Shiyao
4_ExceptionThrown.png

Attachment: 4_ExceptionThrown.png (image/png, text), 33.31 KiB.

[13 Sep 2021 4:43] Wang Shiyao
5_SQLExpressionTreeRealSQL.png

Attachment: 5_SQLExpressionTreeRealSQL.png (image/png, text), 31.35 KiB.

[13 Sep 2021 4:45] Wang Shiyao
SQL Statements that creates a sample table to repro this bug

Attachment: BugRepro-SQL.sql (application/octet-stream, text), 203 bytes.

[13 Sep 2021 4:46] Wang Shiyao
Sample C# code that can repro this bug

Attachment: BugRepro-CSharp.cs (text/plain), 896 bytes.