Would be great to have this indeed.
All my JUnit tests on Oracle database backed data are running on HSQL and I cannot resolve myself to not using this feature just because HSQL does not support it...
could the recursive feature somehow be made to support connect by through the Oracle dialect?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
It is a nice-to-have feature but it will take a lot of development time and needs to be fully funded. This feature may be added to HyperXtremeSQL in order to cover the cost.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
We also use HSQL to unit test our Oracle code and can't write tests against a segment of our system because CONNECT BY PRIOR is not supported. I don't see a voting mechanism here, but we would very much +1 this work.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I have recently encountered this syntax in a promising new open source database:
http://www.cubrid.org/manual/841/en/Hierarchical%20Query
CUBRID and Oracle are the only databases that I'm aware of, which support this very useful syntax. So I can only +1 on this feature request!
Would be great to have this indeed.
All my JUnit tests on Oracle database backed data are running on HSQL and I cannot resolve myself to not using this feature just because HSQL does not support it...
could the recursive feature somehow be made to support connect by through the Oracle dialect?
It is a nice-to-have feature but it will take a lot of development time and needs to be fully funded. This feature may be added to HyperXtremeSQL in order to cover the cost.
We also use HSQL to unit test our Oracle code and can't write tests against a segment of our system because CONNECT BY PRIOR is not supported. I don't see a voting mechanism here, but we would very much +1 this work.