In other words, I don't think these tests will *ever* work on derby 2009/12/11 Andrey Razumovsky <[email protected]>
> We're testing Cayenne, not Derby.. Derby limitations is not our fault.. > ideally we should exclude that per DB, but I'd prefer that until we have > such mechanism in our test framework, tests stiil run fine > > 2009/12/11 Andrus Adamchik <[email protected]> > > >> On Dec 11, 2009, at 3:32 AM, Andrey Razumovsky wrote: >> >> OK, may I suggest we just slightly change the test, so that it works on >>> Derby as well. Current problem is that Derby does not allow more than one >>> column in subquery result. >>> So if wwe replace >>> "SELECT a FROM Artist a WHERE EXISTS (SELECT DISTINCT p1 ...) " >>> with >>> "SELECT a FROM Artist a WHERE EXISTS (SELECT DISTINCT p1.paintingTitle >>> ...) >>> " >>> >>> it will work with same sense >>> >> >> Then how do we know that the other syntax variant is broken? >> >> We clearly need an exclude list per DB... >> >> Andrus >> >> > > > -- > Andrey > -- Andrey
