SQL Server INFORMATION_SCHEMA with CS collation

[jan-bures]

Describe the bug
When using DBAL on the SQL Server platform in a database with case-sensitive collation (specifically SQL_Czech_CP1250_CS_AS), the SqlServerPlatform::getTables method throws QueryException with the message "Invalid object name 'information_schema.tables'".

Expected behavior
This line should contain FROM [INFORMATION_SCHEMA].[TABLES] (other methods in the class already correctly use the uppercase name wrapped in square brackets).

Versions

• Database: SQL Server 2017 CU29
• Dbal: Dbal 5.0

[hrach]

d04066f

Thx for the report. I've just pushed the fix without testing it, so I hope it will work correctly. Plz let me know :)

[jan-bures]

Can confirm that fixed it, thanks for the quick fix!