title: $query->result() returning empty array
body: <p>I'm using Codeigniter active records for some time now and this is the most ridiculous error I've got.</p>
  
  <p>My query is </p>
  
  <pre><code>$this-&gt;db-&gt;select('*');
  $this-&gt;db-&gt;from('my_table');
  $this-&gt;db-&gt;where('is_active', 1);
  
  $query = $this-&gt;db-&gt;get();
  
  if ($query-&gt;num_rows() &gt; 0) {
      //return $query-&gt;result();
      return $query;
  } else {
      return FALSE;
  }
  </code></pre>
  
  <hr>
  
  <p>when I use<code>$query-&gt;result();</code> It is empty. When I use <code>return $query;</code>
  the result is like below,</p>
  
  <pre><code>CI_DB_pdo_result Object
  (
      [num_rows] =&gt; 21
      [conn_id] =&gt; PDO Object
          (
          )
  
      [result_id] =&gt; PDOStatement Object
          (
              [queryString] =&gt; SELECT * FROM my_table WHERE is_active =  1
          )
  
      [result_array] =&gt; Array
          (
          )
  
      [result_object] =&gt; Array
          (
          )
  
      [custom_result_object] =&gt; Array
          (
          )
  
      [current_row] =&gt; 0
      [row_data] =&gt; 
  )
  </code></pre>
  
  <hr>
  
  <p>Count is </p>
  
  <blockquote>
    <p>[num_rows] => 21</p>
  </blockquote>
  
  <p>what is missing/problem here?</p>