You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
Repository navigation
ScriptDom fails to parse CREATE EVENT SESSION statement with NOT LIKE predicate #153
It fails to parse this statement which is completely valid and is successfully compiled on server side:
varcmd=@"CREATE EVENT SESSION [Trace-07a0784d30f94b6fa1af2bb4650df0e8] ON SERVER ADD EVENT sqlserver.sp_statement_starting( ACTION (sqlserver.plan_handle) WHERE (sqlserver.database_id = (1000) AND source_database_id = (1000) AND sqlserver.is_system = 0 AND sqlserver.client_app_name NOT LIKE 'SQLAgent%'))ADD TARGET package0.asynchronous_file_target( SET FILENAME='dummy', MAX_FILE_SIZE=(1024), MAX_ROLLOVER_FILES=(10))WITH (MAX_MEMORY=500 MB, EVENT_RETENTION_MODE=ALLOW_SINGLE_EVENT_LOSS, MAX_DISPATCH_LATENCY=1 SECONDS, MAX_EVENT_SIZE=0 KB, MEMORY_PARTITION_MODE=NONE, TRACK_CAUSALITY=OFF, STARTUP_STATE=OFF)";varparser=TSqlParser.CreateParser(SqlVersion.Sql150,true);vartsql=parser.Parse(newStringReader(cmd),outvarerrors);
errors contains single exception: Incorrect syntax near 'NOT' at line 7. Rewriting into NOT ... LIKE gives the same result.
Activity