-
Type:
Bug
-
Resolution: Unresolved
-
Priority:
Low
-
None
-
Affects Version/s: 6.1.5
-
Component/s: Installation
-
6.01
-
3
-
Severity 3 - Minor
-
1
MSSQL has a known problem with distinguishing between the data and the metadata when you the database is set to case-sensitivity. For example:
-- This SQL query won't work SELECT table_name, table_type FROM information_schema.tables; GO -- This SQL query will work SELECT TABLE_NAME, TABLE_TYPE FROM INFORMATION_SCHEMA.TABLES; GO
This is because the object name is actually INFORMATION_SCHEMA.TABLES.
This has forced our documentation to recommend case-insensitivity for MSSQL database. In the other hand, using case-insensitivity database is known to break a couple of functionality in JIRA, to name a few: