-
Title
Run the same query on a 'changed' session in the same Editor Window, the columns do not expand -
Description
I have two connections Schema_A and Schema_B. When I run or execute a query on Schema_A, then use the 'Change Session' icon to switch my connection in the same Editor Window to Schema_B, and then run the same query again, the column width in the data grid does not expand (does not refresh), and thus new data results does not fit anymore in the column if the new data results is longer than the previous data results.
-
Resolution
WORKAROUND:
NoneSTATUS:
Waiting for fix in a future release of Toad for Oracle. -
Defect ID
ST79966 -
Additional Information
TEST STEPS:
Scenario:
Two schemas have the same table, but data content is different. Using ‘one’ Editor Window, run a query on Schema_A. Next change the session to Schema_B using the “Change Session” icon. Without changing the query statement, press F9 again to run it. The column width does not adjust (or does not refresh) to the new data contents so if data contents has more characters in it, the column width will no longer fit the contents and will cut-off the display of the data contents.View Menu | Toad Options | Data Grids | Visual | Column sizing |“Size to data” | these are set to the default settings.
TEST STEPS:1) Connected both Marvin1 and Marvin 2 schemas
2) The “CCC” table exists in the two schemas
3) Data in CCC table under Marvin2 has 'shorter' data contents length
4) Data in CCC table under Marvin1 has 'longer' data contents length
5) Using ‘one’ Editor Window and using the Marvin2 session, I run SELECT * FROM CCC
6) Data is displayed and the column width fits the header and data contents nicely
7) Used the "Change Session" icon to switch to Marvin1 connection
8) Pressed F9 again to run the same query.
9) Since the “CCC” table data under Marvin1 has longer (has more characters) data contents, it no longer fits in the column size and the display of data contents were cut-off
10) Toad does not refresh the column width size when running same query after changing to another session/schema