Use JSON_VALUE() for scalar JSON values if available or workaround weird JSON_EXTRACT() behavior in regards to null
otherwise
#197
Annotations
10 errors
Functional Tests:
test/EFCore.MySql.FunctionalTests/Query/JsonMicrosoftDomQueryTest.cs#L284
Assert.Equal() Failure: Strings differ
↓ (pos 103)
Expected: ···" AS `j`\r\nWHERE JSON_UNQUOTE(JSON_EXTRACT("···
Actual: ···" AS `j`\r\nWHERE JSON_VALUE(`j`.`CustomerEl"···
↑ (pos 103)
|
Functional Tests:
test/EFCore.MySql.FunctionalTests/Query/JsonMicrosoftDomQueryTest.cs#L195
Assert.Equal() Failure: Strings differ
↓ (pos 103)
Expected: ···" AS `j`\r\nWHERE JSON_EXTRACT(`j`.`Customer"···
Actual: ···" AS `j`\r\nWHERE JSON_VALUE(`j`.`CustomerEl"···
↑ (pos 103)
|
Functional Tests:
test/EFCore.MySql.FunctionalTests/Query/JsonMicrosoftDomQueryTest.cs#L238
Assert.Equal() Failure: Strings differ
↓ (pos 103)
Expected: ···" AS `j`\r\nWHERE JSON_EXTRACT(`j`.`Customer"···
Actual: ···" AS `j`\r\nWHERE JSON_VALUE(`j`.`CustomerEl"···
↑ (pos 103)
|
Functional Tests:
test/EFCore.MySql.FunctionalTests/Query/JsonMicrosoftDomQueryTest.cs#L139
Assert.Equal() Failure: Strings differ
↓ (pos 103)
Expected: ···" AS `j`\r\nWHERE JSON_UNQUOTE(JSON_EXTRACT("···
Actual: ···" AS `j`\r\nWHERE JSON_VALUE(`j`.`CustomerEl"···
↑ (pos 103)
|
Functional Tests:
test/EFCore.MySql.FunctionalTests/Query/JsonMicrosoftDomQueryTest.cs#L270
Assert.Equal() Failure: Strings differ
↓ (pos 110)
Expected: ···"\r\nWHERE JSON_LENGTH(JSON_EXTRACT(`j`.`Cus"···
Actual: ···"\r\nWHERE JSON_LENGTH(CASE JSON_CONTAINS(`j"···
↑ (pos 110)
|
Functional Tests:
test/EFCore.MySql.FunctionalTests/Query/JsonMicrosoftDomQueryTest.cs#L223
Assert.Equal() Failure: Strings differ
↓ (pos 103)
Expected: ···" AS `j`\r\nWHERE JSON_EXTRACT(`j`.`Customer"···
Actual: ···" AS `j`\r\nWHERE JSON_VALUE(`j`.`CustomerEl"···
↑ (pos 103)
|
Functional Tests:
test/EFCore.MySql.FunctionalTests/Query/JsonMicrosoftDomQueryTest.cs#L403
Assert.Equal() Failure: Strings differ
↓ (pos 61)
Expected: ···"j`\r\nWHERE JSON_TYPE(JSON_EXTRACT(`j`.`Cus"···
Actual: ···"j`\r\nWHERE JSON_TYPE(CASE JSON_CONTAINS(`j"···
↑ (pos 61)
|
Functional Tests:
test/EFCore.MySql.FunctionalTests/Query/JsonMicrosoftDomQueryTest.cs#L300
Assert.Equal() Failure: Strings differ
↓ (pos 103)
Expected: ···" AS `j`\r\nWHERE JSON_EXTRACT(`j`.`Customer"···
Actual: ···" AS `j`\r\nWHERE JSON_VALUE(`j`.`CustomerEl"···
↑ (pos 103)
|
Functional Tests:
test/EFCore.MySql.FunctionalTests/Query/JsonMicrosoftDomQueryTest.cs#L209
Assert.Equal() Failure: Strings differ
↓ (pos 103)
Expected: ···" AS `j`\r\nWHERE JSON_EXTRACT(`j`.`Customer"···
Actual: ···" AS `j`\r\nWHERE JSON_VALUE(`j`.`CustomerEl"···
↑ (pos 103)
|
Functional Tests:
test/EFCore.MySql.FunctionalTests/Query/JsonMicrosoftDomQueryTest.cs#L167
Assert.Equal() Failure: Strings differ
↓ (pos 103)
Expected: ···" AS `j`\r\nWHERE JSON_EXTRACT(`j`.`Customer"···
Actual: ···" AS `j`\r\nWHERE JSON_VALUE(`j`.`CustomerEl"···
↑ (pos 103)
|
Loading