Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

强制小写化的问题 #1498

Open
junphine opened this issue May 16, 2017 · 1 comment
Open

强制小写化的问题 #1498

junphine opened this issue May 16, 2017 · 1 comment

Comments

@junphine
Copy link

Select _id from resumeModel where Name='ABC' limit 1;
这个语句小写化后肯定有问题。

使用mycat也好几个月了,提几个建议:

  1. 分区规则配置略有点麻烦,不能重用,不够智能。
  2. prepare语句实际上是再拼成完整的sql,再解析路由的。但我的表中一个字段是大文本字段(里面甚至会含有一些sql语句),解析代价比较大,甚至能不能正确解析都有疑问。所以最好改进路由实现,支持perpare语句,这样也能防止解析出错。
    3.分表功能,鸡肋
@yanjunli
Copy link
Contributor

强制小写化 使用的是什么版本?
我在1.6.5 版本上验证没有出现这个问题.

提的三点建议,建议关注2.0.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants