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

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... 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"