eftomi/PharoADO

Compound expression issue

Opened this issue · 0 comments

eftomi commented

Got

SELECT DISTINCT * FROM ((SELECT t1.ID, t1.STREET, t1.HOUSE_NUM
FROM GR_ADDRESS t1) UNION ALL (SELECT t1.ID, t1.STREET, t1.HOUSE_NUM
FROM GR_ADDRESS t1)) t1

instead of

SELECT DISTINCT * FROM (SELECT t1.ID, t1.STREET, t1.HOUSE_NUM
FROM GR_ADDRESS t1 UNION ALL SELECT t1.ID, t1.STREET, t1.HOUSE_NUM
FROM GR_ADDRESS t1) t1

GlorpQueryUnionTest>>#testCreateCompoundExpression