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

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

    Jesse Piascik Newbie

      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?