alibaba / druid

阿里云计算平台DataWorks(https://help.aliyun.com/document_detail/137663.html) 团队出品,为监控而生的数据库连接池
https://github.com/alibaba/druid/wiki
Apache License 2.0
27.92k stars 8.57k forks source link

Update OracleIntervalExpr handling in PGOutputVisitor #6007

Closed ZhengguanLi closed 3 months ago

ZhengguanLi commented 3 months ago

解决PGOutputVisitor输出OracleIntervalExpr出现多余的括号的问题,比如: SELECT (SYSTIMESTAMP - order_date) DAY(9) TO SECOND from orders WHERE order_id = 2458; 会变成 SELECT ((SYSTIMESTAMP - order_date)) DAY(9) TO SECOND from orders WHERE order_id = 2458;

代码变得跟OracleOutputVisitor的相同方法的code完全相同

没有添加测试用例因为这个设计的是Oracle Interval到PG输出的问题,好像一般测试用例不涉及到跨两个数据库

lizongbo commented 3 months ago

请补充一下对应的单元测试用例代码。

ZhengguanLi commented 3 months ago

请补充一下对应的单元测试用例代码。

已添加