com.atlassian.jira.webtests.ztests.database

Class TestDatabaseLargeInQueries

java.lang.Object

com.atlassian.jira.functest.framework.BaseJiraFuncTest

com.atlassian.jira.webtests.ztests.database.TestDatabaseLargeInQueries

public class TestDatabaseLargeInQueries
extends BaseJiraFuncTest

Test that OfBiz handles queries with large 'IN' portions. e.g. ... where project.id in (1, 2, 3...). Certain databases don't cope well with these sorts of queries and require workarounds.

Since:

6.4

Field Summary

Fields inherited from class com.atlassian.jira.functest.framework.BaseJiraFuncTest

assertions, backdoor, environmentData, initClass, navigation, tester, testRule

Constructor Summary

Constructors

Constructor and Description
TestDatabaseLargeInQueries()

Method Summary

Modifier and Type	Method and Description
void	testLargeInQueryNumeric() Test with a large number of 'IN' values of numeric type.
void	testLargeInQueryString() Test with a large number of 'IN' values of string type.
void	testLargeNumberOfParametersWithSmallerInFragments() The IN(...) fragments each have less than 2000 parameters but in total there are more than 2000 parameters.

Methods inherited from class com.atlassian.jira.functest.framework.BaseJiraFuncTest

getAssertions, getBackdoor, getEnvironmentData, getTester

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

TestDatabaseLargeInQueries

public TestDatabaseLargeInQueries()

Method Detail

testLargeInQueryNumeric

public void testLargeInQueryNumeric()

Test with a large number of 'IN' values of numeric type.

testLargeInQueryString

public void testLargeInQueryString()

Test with a large number of 'IN' values of string type.

testLargeNumberOfParametersWithSmallerInFragments

public void testLargeNumberOfParametersWithSmallerInFragments()

The IN(...) fragments each have less than 2000 parameters but in total there are more than 2000 parameters.