[jbossseam-issues] [JBoss JIRA] Created: (JBSEAM-2393) Query order by regexp fails when using lower/upper on a column
12:29 p.m.
Query order by regexp fails when using lower/upper on a column
--------------------------------------------------------------
Key: JBSEAM-2393
URL: http://jira.jboss.com/jira/browse/JBSEAM-2393
Project: JBoss Seam
Issue Type: Bug
Components: Framework
Affects Versions: 2.0.0.GA
Reporter: Darryl Smith
In o.j.s.framework.Query
private static final Pattern ORDER_CLAUSE_PATTERN =
Pattern.compile("^[\\w\\.,\\s]*$");
while this works with simple cases e.g. v.jobTitle asc
it fails on lower(v.jobTitle) asc, is the proper way to order by a character field on many
databases
--
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
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
9:38 p.m.
New subject: [jbossseam-issues] [JBoss JIRA] Commented: (JBSEAM-2393) Query order by regexp fails when using lower/upper on a column
[ http://jira.jboss.com/jira/browse/JBSEAM-2393?page=comments#action_12394252 ]
Darryl Smith commented on JBSEAM-2393:
--------------------------------------
The fix for this is:
Pattern.compile(
"^\\s*(?:(?:((?:lower|upper){1}+\\s*\\(\\s*(?:\\w)+(?:\\.\\w+)*\\s*\\))|(?:\\w)+(?:\\.\\w+)*)(?:\\s*(?:asc|desc)+)?(?:\\s*,\\s*)?)+\\s*$"
);
Query order by regexp fails when using lower/upper on a column
--------------------------------------------------------------
Key: JBSEAM-2393
URL: http://jira.jboss.com/jira/browse/JBSEAM-2393
Project: JBoss Seam
Issue Type: Bug
Components: Framework
Affects Versions: 2.0.0.GA
Reporter: Darryl Smith
In o.j.s.framework.Query
private static final Pattern ORDER_CLAUSE_PATTERN =
Pattern.compile("^[\\w\\.,\\s]*$");
while this works with simple cases e.g. v.jobTitle asc
it fails on lower(v.jobTitle) asc, is the proper way to order by a character field on
many databases
--
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
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
10:08 p.m.
New subject: [jbossseam-issues] [JBoss JIRA] Commented: (JBSEAM-2393) Query order by regexp fails when using lower/upper on a column
[ http://jira.jboss.com/jira/browse/JBSEAM-2393?page=comments#action_12394254 ]
Darryl Smith commented on JBSEAM-2393:
--------------------------------------
A cleaner version of the pattern:
Pattern.compile(
"^\\s*(?:(?:((?:lower|upper){1}+\\s*\\(\\s*(?:\\w)+(?:\\.\\w+)*\\s*\\))|(?:\\w)+(?:\\.\\w+)*)(?:\\s*(?:asc|desc)+)?(?:\\s*,\\s*)?)+\\s*$"
);
vs
Pattern.compile(
"^\\s*(?:(?:((?:lower|upper){1}+\\s*\\(\\s*(?:\\w)+(?:\\.\\w+)*\\s*\\))|(?:\\w)+(?:\\.\\w+)*)\\s*(?:asc|desc)?\\s*,?\\s*)+$"
);
NOTE: this would also require modifications setOrder as this regex will not work with
empty strings e.g "" or " "
Query order by regexp fails when using lower/upper on a column
--------------------------------------------------------------
Key: JBSEAM-2393
URL: http://jira.jboss.com/jira/browse/JBSEAM-2393
Project: JBoss Seam
Issue Type: Bug
Components: Framework
Affects Versions: 2.0.0.GA
Reporter: Darryl Smith
In o.j.s.framework.Query
private static final Pattern ORDER_CLAUSE_PATTERN =
Pattern.compile("^[\\w\\.,\\s]*$");
while this works with simple cases e.g. v.jobTitle asc
it fails on lower(v.jobTitle) asc, is the proper way to order by a character field on
many databases
--
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
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
4:41 a.m.
New subject: [jbossseam-issues] [JBoss JIRA] Updated: (JBSEAM-2393) Query order by regexp fails when using lower/upper on a column
[ http://jira.jboss.com/jira/browse/JBSEAM-2393?page=all ]
Pete Muir updated JBSEAM-2393:
------------------------------
Assignee: Norman Richards
Query order by regexp fails when using lower/upper on a column
--------------------------------------------------------------
Key: JBSEAM-2393
URL: http://jira.jboss.com/jira/browse/JBSEAM-2393
Project: JBoss Seam
Issue Type: Bug
Components: Framework
Affects Versions: 2.0.0.GA
Reporter: Darryl Smith
Assigned To: Norman Richards
In o.j.s.framework.Query
private static final Pattern ORDER_CLAUSE_PATTERN =
Pattern.compile("^[\\w\\.,\\s]*$");
while this works with simple cases e.g. v.jobTitle asc
it fails on lower(v.jobTitle) asc, is the proper way to order by a character field on
many databases
--
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
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
1:09 p.m.
New subject: [jbossseam-issues] [JBoss JIRA] Commented: (JBSEAM-2393) Query order by regexp fails when using lower/upper on a column
[ http://jira.jboss.com/jira/browse/JBSEAM-2393?page=comments#action_12394848 ]
Norman Richards commented on JBSEAM-2393:
-----------------------------------------
Just a note - we should not be doing any validating at all here. Once seam-gen is fixed,
this code will be removed.
Query order by regexp fails when using lower/upper on a column
--------------------------------------------------------------
Key: JBSEAM-2393
URL: http://jira.jboss.com/jira/browse/JBSEAM-2393
Project: JBoss Seam
Issue Type: Bug
Components: Framework
Affects Versions: 2.0.0.GA
Reporter: Darryl Smith
Assigned To: Norman Richards
In o.j.s.framework.Query
private static final Pattern ORDER_CLAUSE_PATTERN =
Pattern.compile("^[\\w\\.,\\s]*$");
while this works with simple cases e.g. v.jobTitle asc
it fails on lower(v.jobTitle) asc, is the proper way to order by a character field on
many databases
--
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
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
1:14 p.m.
New subject: [jbossseam-issues] [JBoss JIRA] Resolved: (JBSEAM-2393) Query order by regexp fails when using lower/upper on a column
[ http://jira.jboss.com/jira/browse/JBSEAM-2393?page=all ]
Norman Richards resolved JBSEAM-2393.
-------------------------------------
Fix Version/s: 2.1.0.GA
Resolution: Done
Query order by regexp fails when using lower/upper on a column
--------------------------------------------------------------
Key: JBSEAM-2393
URL: http://jira.jboss.com/jira/browse/JBSEAM-2393
Project: JBoss Seam
Issue Type: Bug
Components: Framework
Affects Versions: 2.0.0.GA
Reporter: Darryl Smith
Assigned To: Norman Richards
Fix For: 2.1.0.GA
In o.j.s.framework.Query
private static final Pattern ORDER_CLAUSE_PATTERN =
Pattern.compile("^[\\w\\.,\\s]*$");
while this works with simple cases e.g. v.jobTitle asc
it fails on lower(v.jobTitle) asc, is the proper way to order by a character field on
many databases
--
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
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
7:12 a.m.
New subject: [jbossseam-issues] [JBoss JIRA] Closed: (JBSEAM-2393) Query order by regexp fails when using lower/upper on a column
[ http://jira.jboss.com/jira/browse/JBSEAM-2393?page=all ]
Pete Muir closed JBSEAM-2393.
-----------------------------
Query order by regexp fails when using lower/upper on a column
--------------------------------------------------------------
Key: JBSEAM-2393
URL: http://jira.jboss.com/jira/browse/JBSEAM-2393
Project: JBoss Seam
Issue Type: Bug
Components: Framework
Affects Versions: 2.0.0.GA
Reporter: Darryl Smith
Assigned To: Norman Richards
Fix For: 2.1.0.A1
In o.j.s.framework.Query
private static final Pattern ORDER_CLAUSE_PATTERN =
Pattern.compile("^[\\w\\.,\\s]*$");
while this works with simple cases e.g. v.jobTitle asc
it fails on lower(v.jobTitle) asc, is the proper way to order by a character field on
many databases
--
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
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
6128
days inactive
6216
days old
6 comments
3 participants
participants (3)
-
Darryl Smith (JIRA) -
Norman Richards (JIRA)
-
Pete Muir (JIRA)