Re: CTE and Recursive CTE support in SQL

Hello! Try it and see. With regards of Recursive CTE, I think the development priority is MVCC for now. As for H2 features, there might be further limitations on them in Apache Ignite. Regards, -- Ilya Kasnacheev 2018-08-24 10:34 GMT+03:00 piyush : > H2 has limited support for Recursive

Re: CTE and Recursive CTE support in SQL

H2 has limited support for Recursive CTE. http://h2database.com/html/advanced.html#recursive_queries Does Ignite supports all SQL features which H2 has ? -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: CTE and Recursive CTE support in SQL

When is Recursive CTE planned ? Recursive CTE is super powerful. https://www.postgresql.org/docs/current/static/queries-with.html https://docs.microsoft.com/en-us/sql/t-sql/queries/with-common-table-expression-transact-sql?view=sql-server-2017 -- Sent from:

Re: CTE and Recursive CTE support in SQL

Hello! Apache Ignite already has CTE support (but not Recursive CTE). I think that we have inherited it from H2. Regards, -- Ilya Kasnacheev 2018-08-23 15:34 GMT+03:00 piyush : > When Common Table Expression (CTE) and Recursive CTE are planned to be part > of supported SQL syntax ? > > It