Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Appearance settings

Incorrect table name used #1854

Copy link
Copy link
Closed
Closed
Copy link
@alexcesygroupcom

Description

@alexcesygroupcom
Issue body actions

Preconditions

  • HeidiSQL version: 12.5.0.6687
  • Database type and version: MySQL 8.0.34
  • OS: WIndows 7

Describe the bug

To Reproduce
Type the following.
First, type a select query with any table and put SQL comment dashes at the front so the query is commented.
Then, type another select query underneath without commenting it and run the query.
In the window below you will see query results from table2 table.
Right click on any row and select "Duplicate row without keys" or press "Ctrl" + "Insert". Then click anywhere outside the rows for the row to be actually be inserted. The HeidiSQL will try to create another row in the table2 by using the field names from table1 which will usually cause an error if the column names in either tables are different.

-- SELECT * FROM table1
SELECT * FROM table2

Screenshots or Crash reports

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions

      Morty Proxy This is a proxified and sanitized view of the page, visit original site.