title: @Query annotation is not reading native sql select * spring data
body: <pre><code>public interface ConsumerRepository extends CrudRepository&lt;Consumer, Long&gt;  {
  
      List&lt;Consumer&gt; findByLastName(String lastName);
      List&lt;Consumer&gt; findByFirstName(String firstName);
  
      //List&lt;Consumer&gt; readExistsFirstName(String firstName);
      //List&lt;Consumer&gt; getByFirstNameAndLastNameOrderByFirstName();
      //Collection&lt;Consumer&gt; findById(Long id);
      @Query("select c from Consumer as c where c.firstName like '%?1%'")
      Collection&lt;Consumer&gt; findByNameContains(String word);
  
      @Query(value = "SELECT ppc_consumer FROM ppc_consumer WHERE lastname = ?1",
              countQuery = "SELECT count(*) FROM ppc_consumer WHERE lastname = ?1",
              nativeQuery = true)
      Page&lt;Consumer&gt; findByLastname(String lastname, Pageable pageable);
   }
  </code></pre>
  
  <p><strong>But is shows error " Distinc expected " , got * because i have used * inside @Query annotation ? what is wrong please ?</strong></p>