Toad World® Forums

Exporting a table as a MERGE statement generates invalid SQL if the table contains PK columns only

The WHEN MATCHED part is empty*, which makes sense because there is no column to update. But I would expect the merge statement to contain only the WHEN NOT MATCHED part.

BR
Dirk

* It actually looks like:
WHEN MATCHED THEN UPDATE SET ;

That's a bug. I'll take care of it. Thanks Dirk.