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
Assert.Equal() Failure: Strings differ
↓ (pos 93)
Expected: ···" AS `j`\r\nWHERE JSON_UNQUOTE(JSON_EXTRACT("···
Actual: ···" AS `j`\r\nWHERE JSON_VALUE(`j`.`Customer`,"···
↑ (pos 93)
|
|
Functional Tests
Assert.Equal() Failure: Strings differ
↓ (pos 93)
Expected: ···" AS `j`\r\nWHERE JSON_EXTRACT(`j`.`Customer"···
Actual: ···" AS `j`\r\nWHERE JSON_VALUE(`j`.`Customer`,"···
↑ (pos 93)
|
|
Functional Tests
Assert.Equal() Failure: Strings differ
↓ (pos 93)
Expected: ···" AS `j`\r\nWHERE JSON_UNQUOTE(JSON_EXTRACT("···
Actual: ···" AS `j`\r\nWHERE JSON_VALUE(`j`.`Customer`,"···
↑ (pos 93)
|
|
Functional Tests
Assert.Equal() Failure: Strings differ
↓ (pos 93)
Expected: ···" AS `j`\r\nWHERE JSON_EXTRACT(`j`.`Customer"···
Actual: ···" AS `j`\r\nWHERE JSON_VALUE(`j`.`Customer`,"···
↑ (pos 93)
|
|
Functional Tests
Assert.Equal() Failure: Strings differ
↓ (pos 93)
Expected: ···" AS `j`\r\nWHERE JSON_UNQUOTE(JSON_EXTRACT("···
Actual: ···" AS `j`\r\nWHERE JSON_VALUE(`j`.`ToplevelAr"···
↑ (pos 93)
|
|
Functional Tests
Assert.Equal() Failure: Strings differ
↓ (pos 93)
Expected: ···" AS `j`\r\nWHERE JSON_EXTRACT(`j`.`Customer"···
Actual: ···" AS `j`\r\nWHERE JSON_VALUE(`j`.`Customer`,"···
↑ (pos 93)
|
|
Functional Tests
Assert.Equal() Failure: Strings differ
↓ (pos 93)
Expected: ···" AS `j`\r\nWHERE JSON_UNQUOTE(JSON_EXTRACT("···
Actual: ···" AS `j`\r\nWHERE JSON_VALUE(`j`.`Customer`,"···
↑ (pos 93)
|
|
Functional Tests
Assert.Equal() Failure: Strings differ
↓ (pos 93)
Expected: ···" AS `j`\r\nWHERE JSON_EXTRACT(`j`.`Customer"···
Actual: ···" AS `j`\r\nWHERE JSON_VALUE(`j`.`Customer`,"···
↑ (pos 93)
|
|
Functional Tests
Assert.Equal() Failure: Strings differ
↓ (pos 93)
Expected: ···" AS `j`\r\nWHERE JSON_EXTRACT(`j`.`Customer"···
Actual: ···" AS `j`\r\nWHERE JSON_VALUE(`j`.`Customer`,"···
↑ (pos 93)
|
|
Functional Tests
Assert.Equal() Failure: Strings differ
↓ (pos 93)
Expected: ···" AS `j`\r\nWHERE JSON_EXTRACT(`j`.`Customer"···
Actual: ···" AS `j`\r\nWHERE JSON_VALUE(`j`.`Customer`,"···
↑ (pos 93)
|
Loading