Uploaded image for project: 'MariaDB MaxScale'
  1. MariaDB MaxScale
  2. MXS-2285

Add CREATE TABLE parsing into the query classifier

    XMLWordPrintable

Details

    • New Feature
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 2.4
    • N/A
    • N/A
    • None

    Description

      The following information from a CREATE TABLE statement is needed:

      • Presence of indexes
      • Table options (specifically the ENGINE=... option)

      The most important part is the capability to find out whether a CREATE TABLE statement contains index definitions or explicit ENGINE options. Optionally the following would speed up the processing:

      • Table name
      • Field names
      • Field types (INT, VARCHAR etc.)
      • Field attributes (UNSIGNED, NOT NULL)

      For the field information, indexes must be identified and removed from the SQL statement as they aren't supported by ColumnStore. Unsupported types must also be converted to supported ones (in practice only SERIAL needs to be replaced with BIGINT UNSIGNED). For the table options, the main goal is to filter out any options that aren't supported by the ColumnStore engine and to remove explicit ENGINE=... options.

      Attachments

        Activity

          People

            johan.wikman Johan Wikman
            markus makela markus makela
            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.