Skip to content

5.6.31 分页提取count语句算法优化、日期字符串毫秒、微妙位长度转换兼容

Latest
Compare
Choose a tag to compare
@chenrenfei chenrenfei released this 08 Nov 05:02
· 9 commits to 5.6 since this release
4551c55

1、增强sql自动分页提取count部分sql的算法,兼容最终from前面有非(select from)对称场景:

select field1,(day form(xxx)) as aliase from table 

2、优化DateUtil,对非规范长度的字符串(如:2024-11-07 10:52:36.12345)转LocalDateTime、LocalTime的兼容处理
3、强化opengauss系列getTables方法,表名匹配小写化

<!-- 其他非spring框架可以基于sagacity-sqltoy 进行扩展 -->
<dependency>
	<groupId>com.sagframe</groupId>
	<artifactId>sagacity-sqltoy</artifactId>
         <!-- jdk8 对应的版本号为:5.6.31.jre8 -->
	<version>5.6.31</version>
</dependency>

<!-- springboot  -->
<dependency>
	<groupId>com.sagframe</groupId>
	<artifactId>sagacity-sqltoy-spring-starter</artifactId>
         <!-- jdk8 对应的版本号为:5.6.31.jre8 -->
	<version>5.6.31</version>
</dependency>

<!-- solon 插件  -->
<dependency>
	<groupId>com.sagframe</groupId>
	<artifactId>sagacity-sqltoy-solon-plugin</artifactId>
        <!-- jdk8 对应的版本号为:5.6.31.jre8 -->
	<version>5.6.31</version>
</dependency>