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) created issue -
            David.Hall David Hall (Inactive) made changes -
            Field Original Value New Value
            Assignee David Hall [ david.hall ]
            toddstoffel Todd Stoffel (Inactive) made changes -
            Rank Ranked higher
            David.Hall David Hall (Inactive) made changes -
            toddstoffel Todd Stoffel (Inactive) made changes -
            Fix Version/s 5.5.1 [ 25030 ]
            Fix Version/s 5.5.1 [ 25030 ]
            Fix Version/s 1.5.5 [ 24414 ]
            toddstoffel Todd Stoffel (Inactive) made changes -
            Affects Version/s 1.0.0 [ 22028 ]
            Affects Version/s 1.5.4 [ 24413 ]
            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
            David.Hall David Hall (Inactive) made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            David.Hall David Hall (Inactive) made changes -
            Assignee David Hall [ david.hall ] Ben Thompson [ ben.thompson ]
            Status In Progress [ 3 ] In Review [ 10002 ]
            toddstoffel Todd Stoffel (Inactive) made changes -
            Rank Ranked higher
            toddstoffel Todd Stoffel (Inactive) made changes -
            Rank Ranked higher
            toddstoffel Todd Stoffel (Inactive) made changes -
            Rank Ranked higher
            toddstoffel Todd Stoffel (Inactive) made changes -
            Rank Ranked higher
            toddstoffel Todd Stoffel (Inactive) made changes -
            Rank Ranked higher
            toddstoffel Todd Stoffel (Inactive) made changes -
            Rank Ranked higher
            toddstoffel Todd Stoffel (Inactive) made changes -
            Rank Ranked higher
            toddstoffel Todd Stoffel (Inactive) made changes -
            Rank Ranked higher
            toddstoffel Todd Stoffel (Inactive) made changes -
            Rank Ranked higher
            toddstoffel Todd Stoffel (Inactive) made changes -
            Rank Ranked higher
            toddstoffel Todd Stoffel (Inactive) made changes -
            Rank Ranked higher
            toddstoffel Todd Stoffel (Inactive) made changes -
            Rank Ranked higher
            toddstoffel Todd Stoffel (Inactive) made changes -
            Rank Ranked higher
            toddstoffel Todd Stoffel (Inactive) made changes -
            Rank Ranked higher
            toddstoffel Todd Stoffel (Inactive) made changes -
            Rank Ranked higher
            David.Hall David Hall (Inactive) made changes -
            Assignee Ben Thompson [ ben.thompson ] Gagan Goel [ tntnatbry ]
            David.Hall David Hall (Inactive) made changes -
            Status In Review [ 10002 ] In Testing [ 10301 ]
            David.Hall David Hall (Inactive) made changes -
            Assignee Gagan Goel [ tntnatbry ] Daniel Lee [ dleeyh ]
            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)
            dleeyh Daniel Lee (Inactive) made changes -
            Resolution Fixed [ 1 ]
            Status In Testing [ 10301 ] Closed [ 6 ]

            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.