Uploaded image for project: 'MariaDB Connector/J'
  1. MariaDB Connector/J
  2. CONJ-823

SEC_TO_TIME wraps time at 24 hours

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Not a Bug
    • Affects Version/s: 2.6.2
    • Fix Version/s: 3.0.0
    • Component/s: JDBC 4.2 compatibility
    • Labels:
      None
    • Environment:
      Linux, MariaDB 10.3, MariaDB 10.5

      Description

      SEC_TO_TIME should support converting seconds to the TIME data type, inside the representation limits of the TIME data type.

      However, it looks like the JDBC connector wraps the result at 24 hours.

      E.g. using the `mariadb` client:

      MariaDB [(none)]> SELECT SEC_TO_TIME(257394);
      ---------------------

      SEC_TO_TIME(257394)

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

      71:29:54

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

      E.g. using the JDBC connector to execute the same query:
      23:29:54
      (i.e. 71:29:54 minus 2*24h)

      It might be interesting to note that the MySQL JDBC connector returns `NULL` for the same query.

        Attachments

          Activity

            People

            Assignee:
            diego dupin Diego Dupin
            Reporter:
            vmsh0 Riccardo Paolo Bestetti
            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.