EJBQL Syntax update

-------- Original Message --------
Subject: missing EJBQL stuff
Date: Fri, 05 Nov 2004 10:38:18 -0500
From: Gavin King <gavin@hibernate.org>
To: bill.burke@jboss.com, Scott M Stark <scott.stark@jboss.com>

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 '%'