srielau commented on code in PR #53530:
URL: https://github.com/apache/spark/pull/53530#discussion_r2695006389
##########
sql/api/src/main/antlr4/org/apache/spark/sql/catalyst/parser/SqlBaseParser.g4:
##########
@@ -144,6 +148,22 @@ declareHandlerStatement
: DECLARE (CONTINUE | EXIT) HANDLER FOR conditionValues
(beginEndCompoundBlock | statement | setStatementInsideSqlScript)
;
+declareCursorStatement
+ : DECLARE name=errorCapturingIdentifier (ASENSITIVE | INSENSITIVE)? CURSOR
FOR query (FOR READ ONLY)?
+ ;
+
+openCursorStatement
+ : OPEN multipartIdentifier (USING (LEFT_PAREN params=namedExpressionSeq
RIGHT_PAREN | params=namedExpressionSeq))?
+ ;
+
+fetchCursorStatement
+ : FETCH ((NEXT FROM) | FROM | NEXT)? cursorName=multipartIdentifier INTO
targets=multipartIdentifierList
Review Comment:
Good catch! The spoec is right, the gramar is wrong! FETCH NEXT cur1 is not
allowed
--
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]
