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

[piascikj]

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?

[rhauch]

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.

[piascikj]

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

[rhauch]

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?