Ctrl-Shift-F9 broken in latest versions
Brought to you by:
ansgarbecker
Originally created by: technoma...@googlemail.com
What exact steps will reproduce the problem?
1. Have 2+ separate queries in an sql window
2. Put your cursor on the end of a random query
3. Press Ctr-ShiftF9
What was the expected output?
This used to execute the query on which your cursor is
What happened instead?
Pops with mysql syntax error; heidi seems to try to execute all queries in
the sql window
Suggested fix (optional)?
I know of Ctrl-F9 which executes the "selected" text but Ctrl-Shift-F9 is a
feature that worked for years and does not work anymore.
Version used?
HeidiSQL revision: latest daily
MySQL Server version: any
Operating system: Win any
View and moderate all "tickets Discussion" comments posted by this user
Mark all as spam, and block user from posting to "Tickets"
Originally posted by: a...@anse.de
Works for me. Look at the screenshot and please compare the cursor position to the
one you meant. And please ensure you didn't customize your shortcut for "Run current
query" by right click into query memo and having a look at the popup menu item.
Status: NeedInfo
View and moderate all "tickets Discussion" comments posted by this user
Mark all as spam, and block user from posting to "Tickets"
Originally posted by: technoma...@googlemail.com
Try as above but *without* a semicolon on first row, i.e.:
select 1
select 2 (put your cursor here and press Ctrl-Shift-F9)
This worked for years and was very useful; ppl like to type queries once after the
other and execute them separately in the same window; it broke recently
View and moderate all "tickets Discussion" comments posted by this user
Mark all as spam, and block user from posting to "Tickets"
Originally posted by: a...@anse.de
Ah I see - you expected the old behaviour "Run current line" which was requested to
be changed to "Run current query". See issue #821 for a discussion about that change.
To fix that, just place a delimiter (semicolon) after "SELECT 1". The good thing is
that queries can span more than one line, so the following now also runs:
SELECT 1, 2,
3,<CURSOR HERE> 4;
SELECT 5
Status: Invalid
Related
Tickets:
#821View and moderate all "tickets Discussion" comments posted by this user
Mark all as spam, and block user from posting to "Tickets"
Originally posted by: technoma...@googlemail.com
Ok the key changed behaviour. As a humble advice, try to use a *new* key for new
functionality asked and leave previous behaviour untouched because it is *used* ;
e.g. many query files have been saved *without* the semicolon separating so all this
has to be rewritten. This is like someone asking to change save key (Ctrl-S) to now
behanve as "Send Doc as Email" in an Office application - you would not be that happy
with that. Can you at least give us a key and menu item with the old "Run Current
Line" bahviour?
View and moderate all "tickets Discussion" comments posted by this user
Mark all as spam, and block user from posting to "Tickets"
Originally posted by: a...@anse.de
No, sorry. If you honestly want that you should dive into the discussion in issue #821.
Related
Tickets:
#821