Uppercase columns errors on information_schema tables queries

Created on 27 October 2022, over 2 years ago
Updated 26 April 2024, 10 months ago

Problem/Motivation

The information_schema tables queries issue with UPPER case columns. The query object returns with keys in Uppercase and values are not found.

Errors are logged for all the SQL object properties since all are in uppercase. For example $r->table_name doesnโ€™t work, but $r->TABLE_NAME works fine.
Undefined property: stdClass::$table_name in Drupal\schema\SchemaDatabaseSchema_mysql->inspect() (line 245 of /var/www/web/modules/contrib/schema/src/SchemaDatabaseSchema_mysql.php)

Steps to reproduce

Drupal 9, MySQL8, and PHP8. Install the module in the 2.0.0-alpha1 version.

Proposed resolution

Force the results in lowercase.

Example of the object returned from the query.

๐Ÿ› Bug report
Status

Fixed

Version

2.0

Component

Code

Created by

๐Ÿ‡ง๐Ÿ‡ทBrazil adrianopulz Florianรณpolis

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

Not all content is available!

It's likely this issue predates Contrib.social: some issue and comment data are missing.

Production build 0.71.5 2024