#9891: Drop down does not display the selected database for Query Analyzer Window.

nileshhmali reported Sep 4, 2013 · tariqrahiman last modified Nov 25, 2013

Drop down does not display the selected database for Query Analyzer Window.

Dev	kin-hong
QA	tariqrahiman

Priority	Major
Complexity	Unknown

Component	Q Analyzer
Version	14.0

ADS version : ads-windows-x64-14.0-rc-08

Go to server menu bar ->Click on query analyzer window ->Open Choose server or database popup->Expand server->

select database->Click on ok button then on Query analyzer window database drop down has mysql database as default database,rather then the database under which we are making a selection.

This issue also reproducible in Azure,Cassandra database.

6 attachments

1.jpg

Sep 4, 2013

194 KB
2.jpg

Sep 17, 2013

232 KB
1.jpg

Oct 29, 2013

277 KB
queryanalyzer1.jpg

Nov 21, 2013

267 KB
queryanalyzer3.jpg

Nov 21, 2013

287 KB
queryanalyzer2.jpg

Nov 21, 2013

252 KB

All Comments (9) Change History

nileshhmali Sep 6, 2013 · (edited)

We have not handled above scenario in the following places.

1)Go to server menu bar ->Click on query analyzer window. ==> FIXED

2)Go to ER-Modeler menu bar->Click on generate.

3)Go to tools bar->Schema script generator.

4)Open Entity relationship diagram->go to tools->Compare database.

5)Open Entity relationship diagram->go to tools->Import database.

6)Opened query analyzer window->click on change server connection.

nileshhmali Sep 17, 2013

Above issue also reproducible in server menu bar ->Click on query analyzer window.

Screenshot is attached for reference.

nileshhmali Sep 23, 2013

Verified in 14.0.0-rc-27

tariqrahiman Sep 27, 2013

Verified in 14.0.0-rc-36

nileshhmali Oct 21, 2013

We have not handled above scenario in the following place:

Go to tools menu bar->Select export data.

nileshhmali Oct 29, 2013 · (edited)

ADS version :ADS-windows-x64-15.0-dev-29

Above issue also reproducible

select files tab ->Right click on files system->select mount directory->select directory->Expand this directory

->right click on this file->select Open In.. option.->open choose database window.->select server and expand

->select database.

Screenshot is attached for reference.

tariqrahiman Nov 6, 2013

Verified for all the above scenarios in 14.0.3-21

vaibhavladdha271(*) Nov 21, 2013

ADS 15.0.0-dev-37

Operating environment:Windows 7 x64

Select Local Database servers

Click on Server menu->Select query analyzer->Expand Sql server 2005->select Model database->Click Ok

A java.lang.Null pointer exception is generated

i have attached screenshot(queryanalyzer1.jpg,queryanalyzer2.jpg,queryanalyzer3.pg)

tariqrahiman Nov 21, 2013 · (edited)

Creating a new issue for the Null Pointer Exception(#10869)

Search Tips

Aqua Data Studio / nhilam

Drop down does not display the selected database for Query Analyzer Window.

6 attachments

Issue #9891

Completion

1 issue link

Issue #8615

Search Tips

Aqua Data Studio / nhilam

Title

Drop down does not display the selected database for Query Analyzer Window.

6 attachments

Issue #9891

Completion

1 issue link

Issue #8615