Table alias bug?

[Nilss]

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.

[azyk]

We couldn't reproduce the problem. Please, try to compose a small sample to demonstrate the problem including a script to create test table and send it to andreyz*devart*com .

[GuguinhaBrastak]

I have the same problem, i try to use database.schema.table and when SDAC will try to generate sql they supress the database and just use schema.table, this give me a lot of problems ... this works on 6.11 fine but after update to 7, start to give a error.

[azyk]

We have reproduced this problem and are investigating it. We will notify you about the results as any are available.

[azyk]

We have fixed this problem. This fix will be included in the next SDAC build.