Observed in SQirreL SQL Client Version 3.7.1 and several previous versions.
As 3.7.1 is not a valid choice for the Milestone field, I filed this issue under "All" in order to indicate that the issue is current.
Steps to reproduce
In the results tab of a query,
- select one row with the context menu entry "Select entire row(s)" or all rows with "Select All"
- In the context menu, select "Copy as SQL INSERT-VALUES statement"
- Paste the copied content somewhere
expected result
vaild SQL that reproduces the selected data in a target database
actual result
The table names are replaced with "PressCtrlH", e.g.
INSERT INTO PressCtrlH (KURZNAME,KURZNAMEEWI,NAME) VALUES ('D','DE','Deutschland');
Note: this function is also available in the content tab of the objects tree, where it works as expected (table names are preserved). The corresponding example is
INSERT INTO "SCHEMA"."LAND" (KURZNAME,KURZNAMEEWI,NAME) VALUES ('D','DE','Deutschland');
Hi, thanks for the report and upvotes, but please consider closing this one as a duplicate and vote for the original bug #740 instead.
Oh yes, you're right. I did not find this one.
Turns out I don't have sufficient privileges to close this (my own) issue.
So can please someone close this for being a duplicate?
Closed on user request.