forceedge01 / behat-sql-extension

Provides easy data manipulation with any pdo enabled database
MIT License
10 stars 12 forks source link

Mysql 8 compatibility #90

Closed darren-potter closed 5 years ago

darren-potter commented 5 years ago

The column names in the MySQL 8 version of information_schema.columns are in uppercase. Although we can reference them in lowercase and MySQL doesn't mind, the query response is in uppercase and PHP does care. This change just sets aliases to make sure the response always comes back in lowercase.

forceedge01 commented 5 years ago

I've merged a solution and more tests in, these should resolve your issue https://github.com/forceedge01/behat-sql-extension/pull/91