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
Assigned to: Alex Loubyansky
Fix For: Preview 3
-------- 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
-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://productguide.itmanagersjournal.com/
_______________________________________________
JBoss-Development mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-development
