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

INFORMATION_SCHEMA.COLLATION_PROPERTIES

        Details

        • Type: Task
        • Status: Open
        • Priority: Minor
        • Resolution: Unresolved
        • Fix Version/s: 10.1, 10.0
        • Component/s: None
        • Labels:
          None

          Description

          We'll intorduce a new table INFORMATION_SCHENA.COLLATION_PROPERTIES with
          the following structure:

          CREATE TABLE INFORMATION_SCHEMA.COLLATION_PROPERTIES
{
  ID INT NOT NULL,
  TAILORING TEXT CHARACTER SET utf8,
  USE_COUNT BIGINT NOT NULL
};

          Column description

          • The column TAILORING will return collation definition rules for UCA based
            collations (as defined in strings/ctype-uca.c or in Index.xml) and NULL for non-UCA collations. For example: 
            MariaDB [test]> SELECT TAILORING FROM INFORMATION_SCHEMA.COLLATIONS WHERE ID=202;
+-----------------------------------------------------+
| TAILORING                                           |
+-----------------------------------------------------+
| & C < \u010D <<< \u010C ... & Z < \u017E <<< \u017D |
+-----------------------------------------------------+
          • The column USE_COUNT will contain collation usage statistics,
            similar to what was previously added into INFORMATION_SCHEMA.PLUGINS
            under terms of MDEV-6274. Unlike I_S.PLUGINS (which exists only if the
            feedback plugins is loaded into the server), the new table
            INFORMATION_SCHEMA.COLLATION_PROPERTIES will always
            exist, thus the column USE_COUNT will give an alternative always available
            access to the collation usage statistics.
          • In the future there will be more fields for other properties,
            like case sensitivity, accent sensitivity, Kana sensitivity,
            Unicode version, number of levels for comparison and sort, etc.

            Gliffy Diagrams

              Attachments

                Issue Links

                relates to

                Task - A task that needs to be done. MDEV-6274 Collation usage statistics

                • Major - Major loss of function.
                • Closed

                  Activity

                  There are no comments yet on this issue.

                    People

                    • Assignee:
                      bar Alexander Barkov
                      Reporter:
                      bar Alexander Barkov
                    • Votes:
                      0 Vote for this issue
                      Watchers:
                      2 Start watching this issue

                      Dates

                      • Created:
                        Updated: