I have encountered some odd behavior if I highlight the content of SQL queries before executing them with F9:
ISSUE 1. For some queries, if I highlight the query first, then press F9, the query runs fine but doesn’t go into the “SQL Recall” window, as shown below:
However if I do NOT highlight the query first, and press F9, the query runs and also appears in the “SQL Recall” window:
I would expect the query to appear in the “SQL Recall” window regardless of whether it was highlighted or not.
ISSUE 2: If my SQL query begins with INSERT INTO and I highlight the entire text of the query before pressing F9, the progress bar freezes at the bottom of the screen and in the “Background Processes” window, and it doesn’t tell me how many tasks are running. (It looks like the query is stuck but it will finish normally.) The progress bar for this query is half-filled with green and not moving for this query (and moving normally for a separate query that I started earlier):
However if I do NOT highlight the highlight the query text first before pressing F9, the progress bars all move normally, and the one at the bottom says I have “2 tasks” running:
Perhaps this behavior is intentional, but it looks like bugs to me so I wanted to report it.
I am using Toad Data Point version 126.96.36.19994.