Bug 317189 - test implementation for Advanced Query --- FUNCTION support to extended JPQL
Summary: test implementation for Advanced Query --- FUNCTION support to extended JPQL
Status: RESOLVED FIXED
Alias: None
Product: z_Archived
Classification: Eclipse Foundation
Component: Eclipselink (show other bugs)
Version: unspecified   Edit
Hardware: PC Windows XP
: P3 normal (vote)
Target Milestone: ---   Edit
Assignee: Nobody - feel free to take it CLA
QA Contact:
URL:
Whiteboard:
Keywords: test
Depends on:
Blocks:
 
Reported: 2010-06-17 10:56 EDT by Yiping Zhao CLA
Modified: 2022-06-09 10:21 EDT (History)
0 users

See Also:

Attachments
test implementation for Advanced Query --- FUNC support (146.65 KB, patch)
2010-06-17 11:22 EDT, Yiping Zhao CLA 		no flags Details | Diff
new patch for test implementation for Advanced Query --- FUNC support (7.10 KB, patch)
2010-06-18 10:56 EDT, Yiping Zhao CLA 		no flags Details | Diff
Show Obsolete (1) View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Yiping Zhao CLA 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 CLA 2010-06-17 11:22:49 EDT 
Created attachment 172135 [details]
test implementation for Advanced Query --- FUNC support
Comment 2 Yiping Zhao CLA 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 CLA 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 CLA 2010-06-24 14:30:40 EDT 
checked in the changes to 2.1.1 as revision 7686
Comment 5 Eclipse Webmaster CLA 2022-06-09 10:21:38 EDT 
The Eclipselink project has moved to Github: https://github.com/eclipse-ee4j/eclipselink