Bug 417113 - Add support for INSERT queries in the Query designer
Summary: Add support for INSERT queries in the Query designer
Status: REPORTED
Alias: None
Product: KEXI
Classification: Applications
Component: Queries (show other bugs)
Version: 3.2.0
Platform: Other Microsoft Windows
: NOR wishlist
Target Milestone: ---
Assignee: Kexi Bugs
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-02-03 18:17 UTC by mhansoncs
Modified: 2020-02-03 18:34 UTC (History)
3 users (show)

See Also:
Latest Commit:
Version Fixed In:
Sentry Crash Report:


Attachments
Image showing the issue. (28.58 KB, image/png)
2020-02-03 18:25 UTC, mhansoncs
Details
Another image showing the error. (28.22 KB, image/png)
2020-02-03 18:25 UTC, mhansoncs
Details

Note You need to log in before you can comment on or make changes to this bug.
Description mhansoncs 2020-02-03 18:17:09 UTC
SUMMARY


STEPS TO REPRODUCE
1. Create a query using SQL view.
2. Include in that query INSERT INTO like you would to insert data into another table,(i.e. insert into table2 (a, b, c) select (d, e, f) from table 1;)
3. click "Check Query"

OBSERVED RESULT
"The query is incorrect
"INSERT" is a reserved keyword."

EXPECTED RESULT
The query is correct

SOFTWARE/OS VERSIONS
Windows: 10


ADDITIONAL INFORMATION
Comment 1 mhansoncs 2020-02-03 18:25:05 UTC
Created attachment 125645 [details]
Image showing the issue.
Comment 2 mhansoncs 2020-02-03 18:25:33 UTC
Created attachment 125646 [details]
Another image showing the error.
Comment 3 Jarosław Staniek 2020-02-03 18:34:31 UTC
Thanks, changes the title to "Add support for INSERT queries in the Query designer" because for now only SELECT queries are recongnised in the Designer.

Wish #298149 is somehow alternate approach too.