René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"[BUG] JSQLParser 5.4-SNAPSHOT : PostgreSQL : EXCLUDE TIES not supported in window function frame clause","articleBody":"  **Failing SQL Feature**\n  \n  PostgreSQL `EXCLUDE TIES` frame exclusion clause used inside a window function's frame specification.\n  \n  PostgreSQL supports the SQL-standard `frame_exclusion` options on window function frames: `EXCLUDE CURRENT ROW`, `EXCLUDE GROUP`, `EXCLUDE TIES`, and `EXCLUDE NO OTHERS`. `EXCLUDE TIES` excludes any peers of the current row from the frame,\n  but keeps the current row itself. It is valid syntax in PostgreSQL and appears in analytical queries that need fine-grained control over window frame contents.\n\nDocs: https://www.postgresql.org/docs/current/sql-expressions.html\n  \n  **SQL Example**\n  \n```\n  CREATE TABLE sales (\n      id SERIAL PRIMARY KEY,\n      salesperson TEXT,\n      amount INT\n  );\n\n  INSERT INTO sales (salesperson, amount) VALUES\n  ('Alice', 100),\n  ('Bob',   100),\n  ('Carol', 200),\n  ('Dave',  300);\n\n  SELECT\n      id,\n      salesperson,\n      amount,\n      SUM(amount) OVER (\n          ORDER BY amount\n          RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW\n          EXCLUDE TIES\n      ) AS running_sum_exclude_ties\n  FROM sales\n  ORDER BY amount, id;\n\n```\n  **Parsing error**\n\n`ParseException: Encountered: \u003cK_EXCLUDE\u003e / \"EXCLUDE\", at line 8, column 9, in lexical state DEFAULT.`","author":{"url":"https://github.com/tomershay","@type":"Person","name":"tomershay"},"datePublished":"2026-05-12T17:25:32.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":0},"url":"https://github.com/2430/JSqlParser/issues/2430"}