MySQL Bugs: #70527: Convert to LIKE instead of LOCATE when using Contains in EF Code First

Bug #70527	Convert to LIKE instead of LOCATE when using Contains in EF Code First
Submitted:	4 Oct 2013 21:46	Modified:	6 Dec 2013 23:16
Reporter:	Roberto Ezequiel Garcia Ballesteros	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	Connector / NET	Severity:	S3 (Non-critical)
Version:	6.7.4.0	OS:	Any
Assigned to:	Fernando Gonzalez.Sanchez	CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
When generating the SQL query on a Contains Linq expression using EF Code First, it uses LOCATE instead of LIKE. It could have different results depending on accent and case sensitive data.

How to repeat:
Create a Linq expression using Contains in EF Code First.

Suggested fix:
Modify the sql generator to use LIKE instead of LOCATE in EF Code First.