Uploaded image for project: 'MariaDB MaxScale'
  1. MariaDB MaxScale
  2. MXS-2733

UTC_TIMESTAMP not recognized as a built-in function

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.3.12
    • Fix Version/s: 2.3.13, 2.4.3
    • Component/s: qc_sqlite
    • Labels:
      None

      Description

      The following query is treated as a write:

      SELECT UTC_TIMESTAMP();

      The log_info output:

      2019-10-28 07:54:47   info   : (1) > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 27, type: QUERY_TYPE_READ|QUERY_TYPE_WRITE, stmt: SELECT UTC_TIMESTAMP()

        Attachments

          Activity

            People

            Assignee:
            johan.wikman Johan Wikman
            Reporter:
            markus makela markus makela
            Votes:
            1 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration