File path: /hibernate-distribution-3.3.2.GA/project/testsuite/src/test/java/org/hibernate/test/hql/ASTParserLoadingTest.java | File path: /hibernate-distribution-3.3.2.GA/project/testsuite/src/test/java/org/hibernate/test/hql/BulkManipulationTest.java | |||
Method name: void testCoalesce()
|
Method name: void testDeleteWithMetadataWhereFragments()
|
|||
Number of AST nodes: 6 | Number of AST nodes: 6 | |||
1 | Session session = openSession();↵ | 1 | Session s = openSession();↵ | |
2 | Transaction txn = session.beginTransaction();↵ | 2 | Transaction t = s.beginTransaction();↵ | |
3 | session.createQuery("from Human h where coalesce(h.nickName, h.name.first, h.name.last) = 'max'").list↵ | 3 | // Note: we are just checking the syntax here...↵ | |
4 | ();↵ | 4 | s.createQuery("delete from Bar").executeUpdate();↵ | |
5 | session.createQuery("select nullif(nickName, '1e1') from Human").list();↵ | 5 | s.createQuery("delete from Bar where barString = 's'").executeUpdate();↵ | |
6 | txn.commit();↵ | 6 | t.commit();↵ | |
7 | session.close(); | 7 | s.close(); | |
See real code fragment | See real code fragment |
Number of common nesting structure subtrees | 1 |
Number of refactorable cases | 0 |
Number of non-refactorable cases | 1 |
Time elapsed for finding largest common nesting structure subtrees (ms) | 0.0 |
Clones location | Clones are in different classes having the same super class |
Number of node comparisons | 20 |
Number of mapped statements | 4 |
Number of unmapped statements in the first code fragment | 2 |
Number of unmapped statements in the second code fragment | 2 |
Time elapsed for statement mapping (ms) | 0.0 |
Clone type | Type 2 |
ID | Statement | ID | Statement | |||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Session session = openSession(); |
| 1 | Session s = openSession(); | ||||||||||||||||
2 | Transaction txn = session.beginTransaction(); |
| 2 | Transaction t = s.beginTransaction(); | ||||||||||||||||
|
| 3 | s.createQuery("delete from Bar").executeUpdate(); | |||||||||||||||||
3 | session.createQuery("from Human h where coalesce(h.nickName, h.name.first, h.name.last) = 'max'").list(); |
| | |||||||||||||||||
|
| 4 | s.createQuery("delete from Bar where barString = 's'").executeUpdate(); | |||||||||||||||||
4 | session.createQuery("select nullif(nickName, '1e1') from Human").list(); |
| | |||||||||||||||||
5 | txn.commit(); |
| 5 | t.commit(); | ||||||||||||||||
6 | session.close(); |
| 6 | s.close(); |
Row | Violation |
---|---|
1 | Unmatched statement s.createQuery("delete from Bar").executeUpdate(); cannot be moved before or after the extracted code, because it has dependencies to/from statements that will be extracted |
2 | Unmatched statement session.createQuery("from Human h where coalesce(h.nickName, h.name.first, h.name.last) = 'max'").list(); cannot be moved before or after the extracted code, because it has dependencies to/from statements that will be extracted |
3 | Unmatched statement s.createQuery("delete from Bar where barString = 's'").executeUpdate(); cannot be moved before or after the extracted code, because it has dependencies to/from statements that will be extracted |
4 | Unmatched statement session.createQuery("select nullif(nickName, '1e1') from Human").list(); cannot be moved before or after the extracted code, because it has dependencies to/from statements that will be extracted |
5 | Clone fragment #1 returns variable session with type org.hibernate.Session , while Clone fragment #2 returns variable s with type org.hibernate.classic.Session |