-
Notifications
You must be signed in to change notification settings - Fork 34
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.
Metadata
Metadata
Assignees
Labels
No labels