Closed holc-tkomp closed 9 months ago
@holc-tkomp The syntax is neither released or supported.
Are you considering to add support for this in the future though? Or if we'd want to support this syntax in near future we would have to use a different parser?
@holc-tkomp could you please help us by explaining your broader scenario? Are you trying to do this in the context of a DACPAC deployment as a post-deployment script, or such? Why is it necessary for you to specify the OID using this undocumented syntax?
The script is something used by one of our clients. Our tool (SSMS addin) allows formatting of script within SSMS query window and for that we use your parser, so we can analyze tokens/fragments to decide where to put newlines, semicolons, etc.
Issue
Microsoft.SqlServer.TransactSql.ScriptDom.TSql160Parser
fails to parse following sql:WITH OBJECT_ID
syntax doesn't seem to be documented yet, however it's already available on (some?) Azure databases, see https://github.com/MicrosoftDocs/sql-docs/issues/7167.Reproduction
Latest tested version of Microsoft.SqlServer.TransactSql.ScriptDom package: 161.8905.0