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

LP:769583 - 5.1-micro length of TIME datatype is wrong

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • None
    • None
    • None

    Description

      The length of TIME column is reported as 9 in this 5.1-micro, but 8 otherwise.

      To reproduce,
      mysql -uroot -e "select time('01:01:01')"

      It reports :
      Field 1: `time('01:01:01')`
      Catalog: `def`
      Database: ``
      Table: ``
      Org_table: ``
      Type: TIME
      Collation: binary (63)
      Length: 9
      Max_length: 8
      Decimals: 31
      Flags: BINARY

      Length field should be 8, not 9

      Attachments

        Activity

          People

            serg Sergei Golubchik
            wlad Vladislav Vaintroub
            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.