shardingsphere icon indicating copy to clipboard operation
shardingsphere copied to clipboard
verified publisher icon apache

"ERROR 1046 (3D000): No database selected",`preview sql` can't act as nomale sql ，even though i appoint database in sql

Open wsm12138 opened this issue 3 years ago • 3 comments

Bug Report

Which version of ShardingSphere did you use?

f44e5d3c09a38139dbb2e1b0548816aa572ccc3c

Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?

ShardingSphere-Proxy

Expected behavior

preview select have same action like select

Actual behavior

image

Reason analyze (If you can)

Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.

  1. start proxy
  2. don't use db
  3. execute select 1 from db.table image

Example codes for reproduce this issue (such as a github link).

wsm12138 avatar Sep 15 '22 07:09 wsm12138

@wsm12138 What does nomale SQL mean?

TeslaCN avatar Sep 30 '22 09:09 TeslaCN

I will follow up @wsm12138

RaigorJiang avatar Jan 29 '23 10:01 RaigorJiang

I will follow up @wsm12138

Thanks

wsm12138 avatar Aug 12 '24 02:08 wsm12138