Bug 338834

Summary: F9 shortcut key does not Check Query of SQL query in Query Design view SQL mode
Product: [Applications] KEXI Reporter: Ian Balchin <inksi>
Component: QueriesAssignee: Kexi Bugs <kexi-bugs>
Status: CLOSED FIXED    
Severity: normal CC: adam, inksi, staniek
Priority: NOR Keywords: junior-jobs
Version: 2.9 AlphaFlags: staniek: Usability+
Target Milestone: 2.9   
Platform: Mint (Ubuntu based)   
OS: Linux   
Latest Commit: http://commits.kde.org/calligra/1ba3fd5a5bcff842ec27ee27e65cc1808eb0dd71 Version Fixed In: 2.9.0
Sentry Crash Report:

Description Ian Balchin 2014-09-05 21:27:51 UTC 
F9 should initiate the same action as the Verify Query button for a written SQL query in Query Design view, SQL mode, but this does not occur.

Reproducible: Always

Steps to Reproduce:
1. Open a Query in Design view
2. Make a change to the SQL query to render it invalid
3. Press F9
4. Click the 'Check Query' icon

Actual Results:  
Checking the SQL query using the F9 shortcut produces no output. Clicking the 'Check Query' icon produces the message 'The Query is incorrect'.

Expected Results:  
That the F9 shortcut would act the same as the 'Check Query' icon.

This shortcut is not shown on the right-click menu

The earlier list of shortcuts shows this as functional under the Data view which is surely incorrect because you cannot move into Data mode from an incorrect SQL query.
Comment 1 Jarosław Staniek 2014-11-03 08:35:56 UTC 
It's a conflict with Kate's (part) shortcut for "Show folding markers" action.

One solution could be to change to something else. MS Access lacks the action; users have to actually switch to data mode to check validity.
The closest thing I (quickly) found is MS SQL Server's Query Analyzer Shortcuts offer CTRL+F5 for "Parse query and check syntax":

http://blog.sqlauthority.com/2007/01/20/sql-server-query-analyzer-shortcuts/

Would it be OK to change?
Comment 2 Roman Shtemberko 2015-01-19 09:26:54 UTC 
Git commit 1ba3fd5a5bcff842ec27ee27e65cc1808eb0dd71 by Roman Shtemberko.
Committed on 19/01/2015 at 09:25.
Pushed by rshtemberko into branch 'calligra/2.9'.

Add Ctrl+F5 shortcut for Check Query of SQL query in Query Design view SQL.
REVIEW:122051

M  +2    -1    kexi/plugins/queries/kexiquerydesignersql.cpp

http://commits.kde.org/calligra/1ba3fd5a5bcff842ec27ee27e65cc1808eb0dd71