Bug 417113

Summary:	Add support for INSERT queries in the Query designer
Product:	[Applications] KEXI	Reporter:	mhansoncs
Component:	Queries	Assignee:	Kexi Bugs <kexi-bugs>
Status:	REPORTED ---
Severity:	wishlist	CC:	adam, inksi, staniek
Priority:	NOR
Version:	3.2.0
Target Milestone:	---
Platform:	Other
OS:	Microsoft Windows
Latest Commit:		Version Fixed In:
Sentry Crash Report:
Attachments:	Image showing the issue. Another image showing the error.

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.