#277 Add support for CONNECT BY PRIOR START WITH

open
nobody
None
5
2016-05-18
2012-03-25
Anonymous
No

Add support for CONNECT BY PRIOR START WITH (like Oracle one)

Discussion

  • Lukas Eder

    Lukas Eder - 2012-04-06

    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!

     
  • Alain Pannetier

    Alain Pannetier - 2016-05-18

    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?

     
  • Fred Toussi

    Fred Toussi - 2016-05-18

    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.

     

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks