Options
MERGE statements not being parsed correctly
AaronPDX
Posts: 3 New member
I just upgraded from SQL Prompt v. 7.0.something, and am now at 7.1.0.315.
SQL Prompt doesn't seem to be parsing MERGE statements correctly for recognizing suggestions for auto-complete, OR for doing Smart Rename.
For example:
I would expect to get a list of columns available from the dbo.Person table, but instead I ONLY get columns suggested from dbo.Person_Address.
Similarly, if I try to do a Smart Rename of a column in the dbo.Person table that is included in the MERGE statement (eg. 'Person_ID' to 'ID'), it will recognize that this MERGE needs to be included in the Smart Rename, but it will not recognize that the 'Person_ID' column is connected to dbo.Person, and will leave it as is, then throw an error when trying to run the Smart Rename script.
SQL Prompt doesn't seem to be parsing MERGE statements correctly for recognizing suggestions for auto-complete, OR for doing Smart Rename.
For example:
MERGE dbo.Person USING dbo.Person_Address pa ON p.Person_ID = pa.Person_ID WHEN NOT MATCHED THEN INSERT (
I would expect to get a list of columns available from the dbo.Person table, but instead I ONLY get columns suggested from dbo.Person_Address.
Similarly, if I try to do a Smart Rename of a column in the dbo.Person table that is included in the MERGE statement (eg. 'Person_ID' to 'ID'), it will recognize that this MERGE needs to be included in the Smart Rename, but it will not recognize that the 'Person_ID' column is connected to dbo.Person, and will leave it as is, then throw an error when trying to run the Smart Rename script.
