JPA@Query时,无法使用limit函数的问题及解决

@Query(nativeQuery=true,value = "") 

public interface GaidDao extends LogicDeleteableRepository<Gaid, Long>, JpaSpecificationExecutor<Gaid> {
	//加入：nativeQuery注解时，写原生sql，支持limit函数
	//不加入：nativeQuery注解时是JPQL。JPQL不支持limit函数
	@Query(nativeQuery=true, value = "select gaid from sdp_gaid where geo = ?1 and deleted = 0 order by id desc limit 1000000")
	List<String> findGaidByGeo(String geo);
}

@Query(value = "select * from d_quarterly_report where report_type=?1 order by cycle_number desc limit 1" ,nativeQuery = true)
    QuarterlyReport getLastUploadByReportType(Boolean type);

@Query(value = "select * from d_quarterly_report where report_type=?1 order by cycle_number desc limit 0,1",nativeQuery = true,)
    QuarterlyReport getLastUploadByReportType(Boolean type);