#13269: When disconnected, autocomplete should not update its schema cache

kin-hong reported 2015-04-23T19:54:22Z · VikramPacharne(*) last modified 2015-05-04T06:03:05Z

When disconnected, autocomplete should not update its schema cache

Dev	kin-hong
QA	tariqrahiman

Priority	Major
Complexity	Easy

Component	Q Analyzer - Auto-Completion
Version	15.0

Autocomplete should not update its schema cache when the database connection is disconnected.

open a query analyzer window to, say, Sybase ASE 16
without typing anything, click the "Disconnect" button to disconnect from database server
type "select *^" to autocomplete, no popup should show because it is disconnected
now click the "Reconnect" button to re-establish a database connection
do autocomplete with "select *^" again

Notice that no completion popup (that shows a list of table names) appears although it should.

1 attachment

Screen Shot 2015-04-23 at 4.28.44 PM.png

2015-04-23T23:30:46Z

63 KB

All Comments (3) Change History

kin-hong 2015-04-23T20:14:15Z

The fix is to not cache an AFSchema with no tables in autocomplete. Then when the connection is re-established, autocomplete gets the chance to re-query the database to extract schema information.

tariqrahiman 2015-04-24T19:31:13Z · (edited)

Test 1

Connection time out occurs

User performs a re-connect and then types in SELECT * from ^

Actual result -> auto-complete does not work

Expected result -> auto completion pops up

Build ADS 15.0.15.2 is fixed.

---

Test 1

Open Query window.

Disconnect Server in Query Window

User performs a re-connect and then types in SELECT * from ^

Actual result -> auto-complete does not work

Expected result -> auto completion pops up

Build ADS 15.0.15.2 is fixed.

---

Test 3

Open Query window and Disconnect.

Type SQL and SELECT * from ^

Actual result -> auto-complete pops up

Expected result -> auto completion should not pop up

Build ADS 15.0.15.2 is not fixed.

Earlier builds are also not working properly [Log a new issue]

VikramPacharne(*) 2015-05-04T06:03:05Z

Verified in ADS 16.0.5

Search Tips

Aqua Data Studio / nhilam

When disconnected, autocomplete should not update its schema cache

1 attachment

Issue #13269

Completion

1 issue link

Issue #13860

Search Tips

Aqua Data Studio / nhilam

Title

When disconnected, autocomplete should not update its schema cache

1 attachment

Issue #13269

Completion

1 issue link

Issue #13860