Support MySQL 5.7.5 virtual columns

Signed-off-by: Madhura Jayaratne <madhura.cj@gmail.com>

1 files changed, 22 insertions, 0 deletions

diff --git a/js/functions.js b/js/functions.js
index 092490daea..531994079a 100644
--- a/js/functions.js
+++ b/js/functions.js
@@ -230,6 +230,21 @@ function PMA_hideShowDefaultValue($default_type)
 }
 
 /**
+ * Hides/shows the input field for column expression based on whether
+ * VIRTUAL/PERSISTENT is selected
+ *
+ * @param $virtuality virtuality dropdown
+ */
+function PMA_hideShowExpression($virtuality)
+{
+    if ($virtuality.val() == '') {
+        $virtuality.siblings('.expression').hide();
+    } else {
+        $virtuality.siblings('.expression').show();
+    }
+}
+
+/**
  * Show notices for ENUM columns; add/hide the default value
  *
  */
@@ -241,6 +256,9 @@ function PMA_verifyColumnsProperties()
     $("select.default_type").each(function () {
         PMA_hideShowDefaultValue($(this));
     });
+    $('select.virtuality').each(function () {
+        PMA_hideShowExpression($(this));
+    });
 }
 
 /**
@@ -3035,6 +3053,7 @@ AJAX.registerOnload('functions.js', function () {
 AJAX.registerTeardown('functions.js', function () {
     $(document).off('change', "select.column_type");
     $(document).off('change', "select.default_type");
+    $(document).off('change', "select.virtuality");
     $(document).off('change', 'input.allow_null');
     $(document).off('change', '.create_table_form select[name=tbl_storage_engine]');
 });
@@ -3054,6 +3073,9 @@ AJAX.registerOnload('functions.js', function () {
     $(document).on('change', "select.default_type", function () {
         PMA_hideShowDefaultValue($(this));
     });
+    $(document).on('change', "select.virtuality", function () {
+        PMA_hideShowExpression($(this));
+    });
     $(document).on('change', 'input.allow_null', function () {
         PMA_validateDefaultValue($(this));
     });