snuyanzin commented on PR #24704:
URL: https://github.com/apache/flink/pull/24704#issuecomment-2125483868
hm... I tested with the latest version and noticed this strange behavior:
I use same query
```sql
SELECT JSON_QUERY('{"a":[{"c":null},{"c":"c2"}]}', 'lax $.a[*].c' RETURNING
ARRAY<STRING> ERROR ON ERROR);
```
for this the result is
```
[NULL, c2]
```
Now the only thing I change is using uppercase `null` in json or just some
of letters in uppercase like
```sql
SELECT JSON_QUERY('{"a":[{"c":Null},{"c":"c2"}]}', 'lax $.a[*].c' RETURNING
ARRAY<STRING> ERROR ON ERROR);
```
and now the result is different, just
```
Did I do something wrong here?
<NULL>
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
