Fix #11909 Can't insert row into table that contains generated column

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

1 files changed, 13 insertions, 7 deletions

diff --git a/tbl_replace.php b/tbl_replace.php
index 3d503b72a5..a09d5de93d 100644
--- a/tbl_replace.php
+++ b/tbl_replace.php
@@ -181,6 +181,10 @@ foreach ($loop_array as $rownumber => $where_clause) {
         = isset($_REQUEST['auto_increment']['multi_edit'][$rownumber])
         ? $_REQUEST['auto_increment']['multi_edit'][$rownumber]
         : null;
+    $multi_edit_virtual
+        = isset($_REQUEST['virtual']['multi_edit'][$rownumber])
+        ? $_REQUEST['virtual']['multi_edit'][$rownumber]
+        : null;
 
     // When a select field is nullified, it's not present in $_REQUEST
     // so initialize it; this way, the foreach($multi_edit_columns) will process it
@@ -259,13 +263,15 @@ foreach ($loop_array as $rownumber => $where_clause) {
             $gis_from_wkb_functions, $func_optional_param, $func_no_param, $key
         );
 
-        list($query_values, $query_fields)
-            = PMA_getQueryValuesForInsertAndUpdateInMultipleEdit(
-                $multi_edit_columns_name, $multi_edit_columns_null, $current_value,
-                $multi_edit_columns_prev, $multi_edit_funcs, $is_insert,
-                $query_values, $query_fields, $current_value_as_an_array,
-                $value_sets, $key, $multi_edit_columns_null_prev
-            );
+        if (! isset($multi_edit_virtual) || ! isset($multi_edit_virtual[$key])) {
+            list($query_values, $query_fields)
+                = PMA_getQueryValuesForInsertAndUpdateInMultipleEdit(
+                    $multi_edit_columns_name, $multi_edit_columns_null, $current_value,
+                    $multi_edit_columns_prev, $multi_edit_funcs, $is_insert,
+                    $query_values, $query_fields, $current_value_as_an_array,
+                    $value_sets, $key, $multi_edit_columns_null_prev
+                );
+        }
         if (isset($multi_edit_columns_null[$key])) {
             $multi_edit_columns[$key] = null;
         }