Table alias bug?
Posted: Mon 18 May 2015 10:54
Hello,
we recently upgraded the SDAC components we use in our projects to version 7.1.3. This version has introduced a behavior that might be a bug:
If a SQL statement contains schema and table name in square brackets the table will get an alias. Auto-generated refresh statements will be of incorrect syntax for this.
Example:
SELECT FieldName FROM [Schema].[Table]
Resulting refresh statement:
SELECT FieldName AS _0 FROM Schema.Table [Schema].[Table]
WHERE ...
Is this a bug? The SDAC version used before did not use an alias.
we recently upgraded the SDAC components we use in our projects to version 7.1.3. This version has introduced a behavior that might be a bug:
If a SQL statement contains schema and table name in square brackets the table will get an alias. Auto-generated refresh statements will be of incorrect syntax for this.
Example:
SELECT FieldName FROM [Schema].[Table]
Resulting refresh statement:
SELECT FieldName AS _0 FROM Schema.Table [Schema].[Table]
WHERE ...
Is this a bug? The SDAC version used before did not use an alias.