1 | public void testNoLoss() {↵ | | 1 | public void test↵
|
2 | assertNoLoss( "insert into Address (city, state, zip, \"from\") values (?, ?, ?, 'insert value')" );↵ | | |
|
3 | assertNoLoss↵ | | 2 | OtherSyntax() throws Exception {↵
|
4 | ( "delete from Address where id = ? and version = ?" );↵ | | 3 | parse( "sele↵
|
5 | assertNoLoss( "update Address set city = ?, state=?, zip=?, version = ? where id = ? and version = ?" );↵ | | |
|
6 | assertNoLoss( "update Address set city = ?, state=?, zip=?, version = ? where id↵ | | 4 | ct bar from org.hibernate.test.Bar bar order by ((bar.x - :valueX)*(bar.x - :valueX))" );↵
|
7 | in (select aid from Person)" );↵ | | 5 | parse( "from bar in class org.hibernate.test.Bar, foo in ele↵
|
8 | assertNoLoss(↵ | | |
|
9 | "select p.name, a.zipCode, count(*) from Person p left outer join Employee e on e.id = p.id and p.type = 'E' and (e.effective>? or e.effective<?) join Address a on a.pid = p.id where upper(p.name) like 'G%' and p.age > 100 and (p.sex = 'M' or p.sex = 'F') and coalesce( trim(a.street), a.city, (a.zip) ) is not null order by p.name asc, a.zipCode asc"↵ | | |
|
10 | );↵ | | |
|
11 | assertNoLoss(↵ | | |
|
12 | "select ( (m.age - p.age) * 12 ), trim(upper(p.name)) from Person p, Person m where p.mother = m.id and ( p.age = (select max(p0.age) from Person p0 where (p0.mother=m.id)) and p.name like ? )"↵ | | |
|
13 | );↵ | | |
|
14 | assertNoLoss(↵ | | |
|
15 | "select * from Address a join Person p on a.pid = p.id, Person m join Address b on b.pid = m.id where p.mother = m.id and p.name like ?"↵ | | |
|
16 | );↵ | | |
|
17 | assertNoLoss(↵ | | |
|
18 | "select case when p.age > 50 then 'old' when p.age > 18 then 'adult' else 'child' end from Person p where ( case when p.age > 50 then 'old' when p.age > 18 then 'adult' else 'child' end ) like ?"↵ | | |
|
19 | );↵ | | |
|
20 | assertNoLoss(↵ | | |
|
21 | "/* Here we' go! */ select case when p.age > 50 then 'old' when p.age > 18 then 'adult' else 'child' end from Person p where ( case when p.age > 50 then 'old' when p.age > 18 then 'adult' else 'child' end ) like ? | | 6 | ments(bar.baz.fooSet)" );↵
|
| | | 7 | parse( "from one in class org.hibernate.test.One, many in elements(one.manies) where one.id = 1 and many.id = 1" );↵
|
| | | 8 | parse( "from org.hibernate.test.Inner _inner join _inner.middles middle" );↵
|
| | | 9 | parse( "FROM m IN CLASS org.hibernate.test.Master WHERE NOT EXISTS ( FROM d IN elements(m.details) WHERE NOT d.i=5 )" );↵
|
| | | 10 | parse( "FROM m IN CLASS org.hibernate.test.Master WHERE NOT 5 IN ( SELECT d.i FROM d IN elements(m.details) )" );↵
|
| | | 11 | parse( "SELECT m FROM m IN CLASS org.hibernate.test.Master, d IN elements(m.details) WHERE d.i=5" );↵
|
| | | 12 | parse( "SELECT m FROM m IN CLASS org.hibernate.test.Master, d IN elements(m.details) WHERE d.i=5" );↵
|
| | | 13 | parse( "SELECT m.id FROM m IN CLASS org.hibernate.test.Master, d IN elements(m.details) WHERE d.i=5" )
|