UNION with MySQL

rkishore999 Jan 20, 2010 6:17 PM

UNION with more than two queries is not working with VDB built from MySql tables.

select column1 from table1

UNION

select column1 from table2

In the above case it's working.

select column1 from table1

UNION

select column1 from table2

UNION

select column1 from table3

In this case it's not working. It's working connecting to Oracle though. Any help please??

Regards

Ram

1. Re: UNION with MySQL

shawkins Jan 21, 2010 12:07 AM (in response to rkishore999)

This will require a code fix. Our generated query assumes you can use parens to nest set operations, which is apparently not supported for MySQL.
Actions
2. Re: UNION with MySQL

shawkins Jan 21, 2010 9:20 PM (in response to shawkins)

This was logged as https://jira.jboss.org/jira/browse/TEIID-939, targeted to 7.0.
Actions