Return
-
Title
“[Incorrect syntax near 'LEFT'] at [position: 1235, line: 42, column: 64]…” parser error appears when adding an index to the table, and the Action center does not show that change -
Description
Whole error: “Parse error: Incorrect syntax near 'LEFT'] at [position: 1235, line: 42, column: 64]
Parse error: [FROM [dt_map].[DataHub].[vw_appr_rawdata_unitinfo] (NOLOCK) a LEFT JOIN SYN_ESU_properties p on TRIM(a.Prty_Ref) = p.esu_unitreferenceuprn ] at [position: 1235, line: 42, column: 64]”
Repro steps:
- Create a Cognito database
- With the attached script (Error_table.sql) create a table in that database
- Link a Cognito database in the shared model
- Then create a stored procedure with the attached script (ApexSQL_usp_appr_rawdata_unitinfo_latest.sql)
- On the previously created table add a non-clustered index (Index.sql)
- Open Action center the change will not be presented there
-
Resolution
Workaround: The workaround would be not to use '(NOLOCK)' and 'a' identifiers together, meaning - use either (NOLOCK) or a, but not together as it did here.
-
Defect ID
228042