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

Add intfastructure to have ENUM columns in INFORMATION_SCHEMA

Details

    Description

      Marko asked for a simple way to have ENUM columns in I_S.

      This task will introduce helper classes, so a ENUM will be declared as simply as follows:

      static const LEX_CSTRING io_values[]=
      		 
      {
      		 
        STRING_WITH_LEN("IO_NONE"),
      		 
        STRING_WITH_LEN("IO_READ"),
      		 
        STRING_WITH_LEN("IO_WRITE"),
      		 
        STRING_WITH_LEN("IO_PIN")
      		 
      };
      		 
       
      		 
      static TypelibBuffer<4> io_values_typelib(io_values);

      A definition of a column using the above ENUM declaration will look about like this:

        Column("IO_FIX", Enum(&io_values_typelib), NULLABLE),

      This task will change INFORMATION_SCHEMA.INNODB_BUFFER_PAGE.IO_FIX from VARCHAR(64) to ENUM.

      Attachments

        Issue Links

          blocks

          Task - A task that needs to be done. MDEV-19940 Clean up INFORMATION_SCHEMA.INNODB_ tables

          • Major - Major loss of function.
          • Closed
          is blocked by

          Task - A task that needs to be done. MDEV-19863 Add const to TYPELIB pointers

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            bar Alexander Barkov created issue -
            bar Alexander Barkov made changes -
            Field Original Value New Value
            bar Alexander Barkov made changes -
            issue.field.resolutiondate 2019-06-26 02:48:17.0 2019-06-26 02:48:17.905
            bar Alexander Barkov made changes -
            Fix Version/s 10.5.0 [ 23709 ]
            Fix Version/s 10.5 [ 23123 ]
            Resolution Fixed [ 1 ]
            Status Open [ 1 ] Closed [ 6 ]
            marko Marko Mäkelä made changes -
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 97752 ] MariaDB v4 [ 134012 ]

            People

              bar Alexander Barkov
              bar Alexander Barkov
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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