Re:How does shardingsphere handle queries about information_shema ?

2019-11-19 Thread Juan Pan
Sure, a further discussion, as the first step, is necessary. Juan Pan panj...@apache.org Juan Pan(Trista), Apache ShardingSphere On 11/20/2019 14:23??sushixiang wrote?? Thank you, And I think this feature may need a further disscussion. --Original--

Re:How does shardingsphere handle queries about information_shema ?

2019-11-19 Thread sushixiang
Thank you, And I think this feature may need a further disscussion. --Original-- From:"Juan Pan"

Re:How does shardingsphere handle queries about information_shema ?

2019-11-19 Thread Juan Pan
Exactly true. ShardingSphere only returns the metadata of actual table currently. We expect someone who is interested in it can do some contributions to make it better. :) Welcome. Juan Pan panj...@apache.org Juan Pan(Trista), Apache ShardingSphere On 11/20/2019 14:11??sushixiang

Re:How does shardingsphere handle queries about information_shema ?

2019-11-19 Thread sushixiang
Thanks for replying. But, there are also some problems.If my sql is "select * from information_schema.columns where table_name = 't_order'", shardingsphere will not response the correct result while the t_oder is a sharding table, because the physical table name may be t_order_0. It may be

Re:How does shardingsphere handle queries about information_shema ?

2019-11-19 Thread Juan Pan
Hi did you use MySQL?? Please add item of `defaultDataSource` to your shardingRule configuration. When ShardingSphere doesn??t find any sharding table named `column`, it will send query to default datasource, i.e `innformation_schema`. Juan Pan panj...@apache.org Juan Pan(Trista), Apache

How does shardingsphere handle queries about information_shema ?

2019-11-19 Thread sushixiang
How does shardingsphere handle queries about information_shema ? Now, when I query from tables in information_schema, exception like "Table 'information.column' doesn't exist"will cause. So, does shardingsphere deal with the information_shema query scene??