1 | if ( ! (getDialect() instanceof MySQLDialect) && ! (getDialect() instanceof HSQLDialect) ) { //My SQL has no subqueries
↵ | | 1 | if ( ! (getDialect() instanceof MySQLDialect) && ! (getDialect() instanceof HSQLDialect) ) { //My SQL has no subqueries↵
|
2 | assertTrue(
↵ | | 2 | assertTrue(↵
|
3 | s.find("from Simple s where s.count > ( select min(sim.count) from Simple sim )").size()==2
↵ | | 3 | s.find("from Simple s where s.count > ( select min(sim.count) from Simple sim )").size()==2↵
|
4 | );
↵ | | 4 | );↵
|
5 | t.commit();
↵ | | 5 | t.commit();↵
|
6 | t = s.beginTransaction();
↵ | | 6 | t = s.beginTransaction();↵
|
7 | assertTrue(
↵ | | 7 | assertTrue(↵
|
8 | s.find("from Simple s where s = some( select sim from Simple sim where sim.count>=0 ) and s.count >= 0").size()==2
↵ | | 8 | s.find("from Simple s where s = some( select sim from Simple sim where sim.count>=0 ) and s.count >= 0").size()==2↵
|
9 | );
↵ | | 9 | );↵
|
10 | assertTrue(
↵ | | 10 | assertTrue(↵
|
11 | s.find("from Simple s where s = some( select sim from Simple sim where sim.other.count=s.other.count ) and s.other.count > 0").size()==1
↵ | | 11 | s.find("from Simple s where s = some( select sim from Simple sim where sim.other.count=s.other.count ) and s.other.count > 0").size()==1↵
|
12 | | | 12 |
|