Description:
ShardingSphere-Proxy with MySQL protocol didn't cleanup session completely
after client authentication failed, which allows an attacker to execute normal
commands by constructing a special MySQL client. This vulnerability has been
fixed in ShardingSphere 5.3.0.
References:
https
Hello my friend,
Could you translate it to English?
--
Sincerely,
Liang Zhang (John)
Apache ShardingSphere
黄桂荣 于2022年11月5日周六 12:08写道:
> 你们好!在测试和调研sharding proxy中间件的功能 ,有如下疑问,请针对我的问题给我一个回复好吗?
>
>
> 1 通过 Sharding Proxy 中间件 去备份 MySQL 怎么保证 全局一致性备份(假设我的业务做了数据分片,分片刚好是
你们好!在测试和调研sharding proxy中间件的功能 ,有如下疑问,请针对我的问题给我一个回复好吗?
1 通过 Sharding Proxy 中间件 去备份 MySQL 怎么保证 全局一致性备份(假设我的业务做了数据分片,分片刚好是跨数据库集群)?
2 把sharding proxy做为后端程序连接数据库的中间件,后端数据库高可用怎么做到故障切换后,中间件怎么去感知主节点的切换 ?
3 后端数据库如何
做到横向扩展,就比如说我原本业务数据在一个数据库集群中,随着时间和业务量的增长,数据量大,随之而来的就是要对数据库进行横向扩展,那么中间件怎么做到认识新数据节点和旧的数据节点中
The vote thread is [1]
[1] https://lists.apache.org/thread/6xr95mlt88x1c2ckv4py2nnz26796jdt
On 2022/04/01 03:41:46 "zhangli...@apache.org" wrote:
> Vote passed.
>
> We got 7 votes, the details of result:
>
> 2 +1 from PMC members
> 4 +1 from Committers
> 1 +1 from Community contributor
>
>
>
Vote passed.
We got 7 votes, the details of result:
2 +1 from PMC members
4 +1 from Committers
1 +1 from Community contributor
--
Sincerely,
Liang Zhang (John)
Apache ShardingSphere
So great +1
--
Trista Pan
Twitter & Github: tristaZero
On 03/29/2022 11:24,zhangli...@apache.org wrote:
Hi community,
Please vote about donate ShardingSphere-Proxy Helm Chart to ShardingSphere
commu
+1
On 2022/03/29 03:24:05 "zhangli...@apache.org" wrote:
> Hi community,
>
> Please vote about donate ShardingSphere-Proxy Helm Chart to ShardingSphere
> community.
>
> The proposal is:
> https://cwiki.apache.org/confluence/display/SHARDINGSPHERE/ShardingS
+ 1
On Tue, 29 Mar 2022 at 10:04, 陈出新 wrote:
> + 1
>
> > 2022年3月29日 上午11:24,zhangli...@apache.org 写道:
> >
> > Hi community,
> >
> > Please vote about donate ShardingSphere-Proxy Helm Chart to
> ShardingSphere
> > community.
> >
> > T
+ 1
> 2022年3月29日 上午11:24,zhangli...@apache.org 写道:
>
> Hi community,
>
> Please vote about donate ShardingSphere-Proxy Helm Chart to ShardingSphere
> community.
>
> The proposal is:
> https://cwiki.apache.org/confluence/display/SHARDINGSPHERE/ShardingSphere-Proxy+H
+1
——
Longtao Jiang (jianglong...@apache.org)
Apache ShardingSphere Committer
GitHub@RaigorJiang
On 2022/03/29 03:24:05 "zhangli...@apache.org" wrote:
> Hi community,
>
> Please vote about donate ShardingSphere-Proxy Helm Chart to Shardin
b@TeslaCN
>
> zhangli...@apache.org 于2022年3月29日周二 11:24写道:
> >
> > Hi community,
> >
> > Please vote about donate ShardingSphere-Proxy Helm Chart to
> ShardingSphere
> > community.
> >
> > The proposal is:
> >
> https://cwiki.apache.org/co
+1
---
Weijie Wu 吴伟杰
Apache ShardingSphere Committer
GitHub@TeslaCN
zhangli...@apache.org 于2022年3月29日周二 11:24写道:
>
> Hi community,
>
> Please vote about donate ShardingSphere-Proxy Helm Chart to ShardingSphere
> community.
&
+1
On Mar 29, 2022 11:24,zhangli...@apache.org wrote:
Hi community, Please vote about donate ShardingSphere-Proxy Helm Chart to
ShardingSphere community. The proposal is:
https://cwiki.apache.org/confluence/display/SHARDINGSPHERE/ShardingSphere-Proxy+Helm+Chart+Donation+Proposal
I paste
Hi community,
Please vote about donate ShardingSphere-Proxy Helm Chart to ShardingSphere
community.
The proposal is:
https://cwiki.apache.org/confluence/display/SHARDINGSPHERE/ShardingSphere-Proxy+Helm+Chart+Donation+Proposal
I paste the content below
>
> totalo 于2022年3月26日周六 22:45写道:
> >
> > +1
> >
> >
> > On Mar 25, 2022 20:21,zhangli...@apache.org
> wrote:
> >
> >
> > Hi community, I want to discuss about donate ShardingSphere-Proxy Helm
> Chart to ShardingSphere communi
+1
---
Weijie Wu 吴伟杰
Apache ShardingSphere Committer
GitHub@TeslaCN
totalo 于2022年3月26日周六 22:45写道:
>
> +1
>
>
> On Mar 25, 2022 20:21,zhangli...@apache.org wrote:
>
>
> Hi community, I want to discuss about donate Shardin
+1
On Mar 25, 2022 20:21,zhangli...@apache.org wrote:
Hi community, I want to discuss about donate ShardingSphere-Proxy Helm Chart to
ShardingSphere community. The proposal is:
https://cwiki.apache.org/confluence/display/SHARDINGSPHERE/ShardingSphere-Proxy+Helm+Chart+Donation+Proposal
I
+1
On 2022/03/25 12:21:17 "zhangli...@apache.org" wrote:
> Hi community,
>
> I want to discuss about donate ShardingSphere-Proxy Helm Chart to
> ShardingSphere community.
>
> The proposal is:
> https://cwiki.apache.org/confluence/display/SHARDINGSPHERE/ShardingS
+ 1
> 在 2022年3月25日,20:21,zhangli...@apache.org 写道:
>
> Hi community,
>
> I want to discuss about donate ShardingSphere-Proxy Helm Chart to
> ShardingSphere community.
>
> The proposal is:
> https://cwiki.apache.org/confluence/display/SHARDINGSPHERE/ShardingSpher
+1
——
Zhengqaing Duan (duanzhengqi...@apache.org)
Apache ShardingSphere Committer
GitHub@strongduanmu
zhangli...@apache.org 于2022年3月25日周五 20:21写道:
> Hi community,
>
> I want to discuss about donate ShardingSphere-Proxy Helm Chart to
> ShardingSphe
+1
On 2022/03/25 12:21:17 "zhangli...@apache.org" wrote:
> Hi community,
>
> I want to discuss about donate ShardingSphere-Proxy Helm Chart to
> ShardingSphere community.
>
> The proposal is:
> https://cwiki.apache.org/confluence/display/SHARDINGSPHERE/ShardingS
+1
On 2022/03/25 12:26:06 Longtao Jiang wrote:
> +1
>
> On 2022/03/25 12:21:17 "zhangli...@apache.org" wrote:
> > Hi community,
> >
> > I want to discuss about donate ShardingSphere-Proxy Helm Chart to
> > ShardingSphere community.
> >
+1
On 2022/03/25 12:21:17 "zhangli...@apache.org" wrote:
> Hi community,
>
> I want to discuss about donate ShardingSphere-Proxy Helm Chart to
> ShardingSphere community.
>
> The proposal is:
> https://cwiki.apache.org/confluence/display/SHARDINGSPHERE/ShardingS
Hi community,
I want to discuss about donate ShardingSphere-Proxy Helm Chart to
ShardingSphere community.
The proposal is:
https://cwiki.apache.org/confluence/display/SHARDINGSPHERE/ShardingSphere-Proxy+Helm+Chart+Donation+Proposal
I paste the content below
The format is bad.
I will paste the proposal to wiki later.
--
Sincerely,
Liang Zhang (John)
Apache ShardingSphere
李卓 于2022年3月25日周五 19:57写道:
> Background ShardingSphere is a Top-Level open source distributed database
> middleware. However, currently ShardingSphere cannot be
Background ShardingSphere is a Top-Level open source distributed database
middleware. However, currently ShardingSphere cannot be quickly deployed and
upgraded in a cloud environment. SphereEx created
shardingsphere proxy ??
Hi
Thanks for your email, however the attachment, i.e., your log, could not show
well.
So I suggested you??d better raise an issue with this log on github[1].
Besides, English communication is required.
[1] https://github.com/apache/shardingsphere/issues
Juan Pan (Trista)
??log??mysql8.0.20,mysql-connector-java-8.0.20.jar
4.0.0-RC2 is too old. Can you change ther Proxy version to 4.1.1 just
released? You can download from
https://shardingsphere.apache.org/document/current/en/downloads/ .
--
Zhang Yonglun
Apache ShardingSphere
Kai Yu 于2020年6月11日周四 下午4:19写道:
> Hi:
>We test again, the cost use
Hi:
We test again, the cost use Proxy to route to only one database :
> “select count(*) from member where merchant_id = 'dwj'”
> the cost is :
4.32 sec
its looks like the same cost of count query to one server( db0 or db1)
,like this.
so , the same question
query co
Get it. What about the cost use Proxy to route to only one database?
Actually merging just consume little time.
--
Zhang Yonglun
Apache ShardingSphere
Kai Yu 于2020年6月4日周四 下午4:56写道:
> hi:
>thx for your replay,
>our machine'environment is aliyun RDS 4C8G
> The 16 machin
.03 sec)
> db8 (5.37 sec)
> db9 (5.66 sec)
> db9 (5.75 sec)
> db10 (5.49 sec)
> db11 (5.11 sec)
> db12 (4.98 sec)
> db13 (5.72 sec)
> db14 (5.33 sec)
> db15 (5.15 sec)
发件人: Zhang Yonglun
发送时间: 2020年6月4日 14:03
收件人: dev
主题: Re: About count
于2020年6月3日周三 下午6:05写道:
> hi
> we think the count query from 16databases , in the end ,it seems every
> database result to sum by sharding-proxy in memory ,we think it so fast.
> for example , db0 count query cost 5s, by the sharding-proxy count
> query cost 25s with 16dat
>
> Is there a way to continue improve this ? thanks
>
> 发件人: Kai Yu
> 发送时间: 2020年6月3日 15:16
> 收件人: dev@shardingsphere.apache.org
> 主题: About count query in sharding-proxy 4.0.0-RC2
>
> Hi ALL :
> we have a project used 16 data
hi
we think the count query from 16databases , in the end ,it seems every
database result to sum by sharding-proxy in memory ,we think it so fast.
for example , db0 count query cost 5s, by the sharding-proxy count
query cost 25s with 16databases, to deal with the count result need 20s
24-26s
Is this situation normal ?
Is there a way to continue improve this ? thanks
发件人: Kai Yu
发送时间: 2020年6月3日 15:16
收件人: dev@shardingsphere.apache.org
主题: About count query in sharding-proxy 4.0.0-RC2
Hi ALL :
we have a project used 16 databases (db0
e used
> sharding-proxy 4.0.0-RC2 ,
> and config the sharding.xml like this:
> schemaName: ty-basic-member
> dataSources:
> db0:
> url: jdbc:mysql://xxx:3306/db0?useSSL=false
> username: root
> password: root
> connectionTimeoutMilliseconds: 3
>
Hi ALL :
we have a project used 16 databases (db0 ...db15),we used sharding-proxy
4.0.0-RC2 ,
and config the sharding.xml like this:
schemaName: ty-basic-member
dataSources:
db0:
url: jdbc:mysql://xxx:3306/db0?useSSL=false
username: root
password: root
Hi,
I can feel the pain at the tedious work of DataSource configuration.
Thanks for your effort in this issue.
Considering configuration format, currently, I have no satisfying solution,
here[1] is just some of my daft idea for discussion, which is inspired by
`defaultDatabaseStrategy`
Hi All community friends:
now,There are a lot of the same datasource config when we use
sharding,master-slave datasource.
In springboot project we can configruation like this :
-
(John)
Apache ShardingSphere & Dubbo
Juan Pan 于2020年5月14日周四 下午12:09写道:
> Hi fellows,
>
>
> There is a significant change for release 5.x need to be public to our
> community.
> To get a consistent and straightforward orchestration function for both of
> Sharding Prox
Hi fellows,
There is a significant change for release 5.x need to be public to our
community.
To get a consistent and straightforward orchestration function for both of
Sharding Proxy and Sharding JDBC,
we extracted the joint members from them, which will be passed down to
`shardingsphere
---
>
>Liang Zhang (John)
>Apache ShardingSphere & Dubbo
>
>
>rainbpfjin(金沛锋) 于2020年4月27日周一 下午8:27写道:
>
>> 你好,在测试ShardingSphere的sharding proxy时,使用客户端访问时,总需要先使用use 到数据库,才能执行查询。
>>
>>
>>
>>
Welcome to Apache ShardingSphere community, communication for English only,
could you translate the email?
--
Liang Zhang (John)
Apache ShardingSphere & Dubbo
rainbpfjin(金沛锋) 于2020年4月27日周一 下午8:27写道:
> 你好,在测试ShardingSphere的sharding proxy时,使用客户端访问时,总需要先使用use 到数据库,才能执行查询。
>
>
>
>
你好,在测试ShardingSphere的sharding proxy时,使用客户端访问时,总需要先使用use 到数据库,才能执行查询。
[cid:image001.png@01D61CBD.B89FB7C0]
Done.
--
Liang Zhang (John)
Apache ShardingSphere & Dubbo
Hongtao Gao 于2020年3月10日周二 下午2:59写道:
> go for it
>
> zhangli...@apache.org 于2020年3月10日周二 下午1:41写道:
>
> > The branch proxy-with-netty-backend is a too old branch which is
> > establishi
go for it
zhangli...@apache.org 于2020年3月10日周二 下午1:41写道:
> The branch proxy-with-netty-backend is a too old branch which is
> establishing before we enter incubator.
> This branch is for using netty to connect MySQL. The feature is not
> completed and it seems no further
+1 to remove it now
After orchestration tasks,I will pick this feature enhancement.
Or any buddy is interested in it, we could discuss details after it closed and
make a plan to launch a new one.
At 2020-03-10 13:41:23, "zhangli...@apache.org" wrote:
>The branch proxy-with-
Good for me, Remove please.
Sheng Wu 吴晟
Twitter, wusheng1108
zhangli...@apache.org 于2020年3月10日周二 下午1:41写道:
> The branch proxy-with-netty-backend is a too old branch which is
> establishing before we enter incubator.
> This branch is for using netty to connect MySQL. Th
The branch proxy-with-netty-backend is a too old branch which is
establishing before we enter incubator.
This branch is for using netty to connect MySQL. The feature is not
completed and it seems no further update plan by the author. It is
difficult to merge master now for code conflict reason.
I
Hi, Daniel,
IMO, SQL like your case will be routed to any one database, then the
performance with sharding-proxy is almost equals with direct jdbc.
I guess 4 point maybe cause this issue:
1. system load and instances, just like yonglun talk about.
2. network issues, such as DNS etc.
3. router
ng...@apache.org>
> Date: 2020-01-20 12:24
> To: dev<mailto:dev@shardingsphere.apache.org>
> Subject: Re: Re: use sharding-proxy, query is slow
> The hostname xxx you omitted is what I want to see. Just tell me how many
> hosts or how may MySQL instance there are.
&
月20日周一 下午12:14写道:
> Hi:
>thx for you reply.
>
> 1. What's the cost when mysql client query database1 directly without
> sharding-proxy? (use member_id as where condition)
> it cost 8 seconds
> the cost means the SQL query time spent, i use the command like " mys
1. What's the cost when mysql client query database1 directly without
sharding-proxy? (use member_id as where condition)
2. Is 'member_id' the primary key?
3. Please show me the config-sharding.yaml and server.yaml.
--
Zhang Yonglun
Apache ShardingSphere
Daniel Yu 于2020年1月20日周一 上午11:17写道
from member where member_id = 'abc' "
on database 1 ,it cost 8s,
when i used proxy query on 16 databases by the same sql , it cost 60s ,
as far as I know the proxy used threadpool to Parallel execution the query ,
but the query is slow , why?
Hi English communication is prerequisite.
Could you use 4.0.0-RC3 to test?
Juan Pan (Trista)
Senior DBA & PPMC of Apache ShardingSphere(Incubating)
email: panj...@apache.org
On 12/12/2019 16:05,文光临 wrote:
您好!
Sharding-Proxy 连接 mysql8.0.18 报错,读取元数据出错。
报错信息如下(
Please use English, thank you.
--
Liang Zhang (John)
Apache ShardingSphere & Dubbo
文光临 于2019年12月12日周四 下午5:56写道:
> 您好!
> Sharding-Proxy 连接 mysql8.0.18 报错,读取元数据出错。
> 报错信息如下(配置和报错日志 在附件。多谢了)
>
>[INFO ] 15:36:31.679 [main] c.a.icatch.provider.imp.Ass
您好!
Sharding-Proxy 连接 mysql8.0.18 报错,读取元数据出错。
报错信息如下(配置和报错日志 在附件。多谢了)
[INFO ] 15:36:31.679 [main] c.a.icatch.provider.imp.AssemblerImp - USING:
com.atomikos.icatch.recovery_delay = 30
[INFO ] 15:36:31.679 [main] c.a.icatch.provider.imp.AssemblerImp - USING
Thanks for your response, I recently set up a highly available MySQL
database cluster on K8s. I chose MGR as the cluster solution. At the proxy
layer, I chose ProxySQL, because as far as I know, Sharding-Proxy does not
currently support dynamics. Master-slave clustering scheme.
Zhang Yonglun 于
日周六 下午1:14写道:
> Does Sharding-Proxy support the mgr or pxc cluster?
>
Does Sharding-Proxy support the mgr or pxc cluster?
Raigor 于2019年11月19日周二 上午10:51写道:
Hi, everyone,
I found some issues with Sharding-Proxy when using postgres and collected
as follows:
First, I prepared an environment like:
https://github.com/apache/incubator-shardingsphere/issues/3419,
my postgres version is 12.0, and use the latest Proxy s
new issues on GitHub for 2 and 3.
Zhang Yonglun
Apache ShardingSphere
Jiang Raigor 于2019年11月19日周二 上午10:51写道:
> Hi, everyone,
>
> I found some issues with Sharding-Proxy when using postgres and collected
> as follows:
>
> First, I prepared an environment like:
>
> h
Not yet. Can I ask what's your MGR solution for now? Middleware or VIP?
Zhang Yonglun
Apache ShardingSphere
Zero Dai 于2019年11月19日周二 下午1:11写道:
> Does Sharding-Proxy support the mgr or pxc cluster?
>
Hi!
The same error when using preparedStatement to connect proxy!
获取 Outlook for Android<https://aka.ms/ghei36>
From: Jiang Raigor
Sent: Tuesday, November 19, 2019 9:12:37 AM
To: dev@shardingsphere.apache.org
Subject: (Resend)issues for Proxy with Po
Hi, everyone,
I found some issues with Sharding-Proxy when using postgres and collected as
follows:
First, I prepared an environment like:
https://github.com/apache/incubator-shardingsphere/issues/3419,
my postgres version is 12.0, and use the latest Proxy source code.
(commit 962a9656
Sorry, due to the reason of the mailbox, the content of the previously mail is
lost, now resend.
Hi, everyone,
I found some issues with Sharding-Proxy when using postgres and collected as
follows:
First, I prepared an environment like:
https://github.com
/community/en/contribute/subscribe/
Juan Pan
panj...@apache.org
Juan Pan(Trista), Apache ShardingSphere
在2019年11月1日 11:02,edwardhuang<15372048...@163.com> 写道:
hello,sharding-proxy怎么实现 比如分表规则: 日期(mmdd+userid%8
这个策略,能否给一个案例,这个在实际生产中非常常见,万分感谢
edward huang
Please treat proxy as a regular DB to use it.
Juan Pan
panj...@apache.org
Juan Pan(Trista), Apache ShardingSphere
On 11/03/2019 09:34, 张宇波 wrote:
Dear
How do I use springboot2 to connect to proxy
----
??:"??"
Hello, same question we can discuss in one thread, thank you.
--
Liang Zhang (John)
Apache ShardingSphere & Dubbo
张宇波 于2019年11月3日周日 上午9:27写道:
> Dear
>
>
> How do I use springboot2 to connect to proxy
Hi Sion,
Thank you very much for your prompt feedback. Please consider it as a
future feature. It can be very useful when there are a lot of tables or
similar to some auto sharding applications.
Regards,
Eric Poon
On Mon, Jul 22, 2019 at 9:20 AM Sion Yang wrote:
> Hi Eric Poon,
>
>
>
Hi Eric Poon,
ShardingSphere requires users to configure which tables need to be shard
currently.
If there are no sharding-rule for sharding tables, ShardingSphere will use
default-datasource
to execute it. So it should not work with dynamic table names for now.
--
Yi Yang(Sion)
Apache
Hi,
I am trying to apply sharding on all tables on the same key column exists
on all tables. The objective is evenly distribute the records on several
database instances. For example, even no. records on one server. After
trying around several hours, seems it's not possible to define database
Hi,
I am trying out the ShardingSphere features. I have two questions on admin
related tasks. I tried different configurations but in vain. Very
appreciate for anyone could help.
1) How to configure the yaml files such that I can create tables on all
sharded databases through proxy
cherrylzhao opened a new issue #2303: sharding-proxy does not support
COM_STMT_RESET command of mySQL
URL: https://github.com/apache/incubator-shardingsphere/issues/2303
when I try to send prepare statement with python mysql connector.
it block it at `COM_STMT_RESET command can
tianyijushi commented on issue #2301: sharding-proxy doesn't has some tables in
the config default datasource,why?
URL:
https://github.com/apache/incubator-shardingsphere/issues/2301#issuecomment-487536159
sharding-proxy-3.0.0
tianyijushi commented on issue #2301: sharding-proxy doesn't has some tables in
the config default datasource,why?
URL:
https://github.com/apache/incubator-shardingsphere/issues/2301#issuecomment-487537151
@cherrylzhao sharding-proxy-3.0.0
cherrylzhao commented on issue #2301: sharding-proxy doesn't has some tables in
the config default datasource,why?
URL:
https://github.com/apache/incubator-shardingsphere/issues/2301#issuecomment-487531131
hi,please let me know the proxy version you used
Zatomsmasher commented on issue #2277: ERROR when tried to import sql file into
a sharding-proxy system
URL:
https://github.com/apache/incubator-shardingsphere/issues/2277#issuecomment-487523678
I'll have a shot
tuohai666 commented on issue #2277: ERROR when tried to import sql file into a
sharding-proxy system
URL:
https://github.com/apache/incubator-shardingsphere/issues/2277#issuecomment-487522914
This error may happens in 3.1.0. Can you try 4.0.0-RC1
Zatomsmasher commented on issue #2277: ERROR when tried to import sql file into
a sharding-proxy system
URL:
https://github.com/apache/incubator-shardingsphere/issues/2277#issuecomment-487522617
![image](https://user-images.githubusercontent.com/37434384/56888991-e83e7200-6aa7-11e9-8fec
tuohai666 commented on issue #2277: ERROR when tried to import sql file into a
sharding-proxy system
URL:
https://github.com/apache/incubator-shardingsphere/issues/2277#issuecomment-487515178
or master-slave rule which master and slave share the same datasource
tuohai666 commented on issue #2277: ERROR when tried to import sql file into a
sharding-proxy system
URL:
https://github.com/apache/incubator-shardingsphere/issues/2277#issuecomment-487512597
`insert into info_title values(1521846697390,'搜索结果:\'swatch 、\'');`
This SQL can't
Zatomsmasher commented on issue #2277: ERROR when tried to import sql file into
a sharding-proxy system
URL:
https://github.com/apache/incubator-shardingsphere/issues/2277#issuecomment-487513893
or I can make a sharding rule like %1
Zatomsmasher commented on issue #2277: ERROR when tried to import sql file into
a sharding-proxy system
URL:
https://github.com/apache/incubator-shardingsphere/issues/2277#issuecomment-487512245
i did a little test. It seems that all the error sql contains **\'**
character
Zatomsmasher edited a comment on issue #2277: ERROR when tried to import sql
file into a sharding-proxy system
URL:
https://github.com/apache/incubator-shardingsphere/issues/2277#issuecomment-487512245
i did a little test. It seems that all the error sql contains **\\'**
character
Zatomsmasher edited a comment on issue #2277: ERROR when tried to import sql
file into a sharding-proxy system
URL:
https://github.com/apache/incubator-shardingsphere/issues/2277#issuecomment-487512245
i did a little test. It seems that all the error sql contains **\'**
character
tuohai666 commented on issue #2277: ERROR when tried to import sql file into a
sharding-proxy system
URL:
https://github.com/apache/incubator-shardingsphere/issues/2277#issuecomment-487504024
@Zatomsmasher This is a parsing problem. Are there any more SQLs that can't
execute? We may fix
tianyijushi opened a new issue #2301: sharding-proxy doesn't has some tables in
the config default datasource,why?
URL: https://github.com/apache/incubator-shardingsphere/issues/2301
## Question
i has three databases,the config-sharding.yaml like that :
schemaName: sharding_db
tuohai666 commented on issue #2277: ERROR when tried to import sql file into a
sharding-proxy system
URL:
https://github.com/apache/incubator-shardingsphere/issues/2277#issuecomment-487502274
@Zatomsmasher I got it . These two SQLs are not identical
Zatomsmasher commented on issue #2277: ERROR when tried to import sql file into
a sharding-proxy system
URL:
https://github.com/apache/incubator-shardingsphere/issues/2277#issuecomment-487502249
@tuohai666
CREATE TABLE `info_title` (
`id` bigint(20) NOT NULL,
`name` varchar
tuohai666 commented on issue #2277: ERROR when tried to import sql file into a
sharding-proxy system
URL:
https://github.com/apache/incubator-shardingsphere/issues/2277#issuecomment-487501774
@Zatomsmasher Please describe table
Zatomsmasher commented on issue #2277: ERROR when tried to import sql file into
a sharding-proxy system
URL:
https://github.com/apache/incubator-shardingsphere/issues/2277#issuecomment-487501023
@tuohai666
MySQL Community Server 5.5.52
![Uploading image.png
Zatomsmasher edited a comment on issue #2277: ERROR when tried to import sql
file into a sharding-proxy system
URL:
https://github.com/apache/incubator-shardingsphere/issues/2277#issuecomment-487501023
@tuohai666
MySQL Community Server 5.5.52
![image](https://user
tuohai666 commented on issue #2277: ERROR when tried to import sql file into a
sharding-proxy system
URL:
https://github.com/apache/incubator-shardingsphere/issues/2277#issuecomment-487492861
@Zatomsmasher I have tried the SQL in raw database and got a error message:
```
insert
Zatomsmasher commented on issue #2277: ERROR when tried to import sql file into
a sharding-proxy system
URL:
https://github.com/apache/incubator-shardingsphere/issues/2277#issuecomment-487488976
@tuohai666
1.same error
2.worked well
3. insert into info_title values
Zatomsmasher commented on issue #2277: ERROR when tried to import sql file into
a sharding-proxy system
URL:
https://github.com/apache/incubator-shardingsphere/issues/2277#issuecomment-487489206
@tuohai666 sry for the delay
1 - 100 of 227 matches
Mail list logo