Details

    • Type: Improvement Improvement
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 10.3.1.4
    • Component/s: SQL
    • Labels:
      None

      Description

      I suggest to implement a SQL statement to create and fill a table with a query, without having to write the columns definition.

      e.g.:

      CREATE TABLE new_table AS SELECT ...;

      or:

      SELECT ... INTO new_table FROM ...;

      1. Derby64Patch4.txt
        21 kB
        James F. Adams
      2. Derby64Patch3.txt
        18 kB
        James F. Adams
      3. Derby64Patch2.txt
        11 kB
        James F. Adams
      4. Derby64Patch1.txt
        12 kB
        James F. Adams

        Issue Links

          Activity

          Gavin made changes -
          Workflow jira [ 38321 ] Default workflow, editable Closed status [ 12801254 ]
          Kathey Marsden made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Dag H. Wanvik made changes -
          Issue Type New Feature [ 2 ] Improvement [ 4 ]
          A B made changes -
          Link This issue is related to DERBY-2605 [ DERBY-2605 ]
          Dag H. Wanvik made changes -
          Link This issue relates to DERBY-2593 [ DERBY-2593 ]
          Daniel John Debrunner made changes -
          Link This issue relates to DERBY-2288 [ DERBY-2288 ]
          Daniel John Debrunner made changes -
          Resolution Fixed [ 1 ]
          Assignee James F. Adams [ james.f.adams ]
          Fix Version/s 10.3.0.0 [ 12310800 ]
          Status In Progress [ 3 ] Resolved [ 5 ]
          James F. Adams made changes -
          Assignee James F. Adams [ james.f.adams ]
          A B made changes -
          Derby Info [Patch Available]
          James F. Adams made changes -
          Attachment Derby64Patch4.txt [ 12348734 ]
          James F. Adams made changes -
          Attachment Derby64Patch4.txt [ 12348732 ]
          James F. Adams made changes -
          Attachment Derby64Patch4.txt [ 12348732 ]
          Daniel John Debrunner made changes -
          Comment [ James - here's the top-level wiki page on derby's Junit tests.
          ]
          James F. Adams made changes -
          Attachment Derby64Patch3.txt [ 12348617 ]
          James F. Adams made changes -
          Attachment Derby64Patch2.txt [ 12346833 ]
          James F. Adams made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          James F. Adams made changes -
          Derby Info [Patch Available]
          James F. Adams made changes -
          Attachment Derby64Patch1.txt [ 12345789 ]
          James F. Adams made changes -
          Field Original Value New Value
          Assignee James F. Adams [ james.f.adams ]
          Christian d'Heureuse created issue -

            People

            • Assignee:
              James F. Adams
              Reporter:
              Christian d'Heureuse
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development