Title: ScriptDom fails to parse `CREATE EVENT SESSION` statement with NOT LIKE predicate · Issue #153 · microsoft/SqlScriptDOM · GitHub
Open Graph Title: ScriptDom fails to parse `CREATE EVENT SESSION` statement with NOT LIKE predicate · Issue #153 · microsoft/SqlScriptDOM
X Title: ScriptDom fails to parse `CREATE EVENT SESSION` statement with NOT LIKE predicate · Issue #153 · microsoft/SqlScriptDOM
Description: ScriptDom version: 170.82.0 It fails to parse this statement which is completely valid and is successfully compiled on server side: var cmd = @" CREATE EVENT SESSION [Trace-07a0784d30f94b6fa1af2bb4650df0e8] ON SERVER ADD EVENT sqlserver....
Open Graph Description: ScriptDom version: 170.82.0 It fails to parse this statement which is completely valid and is successfully compiled on server side: var cmd = @" CREATE EVENT SESSION [Trace-07a0784d30f94b6fa1af2bb4...
X Description: ScriptDom version: 170.82.0 It fails to parse this statement which is completely valid and is successfully compiled on server side: var cmd = @" CREATE EVENT SESSION [Trace-07a0784d30f94b6fa1a...
Opengraph URL: https://github.com/microsoft/SqlScriptDOM/issues/153
X: @github
Domain: github.com
{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"ScriptDom fails to parse `CREATE EVENT SESSION` statement with NOT LIKE predicate","articleBody":"ScriptDom version: 170.82.0\n\nIt fails to parse this statement which is completely valid and is successfully compiled on server side:\n\n```csharp\nvar cmd = @\"\nCREATE EVENT SESSION [Trace-07a0784d30f94b6fa1af2bb4650df0e8] ON SERVER \nADD EVENT sqlserver.sp_statement_starting(\n ACTION (sqlserver.plan_handle)\n WHERE (sqlserver.database_id = (1000)\n AND source_database_id = (1000)\n AND sqlserver.is_system = 0\n AND sqlserver.client_app_name NOT LIKE 'SQLAgent%'))\nADD TARGET package0.asynchronous_file_target(\n SET FILENAME='dummy', MAX_FILE_SIZE=(1024), MAX_ROLLOVER_FILES=(10))\nWITH (MAX_MEMORY=500 MB, EVENT_RETENTION_MODE=ALLOW_SINGLE_EVENT_LOSS, MAX_DISPATCH_LATENCY=1 SECONDS,\n MAX_EVENT_SIZE=0 KB, MEMORY_PARTITION_MODE=NONE, TRACK_CAUSALITY=OFF, STARTUP_STATE=OFF)\n\";\n\nvar parser = TSqlParser.CreateParser(SqlVersion.Sql150, true);\nvar tsql = parser.Parse(new StringReader(cmd), out var errors);\n```\n\n`errors` contains single exception: `Incorrect syntax near 'NOT' at line 7`. Rewriting into `NOT ... LIKE` gives the same result.\n\nThere should be no error.","author":{"url":"https://github.com/IVNSTN","@type":"Person","name":"IVNSTN"},"datePublished":"2025-08-26T10:20:12.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":0},"url":"https://github.com/153/SqlScriptDOM/issues/153"}
| route-pattern | /_view_fragments/issues/show/:user_id/:repository/:id/issue_layout(.:format) |
| route-controller | voltron_issues_fragments |
| route-action | issue_layout |
| fetch-nonce | v2:022417f1-327d-0fd3-a753-94d2ad7cbd3b |
| current-catalog-service-hash | 81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114 |
| request-id | C7D6:3762B:246313A:2EA8BBE:69901B6B |
| html-safe-nonce | e6a04dec57be2759043007dd44c4146394f34a5ce94ddf231cf6d7bbbb261f50 |
| visitor-payload | eyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJDN0Q2OjM3NjJCOjI0NjMxM0E6MkVBOEJCRTo2OTkwMUI2QiIsInZpc2l0b3JfaWQiOiI2Njk4Nzk4ODEzMzE2OTE0MDI3IiwicmVnaW9uX2VkZ2UiOiJpYWQiLCJyZWdpb25fcmVuZGVyIjoiaWFkIn0= |
| visitor-hmac | bc67a6e6793033f9f5285551a78e7f78fe9e479f1ec6a91791afee44f24dddb6 |
| hovercard-subject-tag | issue:3355048383 |
| github-keyboard-shortcuts | repository,issues,copilot |
| google-site-verification | Apib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I |
| octolytics-url | https://collector.github.com/github/collect |
| analytics-location | / |
| fb:app_id | 1401488693436528 |
| apple-itunes-app | app-id=1477376905, app-argument=https://github.com/_view_fragments/issues/show/microsoft/SqlScriptDOM/153/issue_layout |
| twitter:image | https://opengraph.githubassets.com/5f3ec741ad23ed244026106eb509773d36148c9185e6bac425ac02e5966b85ec/microsoft/SqlScriptDOM/issues/153 |
| twitter:card | summary_large_image |
| og:image | https://opengraph.githubassets.com/5f3ec741ad23ed244026106eb509773d36148c9185e6bac425ac02e5966b85ec/microsoft/SqlScriptDOM/issues/153 |
| og:image:alt | ScriptDom version: 170.82.0 It fails to parse this statement which is completely valid and is successfully compiled on server side: var cmd = @" CREATE EVENT SESSION [Trace-07a0784d30f94b6fa1af2bb4... |
| og:image:width | 1200 |
| og:image:height | 600 |
| og:site_name | GitHub |
| og:type | object |
| og:author:username | IVNSTN |
| hostname | github.com |
| expected-hostname | github.com |
| None | 42c603b9d642c4a9065a51770f75e5e27132fef0e858607f5c9cb7e422831a7b |
| turbo-cache-control | no-preview |
| go-import | github.com/microsoft/SqlScriptDOM git https://github.com/microsoft/SqlScriptDOM.git |
| octolytics-dimension-user_id | 6154722 |
| octolytics-dimension-user_login | microsoft |
| octolytics-dimension-repository_id | 543316377 |
| octolytics-dimension-repository_nwo | microsoft/SqlScriptDOM |
| octolytics-dimension-repository_public | true |
| octolytics-dimension-repository_is_fork | false |
| octolytics-dimension-repository_network_root_id | 543316377 |
| octolytics-dimension-repository_network_root_nwo | microsoft/SqlScriptDOM |
| turbo-body-classes | logged-out env-production page-responsive |
| disable-turbo | false |
| browser-stats-url | https://api.github.com/_private/browser/stats |
| browser-errors-url | https://api.github.com/_private/browser/errors |
| release | 3b33c5aedc9808f45bc5fcf0b1e4404cf749dac7 |
| ui-target | full |
| theme-color | #1e2327 |
| color-scheme | light dark |
Links:
Viewport: width=device-width