[jira] Updated: (JCR-1673) Date comparitons are backwards in Queries
[ https://issues.apache.org/jira/browse/JCR-1673?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Michael Neale updated JCR-1673: --- Affects Version/s: core 1.4.4 Date comparitons are backwards in Queries - Key: JCR-1673 URL: https://issues.apache.org/jira/browse/JCR-1673 Project: Jackrabbit Issue Type: Bug Components: query Affects Versions: core 1.4.1, core 1.4.4 Reporter: Michael Neale Priority: Critical Imagine there is a node with jcr:created of: 2008-07-08T15:10:07.125+10:00 The following query: SELECT ... FROM WHERE jcr:created '2009-07-08T15:10:07.125+10:00' should return it, but it doesn't. However, if you put: SELECT ... FROM WHERE jcr:created '2009-07-08T15:10:07.125+10:00' then it does return it. Whoops. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.
[jira] Updated: (JCR-1673) Date comparitons are backwards in Queries
[ https://issues.apache.org/jira/browse/JCR-1673?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Michael Neale updated JCR-1673: --- Comment: was deleted Date comparitons are backwards in Queries - Key: JCR-1673 URL: https://issues.apache.org/jira/browse/JCR-1673 Project: Jackrabbit Issue Type: Bug Components: query Affects Versions: core 1.4.1, core 1.4.4 Reporter: Michael Neale Assignee: Jukka Zitting Priority: Critical Imagine there is a node with jcr:created of: 2008-07-08T15:10:07.125+10:00 The following query: SELECT ... FROM WHERE jcr:created '2009-07-08T15:10:07.125+10:00' should return it, but it doesn't. However, if you put: SELECT ... FROM WHERE jcr:created '2009-07-08T15:10:07.125+10:00' then it does return it. Whoops. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.
[jira] Updated: (JCR-1673) Date comparitons are backwards in Queries
[ https://issues.apache.org/jira/browse/JCR-1673?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Michael Neale updated JCR-1673: --- Description: Imagine there is a node with jcr:created of: 2008-07-08T15:10:07.125+10:00 The following query: SELECT ... FROM WHERE jcr:created '2009-07-08T15:10:07.125+10:00' should return it, but it doesn't. However, if you put: SELECT ... FROM WHERE jcr:created '2009-07-08T15:10:07.125+10:00' then it does return it. Whoops. was: Imagine there is a node with jcr:created of: 2008-07-08T15:10:07.125+10:00 The following query: SELECT ... FROM WHERE jcr:created '2008-07-09T14:55:29.774+10:00' should return it, but it doesn't. However, if you put: SELECT ... FROM WHERE jcr:created '2008-07-09T14:55:29.774+10:00' then it does return it. Whoops. Summary: Date comparitons are backwards in Queries (was: Date comparitons are backwards in SQL query) Date comparitons are backwards in Queries - Key: JCR-1673 URL: https://issues.apache.org/jira/browse/JCR-1673 Project: Jackrabbit Issue Type: Bug Components: query Affects Versions: core 1.4.1 Reporter: Michael Neale Priority: Critical Imagine there is a node with jcr:created of: 2008-07-08T15:10:07.125+10:00 The following query: SELECT ... FROM WHERE jcr:created '2009-07-08T15:10:07.125+10:00' should return it, but it doesn't. However, if you put: SELECT ... FROM WHERE jcr:created '2009-07-08T15:10:07.125+10:00' then it does return it. Whoops. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.