[jira] Commented: (CAY-1084) openbase does not like our join syntax :(

From: Andrus Adamchik (JIRA) ("Andrus)
Date: Tue Jul 01 2008 - 16:22:52 EDT

  • Next message: Tore Halset (JIRA): "[jira] Commented: (CAY-1084) openbase does not like our join syntax :("

        [ https://issues.apache.org/cayenne/browse/CAY-1084?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12989#action_12989 ]

    Andrus Adamchik commented on CAY-1084:
    --------------------------------------

    I suspected some of the DB's won't like the new syntax.... Actually I think the current mechanism is flexible enough to generate "legacy" joins per adapter.

    OpenBase seems to even support outer joins, via a really weird syntax (from the link you posted) :

    "OpenBase supports left outer joins, meaning that records from tables specified first are included even when they cannot be matched with records from tables on the right. An outer join is specified by using the * operator in place of the = operator in the WHERE statement. Here is an example:

    SELECT mov.TITLE, mov.CATEGORY, stu.NAME FROM MOVIE mov, STUDIO stu WHERE mov.STUDIO_ID * stu.STUDIO_ID "

    > openbase does not like our join syntax :(
    > -----------------------------------------
    >
    > Key: CAY-1084
    > URL: https://issues.apache.org/cayenne/browse/CAY-1084
    > Project: Cayenne
    > Issue Type: Bug
    > Components: Cayenne Core Library
    > Affects Versions: 3.0
    > Environment: OpenBase 10.0.11
    > Reporter: Tore Halset
    >
    > Hello.
    > Just tried the junit tests on OpenBase and it did not work very well. A lot of the problems is from the join syntax that OpenBase seem to have problems with.
    > INFO: SELECT t0.COLLECTION_TO_MANY_ID, t0.ID FROM COLLECTION_TO_MANY_TARGET t0 JOIN COLLECTION_TO_MANY t1 ON (t0.COLLECTION_TO_MANY_ID = t1.ID) WHERE t1.ID = ? [bind: 1->ID:1]
    > INFO: *** error.
    > java.sql.SQLException: SQL ERROR - [position 72, near 'JOIN' in '_TARGET t0 JOIN COLLECTIO'] comma or JOIN syntax expected but not found in from clause.
    > SQL: SELECT t0.COLLECTION_TO_MANY_ID, t0.ID FROM COLLECTION_TO_MANY_TARGET t0 JOIN COLLECTION_TO_MANY t1 ON (t0.COLLECTION_TO_MANY_ID = t1.ID) WHERE t1.ID = 1
    > at com.openbase.net.c.a(Unknown Source)
    > at com.openbase.jdbc.c.a(Unknown Source)
    > at com.openbase.jdbc.c.a(Unknown Source)
    > at com.openbase.jdbc.i.executeQuery(Unknown Source)
    > at org.apache.cayenne.access.jdbc.SelectAction.performAction(SelectAction.java:73)
    > This looks like the documentation for select statements including join. The "JOIN" keyword is not shown at all.
    > http://www.openbase.com/help/KnowledgeBase/400_OpenBaseSQL/401_SelectStatements.html 

    -- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

    This archive was generated by hypermail 2.0.0 : Tue Jul 01 2008 - 16:23:22 EDT