MDEV-23805 Make Online DDL to Instant DDL when table is emptybb-10.4-MDEV-23805

- In ha_innobase::prepare_inplace_alter_table(), InnoDB should
check whether the table is empty. If the table is empty then
server should avoid downgrading the MDL after prepare phase.
It is more like instant alter, does change only in dicationary
and metadata.

- Changed few debug test case to make non-empty DDL table

1 files changed, 3 insertions, 0 deletions

diff --git a/sql/handler.h b/sql/handler.h
index 94ac56c3073..9b44b3fd297 100644
--- a/sql/handler.h
+++ b/sql/handler.h
@@ -2493,6 +2493,9 @@ public:
   /** true when InnoDB should abort the alter when table is not empty */
   bool error_if_not_empty;
 
+  /** True when DDL should avoid downgrading the MDL */
+  bool mdl_exclusive_after_prepare= false;
+
   Alter_inplace_info(HA_CREATE_INFO *create_info_arg,
                      Alter_info *alter_info_arg,
                      KEY *key_info_arg, uint key_count_arg,