| /* |
| * Copyright (c) 2011, 2021 Oracle and/or its affiliates. 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: |
| // Oracle - initial API and implementation |
| // |
| package org.eclipse.persistence.jpa.tests.jpql.tools; |
| |
| import java.util.ArrayList; |
| import java.util.Collections; |
| import java.util.List; |
| import org.eclipse.persistence.jpa.jpql.EclipseLinkVersion; |
| import org.eclipse.persistence.jpa.jpql.parser.EclipseLinkJPQLGrammar2_4; |
| import org.eclipse.persistence.jpa.jpql.utility.CollectionTools; |
| import org.eclipse.persistence.jpa.tests.jpql.EclipseLinkVersionTools; |
| import org.junit.Test; |
| import static org.eclipse.persistence.jpa.jpql.parser.Expression.*; |
| |
| /** |
| * This unit-test tests the JPQL content assist at various position within the JPQL query and with |
| * complete and incomplete queries and make sure the EclipseLink additional support works correctly. |
| * |
| * @version 2.5.1 |
| * @since 2.4 |
| * @author Pascal Filion |
| */ |
| @SuppressWarnings("nls") |
| public final class EclipseLinkContentAssistTest2_4 extends AbstractContentAssistTest { |
| |
| @Override |
| protected List<String> classNames() { |
| return Collections.emptyList(); |
| } |
| |
| @Override |
| protected List<String> clauses(String afterIdentifier, String beforeIdentifier, boolean subquery) { |
| |
| List<String> proposals = super.clauses(afterIdentifier, beforeIdentifier, subquery); |
| |
| if (subquery) { |
| return proposals; |
| } |
| |
| if (afterIdentifier == SELECT) { |
| |
| if (beforeIdentifier != FROM && |
| beforeIdentifier != WHERE && |
| beforeIdentifier != GROUP_BY && |
| beforeIdentifier != HAVING && |
| beforeIdentifier != ORDER_BY && |
| beforeIdentifier != UNION && |
| beforeIdentifier != EXCEPT && |
| beforeIdentifier != INTERSECT) { |
| |
| proposals.add(UNION); |
| proposals.add(EXCEPT); |
| proposals.add(INTERSECT); |
| } |
| } |
| else if (afterIdentifier == FROM) { |
| |
| if (beforeIdentifier != WHERE && |
| beforeIdentifier != GROUP_BY && |
| beforeIdentifier != HAVING && |
| beforeIdentifier != ORDER_BY && |
| beforeIdentifier != UNION && |
| beforeIdentifier != EXCEPT && |
| beforeIdentifier != INTERSECT) { |
| |
| proposals.add(UNION); |
| proposals.add(EXCEPT); |
| proposals.add(INTERSECT); |
| } |
| } |
| else if (afterIdentifier == WHERE) { |
| |
| if (beforeIdentifier != GROUP_BY && |
| beforeIdentifier != HAVING && |
| beforeIdentifier != ORDER_BY && |
| beforeIdentifier != UNION && |
| beforeIdentifier != EXCEPT && |
| beforeIdentifier != INTERSECT) { |
| |
| proposals.add(UNION); |
| proposals.add(EXCEPT); |
| proposals.add(INTERSECT); |
| } |
| } |
| else if (afterIdentifier == GROUP_BY) { |
| |
| if (beforeIdentifier != HAVING && |
| beforeIdentifier != ORDER_BY && |
| beforeIdentifier != UNION && |
| beforeIdentifier != EXCEPT && |
| beforeIdentifier != INTERSECT) { |
| |
| proposals.add(UNION); |
| proposals.add(EXCEPT); |
| proposals.add(INTERSECT); |
| } |
| } |
| else if (afterIdentifier == HAVING) { |
| |
| if (beforeIdentifier != ORDER_BY && |
| beforeIdentifier != UNION && |
| beforeIdentifier != EXCEPT && |
| beforeIdentifier != INTERSECT) { |
| |
| proposals.add(UNION); |
| proposals.add(EXCEPT); |
| proposals.add(INTERSECT); |
| } |
| } |
| else if (afterIdentifier == ORDER_BY) { |
| |
| if (beforeIdentifier != UNION && |
| beforeIdentifier != EXCEPT && |
| beforeIdentifier != INTERSECT) { |
| |
| proposals.add(UNION); |
| proposals.add(EXCEPT); |
| proposals.add(INTERSECT); |
| } |
| } |
| |
| return proposals; |
| } |
| |
| @Override |
| protected List<String> columnNames(String tableName) { |
| return Collections.emptyList(); |
| } |
| |
| @Override |
| protected List<String> enumConstants() { |
| return Collections.emptyList(); |
| } |
| |
| @Override |
| protected List<String> enumTypes() { |
| return Collections.emptyList(); |
| } |
| |
| @Override |
| protected List<String> fromClauseInternalClauses(String afterIdentifier) { |
| |
| if (EclipseLinkVersionTools.isNewerThan2_4(getGrammar())) { |
| List<String> proposals = new ArrayList<>(); |
| |
| if (afterIdentifier == FROM) { |
| proposals.addAll(super.fromClauseInternalClauses(FROM)); |
| proposals.add(START_WITH); |
| proposals.add(CONNECT_BY); |
| proposals.add(ORDER_SIBLINGS_BY); |
| proposals.add(AS_OF); |
| } |
| else if (afterIdentifier == JOIN) { |
| proposals.add(START_WITH); |
| proposals.add(CONNECT_BY); |
| proposals.add(ORDER_SIBLINGS_BY); |
| proposals.add(AS_OF); |
| } |
| else if (afterIdentifier == START_WITH) { |
| proposals.add(CONNECT_BY); |
| proposals.add(ORDER_SIBLINGS_BY); |
| proposals.add(AS_OF); |
| } |
| else if (afterIdentifier == CONNECT_BY) { |
| proposals.add(ORDER_SIBLINGS_BY); |
| proposals.add(AS_OF); |
| } |
| else if (afterIdentifier == ORDER_SIBLINGS_BY) { |
| proposals.add(AS_OF); |
| } |
| |
| return proposals; |
| } |
| |
| return super.fromClauseInternalClauses(afterIdentifier); |
| } |
| |
| @Override |
| protected boolean isJoinFetchIdentifiable() { |
| EclipseLinkVersion currentVersion = EclipseLinkVersion.value(getGrammar().getProviderVersion()); |
| return currentVersion.isNewerThanOrEqual(EclipseLinkJPQLGrammar2_4.VERSION); |
| } |
| |
| @Override |
| protected List<String> tableNames() { |
| return Collections.emptyList(); |
| } |
| |
| @Test |
| public void test_CastExpression_01() { |
| String jpqlQuery = "Select "; |
| int position = "Select ".length(); |
| testHasTheseProposals(jpqlQuery, position, CAST); |
| } |
| |
| @Test |
| public void test_CastExpression_02() { |
| String jpqlQuery = "Select c"; |
| int position = "Select ".length(); |
| testHasTheseProposals(jpqlQuery, position, CAST); |
| } |
| |
| @Test |
| public void test_CastExpression_03() { |
| String jpqlQuery = "Select ca"; |
| int position = "Select ".length(); |
| testHasTheseProposals(jpqlQuery, position, CAST); |
| } |
| |
| @Test |
| public void test_CastExpression_04() { |
| String jpqlQuery = "Select cas"; |
| int position = "Select ".length(); |
| testHasTheseProposals(jpqlQuery, position, CAST); |
| } |
| |
| @Test |
| public void test_CastExpression_05() { |
| String jpqlQuery = "Select cast"; |
| int position = "Select ".length(); |
| testHasTheseProposals(jpqlQuery, position, CAST); |
| } |
| |
| @Test |
| public void test_CastExpression_06() { |
| String jpqlQuery = "Select cast(e.firstName as char) From Employee e"; |
| int position = "Select c".length(); |
| testHasTheseProposals(jpqlQuery, position, CAST); |
| } |
| |
| @Test |
| public void test_CastExpression_07() { |
| String jpqlQuery = "Select cast(e.firstName as char) From Employee e"; |
| int position = "Select ca".length(); |
| testHasTheseProposals(jpqlQuery, position, CAST); |
| } |
| |
| @Test |
| public void test_CastExpression_08() { |
| String jpqlQuery = "Select cast(e.firstName as char) From Employee e"; |
| int position = "Select cas".length(); |
| testHasTheseProposals(jpqlQuery, position, CAST); |
| } |
| |
| @Test |
| public void test_CastExpression_09() { |
| String jpqlQuery = "Select cast(e.firstName as char) From Employee e"; |
| int position = "Select cas".length(); |
| testHasTheseProposals(jpqlQuery, position, CAST); |
| } |
| |
| @Test |
| public void test_CastExpression_10() { |
| String jpqlQuery = "Select cast(e.firstName as char) From Employee e"; |
| int position = "Select cast".length(); |
| testHasTheseProposals(jpqlQuery, position, CAST); |
| } |
| |
| @Test |
| public void test_CastExpression_11() { |
| String jpqlQuery = "Select c"; |
| int position = "Select c".length(); |
| testHasTheseProposals(jpqlQuery, position, CAST); |
| } |
| |
| @Test |
| public void test_CastExpression_12() { |
| String jpqlQuery = "Select ca"; |
| int position = "Select ca".length(); |
| testHasTheseProposals(jpqlQuery, position, CAST); |
| } |
| |
| @Test |
| public void test_CastExpression_13() { |
| String jpqlQuery = "Select cas"; |
| int position = "Select cas".length(); |
| testHasTheseProposals(jpqlQuery, position, CAST); |
| } |
| |
| @Test |
| public void test_CastExpression_14() { |
| String jpqlQuery = "Select cast"; |
| int position = "Select cast".length(); |
| testHasTheseProposals(jpqlQuery, position, CAST); |
| } |
| |
| @Test |
| public void test_CastExpression_22() { |
| |
| String jpqlQuery = "Select cast(e.firstName as char(3)) from Employee e where cast(e.firstName as char(3)) = 'Bob'"; |
| int position = "Select cast(".length(); |
| |
| List<String> proposals = new ArrayList<>(); |
| proposals.add("e"); |
| CollectionTools.addAll(proposals, bnfAccessor.scalarExpressionFunctions()); |
| |
| testHasOnlyTheseProposals(jpqlQuery, position, proposals); |
| } |
| |
| @Test |
| public void test_CastExpression_23() { |
| |
| String jpqlQuery = "Select cast(e.firstName as char(3)) from Employee e where cast(e.firstName as char(3)) = 'Bob'"; |
| int position = "Select cast(e.firstName ".length(); |
| |
| List<String> proposals = new ArrayList<>(); |
| proposals.add(AS); |
| CollectionTools.addAll(proposals, bnfAccessor.scalarExpressionAggregates()); |
| |
| testHasOnlyTheseProposals(jpqlQuery, position, proposals); |
| } |
| |
| @Test |
| public void test_CastExpression_24() { |
| |
| String jpqlQuery = "Select cast(e.firstName as char(3)) from Employee e where cast(e.firstName as char(3)) = 'Bob'"; |
| int position = "Select cast(e.firstName a".length(); |
| |
| List<String> proposals = new ArrayList<>(); |
| proposals.add(AS); |
| CollectionTools.addAll(proposals, filter(bnfAccessor.scalarExpressionAggregates(), "a")); |
| |
| testHasOnlyTheseProposals(jpqlQuery, position, proposals); |
| } |
| |
| @Test |
| public void test_CastExpression_25() { |
| |
| String jpqlQuery = "Select cast(e.firstName as char(3)) from Employee e where cast(e.firstName as char(3)) = 'Bob'"; |
| int position = "Select cast(e.firstName as".length(); |
| |
| List<String> proposals = new ArrayList<>(); |
| proposals.add(AS); |
| CollectionTools.addAll(proposals, filter(bnfAccessor.scalarExpressionAggregates(), "as")); |
| |
| testHasOnlyTheseProposals(jpqlQuery, position, proposals); |
| } |
| |
| @Test |
| public void test_CastExpression_26() { |
| |
| String jpqlQuery = "Select cast(e.firstName + as char(3)) from Employee e where cast(e.firstName as char(3)) = 'Bob'"; |
| int position = "Select cast(e.firstName + ".length(); |
| testDoesNotHaveTheseProposals(jpqlQuery, position, AS); |
| } |
| |
| @Test |
| public final void test_CompoundFunction_001() { |
| test_CompoundFunction("LEFT e.employees emps ON"); |
| } |
| |
| @Test |
| public void test_ExtractExpression_01() { |
| String jpqlQuery = "Select "; |
| int position = "Select ".length(); |
| testHasTheseProposals(jpqlQuery, position, EXTRACT); |
| } |
| |
| @Test |
| public void test_ExtractExpression_02() { |
| String jpqlQuery = "Select e"; |
| int position = "Select ".length(); |
| testHasTheseProposals(jpqlQuery, position, EXTRACT); |
| } |
| |
| @Test |
| public void test_ExtractExpression_03() { |
| String jpqlQuery = "Select ex"; |
| int position = "Select ".length(); |
| testHasTheseProposals(jpqlQuery, position, EXTRACT); |
| } |
| |
| @Test |
| public void test_ExtractExpression_04() { |
| String jpqlQuery = "Select ext"; |
| int position = "Select ".length(); |
| testHasTheseProposals(jpqlQuery, position, EXTRACT); |
| } |
| |
| @Test |
| public void test_ExtractExpression_05() { |
| String jpqlQuery = "Select extr"; |
| int position = "Select ".length(); |
| testHasTheseProposals(jpqlQuery, position, EXTRACT); |
| } |
| |
| @Test |
| public void test_ExtractExpression_06() { |
| String jpqlQuery = "Select extra"; |
| int position = "Select ".length(); |
| testHasTheseProposals(jpqlQuery, position, EXTRACT); |
| } |
| |
| @Test |
| public void test_ExtractExpression_07() { |
| String jpqlQuery = "Select extrac"; |
| int position = "Select ".length(); |
| testHasTheseProposals(jpqlQuery, position, EXTRACT); |
| } |
| |
| @Test |
| public void test_ExtractExpression_08() { |
| String jpqlQuery = "Select extract"; |
| int position = "Select ".length(); |
| testHasTheseProposals(jpqlQuery, position, EXTRACT); |
| } |
| |
| @Test |
| public void test_ExtractExpression_09() { |
| String jpqlQuery = "Select extract(YEAR from e.hiringDate) From Employee e"; |
| int position = "Select e".length(); |
| testHasTheseProposals(jpqlQuery, position, EXTRACT); |
| } |
| |
| @Test |
| public void test_ExtractExpression_10() { |
| String jpqlQuery = "Select extract(YEAR from e.hiringDate) From Employee e"; |
| int position = "Select ex".length(); |
| testHasTheseProposals(jpqlQuery, position, EXTRACT); |
| } |
| |
| @Test |
| public void test_ExtractExpression_11() { |
| String jpqlQuery = "Select extract(YEAR from e.hiringDate) From Employee e"; |
| int position = "Select ext".length(); |
| testHasTheseProposals(jpqlQuery, position, EXTRACT); |
| } |
| |
| @Test |
| public void test_ExtractExpression_12() { |
| String jpqlQuery = "Select extract(YEAR from e.hiringDate) From Employee e"; |
| int position = "Select extr".length(); |
| testHasTheseProposals(jpqlQuery, position, EXTRACT); |
| } |
| |
| @Test |
| public void test_ExtractExpression_13() { |
| String jpqlQuery = "Select extract(YEAR from e.hiringDate) From Employee e"; |
| int position = "Select extra".length(); |
| testHasTheseProposals(jpqlQuery, position, EXTRACT); |
| } |
| |
| @Test |
| public void test_ExtractExpression_14() { |
| String jpqlQuery = "Select extract(YEAR from e.hiringDate) From Employee e"; |
| int position = "Select extrac".length(); |
| testHasTheseProposals(jpqlQuery, position, EXTRACT); |
| } |
| |
| @Test |
| public void test_ExtractExpression_15() { |
| String jpqlQuery = "Select extract(YEAR from e.hiringDate) From Employee e"; |
| int position = "Select extract".length(); |
| testHasTheseProposals(jpqlQuery, position, EXTRACT); |
| } |
| |
| @Test |
| public void test_ExtractExpression_16() { |
| String jpqlQuery = "Select e"; |
| int position = "Select e".length(); |
| testHasTheseProposals(jpqlQuery, position, EXTRACT); |
| } |
| |
| @Test |
| public void test_ExtractExpression_17() { |
| String jpqlQuery = "Select ex"; |
| int position = "Select ex".length(); |
| testHasTheseProposals(jpqlQuery, position, EXTRACT); |
| } |
| |
| @Test |
| public void test_ExtractExpression_18() { |
| String jpqlQuery = "Select ext"; |
| int position = "Select ext".length(); |
| testHasTheseProposals(jpqlQuery, position, EXTRACT); |
| } |
| |
| @Test |
| public void test_ExtractExpression_19() { |
| String jpqlQuery = "Select extr"; |
| int position = "Select extr".length(); |
| testHasTheseProposals(jpqlQuery, position, EXTRACT); |
| } |
| |
| @Test |
| public void test_ExtractExpression_20() { |
| String jpqlQuery = "Select extra"; |
| int position = "Select extra".length(); |
| testHasTheseProposals(jpqlQuery, position, EXTRACT); |
| } |
| |
| @Test |
| public void test_ExtractExpression_21() { |
| String jpqlQuery = "Select extrac"; |
| int position = "Select extrac".length(); |
| testHasTheseProposals(jpqlQuery, position, EXTRACT); |
| } |
| |
| @Test |
| public void test_ExtractExpression_22() { |
| String jpqlQuery = "Select extract"; |
| int position = "Select extract".length(); |
| testHasTheseProposals(jpqlQuery, position, EXTRACT); |
| } |
| |
| @Test |
| public void test_ExtractExpression_23() { |
| |
| String jpqlQuery = "Select extract(YEAR from e.hiringDate) from Employee e"; |
| int position = "Select extract(".length(); |
| testHasNoProposals(jpqlQuery, position); |
| } |
| |
| @Test |
| public void test_ExtractExpression_24() { |
| |
| String jpqlQuery = "Select extract(YEAR from e.hiringDate) from Employee e"; |
| int position = "Select extract(YEAR ".length(); |
| testHasOnlyTheseProposals(jpqlQuery, position, FROM); |
| } |
| |
| @Test |
| public void test_ExtractExpression_25() { |
| |
| String jpqlQuery = "Select extract(YEAR from) from Employee e"; |
| int position = "Select extract(YEAR ".length(); |
| |
| List<String> proposals = new ArrayList<>(); |
| proposals.add(FROM); |
| proposals.add("e"); |
| CollectionTools.addAll(proposals, bnfAccessor.scalarExpressionFunctions()); |
| |
| testHasOnlyTheseProposals(jpqlQuery, position, proposals); |
| } |
| |
| @Test |
| public void test_ExtractExpression_26() { |
| |
| String jpqlQuery = "Select extract(YEAR from) from Employee e"; |
| int position = "Select extract(YEAR f".length(); |
| |
| List<String> proposals = new ArrayList<>(); |
| proposals.add(FROM); |
| CollectionTools.addAll(proposals, filter(bnfAccessor.scalarExpressionFunctions(), "f")); |
| |
| testHasOnlyTheseProposals(jpqlQuery, position, proposals); |
| } |
| |
| @Test |
| public void test_ExtractExpression_27() { |
| |
| String jpqlQuery = "Select extract(YEAR from) from Employee e"; |
| int position = "Select extract(YEAR fr".length(); |
| |
| List<String> proposals = new ArrayList<>(); |
| proposals.add(FROM); |
| CollectionTools.addAll(proposals, filter(bnfAccessor.scalarExpressionFunctions(), "fr")); |
| |
| testHasOnlyTheseProposals(jpqlQuery, position, proposals); |
| } |
| |
| @Test |
| public void test_ExtractExpression_28() { |
| |
| String jpqlQuery = "Select extract(YEAR from) from Employee e"; |
| int position = "Select extract(YEAR fro".length(); |
| |
| List<String> proposals = new ArrayList<>(); |
| proposals.add(FROM); |
| CollectionTools.addAll(proposals, filter(bnfAccessor.scalarExpressionFunctions(), "fro")); |
| |
| testHasOnlyTheseProposals(jpqlQuery, position, proposals); |
| } |
| |
| @Test |
| public void test_ExtractExpression_29() { |
| |
| String jpqlQuery = "Select extract(YEAR from) from Employee e"; |
| int position = "Select extract(YEAR from".length(); |
| |
| List<String> proposals = new ArrayList<>(); |
| proposals.add(FROM); |
| CollectionTools.addAll(proposals, filter(bnfAccessor.scalarExpressionFunctions(), "from")); |
| |
| testHasOnlyTheseProposals(jpqlQuery, position, proposals); |
| } |
| |
| @Test |
| public void test_ExtractExpression_30() { |
| |
| String jpqlQuery = "Select extract(YEAR from ) from Employee e"; |
| int position = "Select extract(YEAR from".length(); |
| |
| List<String> proposals = new ArrayList<>(); |
| proposals.add(FROM); |
| CollectionTools.addAll(proposals, filter(bnfAccessor.scalarExpressionFunctions(), "from")); |
| |
| testHasOnlyTheseProposals(jpqlQuery, position, proposals); |
| } |
| |
| @Test |
| public void test_ExtractExpression_31() { |
| |
| String jpqlQuery = "Select extract(YEAR e.hiringDate) from Employee e"; |
| int position = "Select extract(YEAR ".length(); |
| |
| List<String> proposals = new ArrayList<>(); |
| proposals.add(FROM); |
| proposals.add("e"); |
| CollectionTools.addAll(proposals, bnfAccessor.scalarExpressionFunctions()); |
| |
| testHasOnlyTheseProposals(jpqlQuery, position, proposals); |
| } |
| |
| @Test |
| public void test_ExtractExpression_32() { |
| |
| String jpqlQuery = "Select extract(YEAR e.hiringDate) from Employee e"; |
| int position = "Select extract(YEAR e".length(); |
| |
| List<String> proposals = new ArrayList<>(); |
| proposals.add("e"); |
| CollectionTools.addAll(proposals, filter(bnfAccessor.scalarExpressionFunctions(), "e")); |
| |
| testHasOnlyTheseProposals(jpqlQuery, position, proposals); |
| } |
| |
| @Test |
| public void test_ExtractExpression_33() { |
| |
| String jpqlQuery = "Select extract(from e.hiringDate) from Employee e"; |
| int position = "Select extract(f".length(); |
| testHasOnlyTheseProposals(jpqlQuery, position, FROM); |
| } |
| |
| @Test |
| public void test_ExtractExpression_34() { |
| |
| String jpqlQuery = "Select extract(from e.hiringDate) from Employee e"; |
| int position = "Select extract(fr".length(); |
| testHasOnlyTheseProposals(jpqlQuery, position, FROM); |
| } |
| |
| @Test |
| public void test_ExtractExpression_35() { |
| |
| String jpqlQuery = "Select extract(from e.hiringDate) from Employee e"; |
| int position = "Select extract(fro".length(); |
| testHasOnlyTheseProposals(jpqlQuery, position, FROM); |
| } |
| |
| @Test |
| public void test_ExtractExpression_36() { |
| |
| String jpqlQuery = "Select extract(from e.hiringDate) from Employee e"; |
| int position = "Select extract(from".length(); |
| testHasOnlyTheseProposals(jpqlQuery, position, FROM); |
| } |
| |
| @Test |
| public void test_ExtractExpression_37() { |
| |
| String jpqlQuery = "Select extract(YEAR from ) from Employee e"; |
| int position = "Select extract(YEAR from ".length(); |
| |
| List<String> proposals = new ArrayList<>(); |
| proposals.add("e"); |
| CollectionTools.addAll(proposals, bnfAccessor.scalarExpressionFunctions()); |
| |
| testHasOnlyTheseProposals(jpqlQuery, position, proposals); |
| } |
| |
| @Test |
| public final void test_On_01() { |
| test_ConditionalClause_01(ON, "JOIN e.employees emps "); |
| } |
| |
| @Test |
| public final void test_On_02() { |
| test_ConditionalClause_02(ON, "JOIN e.employees emps "); |
| } |
| |
| @Test |
| public final void test_On_03() { |
| test_ConditionalClause_03(ON, "JOIN e.employees emps "); |
| } |
| |
| @Test |
| public final void test_On_04() { |
| test_ConditionalClause_04(ON, "JOIN e.employees emps "); |
| } |
| |
| @Test |
| public final void test_On_05() { |
| test_ConditionalClause_05(ON, "JOIN e.employees emps "); |
| } |
| |
| @Test |
| public final void test_On_06() { |
| test_ConditionalClause_06(ON, "JOIN e.employees emps "); |
| } |
| |
| @Test |
| public final void test_On_07() { |
| test_ConditionalClause_07(ON, "JOIN e.employees emps "); |
| } |
| |
| @Test |
| public void test_OrderByItem_NullOrdering_01() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e ORDER BY e"; |
| int position = jpqlQuery.length(); |
| testHasOnlyTheseProposals(jpqlQuery, position, "e"); |
| } |
| |
| @Test |
| public void test_OrderByItem_NullOrdering_02() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e ORDER BY e "; |
| int position = jpqlQuery.length(); |
| |
| testHasOnlyTheseProposals( |
| jpqlQuery, |
| position, |
| ASC, DESC, |
| NULLS_FIRST, NULLS_LAST, |
| UNION, INTERSECT, EXCEPT |
| ); |
| } |
| |
| @Test |
| public void test_OrderByItem_NullOrdering_03() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e ORDER BY e ASC"; |
| int position = jpqlQuery.length(); |
| testHasOnlyTheseProposals(jpqlQuery, position, ASC, DESC); |
| } |
| |
| @Test |
| public void test_OrderByItem_NullOrdering_04() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e ORDER BY e ASC "; |
| int position = jpqlQuery.length(); |
| |
| testHasOnlyTheseProposals( |
| jpqlQuery, |
| position, |
| NULLS_FIRST, NULLS_LAST, |
| UNION, INTERSECT, EXCEPT |
| ); |
| } |
| |
| @Test |
| public void test_OrderByItem_NullOrdering_05() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e ORDER BY e ASC, e.name"; |
| int position = "SELECT e FROM Employee e ORDER BY e ASC".length(); |
| testHasOnlyTheseProposals(jpqlQuery, position, ASC, DESC); |
| } |
| |
| @Test |
| public void test_OrderByItem_NullOrdering_06() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e ORDER BY e ASC , e.name"; |
| int position = "SELECT e FROM Employee e ORDER BY e ASC".length(); |
| testHasOnlyTheseProposals(jpqlQuery, position, ASC, DESC); |
| } |
| |
| @Test |
| public void test_OrderByItem_NullOrdering_07() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e ORDER BY e ASC NULLS FIRST"; |
| int position = jpqlQuery.length(); |
| testHasOnlyTheseProposals(jpqlQuery, position, NULLS_FIRST, NULLS_LAST); |
| } |
| |
| @Test |
| public void test_OrderByItem_NullOrdering_08() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e ORDER BY e ASC NULLS LAST"; |
| int position = jpqlQuery.length(); |
| testHasOnlyTheseProposals(jpqlQuery, position, NULLS_FIRST, NULLS_LAST); |
| } |
| |
| @Test |
| public void test_OrderByItem_NullOrdering_09() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e ORDER BY e ASC NULLS LAST"; |
| int position = "SELECT e FROM Employee e ORDER BY e ASC ".length(); |
| testHasOnlyTheseProposals(jpqlQuery, position, NULLS_FIRST, NULLS_LAST); |
| } |
| |
| @Test |
| public void test_OrderByItem_NullOrdering_10() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e ORDER BY e ASC NULLS LAST"; |
| int position = "SELECT e FROM Employee e ORDER BY e ASC N".length(); |
| testHasOnlyTheseProposals(jpqlQuery, position, NULLS_FIRST, NULLS_LAST); |
| } |
| |
| @Test |
| public void test_OrderByItem_NullOrdering_11() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e ORDER BY e ASC NULLS LAST"; |
| int position = "SELECT e FROM Employee e ORDER BY e ASC NU".length(); |
| testHasOnlyTheseProposals(jpqlQuery, position, NULLS_FIRST, NULLS_LAST); |
| } |
| |
| @Test |
| public void test_OrderByItem_NullOrdering_12() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e ORDER BY e ASC NULLS LAST"; |
| int position = "SELECT e FROM Employee e ORDER BY e ASC NUL".length(); |
| testHasOnlyTheseProposals(jpqlQuery, position, NULLS_FIRST, NULLS_LAST); |
| } |
| |
| @Test |
| public void test_OrderByItem_NullOrdering_13() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e ORDER BY e ASC NULLS LAST"; |
| int position = "SELECT e FROM Employee e ORDER BY e ASC NULL".length(); |
| testHasOnlyTheseProposals(jpqlQuery, position, NULLS_FIRST, NULLS_LAST); |
| } |
| |
| @Test |
| public void test_OrderByItem_NullOrdering_14() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e ORDER BY e ASC NULLS LAST"; |
| int position = "SELECT e FROM Employee e ORDER BY e ASC NULLS".length(); |
| testHasOnlyTheseProposals(jpqlQuery, position, NULLS_FIRST, NULLS_LAST); |
| } |
| |
| @Test |
| public void test_OrderByItem_NullOrdering_15() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e ORDER BY e ASC NULLS LAST"; |
| int position = "SELECT e FROM Employee e ORDER BY e ASC NULLS ".length(); |
| testHasOnlyTheseProposals(jpqlQuery, position, NULLS_FIRST, NULLS_LAST); |
| } |
| |
| @Test |
| public void test_OrderByItem_NullOrdering_16() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e ORDER BY e ASC NULLS LAST"; |
| int position = "SELECT e FROM Employee e ORDER BY e ASC NULLS L".length(); |
| testHasOnlyTheseProposals(jpqlQuery, position, NULLS_FIRST, NULLS_LAST); |
| } |
| |
| @Test |
| public void test_OrderByItem_NullOrdering_17() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e ORDER BY e ASC NULLS LAST"; |
| int position = "SELECT e FROM Employee e ORDER BY e ASC NULLS LA".length(); |
| testHasOnlyTheseProposals(jpqlQuery, position, NULLS_FIRST, NULLS_LAST); |
| } |
| |
| @Test |
| public void test_OrderByItem_NullOrdering_18() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e ORDER BY e ASC NULLS LAST"; |
| int position = "SELECT e FROM Employee e ORDER BY e ASC NULLS LAS".length(); |
| testHasOnlyTheseProposals(jpqlQuery, position, NULLS_FIRST, NULLS_LAST); |
| } |
| |
| @Test |
| public void test_OrderByItem_NullOrdering_19() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e ORDER BY e ASC NULLS LAST, e.name"; |
| int position = "SELECT e FROM Employee e ORDER BY e ASC ".length(); |
| testHasOnlyTheseProposals(jpqlQuery, position, NULLS_FIRST, NULLS_LAST); |
| } |
| |
| @Test |
| public void test_OrderByItem_NullOrdering_20() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e ORDER BY e ASC NULLS LAST, e.name"; |
| int position = "SELECT e FROM Employee e ORDER BY e ASC N".length(); |
| testHasOnlyTheseProposals(jpqlQuery, position, NULLS_FIRST, NULLS_LAST); |
| } |
| |
| @Test |
| public void test_OrderByItem_NullOrdering_21() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e ORDER BY e ASC NULLS LAST, e.name"; |
| int position = "SELECT e FROM Employee e ORDER BY e ASC NU".length(); |
| testHasOnlyTheseProposals(jpqlQuery, position, NULLS_FIRST, NULLS_LAST); |
| } |
| |
| @Test |
| public void test_OrderByItem_NullOrdering_22() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e ORDER BY e ASC NULLS LAST, e.name"; |
| int position = "SELECT e FROM Employee e ORDER BY e ASC NUL".length(); |
| testHasOnlyTheseProposals(jpqlQuery, position, NULLS_FIRST, NULLS_LAST); |
| } |
| |
| @Test |
| public void test_OrderByItem_NullOrdering_23() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e ORDER BY e ASC NULLS LAST, e.name"; |
| int position = "SELECT e FROM Employee e ORDER BY e ASC NULL".length(); |
| testHasOnlyTheseProposals(jpqlQuery, position, NULLS_FIRST, NULLS_LAST); |
| } |
| |
| @Test |
| public void test_OrderByItem_NullOrdering_24() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e ORDER BY e ASC NULLS LAST, e.name"; |
| int position = "SELECT e FROM Employee e ORDER BY e ASC NULLS".length(); |
| testHasOnlyTheseProposals(jpqlQuery, position, NULLS_FIRST, NULLS_LAST); |
| } |
| |
| @Test |
| public void test_OrderByItem_NullOrdering_25() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e ORDER BY e ASC NULLS LAST, e.name"; |
| int position = "SELECT e FROM Employee e ORDER BY e ASC NULLS ".length(); |
| testHasOnlyTheseProposals(jpqlQuery, position, NULLS_FIRST, NULLS_LAST); |
| } |
| |
| @Test |
| public void test_OrderByItem_NullOrdering_26() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e ORDER BY e ASC NULLS LAST, e.name"; |
| int position = "SELECT e FROM Employee e ORDER BY e ASC NULLS L".length(); |
| testHasOnlyTheseProposals(jpqlQuery, position, NULLS_FIRST, NULLS_LAST); |
| } |
| |
| @Test |
| public void test_OrderByItem_NullOrdering_27() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e ORDER BY e ASC NULLS LAST, e.name"; |
| int position = "SELECT e FROM Employee e ORDER BY e ASC NULLS LA".length(); |
| testHasOnlyTheseProposals(jpqlQuery, position, NULLS_FIRST, NULLS_LAST); |
| } |
| |
| @Test |
| public void test_OrderByItem_NullOrdering_28() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e ORDER BY e ASC NULLS LAST, e.name"; |
| int position = "SELECT e FROM Employee e ORDER BY e ASC NULLS LAS".length(); |
| testHasOnlyTheseProposals(jpqlQuery, position, NULLS_FIRST, NULLS_LAST); |
| } |
| |
| @Test |
| public void test_RegexpExpression_01() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e WHERE e.name "; |
| int position = jpqlQuery.length(); |
| testHasTheseProposals(jpqlQuery, position, REGEXP); |
| } |
| |
| @Test |
| public void test_RegexpExpression_02() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e WHERE e.name R"; |
| int position = jpqlQuery.length(); |
| testHasTheseProposals(jpqlQuery, position, REGEXP); |
| } |
| |
| @Test |
| public void test_RegexpExpression_03() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e WHERE e.name RE"; |
| int position = jpqlQuery.length(); |
| testHasTheseProposals(jpqlQuery, position, REGEXP); |
| } |
| |
| @Test |
| public void test_RegexpExpression_04() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e WHERE e.name REG"; |
| int position = jpqlQuery.length(); |
| testHasTheseProposals(jpqlQuery, position, REGEXP); |
| } |
| |
| @Test |
| public void test_RegexpExpression_05() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e WHERE e.name REGE"; |
| int position = jpqlQuery.length(); |
| testHasTheseProposals(jpqlQuery, position, REGEXP); |
| } |
| |
| @Test |
| public void test_RegexpExpression_06() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e WHERE e.name REGEX"; |
| int position = jpqlQuery.length(); |
| testHasTheseProposals(jpqlQuery, position, REGEXP); |
| } |
| |
| @Test |
| public void test_RegexpExpression_07() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e WHERE e.name REGEXP"; |
| int position = jpqlQuery.length(); |
| testHasTheseProposals(jpqlQuery, position, REGEXP); |
| } |
| |
| @Test |
| public void test_RegexpExpression_08() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e WHERE e.name R"; |
| int position = "SELECT e FROM Employee e WHERE e.name ".length(); |
| testHasTheseProposals(jpqlQuery, position, REGEXP); |
| } |
| |
| @Test |
| public void test_RegexpExpression_09() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e WHERE e.name RE"; |
| int position = "SELECT e FROM Employee e WHERE e.name ".length(); |
| testHasTheseProposals(jpqlQuery, position, REGEXP); |
| } |
| |
| @Test |
| public void test_RegexpExpression_10() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e WHERE e.name REG"; |
| int position = "SELECT e FROM Employee e WHERE e.name ".length(); |
| testHasTheseProposals(jpqlQuery, position, REGEXP); |
| } |
| |
| @Test |
| public void test_RegexpExpression_11() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e WHERE e.name REGE"; |
| int position = "SELECT e FROM Employee e WHERE e.name ".length(); |
| testHasTheseProposals(jpqlQuery, position, REGEXP); |
| } |
| |
| @Test |
| public void test_RegexpExpression_14() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e WHERE e.name REGEX"; |
| int position = "SELECT e FROM Employee e WHERE e.name ".length(); |
| testHasTheseProposals(jpqlQuery, position, REGEXP); |
| } |
| |
| @Test |
| public void test_RegexpExpression_15() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e WHERE e.name REGEXP"; |
| int position = "SELECT e FROM Employee e WHERE e.name ".length(); |
| testHasTheseProposals(jpqlQuery, position, REGEXP); |
| } |
| |
| @Test |
| public void test_RegexpExpression_16() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e WHERE e.name REGEXP "; |
| int position = "SELECT e FROM Employee e WHERE e.name REGEXP ".length(); |
| |
| List<String> proposals = new ArrayList<>(); |
| proposals.add("e"); |
| CollectionTools.addAll(proposals, bnfAccessor.patternValueFunctions()); |
| |
| testHasOnlyTheseProposals(jpqlQuery, position, proposals); |
| } |
| |
| @Test |
| public void test_RegexpExpression_17() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e WHERE e.name REGEXP e"; |
| int position = "SELECT e FROM Employee e WHERE e.name REGEXP e".length(); |
| |
| List<String> proposals = new ArrayList<>(); |
| proposals.add("e"); |
| CollectionTools.addAll(proposals, filter(bnfAccessor.patternValueFunctions(), "e")); |
| |
| testHasOnlyTheseProposals(jpqlQuery, position, proposals); |
| } |
| |
| @Test |
| public void test_SubqueryInFrom_PathtExpression_01() { |
| |
| String jpqlQuery = "Select avg(e3.c) from Employee e, (Select count(e2) as c, e2.name from Employee e2 group by e2.name) e3 where e.name = e3.name"; |
| int position = "Select avg(e3.".length(); |
| testHasOnlyTheseProposals(jpqlQuery, position, "c", "name"); |
| } |
| |
| @Test |
| public void test_SubqueryInFrom_PathtExpression_02() { |
| |
| String jpqlQuery = "Select avg(e3.c) from Employee e, (Select count(e2) as c, e2.name from Employee e2 group by e2.name) e3 where e.name = e3.name"; |
| int position = "Select avg(e3.c) from Employee e, (Select count(e2) as c, e2.name from Employee e2 group by e2.name) e3 where e.name = e3.".length(); |
| testHasOnlyTheseProposals(jpqlQuery, position, "c", "name"); |
| } |
| |
| @Test |
| public void test_TableVariableDeclaration_01() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e, TABLE('EMP_ID')"; |
| int startPosition = jpqlQuery.length(); |
| testHasNoProposals(jpqlQuery, startPosition); |
| } |
| |
| @Test |
| public void test_TableVariableDeclaration_02() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e, TABLE('EMP_ID') "; |
| int startPosition = jpqlQuery.length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, AS); |
| } |
| |
| @Test |
| public void test_TableVariableDeclaration_03() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e, TABLE('EMP_ID') AS"; |
| int startPosition = jpqlQuery.length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, AS); |
| } |
| |
| @Test |
| public void test_TableVariableDeclaration_04() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e, TABLE('EMP_ID') AS"; |
| int startPosition = "SELECT e FROM Employee e, TABLE('EMP_ID') ".length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, AS); |
| } |
| |
| @Test |
| public void test_TableVariableDeclaration_05() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e, TABLE('EMP_ID') AS"; |
| int startPosition = "SELECT e FROM Employee e, TABLE('EMP_ID') A".length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, AS); |
| } |
| |
| @Test |
| public void test_TableVariableDeclaration_06() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e, TABLE('EMP_ID') A"; |
| int startPosition = "SELECT e FROM Employee e, TABLE('EMP_ID') ".length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, AS); |
| } |
| |
| @Test |
| public void test_TableVariableDeclaration_07() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e, TABLE('EMP_ID') A"; |
| int startPosition = "SELECT e FROM Employee e, TABLE('EMP_ID') A".length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, AS); |
| } |
| |
| @Test |
| public void test_TableVariableDeclaration_08() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e, TABLE('EMP_ID') E"; |
| int startPosition = "SELECT e FROM Employee e, TABLE('EMP_ID') ".length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, AS); |
| } |
| |
| @Test |
| public void test_TableVariableDeclaration_09() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e, TABLE('EMP_ID') E"; |
| int startPosition = jpqlQuery.length(); |
| testHasNoProposals(jpqlQuery, startPosition); |
| } |
| |
| @Test |
| public void test_TableVariableDeclaration_10() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e, TABLE('EMP_ID') Astérix"; |
| int startPosition = jpqlQuery.length(); |
| testHasNoProposals(jpqlQuery, startPosition); |
| } |
| |
| @Test |
| public void test_UnionClause_001() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e "; |
| int startPosition = jpqlQuery.length(); |
| testHasTheseProposals(jpqlQuery, startPosition, UNION, INTERSECT, EXCEPT); |
| } |
| |
| @Test |
| public void test_UnionClause_002() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e WHERE e.name "; |
| int startPosition = jpqlQuery.length(); |
| testDoesNotHaveTheseProposals(jpqlQuery, startPosition, UNION, INTERSECT, EXCEPT); |
| } |
| |
| @Test |
| public void test_UnionClause_003() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e WHERE e.name <> 'JPQL' "; |
| int startPosition = jpqlQuery.length(); |
| testHasTheseProposals(jpqlQuery, startPosition, UNION, INTERSECT, EXCEPT); |
| } |
| |
| @Test |
| public void test_UnionClause_004() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e WHERE e.name <> 'JPQL' GROUP BY e.name "; |
| int startPosition = jpqlQuery.length(); |
| testHasTheseProposals(jpqlQuery, startPosition, UNION, INTERSECT, EXCEPT); |
| } |
| |
| @Test |
| public void test_UnionClause_005() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e WHERE e.name <> 'JPQL' GROUP BY e.name "; |
| int startPosition = "SELECT e FROM Employee e WHERE e.name <> 'JPQL' ".length(); |
| testDoesNotHaveTheseProposals(jpqlQuery, startPosition, UNION, INTERSECT, EXCEPT); |
| } |
| |
| @Test |
| public void test_UnionClause_006() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e WHERE e.name <> 'JPQL' GROUP BY e.name "; |
| int startPosition = jpqlQuery.length(); |
| testHasTheseProposals(jpqlQuery, startPosition, UNION, INTERSECT, EXCEPT); |
| } |
| |
| @Test |
| public void test_UnionClause_007() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e WHERE e.name <> 'JPQL' GROUP BY e.name HAVING e.age > 12 "; |
| int startPosition = "SELECT e FROM Employee e WHERE e.name <> 'JPQL' ".length(); |
| testDoesNotHaveTheseProposals(jpqlQuery, startPosition, UNION, INTERSECT, EXCEPT); |
| } |
| |
| @Test |
| public void test_UnionClause_008() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e WHERE e.name <> 'JPQL' GROUP BY e.name HAVING e.age > 12 "; |
| int startPosition = "SELECT e FROM Employee e WHERE e.name <> 'JPQL' GROUP BY e.name ".length(); |
| testDoesNotHaveTheseProposals(jpqlQuery, startPosition, UNION, INTERSECT, EXCEPT); |
| } |
| |
| @Test |
| public void test_UnionClause_009() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e WHERE e.name <> 'JPQL' GROUP BY e.name HAVING e.age > 12 "; |
| int startPosition = jpqlQuery.length(); |
| testHasTheseProposals(jpqlQuery, startPosition, UNION, INTERSECT, EXCEPT); |
| } |
| |
| @Test |
| public void test_UnionClause_010() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e WHERE e.name <> 'JPQL' GROUP BY e.name HAVING e.age > 12 ORDER BY e.name "; |
| int startPosition = "SELECT e FROM Employee e WHERE e.name <> 'JPQL' ".length(); |
| testDoesNotHaveTheseProposals(jpqlQuery, startPosition, UNION, INTERSECT, EXCEPT); |
| } |
| |
| @Test |
| public void test_UnionClause_011() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e WHERE e.name <> 'JPQL' GROUP BY e.name HAVING e.age > 12 ORDER BY e.name "; |
| int startPosition = "SELECT e FROM Employee e WHERE e.name <> 'JPQL' GROUP BY e.name ".length(); |
| testDoesNotHaveTheseProposals(jpqlQuery, startPosition, UNION, INTERSECT, EXCEPT); |
| } |
| |
| @Test |
| public void test_UnionClause_012() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e WHERE e.name <> 'JPQL' GROUP BY e.name HAVING e.age > 12 ORDER BY e.name "; |
| int startPosition = "SELECT e FROM Employee e WHERE e.name <> 'JPQL' GROUP BY e.name HAVING e.age > 12 ".length(); |
| testDoesNotHaveTheseProposals(jpqlQuery, startPosition, UNION, INTERSECT, EXCEPT); |
| } |
| |
| @Test |
| public void test_UnionClause_013() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e WHERE e.name <> 'JPQL' GROUP BY e.name HAVING e.age > 12 ORDER BY e.name "; |
| int startPosition = jpqlQuery.length(); |
| |
| testHasTheseProposals( |
| jpqlQuery, |
| startPosition, |
| ASC, DESC, |
| NULLS_FIRST, NULLS_LAST, |
| UNION, INTERSECT, EXCEPT |
| ); |
| } |
| |
| @Test |
| public void test_UnionClause_014() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e UNION"; |
| int startPosition = "SELECT e FROM Employee e ".length(); |
| testHasTheseProposals(jpqlQuery, startPosition, UNION, INTERSECT, EXCEPT); |
| } |
| |
| @Test |
| public void test_UnionClause_015() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e UNION"; |
| int startPosition = "SELECT e FROM Employee e U".length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, UNION, INTERSECT, EXCEPT); |
| } |
| |
| @Test |
| public void test_UnionClause_016() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e UNION"; |
| int startPosition = "SELECT e FROM Employee e UN".length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, UNION, INTERSECT, EXCEPT); |
| } |
| |
| @Test |
| public void test_UnionClause_017() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e UNION"; |
| int startPosition = "SELECT e FROM Employee e UNI".length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, UNION, INTERSECT, EXCEPT); |
| } |
| |
| @Test |
| public void test_UnionClause_018() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e UNION"; |
| int startPosition = "SELECT e FROM Employee e UNIO".length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, UNION, INTERSECT, EXCEPT); |
| } |
| |
| @Test |
| public void test_UnionClause_019() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e UNION"; |
| int startPosition = "SELECT e FROM Employee e UNION".length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, UNION, INTERSECT, EXCEPT); |
| } |
| |
| @Test |
| public void test_UnionClause_020() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e UNION "; |
| int startPosition = jpqlQuery.length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, ALL, SELECT); |
| } |
| |
| @Test |
| public void test_UnionClause_021() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e UNION A"; |
| int startPosition = jpqlQuery.length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, ALL); |
| } |
| |
| @Test |
| public void test_UnionClause_022() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e UNION AL"; |
| int startPosition = jpqlQuery.length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, ALL); |
| } |
| |
| @Test |
| public void test_UnionClause_023() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e UNION ALL"; |
| int startPosition = jpqlQuery.length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, ALL); |
| } |
| |
| @Test |
| public void test_UnionClause_024() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e UNION ALL "; |
| int startPosition = jpqlQuery.length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, SELECT); |
| } |
| |
| @Test |
| public void test_UnionClause_025() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e UNION ALL"; |
| int startPosition = "SELECT e FROM Employee e UNION ".length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, ALL); |
| } |
| |
| @Test |
| public void test_UnionClause_026() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e UNION AL"; |
| int startPosition = "SELECT e FROM Employee e UNION A".length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, ALL); |
| } |
| |
| @Test |
| public void test_UnionClause_027() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e UNION ALL"; |
| int startPosition = "SELECT e FROM Employee e UNION ALL".length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, ALL); |
| } |
| |
| @Test |
| public void test_UnionClause_028() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e UNION ALL "; |
| int startPosition = jpqlQuery.length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, SELECT); |
| } |
| |
| @Test |
| public void test_UnionClause_029() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e UNION ALL S"; |
| int startPosition = jpqlQuery.length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, SELECT); |
| } |
| |
| @Test |
| public void test_UnionClause_030() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e UNION ALL SE"; |
| int startPosition = jpqlQuery.length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, SELECT); |
| } |
| |
| @Test |
| public void test_UnionClause_031() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e UNION ALL SEL"; |
| int startPosition = jpqlQuery.length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, SELECT); |
| } |
| |
| @Test |
| public void test_UnionClause_032() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e UNION ALL SELE"; |
| int startPosition = jpqlQuery.length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, SELECT); |
| } |
| |
| @Test |
| public void test_UnionClause_033() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e UNION ALL SELEC"; |
| int startPosition = jpqlQuery.length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, SELECT); |
| } |
| |
| @Test |
| public void test_UnionClause_034() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e UNION ALL SELECT"; |
| int startPosition = jpqlQuery.length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, SELECT); |
| } |
| |
| @Test |
| public void test_UnionClause_035() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e UNION ALL SELECT "; |
| int startPosition = "SELECT e FROM Employee e UNION ALL ".length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, SELECT); |
| } |
| |
| @Test |
| public void test_UnionClause_036() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e UNION ALL SELECT "; |
| int startPosition = "SELECT e FROM Employee e UNION ALL S".length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, SELECT); |
| } |
| |
| @Test |
| public void test_UnionClause_037() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e UNION ALL SELECT "; |
| int startPosition = "SELECT e FROM Employee e UNION ALL SE".length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, SELECT); |
| } |
| |
| @Test |
| public void test_UnionClause_038() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e UNION ALL SELECT "; |
| int startPosition = "SELECT e FROM Employee e UNION ALL SEL".length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, SELECT); |
| } |
| |
| @Test |
| public void test_UnionClause_039() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e UNION ALL SELECT "; |
| int startPosition = "SELECT e FROM Employee e UNION ALL SELE".length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, SELECT); |
| } |
| |
| @Test |
| public void test_UnionClause_040() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e UNION ALL SELECT "; |
| int startPosition = "SELECT e FROM Employee e UNION ALL SELEC".length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, SELECT); |
| } |
| |
| @Test |
| public void test_UnionClause_041() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e UNION ALL SELECT "; |
| int startPosition = "SELECT e FROM Employee e UNION ALL SELECT".length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, SELECT); |
| } |
| |
| @Test |
| public void test_UnionClause_042() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e INTERSECT"; |
| int startPosition = "SELECT e FROM Employee e ".length(); |
| testHasTheseProposals(jpqlQuery, startPosition, UNION, INTERSECT, EXCEPT); |
| } |
| |
| @Test |
| public void test_UnionClause_043() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e INTERSECT"; |
| int startPosition = "SELECT e FROM Employee e I".length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, UNION, INTERSECT, EXCEPT); |
| } |
| |
| @Test |
| public void test_UnionClause_044() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e INTERSECT"; |
| int startPosition = "SELECT e FROM Employee e IN".length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, UNION, INTERSECT, EXCEPT); |
| } |
| |
| @Test |
| public void test_UnionClause_045() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e INTERSECT"; |
| int startPosition = "SELECT e FROM Employee e INT".length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, UNION, INTERSECT, EXCEPT); |
| } |
| |
| @Test |
| public void test_UnionClause_046() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e INTERSECT"; |
| int startPosition = "SELECT e FROM Employee e INTE".length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, UNION, INTERSECT, EXCEPT); |
| } |
| |
| @Test |
| public void test_UnionClause_047() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e INTERSECT"; |
| int startPosition = "SELECT e FROM Employee e INTER".length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, UNION, INTERSECT, EXCEPT); |
| } |
| |
| @Test |
| public void test_UnionClause_048() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e INTERSECT"; |
| int startPosition = "SELECT e FROM Employee e INTERC".length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, UNION, INTERSECT, EXCEPT); |
| } |
| |
| @Test |
| public void test_UnionClause_049() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e INTERSECT"; |
| int startPosition = "SELECT e FROM Employee e INTERCE".length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, UNION, INTERSECT, EXCEPT); |
| } |
| |
| @Test |
| public void test_UnionClause_050() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e INTERSECT"; |
| int startPosition = "SELECT e FROM Employee e INTERCEP".length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, UNION, INTERSECT, EXCEPT); |
| } |
| |
| @Test |
| public void test_UnionClause_051() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e INTERSECT"; |
| int startPosition = "SELECT e FROM Employee e INTERSECT".length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, UNION, INTERSECT, EXCEPT); |
| } |
| |
| @Test |
| public void test_UnionClause_052() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e INTERSECT "; |
| int startPosition = jpqlQuery.length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, ALL, SELECT); |
| } |
| |
| @Test |
| public void test_UnionClause_053() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e INTERSECT A"; |
| int startPosition = jpqlQuery.length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, ALL); |
| } |
| |
| @Test |
| public void test_UnionClause_054() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e INTERSECT AL"; |
| int startPosition = jpqlQuery.length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, ALL); |
| } |
| |
| @Test |
| public void test_UnionClause_055() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e INTERSECT ALL"; |
| int startPosition = jpqlQuery.length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, ALL); |
| } |
| |
| @Test |
| public void test_UnionClause_056() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e INTERSECT ALL "; |
| int startPosition = jpqlQuery.length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, SELECT); |
| } |
| |
| @Test |
| public void test_UnionClause_057() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e INTERSECT ALL"; |
| int startPosition = "SELECT e FROM Employee e INTERSECT ".length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, ALL); |
| } |
| |
| @Test |
| public void test_UnionClause_058() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e INTERSECT AL"; |
| int startPosition = "SELECT e FROM Employee e INTERSECT A".length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, ALL); |
| } |
| |
| @Test |
| public void test_UnionClause_059() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e INTERSECT ALL"; |
| int startPosition = "SELECT e FROM Employee e INTERSECT ALL".length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, ALL); |
| } |
| |
| @Test |
| public void test_UnionClause_060() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e INTERSECT ALL "; |
| int startPosition = jpqlQuery.length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, SELECT); |
| } |
| |
| @Test |
| public void test_UnionClause_061() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e INTERSECT ALL S"; |
| int startPosition = jpqlQuery.length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, SELECT); |
| } |
| |
| @Test |
| public void test_UnionClause_062() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e INTERSECT ALL SE"; |
| int startPosition = jpqlQuery.length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, SELECT); |
| } |
| |
| @Test |
| public void test_UnionClause_063() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e INTERSECT ALL SEL"; |
| int startPosition = jpqlQuery.length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, SELECT); |
| } |
| |
| @Test |
| public void test_UnionClause_064() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e INTERSECT ALL SELE"; |
| int startPosition = jpqlQuery.length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, SELECT); |
| } |
| |
| @Test |
| public void test_UnionClause_065() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e INTERSECT ALL SELEC"; |
| int startPosition = jpqlQuery.length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, SELECT); |
| } |
| |
| @Test |
| public void test_UnionClause_066() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e INTERSECT ALL SELECT"; |
| int startPosition = jpqlQuery.length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, SELECT); |
| } |
| |
| @Test |
| public void test_UnionClause_067() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e INTERSECT ALL SELECT "; |
| int startPosition = "SELECT e FROM Employee e INTERSECT ALL ".length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, SELECT); |
| } |
| |
| @Test |
| public void test_UnionClause_068() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e INTERSECT ALL SELECT "; |
| int startPosition = "SELECT e FROM Employee e INTERSECT ALL S".length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, SELECT); |
| } |
| |
| @Test |
| public void test_UnionClause_069() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e INTERSECT ALL SELECT "; |
| int startPosition = "SELECT e FROM Employee e INTERSECT ALL SE".length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, SELECT); |
| } |
| |
| @Test |
| public void test_UnionClause_070() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e INTERSECT ALL SELECT "; |
| int startPosition = "SELECT e FROM Employee e INTERSECT ALL SEL".length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, SELECT); |
| } |
| |
| @Test |
| public void test_UnionClause_071() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e INTERSECT ALL SELECT "; |
| int startPosition = "SELECT e FROM Employee e INTERSECT ALL SELE".length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, SELECT); |
| } |
| |
| @Test |
| public void test_UnionClause_072() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e INTERSECT ALL SELECT "; |
| int startPosition = "SELECT e FROM Employee e INTERSECT ALL SELEC".length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, SELECT); |
| } |
| |
| @Test |
| public void test_UnionClause_073() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e INTERSECT ALL SELECT "; |
| int startPosition = "SELECT e FROM Employee e INTERSECT ALL SELECT".length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, SELECT); |
| } |
| |
| @Test |
| public void test_UnionClause_074() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e EXCEPT"; |
| int startPosition = "SELECT e FROM Employee e ".length(); |
| testHasTheseProposals(jpqlQuery, startPosition, UNION, INTERSECT, EXCEPT); |
| } |
| |
| @Test |
| public void test_UnionClause_075() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e EXCEPT"; |
| int startPosition = "SELECT e FROM Employee e E".length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, UNION, INTERSECT, EXCEPT); |
| } |
| |
| @Test |
| public void test_UnionClause_076() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e EXCEPT"; |
| int startPosition = "SELECT e FROM Employee e EX".length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, UNION, INTERSECT, EXCEPT); |
| } |
| |
| @Test |
| public void test_UnionClause_077() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e EXCEPT"; |
| int startPosition = "SELECT e FROM Employee e EXC".length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, UNION, INTERSECT, EXCEPT); |
| } |
| |
| @Test |
| public void test_UnionClause_078() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e EXCEPT"; |
| int startPosition = "SELECT e FROM Employee e EXCE".length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, UNION, INTERSECT, EXCEPT); |
| } |
| |
| @Test |
| public void test_UnionClause_079() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e EXCEPT"; |
| int startPosition = "SELECT e FROM Employee e EXCEP".length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, UNION, INTERSECT, EXCEPT); |
| } |
| |
| @Test |
| public void test_UnionClause_080() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e EXCEPT"; |
| int startPosition = "SELECT e FROM Employee e EXCEPT".length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, UNION, INTERSECT, EXCEPT); |
| } |
| |
| @Test |
| public void test_UnionClause_081() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e EXCEPT "; |
| int startPosition = jpqlQuery.length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, ALL, SELECT); |
| } |
| |
| @Test |
| public void test_UnionClause_082() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e EXCEPT A"; |
| int startPosition = jpqlQuery.length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, ALL); |
| } |
| |
| @Test |
| public void test_UnionClause_083() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e EXCEPT AL"; |
| int startPosition = jpqlQuery.length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, ALL); |
| } |
| |
| @Test |
| public void test_UnionClause_084() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e EXCEPT ALL"; |
| int startPosition = jpqlQuery.length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, ALL); |
| } |
| |
| @Test |
| public void test_UnionClause_085() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e EXCEPT ALL "; |
| int startPosition = jpqlQuery.length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, SELECT); |
| } |
| |
| @Test |
| public void test_UnionClause_086() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e EXCEPT ALL"; |
| int startPosition = "SELECT e FROM Employee e EXCEPT ".length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, ALL); |
| } |
| |
| @Test |
| public void test_UnionClause_087() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e EXCEPT AL"; |
| int startPosition = "SELECT e FROM Employee e EXCEPT A".length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, ALL); |
| } |
| |
| @Test |
| public void test_UnionClause_088() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e EXCEPT ALL"; |
| int startPosition = "SELECT e FROM Employee e EXCEPT ALL".length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, ALL); |
| } |
| |
| @Test |
| public void test_UnionClause_089() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e EXCEPT ALL "; |
| int startPosition = jpqlQuery.length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, SELECT); |
| } |
| |
| @Test |
| public void test_UnionClause_090() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e EXCEPT ALL S"; |
| int startPosition = jpqlQuery.length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, SELECT); |
| } |
| |
| @Test |
| public void test_UnionClause_091() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e EXCEPT ALL SE"; |
| int startPosition = jpqlQuery.length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, SELECT); |
| } |
| |
| @Test |
| public void test_UnionClause_092() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e EXCEPT ALL SEL"; |
| int startPosition = jpqlQuery.length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, SELECT); |
| } |
| |
| @Test |
| public void test_UnionClause_093() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e EXCEPT ALL SELE"; |
| int startPosition = jpqlQuery.length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, SELECT); |
| } |
| |
| @Test |
| public void test_UnionClause_094() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e EXCEPT ALL SELEC"; |
| int startPosition = jpqlQuery.length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, SELECT); |
| } |
| |
| @Test |
| public void test_UnionClause_095() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e EXCEPT ALL SELECT"; |
| int startPosition = jpqlQuery.length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, SELECT); |
| } |
| |
| @Test |
| public void test_UnionClause_096() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e EXCEPT ALL SELECT "; |
| int startPosition = "SELECT e FROM Employee e EXCEPT ALL ".length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, SELECT); |
| } |
| |
| @Test |
| public void test_UnionClause_097() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e EXCEPT ALL SELECT "; |
| int startPosition = "SELECT e FROM Employee e EXCEPT ALL S".length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, SELECT); |
| } |
| |
| @Test |
| public void test_UnionClause_098() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e EXCEPT ALL SELECT "; |
| int startPosition = "SELECT e FROM Employee e EXCEPT ALL SE".length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, SELECT); |
| } |
| |
| @Test |
| public void test_UnionClause_099() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e EXCEPT ALL SELECT "; |
| int startPosition = "SELECT e FROM Employee e EXCEPT ALL SEL".length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, SELECT); |
| } |
| |
| @Test |
| public void test_UnionClause_100() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e EXCEPT ALL SELECT "; |
| int startPosition = "SELECT e FROM Employee e EXCEPT ALL SELE".length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, SELECT); |
| } |
| |
| @Test |
| public void test_UnionClause_101() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e EXCEPT ALL SELECT "; |
| int startPosition = "SELECT e FROM Employee e EXCEPT ALL SELEC".length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, SELECT); |
| } |
| |
| @Test |
| public void test_UnionClause_102() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e EXCEPT ALL SELECT "; |
| int startPosition = "SELECT e FROM Employee e EXCEPT ALL SELECT".length(); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, SELECT); |
| } |
| |
| @Test |
| public void test_UnionClause_103() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e WHERE e.name <> 'JPQL' GROUP BY e.name, e"; |
| int startPosition = jpqlQuery.length(); |
| |
| List<String> proposals = new ArrayList<>(); |
| proposals.add("e"); |
| CollectionTools.addAll(proposals, filter(bnfAccessor.groupByItemFunctions(), "e")); |
| |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, proposals); |
| } |
| |
| @Test |
| public void test_UnionClause_104() { |
| |
| String jpqlQuery = "SELECT e FROM Employee e WHERE e.name <> 'JPQL' GROUP BY e.name, e e"; |
| int startPosition = jpqlQuery.length(); |
| Iterable<String> proposals = filter(clauses(GROUP_BY, null, false), "e"); |
| testHasOnlyTheseProposals(jpqlQuery, startPosition, proposals); |
| } |
| } |