search

pavanvd / postgres-xl

Public Postgres-XL repository
Mozilla Public License 2.0
4 stars 3 forks source link

Recursive queries do not work #22

Open pavanvd opened 9 years ago

pavanvd commented 9 years ago

Even simple recursive queries which do not involve any real tables are not working.. We had seen such reports in the past and probably had a patch to fix them as well. Needs investigation

 WITH RECURSIVE t(n) AS (
      SELECT (VALUES(1))
  UNION ALL
      SELECT n+1 FROM t WHERE n < 5
  )
  SELECT * FROM t ORDER BY n;