title: MySQL Select lowercase column name but return uppercase column name for information_schema table in version 8
body: <p>in MySQL 5.7 if I query <code>SELECT index_name, non_unique FROM information_schema.statistics</code> I will get lowercase column name.</p>
  
  <p><a href="https://i.stack.imgur.com/AunGC.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/AunGC.png" alt="enter image description here"></a></p>
  
  <p>in MySQL 8.0.14, if I do same query, MySql will return uppercase column name:
  <a href="https://i.stack.imgur.com/xn2BD.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/xn2BD.png" alt="enter image description here"></a></p>
  
  <p>I try a couple case type in the query. in v5.7, MySQL will return case of column name by the case what you type. However, v8.0.14, MySQL return only uppercase column name whatever you type.</p>
  
  <p>Due to my task is upgrade database for Third Party PHP system(SugarCRM), I cannot change any core code of system(the source code use all lowercase column name to get the data). is there any way to resolve this by change configuration of MySQL. or this is just a bug?</p>