[VL] Result mismatch while using get_json_object function with a string wrapped in single quotes
Open
bug
triage
- Dominant language
- Scala
- Stars
- 1.6k
- Forks
- 657
- Avg merge
- 2d 14h
- Merged PRs (30d)
- 80
Description
### Backend
VL (Velox)
### Bug description
Reproduce SQL: `select get_json_object("{'g': 1}", '$.g');`
Gluten result: `NULL`
vanilla spark result: `1`
It appears that Simdjson lib requires double quotes and will not accept single quotes for string, but Jackson lib supports both double quotes and single quotes.
### Spark version
Spark-3.5.x
### Spark configurations
_No response_
### System information
_No response_
### Relevant logs
```bash
```
Contributor guide
Assessment
This issue has not been assessed yet.