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
[BUG] JSQLParser 5.4-SNAPSHOT : PostgreSQL : SEARCH BREADTH FIRST BY not supported #2308
WITH RECURSIVE team_hierarchy AS (
SELECT employee_id, first_name, manager_id, ARRAY[employee_id] AS path
FROM employees
WHERE manager_id IS NULL
UNION ALL
SELECT e.employee_id, e.first_name, e.manager_id, th.path || e.employee_id
FROM employees e
INNER JOIN team_hierarchy th ON e.manager_id = th.employee_id
)
SEARCH BREADTH FIRST BY employee_id SET order_col
SELECT
employee_id,
first_name,
path,
order_col
FROM team_hierarchy
ORDER BY order_col;
Error:
ParseException: Encountered: <S_IDENTIFIER> / "SEARCH", at line 10, column 1, in lexical state DEFAULT.
Was expecting one of these terminals within expansion starting at 974:21:
<K_COMMA> (inside 4375:5) ...
Activity