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

function ROUND incorrect for DATE type

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 1.0.0
    • 5.5.1
    • PrimProc
    • None

    Description

      function ROUND returns the linux time rather than yyymmdd, which is what it used to return. This is a regression when linked with MDB 10.5

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MCOL-3472 ROUND() returns incorrect result

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            David.Hall David Hall (Inactive) added a comment -

            See working_tpch1/qa_fe_cnxFunctions/ROUND.NM.sql

            David.Hall David Hall (Inactive) added a comment - See working_tpch1/qa_fe_cnxFunctions/ROUND.NM.sql
            dleeyh Daniel Lee (Inactive) added a comment -

            Build verified: 5.5.1 (Drone 1233)

            MariaDB [mytest]> select cidx, CDATE, round(CDATE,10) from datatypetestm;
            -------------------------------

            cidx CDATE round(CDATE,10)

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

            1 1997-01-01 19970101
            2 1997-01-01 19970101
            3 1997-01-02 19970102
            4 1997-01-03 19970103
            5 1997-01-04 19970104
            6 2009-12-28 20091228
            7 2009-12-29 20091229
            8 2009-12-30 20091230
            9 2009-12-31 20091231
            10 2009-12-31 20091231
            11 2009-12-31 20091231

            -------------------------------
            11 rows in set (0.011 sec)

            MariaDB [mytest]> select cidx, CDATE, round(CDATE,0) from datatypetestm;
            ------------------------------

            cidx CDATE round(CDATE,0)

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

            1 1997-01-01 19970101
            2 1997-01-01 19970101
            3 1997-01-02 19970102
            4 1997-01-03 19970103
            5 1997-01-04 19970104
            6 2009-12-28 20091228
            7 2009-12-29 20091229
            8 2009-12-30 20091230
            9 2009-12-31 20091231
            10 2009-12-31 20091231
            11 2009-12-31 20091231

            ------------------------------
            11 rows in set (0.011 sec)

            dleeyh Daniel Lee (Inactive) added a comment - Build verified: 5.5.1 (Drone 1233) MariaDB [mytest] > select cidx, CDATE, round(CDATE,10) from datatypetestm; ----- ---------- ---------------- cidx CDATE round(CDATE,10) ----- ---------- ---------------- 1 1997-01-01 19970101 2 1997-01-01 19970101 3 1997-01-02 19970102 4 1997-01-03 19970103 5 1997-01-04 19970104 6 2009-12-28 20091228 7 2009-12-29 20091229 8 2009-12-30 20091230 9 2009-12-31 20091231 10 2009-12-31 20091231 11 2009-12-31 20091231 ----- ---------- ---------------- 11 rows in set (0.011 sec) MariaDB [mytest] > select cidx, CDATE, round(CDATE,0) from datatypetestm; ----- ---------- --------------- cidx CDATE round(CDATE,0) ----- ---------- --------------- 1 1997-01-01 19970101 2 1997-01-01 19970101 3 1997-01-02 19970102 4 1997-01-03 19970103 5 1997-01-04 19970104 6 2009-12-28 20091228 7 2009-12-29 20091229 8 2009-12-30 20091230 9 2009-12-31 20091231 10 2009-12-31 20091231 11 2009-12-31 20091231 ----- ---------- --------------- 11 rows in set (0.011 sec)

            People

              dleeyh Daniel Lee (Inactive)
              David.Hall David Hall (Inactive)
              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.