the issue here is the optimization we have in Jackalope Jackrabbit to use SQL1 where possible instead of slower SQL2 statements. as such this test will indeed fail with other storage backends. therefore it would indeed be better to check the QOM object directly.