Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-5005

Add charset number to system catalog

    XMLWordPrintable

Details

    • New Feature
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • None
    • 23.10.0
    • None
    • 2023-8

    Description

      When MCOL-4580 was started it is believed that information given by MariaDB's server is sufficient for our purposes. But, it is not.

      INSERT operations, right now, are given charset numbers but not actual collation. And if collations for database differ, we get wrong ranges in MCOL-4580 (linked) which leads to incorrect SELECT results.

      The cpimport utility does not have collation information at all and it should receive it from system catalog queries.

      All-in-all, we need to store in system catalog either pair (charset index, collation index) or just collation index (it appears it is possible to deduce charset index from it) and provide API to fetch these.

      [Note for the documentation team]:
      Upgrade instructions from previous versions of ColumnStore to a version with this feature:
      dbbuilder should perform an automatic upgrade of the system catalog. When the package manager starts the ColumnStore services using systemd during installation, dbbuilder is executed.
      After the upgrade, sanity testing should be performed on the installation to ensure the existing database is not impacted in any way.

      Attachments

        Issue Links

          Activity

            People

              tntnatbry Gagan Goel (Inactive)
              sergey.zefirov Sergey Zefirov
              Roman Roman
              Daniel Lee Daniel Lee (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.