fix(CI/Codestyle): Ignore comments for backtick check (#21343)

1 files changed, 6 insertions, 0 deletions

diff --git a/apps/codestyle/codestyle-sql.py b/apps/codestyle/codestyle-sql.py
index 1bb98e037b..703607c128 100644
--- a/apps/codestyle/codestyle-sql.py
+++ b/apps/codestyle/codestyle-sql.py
@@ -216,12 +216,18 @@ def backtick_check(file: io, file_path: str) -> None:
     quote_pattern = re.compile(r"'(?:\\'|[^'])*'|\"(?:\\\"|[^\"])*\"")
 
     for line_number, line in enumerate(file, start=1):
+        # Ignore comments
+        if line.startswith('--'):
+            continue
+
+        # Sanitize single- and doublequotes to prevent false positives
         sanitized_line = quote_pattern.sub('', line)
         matches = pattern.findall(sanitized_line)
         
         for clause, content in matches:
             words = re.findall(r'\b[a-zA-Z_][a-zA-Z0-9_]*\b', content)
             for word in words:
+                # Skip SQL keywords
                 if word.upper() in {"SELECT", "FROM", "JOIN", "WHERE", "GROUP", "BY", "ORDER", 
                                     "DELETE", "UPDATE", "INSERT", "INTO", "SET", "VALUES", "AND",
                                     "IN", "OR", "REPLACE"}: