Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add support for Oracle's PARTITION BY clause in OUTER JOINs #1645

Closed
lukaseder opened this issue Jul 31, 2012 · 0 comments

Comments

@lukaseder
Copy link
Member

@lukaseder lukaseder commented Jul 31, 2012

Oracle allows for a PARTITION BY clause in OUTER JOINs:

outer_join_clause::=
      [ query_partition_clause ]
    { outer_join_type JOIN
    | NATURAL [ outer_join_type ] JOIN
    }
    table_reference [ query_partition_clause ]
      [ ON condition
      | USING ( column [, column ]...)
      ]

query_partition_clause::=
    PARTITION BY
      { value_expr[, value_expr ]...
      | ( value_expr[, value_expr ]... )
      }

See the documentation of the SELECT statement here:
http://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_10002.htm

For jOOQ-internal implementation reasons, the PARTITION BY clause to the left of the JOIN keyword is not yet implemented, neither is a NATURAL { LEFT | RIGHT } OUTER JOIN [x] PARTITION BY [y] not yet supported. i.e. the effectively implemented syntax subset is this:

outer_join_clause::=
    { outer_join_type JOIN table_reference [ query_partition_clause ]
    | NATURAL [ outer_join_type ] JOIN table_reference
    }
    outer_join_condition

outer_join_condition::=
      [ ON condition
      | USING ( column [, column ]...)
      ]

query_partition_clause::=
    PARTITION BY
      { value_expr[, value_expr ]...
      | ( value_expr[, value_expr ]... )
      }
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
1 participant
You can’t perform that action at this time.