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

Documentation for SQL features should reflect current standard

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 10.11.1.1
    • 10.11.1.1
    • Documentation
    • 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
          69 kB
          Camilla Haase
        7. DERBY-6609-3.zip
          12 kB
          Camilla Haase
        8. DERBY-6609-3.diff
          109 kB
          Camilla Haase
        9. DERBY-6609-3.stat
          0.2 kB
          Camilla Haase
        10. DERBY-6609-3.zip
          14 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

              chaase3 Camilla Haase
              chaase3 Camilla Haase
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: