Skip to content

"Delete selected row(s)" fails if the underlying query contains an internal SQL function #838

Description

@trabant-asb

Steps to reproduce this issue

  1. Open HeidiSQL, load and execute an SQL query which contains an internal SQL function like in this case the date function "FROM_UNIXTIME":
SELECT channel_id AS Kanal,VALUE AS Wert,TIMESTAMP,FROM_UNIXTIME(TIMESTAMP / 1000 ) AS Echtzeit,id AS SQL_ID
FROM `volkszaehler`.`data` 
WHERE `channel_id` = 10
and TIMESTAMP> (unix_timestamp(current_timestamp)-24*60*60)*1000
  1. Select a row.
  2. Right click and choose "Delete selected row(s)"
  3. The following pop-up will show up...

error

Current behavior

An error message shows up:

"Grid editing error: Column #3 has an undefined origin: Echtzeit"

Expected behavior

Ignore the column which - in this case - just reformats the timestamp into a human readable format.

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

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions