Clojurians Log v2
Clojure programming
Channels
Apps
honeysql
Discussion of https://github.com/seancorfield/honeysql :slightly_smiling_face:
seancorfield 2020-06-28T04:31:48.165500Z
Anyone here using Oracle? I need someone to test something on Oracle for me please. https://github.com/seancorfield/honeysql/issues/263 has highlighted that FROM (sub-query) alias needs to be FROM (sub-query) AS alias for PostgreSQL -- and that seems to work on every database I have access to for testing (basically next.jdbc's suite) but I don't have an Oracle test rig, and the comment in the code suggests that the reason the if is in the current code is to suppress AS in a FROM etc is because Oracle doesn't allow this...
salam 2020-06-28T18:40:15.166200Z
i'm not sure whether you've got your answer yet, but here is the result from my quick test on oracle 11.2:
seancorfield 2020-06-28T18:58:45.166700Z
Thank you @abdusalam -- that's exactly what I needed to know (but not the answer I had hoped for!).