Menu

#1283 Copy as SQL INSERT-VALUES replaces table name with "PressCtrlH"

All
closed
nobody
None
5
2018-03-25
2017-01-18
No

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');

Discussion

  • Petr Bodnár

    Petr Bodnár - 2018-03-13

    Hi, thanks for the report and upvotes, but please consider closing this one as a duplicate and vote for the original bug #740 instead.

     
  • Harald Albers

    Harald Albers - 2018-03-17

    Oh yes, you're right. I did not find this one.

     
  • Harald Albers

    Harald Albers - 2018-03-17

    Turns out I don't have sufficient privileges to close this (my own) issue.

    So can please someone close this for being a duplicate?

     
  • Gerd Wagner

    Gerd Wagner - 2018-03-25
    • status: open --> closed
     
  • Gerd Wagner

    Gerd Wagner - 2018-03-25

    Closed on user request.

     

Log in to post a comment.