When doing a Group Execute on one table in two databases in MySQL, the result set only shows from one table (4241544)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

When doing a Group Execute on one table in two databases in MySQL, the result set only shows from one table
Description

In the Editor, when doing a Group Execute on one table in 2 MySQL databases, the result set only shows from one table.

The workaround is to run the statement manually, such as:

select column FROM db01.table1
UNION ALL
select column FROM db02.table1;
Cause

The issue happens in v5.3 and v5.4, but only on MySQL. Against another database type it is ok.
Resolution

WORKAROUND:
None

STATUS:
Waiting for fix in a future release of Toad Data Point
Defect ID

QAT-16448

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title