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

cannot use timestamp in create table select for columnstore tables

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 1.4.3
    • Fix Version/s: Icebox
    • Component/s: None
    • Labels:
      None

      Description

      While timestamp is a supported datatype, one cannot use it in create table select. The capability is important for usability of HTAP.

      1. timestamp is a supported type.

      MariaDB [gjd]> create table t2 (t timestamp) engine=columnstore;
      Query OK, 0 rows affected (0.235 sec)

      MariaDB [gjd]> show create table t2;
      -------------------------------------------------------------------------------------------------------------------------------------------------------+

      Table Create Table

      -------------------------------------------------------------------------------------------------------------------------------------------------------+

      t2 CREATE TABLE `t2` (
      `t` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
      ) ENGINE=Columnstore DEFAULT CHARSET=utf8

      -------------------------------------------------------------------------------------------------------------------------------------------------------+

      2. But cannot be used in create table select.

      a) MariaDB [gjd]> create table t3 engine=columnstore select current_timestamp();
      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 [gjd]>

      b) MariaDB [gjd]> create table t3inno engine=innodb select current_timestamp();
      Query OK, 1 row affected (0.027 sec)
      Records: 1 Duplicates: 0 Warnings: 0

      MariaDB [gjd]> show create table t3inno;
      --------------------------------------------------------------------------------------------------------------+

      Table Create Table

      --------------------------------------------------------------------------------------------------------------+

      t3inno CREATE TABLE `t3inno` (
      `current_timestamp()` datetime NOT NULL
      ) ENGINE=InnoDB DEFAULT CHARSET=utf8

      --------------------------------------------------------------------------------------------------------------+
      1 row in set (0.000 sec)

      MariaDB [gjd]> create table t3cs engine=columnstore select * from t3inno;
      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 [gjd]>

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              gdorman Gregory Dorman
              Votes:
              1 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:

                  Git Integration