× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
SachinPrakash reported Feb 8, 2013  · last modified Feb 27, 2013

Query Builder - database context is not being set in certain situations


customer request
Dev
Jenny Nishimura
JennyNishimura
QA
Priority Minor
Complexity Unknown
Component Query Builder
Version 12.0

1) Choose a MySQL connection and open the Query Builder for the first database in the database dropdown list and this database should not be the default database for the MySQL server.  For example, "ac10" is the first database in the database dropdown list and "mysql" is the default database.  I open the Query Builder for the "ac10" database.

2) Build any query and execute it -- it runs fine.

3) Save the query.

4) Re-open the query.  Note that "ac10" is specified in the database box.  However, when you execute the query, it complains that mysql.table doesn't exist.  The database context for "ac10" is not being set.

JennyNishimura   Feb 8, 2013
Field Old Value New Value
Description

1) Create a query in query builder

2) Execute the query in query builder -- it runs fine

3) Save the query

4) Re-open the query: the database context is not being set. This happens only for certain type of queries. Detailed steps pending based upon further code analysis.

 

1) Choose a MySQL connection and open the Query Builder for the first database in the database dropdown list and this database should not be the default database for the MySQL server.  For example, "ac10" is the first database in the database dropdown list and "mysql" is the default database.  I open the Query Builder for the "ac10" database.

2) Build any query and execute it -- it runs fine.

3) Save the query.

4) Re-open the query.  Note that "ac10" is specified in the database box.  However, when you execute the query, it complains that mysql.table doesn't exist.  The database context for "ac10" is not being set.

JennyNishimura   Feb 8, 2013
Field Old Value New Value
Fixed Build 31282
Resolution Fixed
Resolved Date Feb 8, 2013 10:45 PM
Status New Resolved
SachinPrakash   Feb 27, 2013
Field Old Value New Value
Status Resolved Closed

Issue #8319

Closed
Fixed
Resolved Feb 8, 2013
 
 
Completion
No due date
Fixed Build 31282
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017