title: Yii2 query with all() returns less data than expected
body: <p>I want to find all data from database with this query: </p>
  
  <pre><code> $dataSearch = House::find()
     -&gt;select(["number","DATE(reg_date) AS date","((value) &gt; 100) AS result","info"])
     -&gt;join("INNER JOIN", Owner::tableName(), Owner::tableName().'.number_ow= '.House::tableName().'.number_ow')
     -&gt;andWhere([House::tableName().'.number_ow'=&gt;$house-&gt;number_ow])
     -&gt;andFilterWhere([House::tableName().'.space'=&gt;$space])
     -&gt;orderBy([House::tableName().'.reg_date'=&gt;SORT_DESC,'info'=&gt;SORT_ASC]);
  
  
      $data = $dataSearch-&gt;asArray()-&gt;all();
  </code></pre>
  
  <p>If I perform the query with <code>all()</code> return only a few part of the results, but if I perform the raw SQL query on the database, I get all the results. I don't understand where the problem is.</p>
  
  <p>This is raw SQL:</p>
  
  <pre><code>SELECT `number`, DATE(reg_date) AS date, ((value) &gt; 100) AS result, `info` 
  FROM `ho_house` INNER JOIN `ho_owner` ON ho_owner.number_ow = oh_ho_house.number_ow 
  WHERE (`ho_house`.`number_ow`=2100174106) AND (`ho_house`.`space`='m')
  ORDER BY `ho_house`.`reg_date` DESC, `info`
  </code></pre>