MySQL 8.0 pacman case sensitivity issue reading information_schema

[sbulen]

Description

Upon reinstalling a mod, you may get errors:

Database Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ',,,,,,)
			SELECT ,,,,,,
			FROM smf_message_bookmarks_old' at line 1

But the root cause is earlier in the error log:
2: Undefined array key "column_name"

In DbPackages-mysql.php, line 257:

SMF/Sources/DbPackages-mysql.php

Line 257 in 79970eb

$same_col[] = $row['column_name'];

Steps to reproduce

1. Mysql 8 - attempt to reinstall a mod, keeping the data from the prior installation

Environment (complete as necessary)

• Version/Git revision: 2.1.3
• Database Type: mysql
• Database Version: 8
• PHP Version: 8.1

Additional information/references

From the forum:
https://www.simplemachines.org/community/index.php?msg=4131633

In this pic, you can see that DbPackages-mysql.php is looking for 'column_name', but what is returned from a query to INFORMATION_SCHEMA is 'COLUMN_NAME':

[live627]

Steps to reproduce

1. Mysql 8 - attempt to reinstall a mod, keeping the data from the prior installation

2. It must db_create_table with mode update