Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-2740

LP:740173 - 5.1-micro reports incorrect Length metadata for TIME expressions

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • None
    • None
    • None

    Description

      Not repeatable with mysql-5.1 . 5.1-micro reports that the Length of a TIME column is 16 characters:

      $ mysql --column-t -e "SELECT CAST('01:01:01' AS TIME)" -uroot --protocol=tcp --port=3306
      Field 1: `CAST('01:01:01' AS TIME)`
      Catalog: `def`
      Database: ``
      Table: ``
      Org_table: ``
      Type: TIME
      Collation: binary (63)
      Length: 16
      Max_length: 8
      Decimals: 0
      Flags: BINARY

      --------------------------

      CAST('01:01:01' AS TIME)

      --------------------------

      01:01:01

      --------------------------

      Attachments

        Activity

          People

            serg Sergei Golubchik
            philipstoev Philip Stoev (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 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.