Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-40693

Documentation issues with reserved words

    XMLWordPrintable

Details

    • Bug
    • Status: Confirmed (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • N/A
    • Documentation
    • None

    Description

      I found a few inaccuracies in the reserved word manual page at https://mariadb.com/docs/server/reference/sql-structure/sql-language-structure/reserved-words

      Two entries on this page are not actually reserved words, at least in any server version I've tested:

      • ST_COLLECT (> 11.8) - this is also mentioned (incorrectly) as being newly reserved in 12.3+ on https://mariadb.com/docs/release-notes/community-server/12.3/mariadb-12.3-changes-and-improvements but isn't actually reserved in 11.8, 12.0, 12.3, etc
      • deleted textMINUS (> 10.6.0) - think this was recently added to the page, I don't recall seeing it previously; in any case it isn't reserved in 10.6, 10.7, 12.3, or any other version in between that I've tried – apologies, missed that this was in the Oracle mode section only, please disregard

      In a few other recent entries, the version-added information is confusing. For example is "> 12.2" supposed to mean 12.3+, or 12.2+? It's used inconsistently:

      • OFFSET (> 10.6) became reserved in 10.6 and up
      • ROW_NUMBER (> 10.7) became reserved in 10.7 and up
      • VECTOR (> 11.6) became reserved in 11.7 and up
      • CONVERSION (> 12.2) became reserved in 12.3 and up
      • TO_DATE (> 12.2) became reserved in 12.3 and up

      Perhaps this would be clearer as e.g. "12.3+" or "added in 12.3", instead of using greater-than?

      Sorry for being so nitpicky here! My software has a reserved word linter so I use this page a lot...

      Attachments

        Issue Links

          Activity

            People

              maxmether Max Mether
              evanelias Evan Elias
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.