lgbo-ustc opened a new issue, #7550:
URL: https://github.com/apache/incubator-gluten/issues/7550
### Backend
CH (ClickHouse)
### Bug description
When use the result of `get_json_object` as the 1st argument of `IN`, the
result in null
```sql
0: jdbc:hive2://localhost:10000> select s, get_json_object(s, '$.a') in
('1', '2') from t_json;
+------------+--------------------------------------+
| s | (get_json_object(s, $.a) IN (1, 2)) |
+------------+--------------------------------------+
| {'a':'1'} | NULL |
| {'a':'2'} | NULL |
+------------+--------------------------------------+
```
### Spark version
None
### Spark configurations
_No response_
### System information
_No response_
### Relevant logs
```bash
The `CH` plan is
Expression (Rename Output)
Header: s#31 Nullable(String)
#49 Nullable(UInt8)
Actions: INPUT : 0 -> s Nullable(String) : 0
INPUT : 1 -> in(get_json_object(s,$.a_9),__set_10) Nullable(UInt8)
: 1
ALIAS s :: 0 -> s#31 Nullable(String) : 2
ALIAS in(get_json_object(s,$.a_9),__set_10) :: 1 -> #49
Nullable(UInt8) : 0
Positions: 2 0
Expression (Project)
Header: s Nullable(String)
in(get_json_object(s,$.a_9),__set_10) Nullable(UInt8)
Actions: INPUT : 0 -> s Nullable(String) : 0
COLUMN Const(String) -> $.a_9 String : 1
COLUMN Set -> __set_10 Set : 2
FUNCTION get_json_object(s : 0, $.a_9 :: 1) ->
get_json_object(s,$.a_9) Nullable(String) : 3
FUNCTION in(get_json_object(s,$.a_9) :: 3, __set_10 :: 2) ->
in(get_json_object(s,$.a_9),__set_10) Nullable(UInt8) : 1
ALIAS in(get_json_object(s,$.a_9),__set_10) :: 1 ->
in(get_json_object(s,$.a_9),__set_10) Nullable(UInt8) : 2
Positions: 0 2
SubstraitFileSourceStep (read local files)
Header: s Nullable(String)
```
```
--
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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
