NEUpanning opened a new issue, #6845:
URL: https://github.com/apache/incubator-gluten/issues/6845
### Backend
VL (Velox)
### Bug description
SQL:
```
SELECT
t.partner_id,
t.qualifi_name as name,
t.qualifi_type as type_id,
row_number() over(partition by partner_id,qualifi_type order by
modify_time,create_time,end_date desc) row_id
FROM
tbl
WHERE partition_date = '2024-08-02'
and status = 1
AND qualifi_type in (201,202,1);
```
gluten results that mismatch with vanilla:
```
714328 临海市嘴爱烘焙坊 1 1
714328 徐新亮 1 2
```
vanilla results:
```
714328 徐新亮 1 1
714328 临海市嘴爱烘焙坊 1 2
```
the original rows of mismatch results
```
partner_id | qualifi_type | qualifi_name | modify_time |
create_time | end_date
------------+--------------+------------------+---------------------+---------------------+---------------------
714328 | 1 | 徐新亮 | 2019-06-08 05:53:49 |
2019-06-08 05:53:49 | 2099-01-01 00:00:00
714328 | 1 | 临海市嘴爱烘焙坊 | 2019-06-08 05:53:49 | 2019-06-08
05:53:49 | 2099-01-01 00:00:00
```
It seems that `row_number() over(...)` produced different result for the
same order of rows (the columns used to sort the two rows are equal).
Here is gluten physical plan:
<img width="377" alt="Screenshot 2024-08-14 at 20 28 04"
src="https://github.com/user-attachments/assets/ba4df1fa-1969-4589-8723-22cd72c1ead3";>
gluten version : 1.2-rc
### Spark version
None
### Spark configurations
_No response_
### System information
_No response_
### Relevant logs
_No response_
--
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]
