#1344 A change of "SQL Combo History size" takes effect only after restarting Squirrel

[Chris B]

Unlike other settings for new sessions ("File > New Session properties") a change of "SQL Combo History size" takes effect only after restarting Squirrel.
(A change in "Auto Commit SQL" or "SQL results - Limit rows" e.g. takes effect for every newly opened session immediately after closing "New Session properties" with OK.)

[Chris B]

Squirrel 3.8.1

[Gerd Wagner]

Sorry, I can't reproduce the problem. Here's how I tried to reproduce it.

Prerequisite: The history's size is filled to its currently allowed maximum.

1. Increase the size in File --> New Session properties --> tab SQL with no Session open.

2. Open a new Session and execute an SQL that is not already part of the history. (Note: The history does never contain the same SQL twice.)

3. Check the number of entries is now one above the former maximum. That shows increasing the size works.

4. Close the Session, decrease the size and open another Session.

5. Execute any SQL.

6. Check the number of entries is now of the decreased maximum.

Gerd

[Chris B]

Unfortunately, I don't remember my exact findings and exact steps from May 24 :-(
So I replayed your steps 1 -6 ... and got the same results as you did.

However, I found one surprising detail, that could have been ther trigger for me writing the ticket:
If you decrease "SQL Combo History size" from 18 to 15 and open a new session,
the SQL history drow down list (as well as the SQL history window) will still contain 18 ... as long as you don't execute another SQL.
I guess I expected the history not to be longer than 15 from that very moment.

On the other hand, if you close and restart Squirrel, the history will immediately have just the expected 15 items, even if you didn't execute any SQL after the property change.