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

nileshhmali reported 2013-09-04T09:21:25Z · last modified 2013-11-25T22:51:28Z

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

2013-09-04T09:21:25Z

194 KB
2.jpg

2013-09-17T11:49:51Z

232 KB
1.jpg

2013-10-29T12:02:12Z

277 KB
queryanalyzer1.jpg

2013-11-21T13:11:14Z

267 KB
queryanalyzer3.jpg

2013-11-21T13:11:15Z

287 KB
queryanalyzer2.jpg

2013-11-21T13:11:15Z

252 KB

All Comments (9) Change History

nileshhmali 2013-09-09T08:20:25Z · (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 2013-09-17T11:49:52Z

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

Screenshot is attached for reference.

nileshhmali 2013-09-23T11:05:50Z

Verified in 14.0.0-rc-27

tariqrahiman 2013-09-27T21:36:38Z

Verified in 14.0.0-rc-36

nileshhmali 2013-10-21T11:59:26Z

We have not handled above scenario in the following place:

Go to tools menu bar->Select export data.

nileshhmali 2013-10-29T12:04:16Z · (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 2013-11-06T20:35:19Z

Verified for all the above scenarios in 14.0.3-21

vaibhavladdha271(*) 2013-11-21T13:17:31Z

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 2013-11-25T22:51:28Z · (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