[ http://jira.jboss.com/jira/browse/EJBTHREE-17?page=history ]
Bill Burke closed EJBTHREE-17:
------------------------------
Resolution: Done
done minus the following which will be addressed sometime in the next release
(Preview 4)
CURRENT_DATE
CURRENT_TIME
CURRENT_TIMESTAMP
> EJBQL Syntax update
> -------------------
>
> Key: EJBTHREE-17
> URL: http://jira.jboss.com/jira/browse/EJBTHREE-17
> Project: EJB 3.0
> Type: Feature Request
> Versions: Preview 3
> Reporter: Bill Burke
> Assignee: Alexey Loubyansky
> Fix For: Preview 3
>
> Original Estimate: 2 weeks
> Remaining: 2 weeks
>
> -------- Original Message --------
> Subject: missing EJBQL stuff
> Date: Fri, 05 Nov 2004 10:38:18 -0500
> From: Gavin King <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED], Scott M Stark <[EMAIL PROTECTED]>
> I created JIRA issue:
> http://opensource.atlassian.com/projects/hibernate/browse/TODO-131
> you guys will need to register and then have permissions to be able to
> view the issue.
> The missing syntax are:
> SELECT OBJECT(c) FROM Customer c, IN(c.orders) o WHERE ...
> c.orders IS EMPTY
> c.orders IS NOT EMPTY
> c MEMBER OF s.customers
> c NOT MEMBER OF s.customers
> CONCAT('x', 'y')
> SUBSTRING('xyz', 1, 2)
> TRIM(' abcd ')
> TRIM(LEADING ' ' FROM ' abcd ')
> TRIM(TRAILING ' ' FROM ' abcd ')
> TRIM(BOTH ' ' FROM ' abcd ')
> LOWER('ABC')
> UPPER('abc')
> LENGTH('abc')
> LOCATE('abc', 'a')
> LOCATE('abc', 'a', 1)
> ABS(-1)
> SQRT(9)
> MOD(5,2)
> POSITION('a' IN 'abc')
> CHARACTER_LENGTH('xyz')
> CHAR_LENGTH('xyz')
> BIT_LENGTH('zyx')
> CURRENT_DATE
> CURRENT_TIME
> CURRENT_TIMESTAMP
> 'asddsfs' LIKE '%a%' ESCAPE '%'
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.jboss.com/jira/secure/Administrators.jspa
-
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
-------------------------------------------------------
The SF.Net email is sponsored by: Beat the post-holiday blues
Get a FREE limited edition SourceForge.net t-shirt from ThinkGeek.
It's fun and FREE -- well, almost....http://www.thinkgeek.com/sfshirt
_______________________________________________
JBoss-Development mailing list
JBoss-Development@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jboss-development
