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