Please note: This issue is closely related to #838
Steps to reproduce this issue
- 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
-
Select a row.
-
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
Please note: This issue is closely related to #838
Steps to reproduce this issue
Select a row.
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