PeiMouRen commented on issue #26385:
URL:
https://github.com/apache/shardingsphere/issues/26385#issuecomment-1597983468
@RaigorJiang
After full testing, I found that the sharding-proxy is case-sensitive to
the rule config in the configuration file(like `config-sharding.yml`), so I
changed all the config to lower case. After that, if the table is in custom
schema, when performing operations like `count(*)、group by、order by`, I need to
add the schema name before the table name(like `a.t_order`, `a` is the schema
name). If the table is in `public` schema, I do not need to add the schema name.
So the `search path` config will only take effect for normal queries(like
`select * from t_order`)?
--
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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
