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 91)
Expected: ···"` AS `j`\nWHERE JSON_UNQUOTE(JSON_EXTRACT("···
Actual: ···"` AS `j`\nWHERE JSON_VALUE(`j`.`ToplevelAr"···
↑ (pos 91)
|
|
Functional Tests
Assert.Equal() Failure: Strings differ
↓ (pos 103)
Expected: ···"` AS `j`\nWHERE JSON_EXTRACT(`j`.`Customer"···
Actual: ···"` AS `j`\nWHERE JSON_VALUE(`j`.`Customer`,"···
↑ (pos 103)
|
|
Functional Tests
Assert.Equal() Failure: Strings differ
↓ (pos 91)
Expected: ···"` AS `j`\nWHERE JSON_EXTRACT(`j`.`Customer"···
Actual: ···"` AS `j`\nWHERE JSON_VALUE(`j`.`Customer`,"···
↑ (pos 91)
|
|
Functional Tests
Assert.Equal() Failure: Strings differ
↓ (pos 91)
Expected: ···"` AS `j`\nWHERE JSON_EXTRACT(`j`.`Customer"···
Actual: ···"` AS `j`\nWHERE JSON_VALUE(`j`.`Customer`,"···
↑ (pos 91)
|
|
Functional Tests
Assert.Equal() Failure: Strings differ
↓ (pos 91)
Expected: ···"` AS `j`\nWHERE JSON_UNQUOTE(JSON_EXTRACT("···
Actual: ···"` AS `j`\nWHERE JSON_VALUE(`j`.`Customer`,"···
↑ (pos 91)
|
|
Functional Tests
Assert.Equal() Failure: Strings differ
↓ (pos 64)
Expected: ···"HERE JSON_TYPE(JSON_EXTRACT(`j`.`Customer"···
Actual: ···"HERE JSON_TYPE(JSON_VALUE(`j`.`Customer`,"···
↑ (pos 64)
|
|
Functional Tests
Assert.Equal() Failure: Strings differ
↓ (pos 91)
Expected: ···"` AS `j`\nWHERE JSON_EXTRACT(`j`.`Customer"···
Actual: ···"` AS `j`\nWHERE JSON_VALUE(`j`.`Customer`,"···
↑ (pos 91)
|
|
Functional Tests
Assert.Equal() Failure: Strings differ
↓ (pos 78)
Expected: ···"OTE(JSON_QUOTE(JSON_UNQUOTE(JSON_EXTRACT("···
Actual: ···"OTE(JSON_QUOTE(JSON_VALUE(`j`.`Customer`,"···
↑ (pos 78)
|
|
Functional Tests
Assert.Equal() Failure: Strings differ
↓ (pos 96)
Expected: ···"`j`\nWHERE CAST(JSON_UNQUOTE(JSON_EXTRACT("···
Actual: ···"`j`\nWHERE CAST(JSON_VALUE(`j`.`Customer`,"···
↑ (pos 96)
|
|
Functional Tests
Assert.Equal() Failure: Strings differ
↓ (pos 91)
Expected: ···"` AS `j`\nWHERE JSON_EXTRACT(`j`.`Customer"···
Actual: ···"` AS `j`\nWHERE JSON_VALUE(`j`.`Customer`,"···
↑ (pos 91)
|
Loading