Bug 317189

Summary:

test implementation for Advanced Query --- FUNCTION support to extended JPQL

Product:

z_Archived

Reporter:

Yiping Zhao <yiping.zhao>

Component:

Eclipselink

Assignee:

Nobody - feel free to take it <nobody>

Status:

RESOLVED FIXED

QA Contact:

Severity:

normal

Priority:

Keywords:

test

Version:

unspecified

Target Milestone:

---

Hardware:

OS:

Windows XP

Whiteboard:

Attachments:

Description	Flags
test implementation for Advanced Query --- FUNC support	none
new patch for test implementation for Advanced Query --- FUNC support	none

Description Yiping Zhao

2010-06-17 10:56:16 EDT

In EclipseLink 2.1, We have Advanced Query feature, which includes FUNCTION support to extended JPQL, the test implementation is as following according to its test plan http://aseng-wiki.us.oracle.com/asengwiki/display/ASQA/Advanced+Query+---+Add+FUNCTION+support+to+extended+JPQL:

The test implementation is by modifying existing tests and adding new tests in <trunk>\jpa\eclipselink.jpa.test\src\org\eclipse\persistence\testing\tests\jpa\jpql\JUnitJPQLComplexTestSuite.java, details as follow:

1. add testFuncWithStoredFunc() to build stored function and use it with FUNC
2. add testFuncWithMySQLFuncs() to test MySQL specific database functions with FUNC
3. add testNestedFUNCs() to test nested functions with FUNC
4. modify testFunctionInOrderBy() to have FUNC with oder by clause
5. modify testFunctionInGroupBy() to have FUNC with group by clause

Comment 1 Yiping Zhao

2010-06-17 11:22:49 EDT

Created attachment 172135 [details]
test implementation for Advanced Query --- FUNC support

Comment 2 Yiping Zhao

2010-06-18 10:56:57 EDT

Created attachment 172224 [details]
new patch for test implementation for Advanced Query --- FUNC support

Comment 3 Yiping Zhao

2010-06-21 11:43:17 EDT

The following changes are made based on review by Andrei:

1. change buildOracleStoredFunction() to be buildStoredFunction() since this is common stored function, it will work with all databases which support stored function

2. remove FUNC from testFunctionInOrderBy() and testFunctionInGroupBy() since Upper is a standard function

3. add sql string to have FUNC in Oder By clause in testFuncWithMySQLFuncs()

The modified patch has been checked in Main as revision 7641.

Code is reviewed by Andrei Ilitchev.

Comment 4 Yiping Zhao

2010-06-24 14:30:40 EDT

checked in the changes to 2.1.1 as revision 7686

Comment 5 Eclipse Webmaster

2022-06-09 10:21:38 EDT

The Eclipselink project has moved to Github: https://github.com/eclipse-ee4j/eclipselink