[MCOL-2042] Want to know creation TIME of tables using SQL Created: 2018-12-20 Updated: 2022-11-05 Resolved: 2022-11-05 |
|
| Status: | Closed |
| Project: | MariaDB ColumnStore |
| Component/s: | N/A |
| Affects Version/s: | 1.1.6 |
| Fix Version/s: | Icebox |
| Type: | New Feature | Priority: | Major |
| Reporter: | Keita Yaegashi | Assignee: | Todd Stoffel (Inactive) |
| Resolution: | Won't Do | Votes: | 0 |
| Labels: | None | ||
| Environment: |
CentOS Linux release 7.5.1804 (Core) |
||
| Epic Link: | ColumnStore Compatibility Improvements |
| Description |
|
The create_time column of information_schema.tables, whose type is DATETIME, is always NULL for any ColumnStore tables, and the creation_date column of information_schema.columnstore_tables contains only DATE. It means we have no means to get TIME using SQL when the table by ColumnStore was created. If there is no special reason why getting TIME should be unavailable, I want some kind of function to show both DATE and TIME of specified table. |
| Comments |
| Comment by Todd Stoffel (Inactive) [ 2022-11-05 ] |
|
Item is out of date. Closing due to inactivity. If you feel this was done in error please open a new ticket. |