apache / apache/gluten

[VL] Result mismatch while using get_json_object function with a string wrapped in single quotes

Open
#8,754 6 comments 0 reactions 0 assignees View on GitHub
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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.