Announcement

Collapse
No announcement yet.

did not fully support "ON UPDATE CURRENT_TIMESTAMP" for a long time...

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • did not fully support "ON UPDATE CURRENT_TIMESTAMP" for a long time...

    when I set a row of datetime, checked "update by current timestamp", then save ...
    this checkbox would be unchecked automatically, and never turns out...
    but in DDL and desc, it is configured successfully, just not shown in navicat
    it seems there has something wrong when navicat try to analyze mariadb's table structure

    sample:

    CREATE TABLE "dev_time" (
    "id" int(11) NOT NULL,
    "time" datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY ("id")
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

    mariadb version:
    mysql Ver 15.1 Distrib 10.2.14-MariaDB, for Linux (x86_64) using readline 5.1

    with navicat 12.1.16-64bit,
    both premium and mariadb version has this problem...

  • #2
    Hi shen1982,

    Could you please provide the results returned by this query?

    SHOW FULL COLUMNS FROM `dev_time`

    Comment


    • #3
      mayho thanks for replying. ╰( ̄▽ ̄)╮

      like this ↓

      Click image for larger version  Name:	TIM截图20190301141702.png Views:	1 Size:	12.5 KB ID:	5401

      Click image for larger version  Name:	TIM截图20190301142101.png Views:	1 Size:	30.1 KB ID:	5402
      Last edited by shen1982; 03-01-2019, 05:26 AM.

      Comment


      • #4
        Hi shen1982,

        Thanks for the information. We are able to identify the problem and our development team is trying to fix it. We will contact you after the bug is fixed.

        Comment


        • #5
          Hi shen1982,


          We are glad to tell you that Navicat (Windows) version 12.1.17 has been released and fixed your reported problem. Please upgrade to this latest version. You can simply choose Help -> Check for Updates from the menu bar.

          Comment

          Working...
          X