The client got the wrong database name

[hellobob]

Please search the existing issues for relevant feature requests, and use the reaction feature to add upvotes to pre-existing requests.

Feature Description

some client like sharding jdbc get the database name from query like select * from tb where 1!=1 to get the table_schema and the dbname.
But vitess return dbname xxx like vt_xxx, the client user the wrong dbname to send query to vitess and get the errs like
keyspace vt_vt_commerce not found in vschema（using select * from vt_commerce.tb ）
or
Table 'vt_vt_commerce.tb' doesn't exist（using show full columns from vt_commerce.tb ）

use tcpdump get the follows info:

Use Case(s)

Any relevant use-cases that you see.

[harshit-gangal]

Current workaround would be to provide -init_db_name_override in vttablet command line flag to same as keyspace name.

[harshit-gangal]

have to tried providing database name in jdbc connection url? Does that work?

[hellobob]

connection

this does't work . the developer used the java framewrok named shardingjdbc to sharding tables and used vitess to shard db