[seam-issues] [JBoss JIRA] Closed: (JBSEAM-4761) Regexp Query.SUBJECT_PATTERN does not accept DISTINCT

[Marek Novotny (JIRA)]

     [ https://issues.jboss.org/browse/JBSEAM-4761?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Marek Novotny closed JBSEAM-4761.
---------------------------------

    Fix Version/s: 2.3.0.ALPHA
       Resolution: Duplicate Issue


closing as duplicate issue

> Regexp Query.SUBJECT_PATTERN does not accept DISTINCT
> -----------------------------------------------------
>
>                 Key: JBSEAM-4761
>                 URL: https://issues.jboss.org/browse/JBSEAM-4761
>             Project: Seam 2
>          Issue Type: Bug
>          Components: Framework
>    Affects Versions: 2.2.1.CR3
>         Environment: http://fisheye.jboss.org/browse/Seam/branches/community/Seam_2_2/src/main/org/jboss/seam/framework/Query.java?r=11979
>            Reporter: Michael K
>             Fix For: 2.3.0.ALPHA
>
>
> The current pattern in org.jboss.seam.framwork.Query
>    private static final Pattern SUBJECT_PATTERN = Pattern.compile("^select\\s+(\\w+(?:\\s*\\.\\s*\\w+)*?)(?:\\s*,\\s*(\\w+(?:\\s*\\.\\s*\\w+)*?))*?\\s+from", Pattern.CASE_INSENSITIVE); 
> does not accept queries using the keyword DISTINCT, for example:
>  SELECT DISTINCT vehicle FROM VEHICLE vehicle ...
> Proposal:
> Change the pattern to
> "^select\\s+((distinct)?\\s+\\w+(?:\\s*\\.\\s*\\w+)*?)(?:\\s*,\\s*(\\w+(?:\\s*\\.\\s*\\w+)*?))*?\\s+from"

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira