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

ColumnStore table whose name contains $ cannot be renamed

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 1.1.6
    • 1.2.2
    • None
    • None
    • CentOS Linux release 7.5.1804 (Core)
      Server version: 10.2.17-MariaDB-log Columnstore 1.1.6-1
    • 2018-20

    Description

      MariaDB [testdatabase]> CREATE TABLE rename_able (test INT(11)) ENGINE=Columnstore;
      Query OK, 0 rows affected (0.15 sec)
       
      MariaDB [testdatabase]> RENAME TABLE rename_able TO yes_renamed;
      Query OK, 0 rows affected (0.08 sec)
       
      MariaDB [testdatabase]> DROP TABLE yes_renamed;
      Query OK, 0 rows affected (1.22 sec)
       
      MariaDB [testdatabase]> CREATE TABLE dollar$_table (test INT(11)) ENGINE=Columnstore;
      Query OK, 0 rows affected (0.19 sec)
       
      MariaDB [testdatabase]> RENAME TABLE dollar$_table TO dollar$_also_renamed;
      ERROR 1178 (42000): The storage engine for the table doesn't support The syntax or the data type(s) is not supported by Columnstore. Please check the Columnstore syntax guide for supported syntax or data types.
      MariaDB [testdatabase]> DROP TABLE dollar$_table;
      Query OK, 0 rows affected (1.66 sec)
       
      MariaDB [testdatabase]> CREATE TABLE rename_able (test INT(11)) ENGINE=Columnstore;
      Query OK, 0 rows affected (0.17 sec)
       
      MariaDB [testdatabase]> RENAME TABLE rename_able TO dollar$;
      ERROR 1178 (42000): The storage engine for the table doesn't support The syntax or the data type(s) is not supported by Columnstore. Please check the Columnstore syntax guide for supported syntax or data types.
      MariaDB [testdatabase]> DROP TABLE rename_able;
      Query OK, 0 rows affected (1.35 sec)
       
      MariaDB [testdatabase]> status;
      --------------
      /usr/local/mariadb/columnstore/mysql/bin/mysql  Ver 15.1 Distrib 10.2.17-MariaDB, for Linux (x86_64) using readline 5.1
       
      Connection id:		2607
      Current database:	testdatabase
      Current user:		testdatabaseadmin@localhost
      SSL:			Not in use
      Current pager:		stdout
      Using outfile:		''
      Using delimiter:	;
      Server:			MariaDB
      Server version:		10.2.17-MariaDB-log Columnstore 1.1.6-1
      Protocol version:	10
      Connection:		Localhost via UNIX socket
      Server characterset:	latin1
      Db     characterset:	latin1
      Client characterset:	utf8
      Conn.  characterset:	utf8
      UNIX socket:		/usr/local/mariadb/columnstore/mysql/lib/mysql/mysql.sock
      Uptime:			17 days 40 min 19 sec
       
      Threads: 10  Questions: 22504  Slow queries: 0  Opens: 5984  Flush tables: 1  Open tables: 52  Queries per second avg: 0.015
      --------------
       
      MariaDB [testdatabase]> 
      

      The reasons why this issue should be fixed are:

      • In MySQL syntax, $ is available for table name without ` same as _.
      • As CREATE TABLE works with $, RENAME TABLE and ALTER TABLE RENAME also have to work.

      Attachments

        Issue Links

          Activity

            People

              dleeyh Daniel Lee (Inactive)
              k-yaegashi Keita Yaegashi
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.