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
The following CTE never ends in H2 2.3.232, although it does in MySQL:
with recursive
mutations(time, old, new) as (
select1, 'A', 'B'unionselect2, 'B', 'C'unionselect3, 'B', 'B'unionselect4, 'A', 'A'unionselect5, 'C', 'B'unionselect6, 'C', 'C'unionselect7, 'A', 'B'unionselect8, 'D', 'E'
),
permutations(x, y) as (
select new, old from mutations unionselect old, new from mutations
),
related(val) as (
select ? unionselect x from related join permutations on y = val
)
select val from related order by1
The following CTE never ends in H2 2.3.232, although it does in MySQL:
CTE.java.txt
The text was updated successfully, but these errors were encountered: