[ 
https://issues.apache.org/jira/browse/SPARK-49493?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

chaijunjie updated SPARK-49493:
-------------------------------
    Description: 
select * from test.orc_table where load_time<='2024-06-14' limit 10;

select uuid from (select * from test.orc_table where load_time<='2024-06-14' 
limit 10) order by uuid;

!spark-sql.PNG!

  was:!image-2024-09-02-20-50-54-236.png!


> ORDERY BY result is wrong when use sub query
> --------------------------------------------
>
>                 Key: SPARK-49493
>                 URL: https://issues.apache.org/jira/browse/SPARK-49493
>             Project: Spark
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 3.3.1
>            Reporter: chaijunjie
>            Priority: Major
>
> select * from test.orc_table where load_time<='2024-06-14' limit 10;
> select uuid from (select * from test.orc_table where load_time<='2024-06-14' 
> limit 10) order by uuid;
> !spark-sql.PNG!



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to