Mailing-List: contact dev-help@openjpa.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@openjpa.apache.org
Received-SPF: pass (athena.apache.org: local policy)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
  s=s1024; d=yahoo.com;
  h=X-YMail-OSG:Received:X-Mailer:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type:Message-ID;
  b=4U/6huzCT6BcI6KxO6x/rXPUMEgZMJvqTGnxfPgDu+jTwa4ohb3kn4Cup3laieUhfak3ewgIf9H0lQ/gyhow3bIBCzmebTTAzjf6VulfvsGWYkScDuKSXNK1MLH39OjvdxWBsnBVPj/yrWUHqhH8GISpL0z3tcbOrwQB1LnfaOI=;
Date: Wed, 3 Sep 2008 09:47:50 -0700 (PDT)
From: Fay Wang <fyw300@yahoo.com>
Reply-To: fyw300@yahoo.com
Subject: Re: Bug in HAVING clause (JPQL)
To: dev@openjpa.apache.org
In-Reply-To: <48BE4EE3.6040006@etf.bg.ac.yu>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Message-ID: <289328.6647.qm@web55808.mail.re3.yahoo.com>

The manual says "The HAVING clause must specify search conditions over the grouping items or aggregate functions that apply to grouping items." Therefore, the two JPQL should be valid:

    select m.idPublisher, max(m.datePublished)
       from Magazine m
       group by m.idPublisher
       having max(m.datePublished) is null
 
     select m.idPublisher, max(m.datePublished)
       from Magazine m
       group by m.idPublisher
        having max(m.datePublished) = current_date

You might want to open a JIRA to address this problem.


--- On Wed, 9/3/08, Ognjen Blagojevic <ognjen@etf.bg.ac.yu> wrote:

> From: Ognjen Blagojevic <ognjen@etf.bg.ac.yu>
> Subject: Bug in HAVING clause (JPQL)
> To: "OpenJPA developer list" <dev@openjpa.apache.org>
> Date: Wednesday, September 3, 2008, 1:46 AM
> Hi devs,
> 
> It seems that these two (valid?) queries are throwing an
> exception:
> 
>     select m.idPublisher, max(m.datePublished)
>       from Magazine m
>   group by m.idPublisher
>     having max(m.datePublished) is null
> 
>     select m.idPublisher, max(m.datePublished)
>       from Magazine m
>   group by m.idPublisher
>     having max(m.datePublished) = current_date
> 
> The exception thrown is:
> 
> <openjpa-1.3.0-SNAPSHOT-runknown nonfatal user error>
> 
> org.apache.openjpa.persistence.ArgumentException:
> Encountered "max ( m . 
> datePublished ) is" at character 90, but expected:
> ["(", ")", "*", "+",
> 
> "-", ".", "/", ":",
> "<", "<=", "<>",
> "=", ">", ">=",
> "?", "ABS", "ALL", 
> "AND", "ANY", "AS",
> "ASC", "AVG", "BETWEEN",
> "BOTH", "BY", "CONCAT", 
> "COUNT", "CURRENT_DATE",
> "CURRENT_TIME", "CURRENT_TIMESTAMP",
> "DELETE", 
> "DESC", "DISTINCT", "EMPTY",
> "ESCAPE", "EXISTS", "FETCH",
> "FROM", 
> "GROUP", "HAVING", "IN",
> "INNER", "IS", "JOIN",
> "LEADING", "LEFT", 
> "LENGTH", "LIKE", "LOCATE",
> "LOWER", "MAX", "MEMBER",
> "MIN", "MOD", 
> "NEW", "NOT", "NULL",
> "OBJECT", "OF", "OR",
> "ORDER", "OUTER", "SELECT", 
> "SET", "SIZE", "SOME",
> "SQRT", "SUBSTRING", "SUM",
> "TRAILING", "TRIM", 
> "UPDATE", "UPPER", "WHERE",
> <BOOLEAN_LITERAL>, <DECIMAL_LITERAL>, 
> <IDENTIFIER>, <INTEGER_LITERAL>,
> <STRING_LITERAL>].
> 	at 
> org.apache.openjpa.kernel.jpql.JPQL.generateParseException(JPQL.java:9501)
> 	at
> org.apache.openjpa.kernel.jpql.JPQL.jj_consume_token(JPQL.java:9378)
> ...
> 
> For test case, one could use these classes:
> 
> /openjpa/trunk/openjpa-persistence-jdbc/src/test/java/org/apache/openjpa/persistence/query/Magazine.java
> /openjpa/trunk/openjpa-persistence-jdbc/src/test/java/org/apache/openjpa/persistence/query/Publisher.java
> 
> 
> Configuration:
> - OpenJPA 1.2.0 / OpenJPA 1.3.0 SNAPSHOT
> - Enhancing at Build Time
> - MySQL 5.0.22
> 
> Regards,
> Ognjen