search

go-goracle / goracle

Go database/sql driver for connecting to Oracle Database, using the ODPI-C library
273 stars 43 forks source link

Support Factored Subquery #203

Closed mlh758 closed 5 years ago

mlh758 commented 5 years ago

Is your feature request related to a problem? Please describe. Unable to run queries that use with syntax.

Describe the solution you'd like I would like to be able to use that syntax.

Describe alternatives you've considered Nested selects, unions, whatever other thing works.

Additional context https://oracle-base.com/articles/misc/with-clause

I am unable to run these using goracle. I noticed that I also can't run them with the Ruby adapter though, so I'm guessing this has something to do with ODPI-C? If so I'll just close this and move the issue over there.

cjbj commented 5 years ago
mlh758 commented 5 years ago

Wow, I've been using that a long time and apparently didn't know what C libraries it was using.

In any case, it looks like the with thing was actually a red herring, the error was being triggered for a LISTAGG clause and it's probably our fault.

mlh758 commented 5 years ago

Just for context, we've got a query that runs fine in sql developer and then dies when it goes through the sql adapter. But since it's broken on two different libraries that apparently don't even share the same underlying C code there's probably something else going wrong.