× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
ivangron reported 2017-03-24T15:42:43Z  · tariqrahiman last modified 2017-03-31T04:31:17Z

SQL Server -> Extraction queries should always use correct table casing for catalog tables


customer request
Priority Critical
Complexity Unknown
Component DB - SQL Server
Version 18.0

  All sql server extraction queries should use correct case characters for catalog tables.  This is very important in the case that the collation is set to a case sensitive collation.

Example:  following will through an invalid object for information_schema.constraint_column_usage table when collation is case sensitive

// case-sensitive
ALTER DATABASE "Chinook" COLLATE Latin1_General_Bin
GO
USE "Chinook"
GO
select count (*) from information_schema.constraint_column_usage
GO
select count (*) from INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE
GO
// case-insensitive
ALTER DATABASE "Chinook" COLLATE SQL_Latin1_General_CP1_CI_AS
GO
USE "Chinook"
GO
select count (*) from information_schema.constraint_column_usage
GO
select count (*) from INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE
GO

Issue #15100

Closed
Fixed
Resolved 2017-03-24T16:45:13Z
 
 
Completion
No due date
Fixed Build v18.0.5-11
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017