#15915Database Analyser does not create sys_refindex if multiplyDBfieldSize is set
Description
Using the “Compare”-function from the Database Analyser fails to create the table “sys_refindex” with the following error message if $TYPO3_CONF_VARS[SYS][multiplyDBfieldSize]=2 is used (the database analyser than tries to create a field of type TEXT instead of VARCHAR):
BLOB/TEXT column ‘ref_string’ used in key specification without a key length
To solve this a length has to be assigned to the key referencing the column “ref_string”.
This happens because MySQL needs to know how many bytes of a BLOB column should be indexed. See [1] for an explanation.
The MySQL version used on the server- or client-side is not relevant here.
This error is likely to happen in other extensions as well when index is used on BLOB columns.
[1]<http: groups.google.com group mailing.database.myodbc msg></http:>
(issue imported from #M3015)
Reviews 0
No change resolves or names this issue in its commit message, and no comment links one.