
Key: |
QB-1658
|
Type: |
Bug
|
Status: |
Resolved
|
Resolution: |
Fixed
|
Priority: |
Major
|
Assignee: |
Unassigned
|
Reporter: |
Steve Luo
|
Votes: |
0
|
Watchers: |
0
|
If you were logged in you would be able to see more operations.
|
|
|
QuickBuild
Created: 07/Jun/13 04:18 AM
Updated: 13/Jun/13 01:34 PM
|
|
Component/s: |
None
|
Affects Version/s: |
None
|
Fix Version/s: |
5.0.24
|
|
Original Estimate:
|
Unknown
|
Remaining Estimate:
|
Unknown
|
Time Spent:
|
Unknown
|
|
When JUnit report is filtered, showing JUnit aggregated Overview gadget will raise below exception:
java.sql.SQLException: Syntax error in SQL statement "SELECT COUNT(*) AS TOTALS,SUM(DURATION) AS DURATION,SUM(TESTS) AS TESTS,SUM(ERRORS) AS ERRORS,SUM(FAILURES) AS FAILURES,SUM(SKIPS) AS SKIPS,SUM(SUCCESSES) AS SUCCESSES,AVG(SUCCESS_RATE) AS SUCCESS_RATE,SUM(ADDED) AS ADDED,SUM(NEWFAILED) AS NEWFAILED,SUM(NOTFIXED) AS NOTFIXED,SUM(FIXED) AS FIXED FROM AGG_OVERVIEW WHERE "; expected "NOT, EXISTS"; SQL statement:
SELECT COUNT(*) AS TOTALS,SUM(duration) AS duration,SUM(tests) AS tests,SUM(errors) AS errors,SUM(failures) AS failures,SUM(skips) AS skips,SUM(successes) AS successes,AVG(success_rate) AS success_rate,SUM(added) AS added,SUM(newFailed) AS newFailed,SUM(notFixed) AS notFixed,SUM(fixed) AS fixed FROM agg_overview WHERE [42001-159] Query: SELECT COUNT(*) AS TOTALS,SUM(duration) AS duration,SUM(tests) AS tests,SUM(errors) AS errors,SUM(failures) AS failures,SUM(skips) AS skips,SUM(successes) AS successes,AVG(success_rate) AS success_rate,SUM(added) AS added,SUM(newFailed) AS newFailed,SUM(notFixed) AS notFixed,SUM(fixed) AS fixed FROM agg_overview WHERE Parameters: []
at org.apache.commons.dbutils.QueryRunner.rethrow(QueryRunner.java:542)
at org.apache.commons.dbutils.QueryRunner.query(QueryRunner.java:399)
at com.pmease.quickbuild.plugin.report.engine.datastore.DbStore.query(DbStore.java:87)
at com.pmease.quickbuild.plugin.report.engine.datastore.DbStore.query(DbStore.java:59)
at com.pmease.quickbuild.plugin.report.engine.datastore.DbStore.queryForMap(DbStore.java:148)
at com.pmease.quickbuild.plugin.report.engine.renderer.AbstractReportPanel.loadReportStats(AbstractReportPanel.java:239)
at com.pmease.quickbuild.plugin.report.engine.renderer.AbstractReportPanel$1.load(AbstractReportPanel.java:70)
at com.pmease.quickbuild.plugin.report.engine.renderer.AbstractReportPanel$1.load(AbstractReportPanel.java:65)
at org.apache.wicket.model.LoadableDetachableModel.getObject(LoadableDetachableModel.java:119)
at com.pmease.quickbuild.plugin.report.engine.renderer.AbstractReportPanel.getReportStats(AbstractReportPanel.java:257)
at com.pmease.quickbuild.plugin.report.engine.renderer.dashboard.AbstractDashboardStatsPanel.createItemContext(AbstractDashboardStatsPanel.java:66)
at com.pmease.quickbuild.plugin.report.engine.renderer.dashboard.AbstractDashboardStatsPanel$1.load(AbstractDashboardStatsPanel.java:40)
at com.pmease.quickbuild.plugin.report.engine.renderer.dashboard.AbstractDashboardStatsPanel$1.load(AbstractDashboardStatsPanel.java:34)
at org.apache.wicket.model.LoadableDetachableModel.getObject(LoadableDetachableModel.java:119)
at org.apache.wicket.Component.getDefaultModelObject(Component.java:1650)
at com.pmease.quickbuild.plugin.report.engine.renderer.piechart.PieChartLegendPanel.getItemContext(PieChartLegendPanel.java:82)
at com.pmease.quickbuild.plugin.report.engine.renderer.piechart.PieChartLegendPanel.getTotals(PieChartLegendPanel.java:69)
at com.pmease.quickbuild.plugin.report.engine.renderer.piechart.PieChartLegendPanel.onInitialize(PieChartLegendPanel.java:32)
at org.apache.wicket.Component.fireInitialize(Component.java:924)
at org.apache.wicket.MarkupContainer$4.component(MarkupContainer.java:1007)
at org.apache.wicket.MarkupContainer$4.component(MarkupContainer.java:1005)
at org.apache.wicket.util.visit.Visits.visitChildren(Visits.java:143)
at org.apache.wicket.util.visit.Visits.visitChildren(Visits.java:122)
at org.apache.wicket.util.visit.Visits.visitChildren(Visits.java:191)
at org.apache.wicket.MarkupContainer.visitChildren(MarkupContainer.java:923)
at
|
Description
|
When JUnit report is filtered, showing JUnit aggregated Overview gadget will raise below exception:
java.sql.SQLException: Syntax error in SQL statement "SELECT COUNT(*) AS TOTALS,SUM(DURATION) AS DURATION,SUM(TESTS) AS TESTS,SUM(ERRORS) AS ERRORS,SUM(FAILURES) AS FAILURES,SUM(SKIPS) AS SKIPS,SUM(SUCCESSES) AS SUCCESSES,AVG(SUCCESS_RATE) AS SUCCESS_RATE,SUM(ADDED) AS ADDED,SUM(NEWFAILED) AS NEWFAILED,SUM(NOTFIXED) AS NOTFIXED,SUM(FIXED) AS FIXED FROM AGG_OVERVIEW WHERE "; expected "NOT, EXISTS"; SQL statement:
SELECT COUNT(*) AS TOTALS,SUM(duration) AS duration,SUM(tests) AS tests,SUM(errors) AS errors,SUM(failures) AS failures,SUM(skips) AS skips,SUM(successes) AS successes,AVG(success_rate) AS success_rate,SUM(added) AS added,SUM(newFailed) AS newFailed,SUM(notFixed) AS notFixed,SUM(fixed) AS fixed FROM agg_overview WHERE [42001-159] Query: SELECT COUNT(*) AS TOTALS,SUM(duration) AS duration,SUM(tests) AS tests,SUM(errors) AS errors,SUM(failures) AS failures,SUM(skips) AS skips,SUM(successes) AS successes,AVG(success_rate) AS success_rate,SUM(added) AS added,SUM(newFailed) AS newFailed,SUM(notFixed) AS notFixed,SUM(fixed) AS fixed FROM agg_overview WHERE Parameters: []
at org.apache.commons.dbutils.QueryRunner.rethrow(QueryRunner.java:542)
at org.apache.commons.dbutils.QueryRunner.query(QueryRunner.java:399)
at com.pmease.quickbuild.plugin.report.engine.datastore.DbStore.query(DbStore.java:87)
at com.pmease.quickbuild.plugin.report.engine.datastore.DbStore.query(DbStore.java:59)
at com.pmease.quickbuild.plugin.report.engine.datastore.DbStore.queryForMap(DbStore.java:148)
at com.pmease.quickbuild.plugin.report.engine.renderer.AbstractReportPanel.loadReportStats(AbstractReportPanel.java:239)
at com.pmease.quickbuild.plugin.report.engine.renderer.AbstractReportPanel$1.load(AbstractReportPanel.java:70)
at com.pmease.quickbuild.plugin.report.engine.renderer.AbstractReportPanel$1.load(AbstractReportPanel.java:65)
at org.apache.wicket.model.LoadableDetachableModel.getObject(LoadableDetachableModel.java:119)
at com.pmease.quickbuild.plugin.report.engine.renderer.AbstractReportPanel.getReportStats(AbstractReportPanel.java:257)
at com.pmease.quickbuild.plugin.report.engine.renderer.dashboard.AbstractDashboardStatsPanel.createItemContext(AbstractDashboardStatsPanel.java:66)
at com.pmease.quickbuild.plugin.report.engine.renderer.dashboard.AbstractDashboardStatsPanel$1.load(AbstractDashboardStatsPanel.java:40)
at com.pmease.quickbuild.plugin.report.engine.renderer.dashboard.AbstractDashboardStatsPanel$1.load(AbstractDashboardStatsPanel.java:34)
at org.apache.wicket.model.LoadableDetachableModel.getObject(LoadableDetachableModel.java:119)
at org.apache.wicket.Component.getDefaultModelObject(Component.java:1650)
at com.pmease.quickbuild.plugin.report.engine.renderer.piechart.PieChartLegendPanel.getItemContext(PieChartLegendPanel.java:82)
at com.pmease.quickbuild.plugin.report.engine.renderer.piechart.PieChartLegendPanel.getTotals(PieChartLegendPanel.java:69)
at com.pmease.quickbuild.plugin.report.engine.renderer.piechart.PieChartLegendPanel.onInitialize(PieChartLegendPanel.java:32)
at org.apache.wicket.Component.fireInitialize(Component.java:924)
at org.apache.wicket.MarkupContainer$4.component(MarkupContainer.java:1007)
at org.apache.wicket.MarkupContainer$4.component(MarkupContainer.java:1005)
at org.apache.wicket.util.visit.Visits.visitChildren(Visits.java:143)
at org.apache.wicket.util.visit.Visits.visitChildren(Visits.java:122)
at org.apache.wicket.util.visit.Visits.visitChildren(Visits.java:191)
at org.apache.wicket.MarkupContainer.visitChildren(MarkupContainer.java:923)
at |
Show » |
There are no comments yet on this issue.
|
|