-- Automatically generated by SQLQueryTestSuite
-- Number of queries: 12
-- !query 0
create temporary view data as select * from values
(1, 1),
(1, 2),
(2, 1),
(2, 2),
(3, 1),
(3, 2)
as data(a, b)
-- !query 0 schema
struct<>
-- !query 0 output
-- !query 1
select * from data order by 1 desc
-- !query 1 schema
struct<a:int,b:int>
-- !query 1 output
3 1
3 2
2 1
2 2
1 1
1 2
-- !query 2
select * from data order by 1 desc, b desc
-- !query 2 schema
struct<a:int,b:int>
-- !query 2 output
3 2
3 1
2 2
2 1
1 2
1 1
-- !query 3
select * from data order by 1 desc, 2 desc
-- !query 3 schema
struct<a:int,b:int>
-- !query 3 output
3 2
3 1
2 2
2 1
1 2
1 1
-- !query 4
select * from data order by 1 + 0 desc, b desc
-- !query 4 schema
struct<a:int,b:int>
-- !query 4 output
1 2
2 2
3 2
1 1
2 1
3 1
-- !query 5
select * from data order by 0
-- !query 5 schema
struct<>
-- !query 5 output
org.apache.spark.sql.AnalysisException
ORDER BY position 0 is not in select list (valid range is [1, 2]); line 1 pos 28
-- !query 6
select * from data order by -1
-- !query 6 schema
struct<>
-- !query 6 output
org.apache.spark.sql.AnalysisException
ORDER BY position -1 is not in select list (valid range is [1, 2]); line 1 pos 28
-- !query 7
select * from data order by 3
-- !query 7 schema
struct<>
-- !query 7 output
org.apache.spark.sql.AnalysisException
ORDER BY position 3 is not in select list (valid range is [1, 2]); line 1 pos 28
-- !query 8
select * from data sort by 1 desc
-- !query 8 schema
struct<a:int,b:int>
-- !query 8 output
1 1
1 2
2 1
2 2
3 1
3 2
-- !query 9
set spark.sql.orderByOrdinal=false
-- !query 9 schema
struct<key:string,value:string>
-- !query 9 output
spark.sql.orderByOrdinal false
-- !query 10
select * from data order by 0
-- !query 10 schema
struct<a:int,b:int>
-- !query 10 output
1 1
1 2
2 1
2 2
3 1
3 2
-- !query 11
select * from data sort by 0
-- !query 11 schema
struct<a:int,b:int>
-- !query 11 output
1 1
1 2
2 1
2 2
3 1
3 2