#25797Column cHashParams of table index_phash should not be a BLOB
Description
Column cHashParams is configured as BLOB:
CREATE TABLE index_phash ( phash int(11) DEFAULT '0' NOT NULL, phash_grouping int(11) DEFAULT '0' NOT NULL, cHashParams blob, ...
When using DBAL with a MSSQL DBMS, the query in modfunc1 fails because it tries to GROUP BY this column and MSSQL does not allow a BLOB or IMAGE field to be used in GROUP BY.
Changing it to varchar(4000) solves the issue:
CREATE TABLE index_phash ( phash int(11) DEFAULT '0' NOT NULL, phash_grouping int(11) DEFAULT '0' NOT NULL, cHashParams varchar(4000), ...
Reviews 0
No change resolves or names this issue in its commit message, and no comment links one.