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/JsonNewtonsoftDomQueryTest.cs#L139
Assert.Equal() Failure: Strings differ
↓ (pos 101)
Expected: ···" AS `j`\r\nWHERE JSON_UNQUOTE(JSON_EXTRACT("···
Actual: ···" AS `j`\r\nWHERE JSON_VALUE(`j`.`CustomerJT"···
↑ (pos 101)
|
|
Functional Tests:
test/EFCore.MySql.FunctionalTests/Query/JsonNewtonsoftDomQueryTest.cs#L270
Assert.Equal() Failure: Strings differ
↓ (pos 108)
Expected: ···"\r\nWHERE JSON_LENGTH(JSON_EXTRACT(`j`.`Cus"···
Actual: ···"\r\nWHERE JSON_LENGTH(CASE JSON_CONTAINS(`j"···
↑ (pos 108)
|
|
Functional Tests:
test/EFCore.MySql.FunctionalTests/Query/JsonNewtonsoftDomQueryTest.cs#L254
Assert.Equal() Failure: Strings differ
↓ (pos 115)
Expected: ···" AS `j`\r\nWHERE JSON_EXTRACT(`j`.`Customer"···
Actual: ···" AS `j`\r\nWHERE JSON_VALUE(`j`.`CustomerJT"···
↑ (pos 115)
|
|
Functional Tests:
test/EFCore.MySql.FunctionalTests/Query/JsonNewtonsoftDomQueryTest.cs#L328
Assert.Equal() Failure: Strings differ
↓ (pos 101)
Expected: ···" AS `j`\r\nWHERE JSON_EXTRACT(`j`.`Customer"···
Actual: ···" AS `j`\r\nWHERE JSON_VALUE(`j`.`CustomerJT"···
↑ (pos 101)
|
|
Functional Tests:
test/EFCore.MySql.FunctionalTests/Query/JsonNewtonsoftDomQueryTest.cs#L431
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/JsonNewtonsoftDomQueryTest.cs#L195
Assert.Equal() Failure: Strings differ
↓ (pos 101)
Expected: ···" AS `j`\r\nWHERE JSON_EXTRACT(`j`.`Customer"···
Actual: ···" AS `j`\r\nWHERE JSON_VALUE(`j`.`CustomerJT"···
↑ (pos 101)
|
|
Functional Tests:
test/EFCore.MySql.FunctionalTests/Query/JsonNewtonsoftDomQueryTest.cs#L125
Assert.Equal() Failure: Strings differ
↓ (pos 101)
Expected: ···" AS `j`\r\nWHERE JSON_UNQUOTE(JSON_EXTRACT("···
Actual: ···" AS `j`\r\nWHERE JSON_VALUE(`j`.`CustomerJO"···
↑ (pos 101)
|
|
Functional Tests:
test/EFCore.MySql.FunctionalTests/Query/JsonNewtonsoftDomQueryTest.cs#L298
Assert.Equal() Failure: Strings differ
↓ (pos 108)
Expected: ···"\r\nWHERE JSON_LENGTH(JSON_EXTRACT(`j`.`Cus"···
Actual: ···"\r\nWHERE JSON_LENGTH(CASE JSON_CONTAINS(`j"···
↑ (pos 108)
|
|
Functional Tests:
test/EFCore.MySql.FunctionalTests/Query/JsonNewtonsoftDomQueryTest.cs#L209
Assert.Equal() Failure: Strings differ
↓ (pos 101)
Expected: ···" AS `j`\r\nWHERE JSON_EXTRACT(`j`.`Customer"···
Actual: ···" AS `j`\r\nWHERE JSON_VALUE(`j`.`CustomerJT"···
↑ (pos 101)
|
|
Functional Tests:
test/EFCore.MySql.FunctionalTests/Query/JsonNewtonsoftDomQueryTest.cs#L312
Assert.Equal() Failure: Strings differ
↓ (pos 101)
Expected: ···" AS `j`\r\nWHERE JSON_UNQUOTE(JSON_EXTRACT("···
Actual: ···" AS `j`\r\nWHERE JSON_VALUE(`j`.`CustomerJT"···
↑ (pos 101)
|
Loading