Use RAII to free select statement results

1 files changed, 8 insertions, 0 deletions

diff --git a/odb/mysql/view-result.txx b/odb/mysql/view-result.txx
index 6161909..6f1896d 100644
--- a/odb/mysql/view-result.txx
+++ b/odb/mysql/view-result.txx
@@ -15,6 +15,8 @@ namespace odb
     view_result_impl<T>::
     ~view_result_impl ()
     {
+      if (!this->end_)
+        statement_->free_result ();
     }
 
     template <typename T>
@@ -60,6 +62,9 @@ namespace odb
         this->end_ = count_ > statement_->result_size ();
       else
         fetch ();
+
+      if (this->end_)
+        statement_->free_result ();
     }
 
     template <typename T>
@@ -132,7 +137,10 @@ namespace odb
         statement_->cache ();
 
         if (count_ >= statement_->result_size ())
+        {
+          statement_->free_result ();
           this->end_ = true;
+        }
       }
     }