MDEV-406: ANALYZE $stmt

- Testcase for ANALYZE UNION
- Provide r_rows for union result.

1 files changed, 5 insertions, 0 deletions

diff --git a/sql/sql_explain.h b/sql/sql_explain.h
index 7970d778a21..203235f9f5c 100644
--- a/sql/sql_explain.h
+++ b/sql/sql_explain.h
@@ -27,6 +27,11 @@ public:
   ha_rows r_rows; /* How many rows we've got after that */
   ha_rows r_rows_after_table_cond; /* Rows after applying the table condition */
   ha_rows r_rows_after_where; /* Rows after applying attached part of WHERE */
+
+  ha_rows get_avg_rows()
+  {
+    return r_scans ? round((double) r_rows / r_scans): 0;
+  }
 };