Jpa分页查询遇到的bug

背景

1. 问题描述

使用Jpa hsql直接进行分页查询，查询失败

2. 报错error

Caused by: java.lang.IllegalArgumentException: org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: order near line 1, column 14 [select count(order) from xxx.xxx.DataFlow]

3. 问题位置

@Query(value = "from DataFlow order by timestamp")
Page<DataFlow> listByPage(Pageable pageable);

4. 解决方法

给表加别名

@Query(value = "from DataFlow t order by t.timestamp")
Page<DataFlow> listByPage(Pageable pageable);

5. 原因

暂时还没有细看，简单记录，后续再补充