/*******************************************************************************
* Copyright (c) 2011, 2015 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 v1.0 and Eclipse Distribution License v. 1.0
* which accompanies this distribution.
* The Eclipse Public License is available at http://www.eclipse.org/legal/epl-v10.html
* and the Eclipse Distribution License is available at
* http://www.eclipse.org/org/documents/edl-v10.php.
*
* 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 {
/**
* {@inheritDoc}
*/
@Override
protected List<String> classNames() {
return Collections.emptyList();
}
/**
* {@inheritDoc}
*/
@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;
}
/**
* {@inheritDoc}
*/
@Override
protected List<String> columnNames(String tableName) {
return Collections.emptyList();
}
/**
* {@inheritDoc}
*/
@Override
protected List<String> enumConstants() {
return Collections.emptyList();
}
/**
* {@inheritDoc}
*/
@Override
protected List<String> enumTypes() {
return Collections.emptyList();
}
/**
* {@inheritDoc}
*/
@Override
protected List<String> fromClauseInternalClauses(String afterIdentifier) {
if (EclipseLinkVersionTools.isNewerThan2_4(getGrammar())) {
List<String> proposals = new ArrayList<String>();
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);
}
/**
* {@inheritDoc}
*/
@Override
protected boolean isJoinFetchIdentifiable() {
EclipseLinkVersion currentVersion = EclipseLinkVersion.value(getGrammar().getProviderVersion());
return currentVersion.isNewerThanOrEqual(EclipseLinkJPQLGrammar2_4.VERSION);
}
/**
* {@inheritDoc}
*/
@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<String>();
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<String>();
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<String>();
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<String>();
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<String>();
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<String>();
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<String>();
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<String>();
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<String>();
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<String>();
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<String>();
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<String>();
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<String>();
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<String>();
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<String>();
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<String>();
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);
}
}