title: TypeORM Limit Not Working, Query returned one element in the array no matter what the limit is set?
body: <p>I am new to TypeORM. I have used <code>createQueryBuilder</code> to fetch data from database and used <code>.limit</code> function to set limit. But no matter what the limit is set in the query, only single entry in an array is returned in the result.</p>
  <p><strong>code:</strong></p>
  <pre><code>           await this.createQueryBuilder()
              .select(['videoComment.id', 'videoComment.comment', 'videoComment.languageCode', 'videoComment.createdAt'
                  , 'video.id', 'user.id', 'user.name', 'user.profileImage'])
              .from(VideoComment, 'videoComment')
              .innerJoin('videoComment.video', 'video', ' video.id = :videoId  and video.isActive = :isActive ')
              .innerJoin('videoComment.user', 'user')
              .where(' videoComment.id &gt; :commentId ' +
                  ' and videoComment.isActive = :isActive ', {
                  videoId: videoId,
                  commentId: commentId,
                  isActive: isActive
              })
              .orderBy('videoComment.id')
              .limit(size.valueOf())
              .getMany();
  </code></pre>
  <p><strong>query generated:</strong></p>
  <pre><code>SELECT &quot;videoComment&quot;.&quot;id&quot;            AS &quot;videoComment_id&quot;,
         &quot;videoComment&quot;.&quot;created_at&quot;    AS &quot;videoComment_created_at&quot;,
         &quot;videoComment&quot;.&quot;comment&quot;       AS &quot;videoComment_comment&quot;,
         &quot;videoComment&quot;.&quot;language_code&quot; AS &quot;videoComment_language_code&quot;,
         &quot;video&quot;.&quot;id&quot;                   AS &quot;video_id&quot;,
         &quot;user&quot;.&quot;id&quot;                    AS &quot;user_id&quot;,
         &quot;user&quot;.&quot;name&quot;                  AS &quot;user_name&quot;,
         &quot;user&quot;.&quot;profile_image&quot;         AS &quot;user_profile_image&quot;
  FROM &quot;video_comment&quot; &quot;VideoComment&quot;,
       &quot;video_comment&quot; &quot;videoComment&quot;
           INNER JOIN &quot;video&quot; &quot;video&quot;
                      ON &quot;video&quot;.&quot;id&quot; = &quot;videoComment&quot;.&quot;video_id&quot; AND (&quot;video&quot;.&quot;id&quot; = $1 and &quot;video&quot;.&quot;is_active&quot; = $2)
           INNER JOIN &quot;user_detail&quot; &quot;user&quot; ON &quot;user&quot;.&quot;id&quot; = &quot;videoComment&quot;.&quot;user_id&quot;
  WHERE &quot;videoComment&quot;.&quot;id&quot; &gt; $3
    and &quot;videoComment&quot;.&quot;is_active&quot; = $4
  ORDER BY &quot;videoComment&quot;.&quot;id&quot; ASC
  LIMIT 5
  </code></pre>
  <p>query works fine when i am executing it on POSTGRES client. It returned the desired result. But in the application code it returns only single entry in the result set.</p>