Union.list() behavior inconsistent with normal queries

[cowwoc]

Union.list() returns an empty list in case of no results while normal queries return null. The two should behave the same.

[cowwoc (gili)]

My mistake. The Union was returning a list of size 1 where the nested element was an empty list. Closing this bug as invalid.

[cowwoc (gili)]

On second thought, I think the original bug report is still valid. When the union returns no rows, list() returns a list of size 1 containing an empty list instead of returning null.

[Timo Westkämper (timo-westkamper)]

Can you given me an example code snippet of such a query? I couldn't replicate this as a test :

    @Test
    public void Union_Empty_Result() throws SQLException {
        SubQueryExpression<Integer> sq1 = sq().from(employee).where(employee.firstname.eq("XXX")).unique(employee.id);
        SubQueryExpression<Integer> sq2 = sq().from(employee).where(employee.firstname.eq("YYY")).unique(employee.id);
        List<Integer> list = query().union(sq1, sq2).list();
        assertTrue(list.isEmpty());
    }

list() should never return null

[cowwoc (gili)]

My mistake, I was confusing uniqueResult() with list(). The former returns null on no match, the latter returns an empty list. I agree with the current behavior. Closing this issue as INVALID.