MDEV-10139 Support for SEQUENCE objects

- SETVAL(sequence_name, next_value, is_used, round)
- ALTER SEQUENCE, including RESTART WITH

Other things:
- Added handler::extra() option HA_EXTRA_PREPARE_FOR_ALTER_TABLE to signal
  ha_sequence() that it should allow write_row statments.
- ALTER ONLINE TABLE now works with SEQUENCE:s

1 files changed, 23 insertions, 0 deletions

diff --git a/sql/sql_alter.h b/sql/sql_alter.h
index beec5090343..c0232dd7358 100644
--- a/sql/sql_alter.h
+++ b/sql/sql_alter.h
@@ -385,6 +385,29 @@ public:
 
 
 /**
+  Sql_cmd_alter_sequence represents the ALTER SEQUENCE statement.
+*/
+class Sql_cmd_alter_sequence : public Sql_cmd
+{
+public:
+  /**
+    Constructor, used to represent a ALTER TABLE statement.
+  */
+  Sql_cmd_alter_sequence()
+  {}
+
+  ~Sql_cmd_alter_sequence()
+  {}
+
+  enum_sql_command sql_command_code() const
+  {
+    return SQLCOM_ALTER_SEQUENCE;
+  }
+  bool execute(THD *thd);
+};
+
+
+/**
   Sql_cmd_alter_table_tablespace represents ALTER TABLE
   IMPORT/DISCARD TABLESPACE statements.
 */