Actual file extensions vs. "Detected extensions" in "pdfbox_1_8_9_20150316"
| Actual file extension->Detected file extension | COUNT |
pdf->txt
| 17
|
pdf->html
| 1
|
select concat(FILE_EXTENSION, '->', DETECTED_FILE_EXTENSION_B) as "Actual file extension->Detected file extension", count(1) as COUNT from comparisons where FILE_EXTENSION is not null and JSON_EX_B is null and SORT_STACK_TRACE_B is null and FILE_EXTENSION <> DETECTED_FILE_EXTENSION_B group by "Actual file extension->Detected file extension" order by COUNT desc