**使用dbeaver连接 mysql8.0.28 的 shardingsphere proxy可以查看表数据, 使用 datagrip连接mysql8.0.28 的 shardingsphere proxy连接成功, 但是点击数据库无法查看表, 只能通过sql操作, 提示 Connection Error, **
报错如下:
[HY000][30000] Unknown exception: Unable to implement EnumerableSort(sort0=[$0], sort1=[$1], sort2=[$2], dir0=[ASC], dir1=[ASC], dir2=[ASC]): rowcount = 3.375, cumulative cost = {106.75 rows, 4948.792031905426 cpu, 0.0 io}, id = 99 EnumerableCalc(expr#0..30=[{inputs}], expr#31=[null:NULL], expr#32=[1], expr#33=[_UTF-8'FUNCTION'], expr#34=[LIKE($t4, $t33)], expr#35=[CAST($t2):VARCHAR CHARACTER SET "UTF-8"], expr#36=[_UTF-8'clitest':VARCHAR CHARACTER SET "UTF-8"], expr#37=[=($t35, $t36)], expr#38=[IS NOT NULL($t3)], expr#39=[AND($t34, $t37, $t38)], FUNCTION_CAT=[$t2], FUNCTION_SCHEM=[$t31], FUNCTION_NAME=[$t3], REMARKS=[$t26], FUNCTION_TYPE=[$t32], SPECIFIC_NAME=[$t3], $condition=[$t39]): rowcount = 3.375, cumulative cost = {103.375 rows, 4801.0 cpu, 0.0 io}, id = 98 EnumerableTableScan(table=[[INFORMATION_SCHEMA, ROUTINES]]): rowcount = 100.0, cumulative cost = {100.0 rows, 101.0 cpu, 0.0 io}, id = 92.
我的shardingsphere proxy 配置文件如下:
localProxyServer:
authority:
users:
- user: test
password: 123456
privilege:
type: ALL_PERMITTED
props:
sql-federation-type: ADVANCED
数据库版本: mysql8.0.28
datagrip版本: 2023.3.2
shardingsphere proxy 版本: 5.3.2
但是datagrip连接mysql5.7.43的 shardsphere proxy是可以打开数据库看到表的
希望各位给我一些建议