2686334 - Errors 102, 105, and 107 when replicating or upgrading CREATE VIEW - ASE

• Replication or Upgrade of a CREATE VIEW fails with errors 102, 105, and 107
• SET QUOTED_IDENTIFIER ON is in use
• Column names include periods

Examples:

Msg 102, Level 15, State 4:
Server 'ASE', Line 2:
Incorrect syntax near '[]'.
Msg 105, Level 15, State 2:
Server 'ASE', Line 4:
Unclosed quote before the character string '"
'.
Msg 107, Level 15, State 1:
Server 'ASE', Line 2:
The column prefix 'mytable.column1.data.data" does not match
with a table name or alias name used in the query. Either the table is not
specified in the FROM clause or it has a correlation name which must be used
instead.

Read more...

SAP Adaptive Server Enterprise (ASE), all versions

SAP Adaptive Server Enterprise 12.5 ; SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 15.7 Cluster Edition ; SAP Adaptive Server Enterprise 16.0 ; SAP Adaptive Server Enterprise 16.0 Cluster Edition ; Sybase Adaptive Server Enterprise 12.5 ; Sybase Adaptive Server Enterprise 15.0 ; Sybase Adaptive Server Enterprise 15.5 ; Sybase Adaptive Server Enterprise Cluster Edition 15.0 ; Sybase Adaptive Server Enterprise Cluster Edition 15.5 ; Sybase Adaptive Server Enterprise Cluster Edition 15.7

Sybase, ASEServer, SAPASE, dataserver, quoted identifier, create view, view, 102, 105, 107, upgrade, replication , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-SYB-ASE-CE , ASE Cluster Edition (Standalone) , Bug Filed