LauJensen / clojureql

ClojureQL is superior SQL integration for Clojure
https://clojureql.sabrecms.com
Eclipse Public License 1.0
284 stars 39 forks source link

Renaming with aliases generates invalid SQL #139

Closed rm-hull closed 11 years ago

rm-hull commented 11 years ago
(testing "simple renaming"
  (are [x y] (= (-> x (compile nil) interpolate-sql) y)
       (-> (table :users)
           (project [:users.id])
           (rename {:users.id :idx}))
       "SELECT users.id FROM users AS users(idx)"))

(testing "renaming with a table alias"
  (are [x y] (= (-> x (compile nil) interpolate-sql) y)
       (-> (table {:users :people})
           (project [:people.id])
           (rename {:people.id :idx}))
       "SELECT people.id FROM users people AS people(idx)"))

Second test fails as generated SQL is: SELECT people.id FROM users people AS users people()

rm-hull commented 11 years ago

Created pull request #140 to resolve this