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

TIMESTAMP data type is accepted but causes invalid (unsupported) data structure, mysqldump fails

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Confirmed (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 1.4.2, 1.5.3
    • Fix Version/s: Icebox
    • Component/s: None
    • Labels:
      None

      Description

      The problem is caused by a combination of fixed MCOL-265 (support for TIMESTAMP) and unfixed MCOL-1039 (support for CURRENT_TIMESTAMP).

      drop table if exists t1;
      create table t1 (a timestamp) engine=Columnstore;
      show create table t1;
      

      By default, TIMESTAMP column in MariaDB server has CURRENT_TIMESTAMP as default/on update value. So, the resulting table is

      CREATE TABLE `t1` (
        `a` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
      ) ENGINE=Columnstore DEFAULT CHARSET=latin1
      

      However, since current_timestamp is not supported for Columnstore, this statement cannot be run:

      MariaDB [db]> CREATE TABLE `t1` (
          ->   `a` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
          -> ) ENGINE=Columnstore DEFAULT CHARSET=latin1
          -> ;
      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.
      

      It means that tools which rely on the output of SHOW CREATE TABLE – importantly, mysqldump, but there might be others – will fail as long as there is at least one such table.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              alexey.antipovsky Alexey Antipovsky
              Reporter:
              elenst Elena Stepanova
              Votes:
              2 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

                Created:
                Updated:

                  Git Integration