Issue Bug Closed

#25797Column cHashParams of table index_phash should not be a BLOB

Xavier Perseguers 04/06/11, 15:25 updated 01/15/20, 20:01

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.