[jira] [Created] (SPARK-40208) New OFFSET clause does not use new error framework

["Serge Rielau (Jira)" <ji...@apache.org>]

Serge Rielau created SPARK-40208:
------------------------------------

             Summary: New OFFSET clause does not use new error framework 
                 Key: SPARK-40208
                 URL: https://issues.apache.org/jira/browse/SPARK-40208
             Project: Spark
          Issue Type: Bug
          Components: Spark Core
    Affects Versions: 3.4.0
            Reporter: Serge Rielau


CREATE TEMP VIEW person (name, age)
AS VALUES ('Zen Hui', 25),
('Anil B' , 18),
('Shone S', 16),
('Mike A' , 25),
('John A' , 18),
('Jack N' , 16);

SELECT name, age FROM person ORDER BY name OFFSET length(name);

Error in query: The offset expression must evaluate to a constant value, but got length(person.name);

Offset length(name#181)

+- Sort [name#181 ASC NULLS FIRST], true

   +- Project [name#181, age#182]

      +- SubqueryAlias person

         +- View (`person`, [name#181,age#182])

            +- Project [cast(col1#183 as string) AS name#181, cast(col2#184 as int) AS age#182]

               +- LocalRelation [col1#183, col2#184|#183, col2#184]


 

Returning the plan here is quite pointless as well. The context would be more interesting.
 



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

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org