sql_print_information corrected

as checksum/swap don't always occur

1 files changed, 10 insertions, 4 deletions

diff --git a/sql/sql_view.cc b/sql/sql_view.cc
index da7ab7c79bc..24f01aeaa76 100644
--- a/sql/sql_view.cc
+++ b/sql/sql_view.cc
@@ -856,6 +856,8 @@ int mariadb_fix_view(THD *thd, TABLE_LIST *view, bool wrong_checksum,
     else
       view->algorithm= VIEW_ALGORITHM_MERGE;
   }
+  else
+    swap_alg= 0;
   if (wrong_checksum)
   {
     if (view->md5.length != 32)
@@ -875,10 +877,14 @@ int mariadb_fix_view(THD *thd, TABLE_LIST *view, bool wrong_checksum,
                     view->db, view->table_name);
     DBUG_RETURN(HA_ADMIN_INTERNAL_ERROR);
   }
-  sql_print_information("View '%-.192s'.'%-.192s': algorithm swapped to '%s'",
-                        view->db, view->table_name,
-                        (view->algorithm == VIEW_ALGORITHM_MERGE)?
-                        "MERGE":"TEMPTABLE");
+  sql_print_information("View '%-.192s'.'%-.192s': versioned to %llu%s%s",
+                        view->db, view->table_name, view->mariadb_version,
+                        (wrong_checksum ? ", and checksum corrected" : ""),
+                        (swap_alg ?
+                          ((view->algorithm == VIEW_ALGORITHM_MERGE) ?
+                            ", and algorithm swapped to 'MERGE'"
+                           : ", and algorithm swapped to 'TEMPTABLE'")
+                         : ""));
 
 
   DBUG_RETURN(HA_ADMIN_OK);