Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- @Formula("(SELECT SUM(dividend) || '/' || SUM(divisor) " +
- "FROM (SELECT CAST(substr(sr.result, 1, position('/' in sr.result)-1 ) AS int) AS dividend ," +
- "CAST(substr(sr.result, position('/' in sr.result)+1 ) AS int) AS divisor " +
- "FROM suite_results as sr WHERE sr.execution_history=id) AS division)")
- private String result;
- select executionh0_.id as id7_1_, executionh0_.execution_plan as execution3_7_1_, executionh0_.start_time as start2_7_1_,
- (SELECT SUM(sr.duration) FROM suite_results as sr WHERE sr.execution_history=executionh0_.id) as formula0_1_,
- (SELECT SUM(executionh0_.dividend) || '/' || SUM(executionh0_.divisor) FROM
- (SELECT CAST(substr(sr.result, 1, position('/' in sr.result)-1 ) AS executionh0_.int) AS executionh0_.dividend ,
- CAST(substr(sr.result, position('/' in sr.result)+1 ) AS executionh0_.int) AS executionh0_.divisor
- FROM suite_results as sr WHERE sr.execution_history=executionh0_.id) AS executionh0_.division) as
- formula1_1_, executionp1_.id as id6_0_, executionp1_.build_number as
- build2_6_0_, executionp1_.name as name6_0_, executionp1_.owner as owner6_0_, executionp1_.sut as sut6_0_,
- executionp1_.wait_for_page_to_load as wait6_6_0_ from execution_history executionh0_
- left outer join execution_plans executionp1_ on executionh0_.execution_plan=executionp1_.id where executionh0_.id=?
Add Comment
Please, Sign In to add comment