Details

    • Type: Improvement Improvement
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 10.6.1.0
    • Fix Version/s: 10.6.1.0
    • Component/s: SQL
    • Labels:
      None
    • Environment:
      any
    • Issue & fix info:
      Release Note Needed

      Description

      Implement the CROSS JOIN syntax

      SELECT * from t1 CROSS JOIN t2;

      as an alternative syntax to

      SELECT * FROM t1, t2;

      This should be pretty straight forward and ease the migration of SQL code to Derby.

      1. releaseNote.html
        4 kB
        Knut Anders Hatlen
      2. cross_v3.stat
        0.3 kB
        Knut Anders Hatlen
      3. cross_v3.diff
        21 kB
        Knut Anders Hatlen
      4. cross_v2.diff
        13 kB
        Knut Anders Hatlen
      5. cross.diff
        5 kB
        Knut Anders Hatlen

        Issue Links

          Activity

          Gavin made changes -
          Workflow jira [ 12473452 ] Default workflow, editable Closed status [ 12800087 ]
          Kathey Marsden made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Knut Anders Hatlen made changes -
          Link This issue is related to DERBY-4374 [ DERBY-4374 ]
          Knut Anders Hatlen made changes -
          Status In Progress [ 3 ] Resolved [ 5 ]
          Resolution Fixed [ 1 ]
          Knut Anders Hatlen made changes -
          Attachment releaseNote.html [ 12419298 ]
          Knut Anders Hatlen made changes -
          Fix Version/s 10.6.0.0 [ 12313727 ]
          Affects Version/s 10.6.0.0 [ 12313727 ]
          Issue & fix info [Release Note Needed, Patch Available] [Release Note Needed]
          Knut Anders Hatlen made changes -
          Attachment cross_v3.stat [ 12419085 ]
          Knut Anders Hatlen made changes -
          Issue & fix info [Release Note Needed] [Patch Available, Release Note Needed]
          Knut Anders Hatlen made changes -
          Attachment cross_v3.diff [ 12419084 ]
          Knut Anders Hatlen made changes -
          Attachment cross_v2.diff [ 12418913 ]
          Knut Anders Hatlen made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          Knut Anders Hatlen made changes -
          Issue & fix info [Release Note Needed]
          Knut Anders Hatlen made changes -
          Link This issue is related to DERBY-4369 [ DERBY-4369 ]
          Knut Anders Hatlen made changes -
          Assignee Knut Anders Hatlen [ knutanders ]
          Knut Anders Hatlen made changes -
          Attachment cross.diff [ 12418439 ]
          Knut Anders Hatlen made changes -
          Field Original Value New Value
          Component/s SQL [ 11408 ]
          Bernt M. Johnsen created issue -

            People

            • Assignee:
              Knut Anders Hatlen
              Reporter:
              Bernt M. Johnsen
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development