-
Notifications
You must be signed in to change notification settings - Fork 37
Closed
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.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)
";
var parser = TSqlParser.CreateParser(SqlVersion.Sql150, true);
var tsql = parser.Parse(new StringReader(cmd), out var errors);errors contains single exception: Incorrect syntax near 'NOT' at line 7. Rewriting into NOT ... LIKE gives the same result.
There should be no error.
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
No labels