doctrine:migrate not possible with version 3.2.1

[Lemmork]

A doctrine:migrate is not possible with version 3.2.1 and will throw this error:
Exception #1 in line 41 of /var/www/html/Packages/Application/Neos.GoogleAnalytics/Migrations/Mysql/Version20141111161429.php: Notice: Undefined index: CHARACTER_SET_NAME in /var/www/html/Packages/Application/Neos.GoogleAnalytics/Migrations/Mysql/Version20141111161429.php line 41

Downgrading to 3.2.0 runs doctrine:migrate correctly.

Environment:
Neos 5.2.1
php: 7.4.6
mariadb: 10.3

[Sebobo]

I think we need a version switch for 8fd974b

Maybe you or someone else can look into it.

[DrillSergeant]

Just for my understanding, what piece of code changes the name of the result column to uppercase after executing:
SELECT character_set_name FROM information_schema.COLUMNS WHERE table_schema IN (SELECT DATABASE()) AND table_name = '${tableName}' AND column_name = 'persistence_object_identifier'?
As I read this, the field is asked in lower case characters in the SELECT statement.

Is this something doctrine, flow or even PHP does in a certain version? Or mysql/mariadb?

[Lemmork]

What about transforming array keys to lowercase, before getting the value?

$columnCharSets = array_change_key_case($columnCharSets, CASE_LOWER); $charSet = $columnCharSets['character_set_name'];

[DrillSergeant]

Thanks @kdambekalns . I updated the package to 3.2.2 and it works for me, too.