# 案例：典型不下推语句整改案例集
[案例：使排序下推](https://support.huaweicloud.com/devg-911-dws/dws_04_0130.html)
:
[案例：With-Recursive contains only values rte is not shippable](https://support.huaweicloud.com/devg-911-dws/dws_04_0131.html)
:
[案例：With-Recursive contains system table is not shippable](https://support.huaweicloud.com/devg-911-dws/dws_04_0132.html)
:
[案例：SubPlan exec on CN can not be shipped](https://support.huaweicloud.com/devg-911-dws/dws_04_0133.html)
:
[案例：Type of Record in TargetList can not be shipped](https://support.huaweicloud.com/devg-911-dws/dws_04_0134.html)
:
[案例：Type of Record in non-real table can not be shipped](https://support.huaweicloud.com/devg-911-dws/dws_04_0135.html)
:
[案例：main plan exec on CN and SubPlan exec on DN can not be shipped](https://support.huaweicloud.com/devg-911-dws/dws_04_0136.html)
:
[案例：With-Recursive under multi-nodegroup scenario is not shippable](https://support.huaweicloud.com/devg-911-dws/dws_04_0137.html)
:
[案例：With-Recursive contains conflict distribution in none-recursive(xxx) recursive(xxx)](https://support.huaweicloud.com/devg-911-dws/dws_04_0138.html)
:
[案例：Table in TargetList can not be shipped](https://support.huaweicloud.com/devg-911-dws/dws_04_0139.html)
:
[案例："Row () Expression" can not be shipped](https://support.huaweicloud.com/devg-911-dws/dws_04_0140.html)
:
[案例：Merge Into can't be shipped in the scene temporarily](https://support.huaweicloud.com/devg-911-dws/dws_04_0141.html)
:
[案例：Type of Record in dual that is not a real table can not be shipped](https://support.huaweicloud.com/devg-911-dws/dws_04_0142.html)
: