You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@openjpa.apache.org by "Marc Logemann (JIRA)" <ji...@apache.org> on 2010/09/23 20:59:32 UTC

[jira] Created: (OPENJPA-1813) CURRENT_DATE seems broken

CURRENT_DATE seems broken
-------------------------

                 Key: OPENJPA-1813
                 URL: https://issues.apache.org/jira/browse/OPENJPA-1813
             Project: OpenJPA
          Issue Type: Bug
          Components: query
    Affects Versions: 2.0.1
            Reporter: Marc Logemann


the following query:

Query query = em.createQuery("select count(d) from Order o, IN(o.deliveryAddress) d where o.createdYmd = CURRENT_DATE and d.deliveryMode = ?1");

generates the following SQL:

SELECT COUNT(t1.oid) FROM orders t0 INNER JOIN address t1 ON t0.oid = t1.order_oid WHERE (t0.createdymd IS NULL AND t1.deliverymode = ?) [params=?]

Why the where part with "IS NULL" ? Current_date should be applied there shouldnt it?



-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.