U4-1904 - Incorrect Quoting of True/False Keywords in MySQL

Created by Brian Powell 12 Mar 2013, 23:31:25 Updated by Sebastiaan Janssen 25 Mar 2013, 11:42:38

Duplicates: U4-1905

Relates to: U4-1905

MySQL interprets quoted versions of 'True' and 'False' as strings, not boolean keywords. Thus, a query with a WHERE clause of Newest = 'True' actually does not return records where the Newest field is true, it actually records where Newest is False.

This problem lies in Umbraco.Core/Persistence/Querying/PocoToSqlExpressionHelper.cs. It shows up with incorrect page publish status icons when using MySQL.

Comments

Brian Powell 12 Mar 2013, 23:31:40

I have submitted a pull request to fix this issue at http://umbraco.codeplex.com/SourceControl/network/forks/Bitmapped/PublishIconStatus/contribution/4216


Priority: Normal

Type: Bug

State: Duplicate

Assignee:

Difficulty: Normal

Category:

Backwards Compatible: True

Fix Submitted: Pull request

Affected versions: 6.0.2

Due in version:

Sprint:

Story Points:

Cycle: