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

Unable to rename table with special chars

    XMLWordPrintable

Details

    Description

      Hi,
      I'm unable to rename a column with a special char in the name.

      The below example throw the error:
      SQL Error [1815] [HY000]: (conn=14) Internal error: CAL0001: Alter table Failed: MCS-2006: 'INTERNAL_DD.A@002d' does not exist in Columnstore.

      drop table IF EXISTS `A-`, `B`;
      create table `A-` (i int) ENGINE = ColumnStore;
      alter table `A-` rename to `B`
      ----------------------
      The below example works.

      drop table IF EXISTS `A`, `Aa` ;
      create table `A` (i int) ENGINE = ColumnStore;
      alter table `A` rename to `Aa`
      -------------
      [root@devel ~]# dnf list installed | grep columns
      MariaDB-columnstore-cmapi.x86_64 23.10.0-1 @mariadb-main
      MariaDB-columnstore-engine.x86_64 11.2.3_23.10.0-1.el8 @mariadb-main

      Bye Enrico

      Attachments

        Activity

          People

            Unassigned Unassigned
            enricosimon Enrico Simon
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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