[postmodern-devel] query with keyword :on

[Jens Teich]

Marijn Haverbeke wrote:
> So could you give me the error message? That might give me a chance to
> figure out what the problem is.
> 
> Cheers,
> Marijn

Here are two queries which should produce the same result

WEBCAT 36 > (postmodern:with-connection ("web_access" "web_access" "***" "localhost")
              (postmodern:query
               (:select 'pmw.wert
                :from (:as 'projekt-merkmale-werte 'pmw)
                      (:as 'projekt-elemente       'pe)
                :where (:and
                        (:= 'pmw.guid-produkt 'pe.guid-objekt)
                        (:= 'pe.guid "rzt732819vlurc5827955302wwxz8b")
                        (:= 'pmw.merkmal-id "MID1008519")
                        (:= 'pmw.lang-id "de")))))
(("30 N") ("30 N") ("30 N") ("30 N"))

WEBCAT 37 > (postmodern:with-connection ("web_access" "web_access" "***" "localhost")
              (postmodern:query
               (:select 'pmw.wert
                :from (:as 'projekt-merkmale-werte 'pmw)
                :inner-join (:as 'projekt-elemente       'pe)
                :on         (:= 'pmw.guid-produkt 'pe.guid-objekt)
                :where (:and
                        (:= 'pe.guid "rzt732819vlurc5827955302wwxz8b")
                        (:= 'pmw.merkmal-id "MID1008519")
                        (:= 'pmw.lang-id "de")))))

Error: Database error 42601: syntax error at or near "on"
Query: (SELECT pmw.wert FROM projekt_merkmale_werte AS pmw INNER JOIN projekt_elemente AS pe ON (pmw.guid_produkt = pe.guid_objekt), projekt_elemente AS pe, on, (pmw.guid_produkt = pe.guid_objekt) WHERE ((pe.guid = 'rzt732819vlurc5827955302wwxz8b') and (pmw.merkmal_id = 'MID1008519') and (pmw.lang_id = 'de')))

Jens