[Hibernate-JIRA] Created: (HHH-3404) Regular expressions (regex) boolean operator in HQL's where clause: rlike in mysql, regexp_match in informix, ... (regression from hibernate2)
4:36 a.m.
Regular expressions (regex) boolean operator in HQL's where clause: rlike in mysql,
regexp_match in informix, ... (regression from hibernate2)
----------------------------------------------------------------------------------------------------------------------------------------------
Key: HHH-3404
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3404
Project: Hibernate3
Issue Type: New Feature
Components: query-hql
Affects Versions: 3.2.6
Reporter: Geoffrey De Smet
Hibernate 2 supported the rlike boolean operator (at least for mysql): HB-1034. Hibernate3
currently doesn't.
It turns out that most mainstream databases support regular expression patterns
(independently from normal like patterns).
Mysql: rlike
where a.serial rlike '\d*'
Informix: regexp_match()
where regexp_match(a.serial, '\d*')
Oracle: REGEXP_LIKE
where REGEXP_LIKE(a.serial, '\d*')
There have been several forum posts asking about this feature for hibernate3 btw:
http://forum.hibernate.org/viewtopic.php?p=2391395
http://forum.hibernate.org/viewtopic.php?p=2375634
etc
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
1:12 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-3404) Regular expressions (regex) boolean operator in HQL's where clause: rlike in mysql, regexp_match in informix, ... (regression from hibernate2)
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-3404?page=c...
]
Torsten Krah commented on HHH-3404:
-----------------------------------
This is a regression and should be marked as bug than - its not a "new feature"
- searching the bug db its really hard to find this one because of this "bug - new
feature" difference. I would not expect this to be found under "new
feature" as hibernate2 did already support it, so its a bug, a regrression.
Regular expressions (regex) boolean operator in HQL's where
clause: rlike in mysql, regexp_match in informix, ... (regression from hibernate2)
----------------------------------------------------------------------------------------------------------------------------------------------
Key: HHH-3404
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3404
Project: Hibernate Core
Issue Type: New Feature
Components: query-hql
Affects Versions: 3.2.6
Reporter: Geoffrey De Smet
Hibernate 2 supported the rlike boolean operator (at least for mysql): HB-1034.
Hibernate3 currently doesn't.
It turns out that most mainstream databases support regular expression patterns
(independently from normal like patterns).
Mysql: rlike
where a.serial rlike '\d*'
Informix: regexp_match()
where regexp_match(a.serial, '\d*')
Oracle: REGEXP_LIKE
where REGEXP_LIKE(a.serial, '\d*')
There have been several forum posts asking about this feature for hibernate3 btw:
http://forum.hibernate.org/viewtopic.php?p=2391395
http://forum.hibernate.org/viewtopic.php?p=2375634
etc
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
10:32 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-3404) Regular expressions (regex) boolean operator in HQL's where clause: rlike in mysql, regexp_match in informix, ... (regression from hibernate2)
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-3404?page=c...
]
Steve Ebersole commented on HHH-3404:
-------------------------------------
Torsten: Just because something happened to work does not make it a feature. If something
is not discussed in the documentation and is not covered in the Hibernate test-suite then
upon what are you basing your assertion that it was a feature?
Regular expressions (regex) boolean operator in HQL's where
clause: rlike in mysql, regexp_match in informix, ... (regression from hibernate2)
----------------------------------------------------------------------------------------------------------------------------------------------
Key: HHH-3404
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3404
Project: Hibernate Core
Issue Type: New Feature
Components: query-hql
Affects Versions: 3.2.6
Reporter: Geoffrey De Smet
Hibernate 2 supported the rlike boolean operator (at least for mysql): HB-1034.
Hibernate3 currently doesn't.
It turns out that most mainstream databases support regular expression patterns
(independently from normal like patterns).
Mysql: rlike
where a.serial rlike '\d*'
Informix: regexp_match()
where regexp_match(a.serial, '\d*')
Oracle: REGEXP_LIKE
where REGEXP_LIKE(a.serial, '\d*')
There have been several forum posts asking about this feature for hibernate3 btw:
http://forum.hibernate.org/viewtopic.php?p=2391395
http://forum.hibernate.org/viewtopic.php?p=2375634
etc
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
3:32 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-3404) Regular expressions (regex) boolean operator in HQL's where clause: rlike in mysql, regexp_match in informix, ... (regression from hibernate2)
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-3404?page=c...
]
Torsten Krah commented on HHH-3404:
-----------------------------------
Looking at this one there was once a Improvement request which made it to Hibernate2 and 3
(classic).
http://opensource.atlassian.com/projects/hibernate/browse/HB-1034
Gavin accepted the patch and because of this jira issue i made the assumption, excuse me
please if i was wrong, that this "was" a feature.
Looking at the classic parser it seems still supported, only the antlr based AST Parser
seems not to support this syntax - thought the "new" one would support the same
syntax (or more) than the classic one already support.
Sorry if this is not what i should expect.
Regular expressions (regex) boolean operator in HQL's where
clause: rlike in mysql, regexp_match in informix, ... (regression from hibernate2)
----------------------------------------------------------------------------------------------------------------------------------------------
Key: HHH-3404
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3404
Project: Hibernate Core
Issue Type: New Feature
Components: query-hql
Affects Versions: 3.2.6
Reporter: Geoffrey De Smet
Hibernate 2 supported the rlike boolean operator (at least for mysql): HB-1034.
Hibernate3 currently doesn't.
It turns out that most mainstream databases support regular expression patterns
(independently from normal like patterns).
Mysql: rlike
where a.serial rlike '\d*'
Informix: regexp_match()
where regexp_match(a.serial, '\d*')
Oracle: REGEXP_LIKE
where REGEXP_LIKE(a.serial, '\d*')
There have been several forum posts asking about this feature for hibernate3 btw:
http://forum.hibernate.org/viewtopic.php?p=2391395
http://forum.hibernate.org/viewtopic.php?p=2375634
etc
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
1:17 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-3404) Regular expressions (regex) boolean operator in HQL's where clause: rlike in mysql, regexp_match in informix, ... (regression from hibernate2)
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-3404?page=c...
]
Andrew Houghton commented on HHH-3404:
--------------------------------------
We've been running our service forever on Hib2; we're finally making the change to
Hib3, and this is the only outstanding issue preventing widespread testing for us.
Torsten's point seems good -- the original patch was clearly a feature that was
accepted into the base Hib2 tree; it would be nice to see this feature in Hib3.
Regular expressions (regex) boolean operator in HQL's where
clause: rlike in mysql, regexp_match in informix, ... (regression from hibernate2)
----------------------------------------------------------------------------------------------------------------------------------------------
Key: HHH-3404
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3404
Project: Hibernate Core
Issue Type: New Feature
Components: query-hql
Affects Versions: 3.2.6
Reporter: Geoffrey De Smet
Hibernate 2 supported the rlike boolean operator (at least for mysql): HB-1034.
Hibernate3 currently doesn't.
It turns out that most mainstream databases support regular expression patterns
(independently from normal like patterns).
Mysql: rlike
where a.serial rlike '\d*'
Informix: regexp_match()
where regexp_match(a.serial, '\d*')
Oracle: REGEXP_LIKE
where REGEXP_LIKE(a.serial, '\d*')
There have been several forum posts asking about this feature for hibernate3 btw:
http://forum.hibernate.org/viewtopic.php?p=2391395
http://forum.hibernate.org/viewtopic.php?p=2375634
etc
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
7:22 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-3404) Regular expressions (regex) boolean operator in HQL's where clause: rlike in mysql, regexp_match in informix, ... (regression from hibernate2)
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-3404?page=c...
]
Ancoron Luziferis commented on HHH-3404:
----------------------------------------
For PostgreSQL there are two ways:
# The {{[NOT] SIMILAR TO}} operator (including support for the escape character
sequence):
#* {{'abc' SIMILAR TO 'abc'}}
#* {{'abc' SIMILAR TO 'a'}}
#* {{'abc' SIMILAR TO '%(b|d)%'}}
#* {{'abc' SIMILAR TO '(b|c)%'}}
The POSIX regular expression operators:
||Operator||Description||Example||
|~|Matches regular expression, case sensitive|'thomas' ~ '.*thomas.*'|
|~*|Matches regular expression, case insensitive|'thomas' ~*
'.*Thomas.*'|
|!~|Does not match regular expression, case sensitive|'thomas' !~
'.*Thomas.*'|
|!~*|Does not match regular expression, case insensitive|'thomas' !~*
'.*vadim.*'|
Regular expressions (regex) boolean operator in HQL's where
clause: rlike in mysql, regexp_match in informix, ... (regression from hibernate2)
----------------------------------------------------------------------------------------------------------------------------------------------
Key: HHH-3404
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3404
Project: Hibernate Core
Issue Type: New Feature
Components: query-hql
Affects Versions: 3.2.6
Reporter: Geoffrey De Smet
Hibernate 2 supported the rlike boolean operator (at least for mysql): HB-1034.
Hibernate3 currently doesn't.
It turns out that most mainstream databases support regular expression patterns
(independently from normal like patterns).
Mysql: rlike
where a.serial rlike '\d*'
Informix: regexp_match()
where regexp_match(a.serial, '\d*')
Oracle: REGEXP_LIKE
where REGEXP_LIKE(a.serial, '\d*')
There have been several forum posts asking about this feature for hibernate3 btw:
http://forum.hibernate.org/viewtopic.php?p=2391395
http://forum.hibernate.org/viewtopic.php?p=2375634
etc
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
8:02 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-3404) Regular expressions (regex) boolean operator in HQL's where clause: rlike in mysql, regexp_match in informix, ... (regression from hibernate2)
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-3404?page=c...
]
Dmitry Katsubo commented on HHH-3404:
-------------------------------------
For HSQLDB:
{{regexp_substring(column, 'regexp') is not null}}
Regular expressions (regex) boolean operator in HQL's where
clause: rlike in mysql, regexp_match in informix, ... (regression from hibernate2)
----------------------------------------------------------------------------------------------------------------------------------------------
Key: HHH-3404
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3404
Project: Hibernate Core
Issue Type: New Feature
Components: query-hql
Affects Versions: 3.2.6
Reporter: Geoffrey De Smet
Hibernate 2 supported the rlike boolean operator (at least for mysql): HB-1034.
Hibernate3 currently doesn't.
It turns out that most mainstream databases support regular expression patterns
(independently from normal like patterns).
Mysql: rlike
where a.serial rlike '\d*'
Informix: regexp_match()
where regexp_match(a.serial, '\d*')
Oracle: REGEXP_LIKE
where REGEXP_LIKE(a.serial, '\d*')
There have been several forum posts asking about this feature for hibernate3 btw:
http://forum.hibernate.org/viewtopic.php?p=2391395
http://forum.hibernate.org/viewtopic.php?p=2375634
etc
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
4591
days inactive
5788
days old
hibernate-issues@lists.jboss.org
6 comments
6 participants
participants (6)
-
Ancoron Luziferis (JIRA) -
Andrew Houghton (JIRA)
-
Dmitry Katsubo (JIRA)
-
Geoffrey De Smet (JIRA)
-
Steve Ebersole (JIRA)
-
Torsten Krah (JIRA)