speedment/speedment

This does not return a correct result. The query would be this:

SELECT
    l_shipmode,
    sum (case
        when o_orderpriority = '1-URGENT'
            OR o_orderpriority = '2-HIGH'
            then 1
        else 0
    end) the high_line_count,
    sum (case
        when o_orderpriority <> '1-URGENT'
            AND o_orderpriority <> '2-HIGH'
            then 1
        else 0
    end) AS low_line_count
FROM
    orders
    lineitem
ONDE
    o_orderkey = l_orderkey
    AND l_shipmode in ('MAIL', 'SHIP')
    AND l_receiptdate> = date '1994-01-01'
    AND l_receiptdate <date '1994-01-01' + interval '1' year
GROUP BY
    l_shipmode

And I have this:

Join <Tuple2 <Orders, Lineitem >> joinFirst = joinComponent
                .from (OrdersManager.IDENTIFIER)
                .innerJoinOn (Lineitem.L_ORDERKEY) .equal (Orders.O_ORDERKEY)
                .where (Lineitem.L_SHIPMODE.in ("MAIL", "SHIP"))
                .where (Lineitem.L_RECEIPTDATE.greaterOrEqual (sqlDate) .and (Lineitem.L_RECEIPTDATE.lessThan (sqlDate2)))
                .build (Tuples :: of);


        Map <Boolean, Long> grouped = joinFirst.stream ()
                .collect (Collectors.partitioningBy (t> t.get0)) getOOrderpriority (). equals ("1-URGENT") || t.get0.) getOOrderpriority (). equals ("2-HIGH"), counting ()));


        grouped.forEach ((k, v) -> {
            System.out.format ("% - 32s,%, d% n", k, v);
        });