开发进度
最后更新:2024-07-10 09:03:59
|
状态:未完成
多表关联更新
读取默认值识别内置变量
PG查询列时检测表名大小写
自定义SQL拆分忽略部分条件
查询条件中点位符
ConfigStore 生成SQL,生成查询条件注意between等多值条件
CompareAdapter
多表查询 检测查询条件
JSON_CONTAINS
TableBuilder生成union union all
流式查询
![](http://cdn.anyline.org/img/icon/chk_status_0969.png)
![](http://cdn.anyline.org/img/icon/chk_status_0969.png)
![](http://cdn.anyline.org/img/icon/chk_status_0969.png)
![](http://cdn.anyline.org/img/icon/chk_status_0969.png)
![](http://cdn.anyline.org/img/icon/chk_status_0969.png)
![](http://cdn.anyline.org/img/icon/chk_status_0969.png)
![](http://cdn.anyline.org/img/icon/chk_status_0969.png)
![](http://cdn.anyline.org/img/icon/chk_status_0969.png)
![](http://cdn.anyline.org/img/icon/chk_status_0969.png)
DMInterceptor
UPDATE TAB_A AS A SET
TOTAL_WEIGHT = B.TOTAL_WEIGHT
, TOTAL_QTY = B.TOTAL_QTY
FROM TAB_B AS B
WHERE A.ID = F.ID AND A.Y = ?
UPDATE TAB_A AS A SET
TOTAL_WEIGHT = B.TOTAL_WEIGHT
, TOTAL_QTY = B.TOTAL_QTY
FROM TAB_B AS B , TAB_C AS C
WHERE A.ID = F.ID AND A.Y = ?
UPDATE TAB_A AS A SET
TOTAL_WEIGHT = B.TOTAL_WEIGHT
, TOTAL_QTY = B.TOTAL_QTY
FROM TAB_B AS B LEFT JOIN TAB_C AS C ON B.ID = C.ID
WHERE A.ID = F.ID AND A.Y = ?