Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-76

TIMESTAMPADD() and TIMESTAMPDIFF() returned syntax error when FRAC_SECOND is used

    XMLWordPrintable

Details

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

    Description

      Build tested:

      getcalpontsoftwareinfo Mon May 23 15:52:13 2016

      Name : infinidb-platform Relocations: (not relocatable)
      Version : 5.0 Vendor: MariaDB, Inc.
      Release : 0 Build Date: Sun 15 May 2016 07:24:29 PM CDT
      Install Date: Mon 16 May 2016 05:21:51 PM CDT Build Host: srvbuilder

      The issue was identified by Autopilot's functions test:

      MariaDB [mytest]> select cidx, CDATE, TIMESTAMPADD(FRAC_SECOND,5,CDATE) from datatypetestm order by cidx;
      ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'FRAC_SECOND,5,CDATE) from datatypetestm order by cidx' at line 1
      MariaDB [mytest]> select cidx, CDATETIME, TIMESTAMPADD(FRAC_SECOND,5,CDATETIME) from datatypetestm order by cidx;
      ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'FRAC_SECOND,5,CDATETIME) from datatypetestm order by cidx' at line 1
      MariaDB [mytest]> select cidx, CDATE, TIMESTAMPDIFF(FRAC_SECOND,CDATE, '2011-05-06 11:09:36') from datatypetestm order by cidx;
      ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'FRAC_SECOND,CDATE, '2011-05-06 11:09:36') from datatypetestm order by cidx' at line 1
      MariaDB [mytest]> select cidx, CDATETIME, TIMESTAMPDIFF(FRAC_SECOND,CDATETIME, '2011-05-06 11:09:36') from datatypetestm order by cidx;
      ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'FRAC_SECOND,CDATETIME, '2011-05-06 11:09:36') from datatypetestm order by cidx' at line 1

      Attachments

        Activity

          People

            dleeyh Daniel Lee (Inactive)
            dleeyh Daniel Lee (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.