Sure, a further discussion, as the first step, is necessary.
Juan Pan [email protected] Juan Pan(Trista), Apache ShardingSphere On 11/20/2019 14:23??sushixiang<[email protected]> wrote?? Thank you, And I think this feature may need a further disscussion. ------------------ Original ------------------ From: "Juan Pan"<[email protected]>; Date: Wed, Nov 20, 2019 02:15 PM To: "[email protected]"<[email protected]>; Cc: "dev"<[email protected]>; Subject: Re:How does shardingsphere handle queries about information_shema ? 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 [email protected] Juan Pan(Trista), Apache ShardingSphere On 11/20/2019 14:11??sushixiang<[email protected]> wrote?? 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 not elegant for using the physical table name. ------------------&nbsp;Original&nbsp;------------------ From:&nbsp;"Juan Pan"<[email protected]&gt;; Date:&nbsp;Wed, Nov 20, 2019 02:03 PM To:&nbsp;"[email protected]"<[email protected]&gt;; Cc:&nbsp;"dev"<[email protected]&gt;; Subject:&nbsp;Re:How does shardingsphere handle queries about information_shema ? 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`. &nbsp;Juan Pan [email protected] Juan Pan(Trista), Apache ShardingSphere On 11/20/2019 13:47??sushixiang<[email protected]&gt; wrote?? 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"&amp;nbsp;will cause. So, does shardingsphere deal with the information_shema query scene??
