3 Replies Latest reply on May 2, 2011 8:16 AM by rhauch

Why does SQL2 cast() not work after restart of engine?

piascikj Apr 29, 2011 5:04 PM

I'm trying to execute the sql2 query:

SELECT * FROM [fincayra:User] as user WHERE user.active=cast('true' as boolean)

It returns the desired result set unless I restart the engine.

I've created a test app that can be found on github at https://github.com/piascikj/modeshape_sql2_test

I've also noticed this happening with joins, but do not have the test included in my code.

Anyone have an idea of what's going on?

1. Why does SQL2 cast() not work after restart of engine?

rhauch May 1, 2011 11:54 PM (in response to piascikj)

Would you mind checking one thing .. could you run the query after restarting and waiting for the indexes to warm up? I'm wondering if ModeShape is rebuilding its indexes and hasn't yet completed when you're running your query. That's a known issue (MODE-1097) that we're planning to fix soon. Hopefully this is what you're seeing.
Actions
2. Re: Why does SQL2 cast() not work after restart of engine?

piascikj May 2, 2011 1:39 AM (in response to rhauch)
I wish this were the case. My test is only adding a single node, and I also run a query by name which does return a result. So I don't think the index to be the cause here.

SELECT * FROM [fincayra:User] as user WHERE user.name='test1'

https://github.com/piascikj/modeshape_sql2_test/blob/master/src/test/java/org/fincayra/modeshape/SQL2AppTest.java

https://github.com/piascikj/modeshape_sql2_test/blob/master/src/main/java/org/fincayra/modeshape/SQL2App.java
Actions
3. Re: Why does SQL2 cast() not work after restart of engine?

rhauch May 2, 2011 8:16 AM (in response to piascikj)

Okay, thanks. I'm traveling for most of this week, but will look into this when I return. If you haven't already, can you please log a bug report in JIRA?
Actions