Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-6609

Documentation for SQL features should reflect current standard

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.11.1.1
    • Fix Version/s: 10.11.1.1
    • Component/s: Documentation
    • Labels:
      None

      Description

      We document Derby as an SQL-92 database. This standard is now very old, and we should describe how Derby conforms to the most current standard (SQL:2011). Knut Anders Hatlen listed the relevant features in a comment to DERBY-6605.

      This will involve at a minimum replacing the "Derby support for SQL-92 features" topic (http://db.apache.org/derby/docs/10.10/ref/rrefsql9241891.html) with a new one that describes Derby's support for current features, with notes as needed indicating when the support is partial. Only features Derby supports, fully or partially, should be listed. We should state that features not listed are not supported.

      The information would be taken from http://wiki.apache.org/db-derby/SQLvsDerbyFeatures (which currently goes only through the 2003 standard). Listing the Feature IDs in the documentation would also be helpful.

      Other topics should be changed as needed. For example, is the term "SQL92Identifier" still correct?

        Attachments

        1. DERBY-6609.diff
          58 kB
          Camilla Haase
        2. DERBY-6609.stat
          0.1 kB
          Camilla Haase
        3. DERBY-6609.zip
          12 kB
          Camilla Haase
        4. DERBY-6609-2.diff
          55 kB
          Camilla Haase
        5. DERBY-6609-2.zip
          12 kB
          Camilla Haase
        6. DERBY-6609-3.diff
          109 kB
          Camilla Haase
        7. DERBY-6609-3.diff
          69 kB
          Camilla Haase
        8. DERBY-6609-3.stat
          0.2 kB
          Camilla Haase
        9. DERBY-6609-3.zip
          14 kB
          Camilla Haase
        10. DERBY-6609-3.zip
          12 kB
          Camilla Haase
        11. DERBY-6609-4.diff
          47 kB
          Camilla Haase
        12. DERBY-6609-4.stat
          2 kB
          Camilla Haase
        13. DERBY-6609-4.zip
          126 kB
          Camilla Haase
        14. DERBY-6609-5.diff
          4 kB
          Camilla Haase
        15. DERBY-6609-5.stat
          0.1 kB
          Camilla Haase
        16. DERBY-6609-5.zip
          15 kB
          Camilla Haase
        17. DERBY-6609-6.diff
          8 kB
          Camilla Haase
        18. DERBY-6609-6.stat
          0.1 kB
          Camilla Haase
        19. DERBY-6609-6.zip
          13 kB
          Camilla Haase
        20. DERBY-6609-7.diff
          2 kB
          Camilla Haase
        21. rrefsqlstandard.html
          82 kB
          Camilla Haase

          Issue Links

            Activity

              People

              • Assignee:
                chaase3 Camilla Haase
                Reporter:
                chaase3 Camilla Haase
              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: