Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
1.4.3
-
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
- relates to
-
-
- Closed
-
Activity
| Field | Original Value | New Value |
|---|---|---|
| Description | While timestamp is a supported datatype, one cannot use it in create table select. The capability is important for usability of HTAP. |
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) |
| Assignee | Gregory Dorman [ gdorman ] |
| 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) |
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]> |
| Assignee | Gregory Dorman [ gdorman ] | Jose Rojas [ jrojas ] |
| Rank | Ranked higher |
| Rank | Ranked lower |
| Fix Version/s | Icebox [ 22302 ] |
| Assignee | Jose Rojas [ jrojas ] |
| Component/s | PrimProc [ 13700 ] | |
| Resolution | Duplicate [ 3 ] | |
| Status | Open [ 1 ] | Closed [ 6 ] |