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

Add intfastructure to have ENUM columns in INFORMATION_SCHEMA

    XMLWordPrintable

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

            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.