More interesting details - I printed out the publishDate for each Story. It
seem that the upper bound is being properly matched, and it is the lower
bound that is being ignored.
Also, I ran a nonsensical query:
select * from eol:Story where jcr:path like '/EOL/News/Stories/%' and
publishDate >= DATE '2006-11-15' and publishDate <= DATE '2006-11-01'
Again, the publishdate >= DATE '2006-11-15' was ignored, and all results
with a publishDate <= DATE '2006-11-01' were returned.
While I can reimport the data again, I would like to help track down any
issues that my upgrade may be exposing.
Thanks,
-Dave
On 1/12/07, Marcel Reutegger <[EMAIL PROTECTED]> wrote:
Hi David,
David B. Johnson wrote:
> I am running a repository on the 1.2 Release Candidate that I upgraded
>>from 1.1.1, i.e., I did not reload the data, I am using the same
> repository. It is a JNDI DataSource Repository with a MySQL backend,
> running as a JCA rar in JBoss. I am using an SQL query that was working
> fine in 1.1.1 and now appears to not work in 1.2, specifically the query
> is of the form:
>
> select * from Story where jcr:path like '/News/Stories/%' and
> publishDate >= DATE '2006-11-01' and publishDate <= DATE '2006-11-15'
>
> Instead of only returning stories with a publishDate within the date
> range, the system appears to return all stories.
>
> Do I need to create a fresh repository, and re-import the data?
no, that shouldn't be necessary. all changes in 1.2 are backward
compatible. at
least that's the goal.
I quickly tried to reproduce the issue with a simple test case [1]. First
I ran
the test on a jackrabbit 1.1 and then again on a jackrabbit 1.2 pointing
to the
existing 1.1 repository data. Both returned the same 30 results.
> If I can help with any additional information, please feel free to
> contact me.
Is there anything else you changed when you upgraded jackrabbit?
Can you please check if you can reproduce the issue with the below test
case in
your environment?
regards
marcel
[1] test class:
package org.apache.jackrabbit.core.query;
import javax.jcr.RepositoryException;
import javax.jcr.Node;
import javax.jcr.query.QueryManager;
import javax.jcr.query.Query;
import java.util.Calendar;
import java.text.SimpleDateFormat;
/**
* <code>DateRangeTest</code>...
*/
public class DateRangeTest extends AbstractQueryTest {
private static final SimpleDateFormat FORMAT = new
SimpleDateFormat("yyyy-MM-dd");
public void testRange() throws RepositoryException {
if (!superuser.itemExists("/data")) {
System.out.println("creating test data...");
Node data = superuser.getRootNode().addNode("data");
for (int i = 0; i < 100; i++) {
Calendar c = Calendar.getInstance();
c.add(Calendar.DATE, i);
data.addNode("node" + i).setProperty("date", c);
}
superuser.save();
}
QueryManager qm = superuser.getWorkspace().getQueryManager();
Calendar lower = Calendar.getInstance();
lower.add(Calendar.DATE, 20);
Calendar upper = Calendar.getInstance();
upper.add(Calendar.DATE, 50);
String sql = "select * from nt:unstructured " +
"where " +
"jcr:path like '/data/%' and " +
"date >= DATE '" + FORMAT.format(lower.getTime()) + "' "
+
"and " +
"date <= DATE '" + FORMAT.format(upper.getTime()) + "'";
Query q = qm.createQuery(sql, Query.SQL);
System.out.println("result size: " + q.execute
().getNodes().getSize());
}
}
