Differences in exceptions in "pdfbox_1_8_8" vs. "PDFBox_1_8_9-SNAPSHOT"
| FILE_EXTENSION | NUM_FILES | Number of Exceptions in A | Number of Exceptions in B | Number of Differences A to B | Percent Exceptions in A | Percent Exceptions in B |
pdf
| 231229
| 110
| 107
| -3
| 0.05
| 0.05
|
select extensions_total.FILE_EXTENSION as "File Extension", NUM_FILES as "Number of Files", ifNull(NUM_CAUGHT_EXCEPTIONS_A, 0) as "Number of Exceptions in A", ifNull(NUM_CAUGHT_EXCEPTIONS_B, 0) as "Number of Exceptions in B", (ifNull(NUM_CAUGHT_EXCEPTIONS_B, 0) - ifNull(NUM_CAUGHT_EXCEPTIONS_A, 0)) as "Number of Differences A to B", DEC_PATTERN((100.0*ifNull(exceptions_A.NUM_CAUGHT_EXCEPTIONS_A, 0)/NUM_FILES), '#.##') as "Percent Exceptions in A", DEC_PATTERN((100.0*ifNull(exceptions_B.NUM_CAUGHT_EXCEPTIONS_B, 0)/NUM_FILES), '#.##') as "Percent Exceptions in B" from extensions_total left join exceptions_A on extensions_total.file_extension =exceptions_A.file_extension left join exceptions_B on extensions_total.file_extension =exceptions_B.file_extension where (ifNull(NUM_CAUGHT_EXCEPTIONS_B, 0) - ifNull(NUM_CAUGHT_EXCEPTIONS_A, 0)) <> 0 order by abs(ifNull(NUM_CAUGHT_EXCEPTIONS_B, 0) - ifNull(NUM_CAUGHT_EXCEPTIONS_A, 0)) desc;