distal-attribute
distal-attribute
distal-attribute
distal-attribute

[Bug] - Export SQL DELETEs/INSERT

firemaker86 posted 1 year ago in General

Hi,

I've the latest nightly build of HeidiSQL 9.3.0.5072.

When I try to export to clipboard a resultset, with SQL DELETEs/INSERTs option the application crashes.

The problem is that the query is not from a table, but is a derived from a Union, so the table name is "Ignote".

SELECT * FROM table_a
UNION
SELECT * FROM table_a_bak

Should fix this bug like in other options "SQL INSERT" and "SQL REPLACEs":

REPLACE INTO `UnknownTable`

Regards

ansgar posted 12 months ago

Confirmed. That's a problem with the new DELETE/INSERT format, which requires an appropriate WHERE clause in the DELETE query. While composing that WHERE clause, HeidiSQL searches for the right table name and fails here for non-table queries, which is good when the user edits data in a grid, but renders the export option useless here.

ansgar posted 12 months ago

r5075 now shows a normal error box instead of the crash in such cases.

Please login to leave a reply, or register at first.