hibernate使用日期函数(ADDDATE)可能会引起 type [null] at specified position [1] in call arguments was not type错误

版本信息

Hibernate：6.1.5.Final
Spring Data JPA: 3.0.0

问题原因

第一个函数的第一个参数为占位符，如：
ADDDATE(?,1)

问题代码

文件 DemoEntity.java：

@Entity
public class DemoEntity implements Serializable {
    @Id
    private Integer id;
    private LocalDateTime recordDateTime;
	
	public Integer getId(){
		return id;
	}
	public void setId(Integer value){
		this.id = value;
	}
	public LocalDateTime getRecordDateTime(){
		return this.recordDateTime;
	}
	public void setRecordDateTime(LocalDateTime value){
		this.recordDateTime = value;
	}
}

文件 DemoRepository.java

public interface OrdersCountRepository extends JpaRepository<DemoEntity, Integer> {
    @Query("from DemoEntity where recordDateTime > ?1 and recordDateTime < ADDDATE(?1,1)")
	List<DemoEntity> getListByDate(LocalDateTime date);
}

错误提示

Caused by: org.hibernate.QueryException: Function argument [SqmPositionalParameter(1)] of type [null] at specified position [1] in call arguments was not typed as an allowable function return type

其实原因很简单，就是 ?1 的类型无法获取到，稍微改进一下就行：

改进

文件 DemoRepository.java

public interface OrdersCountRepository extends JpaRepository<DemoEntity, Integer> {
    @Query("from DemoEntity where recordDateTime > ?1 and recordDateTime < ADDDATE(CAST(?1 AS LOCALDATETIME),1)")
	List<DemoEntity> getListByDate(LocalDateTime date);
}

指定类型： CAST(?1 AS LOCALDATETIME)

问题已解决