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

Want to know creation TIME of tables using SQL

    XMLWordPrintable

Details

    • New Feature
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Won't Do
    • 1.1.6
    • Icebox
    • N/A
    • None
    • CentOS Linux release 7.5.1804 (Core)
      Server version: 10.2.17-MariaDB-log Columnstore 1.1.6-1

    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.

      Attachments

        Activity

          People

            toddstoffel Todd Stoffel (Inactive)
            k-yaegashi Keita Yaegashi
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.