Skip to content

"Column #x has an undefined origin" when trying to delete row from a multi-table result #839

Description

@trabant-asb

Please note: This issue is closely related to #838

Steps to reproduce this issue

  1. Open HeidiSQL, load and execute an SQL query which contains an a subquery to another table:
SELECT channel_id AS Kanal,
  (SELECT VALUE FROM `volkszaehler`.`properties`  WHERE  `entity_id` = 10 AND `pkey` = 'title') AS Name,
  VALUE AS Wert,
  TIMESTAMP, id AS SQL_ID
  FROM volkszaehler`.`data`
  WHERE `channel_id` =  10
  1. Select a row.

  2. Right click and choose "Delete selected row(s)"
    A pop-up will show up...

Current behavior

"Grid editing error: Column #1 has an undefined origin: Name"

Expected behavior

Delete the row without affecting the column coming from the sub-query.

Possible solution

Show a pop-up informing the user about the unknown origin of that column. Explain that the delete operation won't affect the values in that column. Ask if he/she is sure about that delete and wants to continue.

Environment

HeidiSQL version: 10.3.0.5771 (32 bit, Windows 7)
Database system and version: MariaDB 10.3
Operating system: Linux 4.19.50-v7+ #896 SMP Thu Jun 20 16:11:44 BST 2019 armv7l GNU/Linux

Metadata

Metadata

Assignees

No one assigned

    Labels

    confirmedIssue verified by project memberenhancementEnhances an existing feature

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions