LauJensen / clojureql

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

Problem with table containing underscores #92

Closed r0man closed 13 years ago

r0man commented 13 years ago

The following query

(defn select-contact-classes-1 [campaign-id max-class]
  (-> (table :campaign_contact_classes)
      (select (where (and (= :campaign_id campaign-id)
                          (< :contact_class max-class))))))

should produce

SELECT campaign_contact_classes.*
  FROM campaign_contact_classes
 WHERE ((campaign_contact_classes.campaign_id = 9796)
   AND (campaign_contact_classes.contact_class < 8))

but does this instead:

SELECT campaign_contact_classes.*
  FROM campaign_contact_classes
 WHERE ((campaign_campaign_contact_classes.contact_classes.campaign_id = 9796)
   AND (campaign_contact_classes.contact_class < 8))