Incorrect database name in error when filtering non-existing table name
a
anonymous
started a topic
almost 10 years ago
[This topic is migrated from our old forums. The original author name has been removed]
Steps
- In the Object filter, Set database name to a database name (e.g. hello_world) that doesn't exist.
- Click Save Filter
Expected:
- The error that appears is: Unknown database 'hello_world'
Actual:
- The error that appears is: Unknown database '(null)'
An error occurred while executing the database request for:
MySQL
5.6.12
MySQL Connector Java
mysql-connector-java-5.1.25 ( Revision: ${bzr.revision-id} )
Short message:
An error occurred while performing the operation:
Unknown database '(null)'
The command that caused the problem:
SHOW FULL TABLES FROM `(null)` WHERE `table_type` NOT IN ('VIEW')
Long Message:
Unknown database '(null)'
Details:
Type: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException
Error Code: 1049
SQL State: 42000
System Information:
Product: DbVisualizer Pro 91.2030
Build: #2030 (2013/07/04 10:13)
Java VM: Java HotSpot(TM) Client VM
Java Version: 1.7.0_25
Java Vendor: Oracle Corporation
OS Name: Windows 7
OS Arch: x86
OS Version: 6.1
Edited by: Geff Chang on Jul 25, 2013 4:28 PM
anonymous