MDEV-10581 sql_mode=ORACLE: Explicit cursor FOR LOOP

MDEV-12098 sql_mode=ORACLE: Implicit cursor FOR loop

1 files changed, 16 insertions, 1 deletions

diff --git a/sql/structs.h b/sql/structs.h
index e0fb05f05da..1b3c0b7a7f2 100644
--- a/sql/structs.h
+++ b/sql/structs.h
@@ -674,22 +674,37 @@ public:
 };
 
 
+struct Lex_for_loop_bounds_st
+{
+public:
+  class sp_assignment_lex *m_index;
+  class sp_assignment_lex *m_upper_bound;
+  int8 m_direction;
+  bool m_implicit_cursor;
+  bool is_for_loop_cursor() const { return m_upper_bound == NULL; }
+};
+
+
 struct Lex_for_loop_st
 {
 public:
   class sp_variable *m_index;
   class sp_variable *m_upper_bound;
-  int m_direction;
+  int m_cursor_offset;
+  int8 m_direction;
+  bool m_implicit_cursor;
   void init()
   {
     m_index= 0;
     m_upper_bound= 0;
     m_direction= 0;
+    m_implicit_cursor= false;
   }
   void init(const Lex_for_loop_st &other)
   {
     *this= other;
   }
+  bool is_for_loop_cursor() const { return m_upper_bound == NULL; }
 };