jpa/eclipselink.jpa.wdf.test/src/it/java/org/eclipse/persistence/testing/tests/wdf/jpa1/query/TestAggregates.java

/*
 * Copyright (c) 2005, 2020 Oracle and/or its affiliates. All rights reserved.
 * Copyright (c) 2005, 2015 SAP. All rights reserved.
 *
 * This program and the accompanying materials are made available under the
 * terms of the Eclipse Public License v. 2.0 which is available at
 * http://www.eclipse.org/legal/epl-2.0,
 * or the Eclipse Distribution License v. 1.0 which is available at
 * http://www.eclipse.org/org/documents/edl-v10.php.
 *
 * SPDX-License-Identifier: EPL-2.0 OR BSD-3-Clause
 */

// Contributors:
//     SAP - initial API and implementation

package org.eclipse.persistence.testing.tests.wdf.jpa1.query;

import org.eclipse.persistence.testing.framework.wdf.ToBeInvestigated;
import org.junit.Test;

public class TestAggregates extends QueryTest {

    @Test
    public void testAvgHandling1() {
        /*
         * 00 null, /* 01 null, /* 02 "line 1: Path 'c.informers' is not a CMP path\n" +
         * "SELECT avg(distinct c.informers) FROM Cop c where avg(distinct c.partner) > 3.5 and exists(select avg(c1.partner) from Cop c1)\n"
         * + "                    ^\n" + "line 1: Path 'c.informers' is not of numeric type (Informer)\n" +
         * "SELECT avg(distinct c.informers) FROM Cop c where avg(distinct c.partner) > 3.5 and exists(select avg(c1.partner) from Cop c1)\n"
         * + "                    ^\n" + "line 1: Path 'c.partner' is not a CMP path\n" +
         * "SELECT avg(distinct c.informers) FROM Cop c where avg(distinct c.partner) > 3.5 and exists(select avg(c1.partner) from Cop c1)\n"
         * + "                                                               ^\n" +
         * "line 1: Path 'c.partner' is not of numeric type (Cop)\n" +
         * "SELECT avg(distinct c.informers) FROM Cop c where avg(distinct c.partner) > 3.5 and exists(select avg(c1.partner) from Cop c1)\n"
         * + "                                                               ^\n" +
         * "line 1: Path 'c1.partner' is not a CMP path\n" +
         * "SELECT avg(distinct c.informers) FROM Cop c where avg(distinct c.partner) > 3.5 and exists(select avg(c1.partner) from Cop c1)\n"
         * + "                                                                                                      ^\n" +
         * "line 1: Path 'c1.partner' is not of numeric type (Cop)\n" +
         * "SELECT avg(distinct c.informers) FROM Cop c where avg(distinct c.partner) > 3.5 and exists(select avg(c1.partner) from Cop c1)\n"
         * + "                                                                                                      ^\n",
         */
        // TODO parser/mapper have to be fixed
        /* 0 assertValidQuery("SELECT avg(c.id) FROM Cop c where avg(c.id) > 3.5 and exists(select avg(c1.id) from Cop c1)"); */

        // TODO parser/mapper have to be fixed
        /*
         * 1assertValidQuery(
         * "SELECT avg(distinct c.id) FROM Cop c where avg(distinct c.id) > 3.5 and exists(select avg(distinct c1.id) from Cop c1)"
         * );
         */

        assertValidQueryExecution("SELECT e.firstname, avg(e.salary) FROM Employee e GROUP BY e.firstname HAVING avg(e.salary) > 2000");
    }

    @Test
    public void testAvgHandling2() {
        /* 2 */assertInvalidQuery("SELECT avg(distinct c.informers) FROM Cop c where avg(distinct c.partner) > 3.5 and exists(select avg(c1.partner) from Cop c1)");
    }

    @Test
    public void testMaxHandling() {
        /*
         * 03 null, /* 04 null, /* 05 "line 1: Path 'c.informers' is not a CMP path\n" +
         * "SELECT max(distinct c.informers) FROM Cop c where max(distinct c.partner) > 3.5 and exists(select max(c1.partner) from Cop c1)\n"
         * + "                    ^\n" + "line 1: No order defined on type (Informer) of path 'c.informers'\n" +
         * "SELECT max(distinct c.informers) FROM Cop c where max(distinct c.partner) > 3.5 and exists(select max(c1.partner) from Cop c1)\n"
         * + "                    ^\n" + "line 1: Path 'c.partner' is not a CMP path\n" +
         * "SELECT max(distinct c.informers) FROM Cop c where max(distinct c.partner) > 3.5 and exists(select max(c1.partner) from Cop c1)\n"
         * + "                                                               ^\n" +
         * "line 1: No order defined on type (Cop) of path 'c.partner'\n" +
         * "SELECT max(distinct c.informers) FROM Cop c where max(distinct c.partner) > 3.5 and exists(select max(c1.partner) from Cop c1)\n"
         * + "                                                               ^\n" +
         * "line 1: Comparison '>' not defined for entity beans\n" +
         * "SELECT max(distinct c.informers) FROM Cop c where max(distinct c.partner) > 3.5 and exists(select max(c1.partner) from Cop c1)\n"
         * + "                                                                          ^\n" +
         * "line 1: Comparison of incompatible types: (Cop) '>' (java.math.BigDecimal)\n" +
         * "SELECT max(distinct c.informers) FROM Cop c where max(distinct c.partner) > 3.5 and exists(select max(c1.partner) from Cop c1)\n"
         * + "                                                                          ^\n" +
         * "line 1: Path 'c1.partner' is not a CMP path\n" +
         * "SELECT max(distinct c.informers) FROM Cop c where max(distinct c.partner) > 3.5 and exists(select max(c1.partner) from Cop c1)\n"
         * + "                                                                                                      ^\n" +
         * "line 1: No order defined on type (Cop) of path 'c1.partner'\n" +
         * "SELECT max(distinct c.informers) FROM Cop c where max(distinct c.partner) > 3.5 and exists(select max(c1.partner) from Cop c1)\n"
         * + "                                                                                                      ^\n",
         */
        // TODO parser/mapper have to be fixed
        /* 3 assertValidQuery("SELECT max(c.id) FROM Cop c where max(c.id) > 3.5 and exists(select max(c1.id) from Cop c1)"); */

        // TODO parser/mapper have to be fixed
        /*
         * 4assertValidQuery(
         * "SELECT max(distinct c.id) FROM Cop c where max(distinct c.id) > 3.5 and exists(select max(distinct c1.id) from Cop c1)"
         * );
         */

        /* 5 */assertInvalidQuery("SELECT max(distinct c.informers) FROM Cop c where max(distinct c.partner) > 3.5 and exists(select max(c1.partner) from Cop c1)");
    }

    @Test
    public void testMinHandling() {
        /*
         * 06 null, /* 07 null, /* 08 "line 1: Path 'c.informers' is not a CMP path\n" +
         * "SELECT min(distinct c.informers) FROM Cop c where min(distinct c.partner) > 3.5 and exists(select min(c1.partner) from Cop c1)\n"
         * + "                    ^\n" + "line 1: No order defined on type (Informer) of path 'c.informers'\n" +
         * "SELECT min(distinct c.informers) FROM Cop c where min(distinct c.partner) > 3.5 and exists(select min(c1.partner) from Cop c1)\n"
         * + "                    ^\n" + "line 1: Path 'c.partner' is not a CMP path\n" +
         * "SELECT min(distinct c.informers) FROM Cop c where min(distinct c.partner) > 3.5 and exists(select min(c1.partner) from Cop c1)\n"
         * + "                                                               ^\n" +
         * "line 1: No order defined on type (Cop) of path 'c.partner'\n" +
         * "SELECT min(distinct c.informers) FROM Cop c where min(distinct c.partner) > 3.5 and exists(select min(c1.partner) from Cop c1)\n"
         * + "                                                               ^\n" +
         * "line 1: Comparison '>' not defined for entity beans\n" +
         * "SELECT min(distinct c.informers) FROM Cop c where min(distinct c.partner) > 3.5 and exists(select min(c1.partner) from Cop c1)\n"
         * + "                                                                          ^\n" +
         * "line 1: Comparison of incompatible types: (Cop) '>' (java.math.BigDecimal)\n" +
         * "SELECT min(distinct c.informers) FROM Cop c where min(distinct c.partner) > 3.5 and exists(select min(c1.partner) from Cop c1)\n"
         * + "                                                                          ^\n" +
         * "line 1: Path 'c1.partner' is not a CMP path\n" +
         * "SELECT min(distinct c.informers) FROM Cop c where min(distinct c.partner) > 3.5 and exists(select min(c1.partner) from Cop c1)\n"
         * + "                                                                                                      ^\n" +
         * "line 1: No order defined on type (Cop) of path 'c1.partner'\n" +
         * "SELECT min(distinct c.informers) FROM Cop c where min(distinct c.partner) > 3.5 and exists(select min(c1.partner) from Cop c1)\n"
         * + "                                                                                                      ^\n",
         */

        // TODO parser/mapper have to be fixed
        /* 6 assertValidQuery("SELECT min(c.id) FROM Cop c where min(c.id) > 3.5 and exists(select min(c1.id) from Cop c1)"); */

        // TODO parser/mapper have to be fixed
        /*
         * 7assertValidQuery(
         * "SELECT min(distinct c.id) FROM Cop c where min(distinct c.id) > 3.5 and exists(select min(distinct c1.id) from Cop c1)"
         * );
         */
        /* 8 */assertInvalidQuery("SELECT min(distinct c.informers) FROM Cop c where min(distinct c.partner) > 3.5 and exists(select min(c1.partner) from Cop c1)");
    }

    @Test
    public void testSumHandling() {
        /*
         * 09 null, /* 10 null, /* 11 "line 1: Path 'c.informers' is not a CMP path\n" +
         * "SELECT sum(distinct c.informers) FROM Cop c where sum(distinct c.partner) > 3.5 and exists(select sum(c1.partner) from Cop c1)\n"
         * + "                    ^\n" + "line 1: Path 'c.informers' is not of numeric type (Informer)\n" +
         * "SELECT sum(distinct c.informers) FROM Cop c where sum(distinct c.partner) > 3.5 and exists(select sum(c1.partner) from Cop c1)\n"
         * + "                    ^\n" + "line 1: Path 'c.partner' is not a CMP path\n" +
         * "SELECT sum(distinct c.informers) FROM Cop c where sum(distinct c.partner) > 3.5 and exists(select sum(c1.partner) from Cop c1)\n"
         * + "                                                               ^\n" +
         * "line 1: Path 'c.partner' is not of numeric type (Cop)\n" +
         * "SELECT sum(distinct c.informers) FROM Cop c where sum(distinct c.partner) > 3.5 and exists(select sum(c1.partner) from Cop c1)\n"
         * + "                                                               ^\n" +
         * "line 1: Path 'c1.partner' is not a CMP path\n" +
         * "SELECT sum(distinct c.informers) FROM Cop c where sum(distinct c.partner) > 3.5 and exists(select sum(c1.partner) from Cop c1)\n"
         * + "                                                                                                      ^\n" +
         * "line 1: Path 'c1.partner' is not of numeric type (Cop)\n" +
         * "SELECT sum(distinct c.informers) FROM Cop c where sum(distinct c.partner) > 3.5 and exists(select sum(c1.partner) from Cop c1)\n"
         * + "                                                                                                      ^\n",
         */
        // TODO parser/mapper have to be fixed
        /* 9 assertValidQuery("SELECT sum(c.id) FROM Cop c where sum(c.id) > 3.5 and exists(select sum(c1.id) from Cop c1)"); */
        /*
         * 10assertValidQuery(
         * "SELECT sum(distinct c.id) FROM Cop c where sum(distinct c.id) > 3.5 and exists(select sum(distinct c1.id) from Cop c1)"
         * );
         */

        /*
         * 11assertInvalidQuery(
         * "SELECT sum(distinct c.informers) FROM Cop c where sum(distinct c.partner) > 3.5 and exists(select sum(c1.partner) from Cop c1)"
         * );
         */
    }

    @Test
    @ToBeInvestigated
    public void testCountHandling() {
        /*
         * 12 null, /* 13 null, /* 14 "line 1: Path 'c.informers' is neither a CMP path nor a single valued CMR path\n" +
         * "SELECT count(distinct c.informers) FROM Cop c where count(distinct c.informers) > 3.5 and exists(select count(c1.informers) from Cop c1)\n"
         * + "                      ^\n" + "line 1: Path 'c.informers' is neither a CMP path nor a single valued CMR path\n" +
         * "SELECT count(distinct c.informers) FROM Cop c where count(distinct c.informers) > 3.5 and exists(select count(c1.informers) from Cop c1)\n"
         * + "                                                                   ^\n" +
         * "line 1: Path 'c1.informers' is neither a CMP path nor a single valued CMR path\n" +
         * "SELECT count(distinct c.informers) FROM Cop c where count(distinct c.informers) > 3.5 and exists(select count(c1.informers) from Cop c1)\n"
         * +
         * "                                                                                                              ^\n",
         * /* 15 null,
         */

        // TODO parser/mapper handling have to be fixed
        /* 12 */assertValidQuery("SELECT count(c.id) FROM Cop c where count(c.id) > 3.5 and exists(select count(c1.id) from Cop c1)"); /**/
        /*
         * 13assertValidQuery(
         * "SELECT count(distinct c.partner) FROM Cop c where count(distinct c.partner) > 3.5 and exists(select count(distinct c1.partner) from Cop c1)"
         * );
         */
        /*
         * 14assertInvalidQuery(
         * "SELECT count(distinct c.informers) FROM Cop c where count(distinct c.informers) > 3.5 and exists(select count(c1.informers) from Cop c1)"
         * );
         */
        /* 15 assertValidQuery("SELECT count(c) FROM Cop c where count(c) > 3.5 and exists(select count(c1) from Cop c1)"); */
    }
}