[GitHub] [shardingsphere] linghengqian commented on issue #16857: Syntax exception thrown when executing nested MySQL function

[GitBox <gi...@apache.org>]

linghengqian commented on issue #16857:
URL: https://github.com/apache/shardingsphere/issues/16857#issuecomment-1100588573

   @tuichenchuxin I'm sorry that the issue I raised has been resolved, I think I should close this issue and mark this issue as invalid. Because this has nothing to do with SQL parsing. I made the following changes in my local project and the issue was resolved.
   ```yaml
   spring.shardingsphere.rules.sharding.tables.t_order.actual-data-nodes: $->{com.lingh.ActualDataNodesUtil.getActualDataNodesString()}
   ```
   The problem is solved after changing it to the following. Now I am passing back the full string in the business to avoid calling the static method of the Java class. The method I used before seems to have a problem. I can open a new issue about groovy if necessary.
   ```yaml
   spring.shardingsphere.rules.sharding.tables.t_order.actual-data-nodes: ds-0.t_order_$->{20220410..20220415}
   ```


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org