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

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


      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?