Issue Bug Closed

#91907tinytext columns cause schema inspector loop when adding an index on these columns

S P 07/31/20, 07:36 updated 10/16/24, 07:12

Description

Some columns (I didn’t check all, these are probably just some of them), like

  • sys_category.title
  • sys_file.name
  • sys_file_metadata.title

define itself as

<columname> tinytext
or
@<columname> tinytext NOT NULL@</columname>

First minor problem: BLOB-type columns (like BLOB and TEXT and their differnet sizes) are not not-nullable (specifying NULL or NOT NULL on them has no effect at all).

When adding an index on these columns like

CREATE TABLE sys_category (
    INDEX my_title_index (title(100))
);

The schema inspector will create the index first, but then always suggests to drop and recreate it, in an endless loop.

Why are these columns tinytext anyways? Instead of varchar(255)? tinytext is not Unicode-aware (it can only store 255 bytes, not 255 characters). Also it is a BLOB-type, which means usually it is way slower than varchar on lookup-time (depending on lots of factors, but it can never be faster than varchar, and usally it’s really slower).

I marked this as v9, but I assume it’s like this in any version.

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.

History 4

  1. S P commented 07/31/20, 07:39

    This seems only to happen with tinytext. Tested it on a text column (sys_file.identifier) -> works perfectly.

  2. S P commented and changed TYPO3 Version 9 10 10/20/21, 06:09

    Valid on v10, still.

  3. S P commented 10/16/24, 06:57

    Works on v12 (these fields are still tinytext instead of varchar(255), but the schema inspector correctly detectd indexes on them).

    Ticket can be closed.

  4. Oliver Bartsch commented and changed status New Closed 10/16/24, 07:12

    Closed as requested by author.