title: JPA Unknow column in table aliases with Pagination/Page in Spring
body: <p>In spring implementing pagination with a custom query I request:</p>
  
  <pre><code>{{host}}:8080/list?page=0&amp;size=2 and the result is OK
  {{host}}:8080/list?page=0&amp;size=3 and the result is OK
  {{host}}:8080/list?page=0&amp;size=4 and the result is OK
  {{host}}:8080/list?page=0&amp;size=1 and the result is NOT OK
  {{host}}:8080/list?page=1&amp;size=1 and the result is NOT OK
  {{host}}:8080/list?page=1&amp;size=2 and the result is NOT OK
  {{host}}:8080/list?page=1&amp;size=3 and the result is NOT OK
  </code></pre>
  
  <p>Controller:</p>
  
  <pre><code>@GetMapping(value = "/list")
  public Page&lt;User&gt; list(Pageable pageable) {
      try {
          return userRepository.findUser(pageable);
      } catch (Exception e) {
          logger.error("Ex: {}", e);
          return null;
      }
  }
  </code></pre>
  
  <p>Repository:</p>
  
  <pre><code>@Query(value = "select U.*, M.local as LocalM from user U inner join Morada M on M.idmorada = U.morada", nativeQuery= true)
  public Page&lt;User&gt; findUser(Pageable pageable);
  </code></pre>
  
  <p>What happens when the response is not ok:</p>
  
  <pre><code>2020-01-03 11:34:01.659  WARN 9652 --- [nio-8080-exec-3] o.h.engine.jdbc.spi.SqlExceptionHelper   : SQL Error: 1054, SQLState: 42S22
  2020-01-03 11:34:01.659 ERROR 9652 --- [nio-8080-exec-3] o.h.engine.jdbc.spi.SqlExceptionHelper   : Unknown column 'U' in 'field list'
  </code></pre>
  
  <p>Why does the pagination properties size and page only work in certain scenarios with the nativeQuery?</p>