使用HSQLDB生成基于CTE的序列

I am using a recursive common table expression to fetch a batch of sequence number. The following query works with Postgres, SQL Server and H2 (minus the I am using a recursive common table expression