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.
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. |
Field | Old Value | New Value |
---|---|---|
Fixed Build | 31282 | |
Resolution | Fixed | |
Resolved Date | Feb 8, 2013 10:45 PM | |
Status | New | Resolved |
Field | Old Value | New Value |
---|---|---|
Status | Resolved | Closed |
Issue #8319 |
Closed |
Fixed |
Resolved |
Completion |
No due date |
Fixed Build 31282 |
No time estimate |