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

ceiling() gives wrong answer for datetime

    XMLWordPrintable

    Details

    • Sprint:
      2020-8

      Description

      From working_tpch1/qa_fe_cnxFunctions/bug_3334_ceil.sql
      select 'ceil(dtm)', id as id, dtm, ceiling(dtm) from dtypes;
      I Should be:
      ceil(dtm) id dtm ceiling(dtm)
      -ceil(dtm) 1 2010-11-08 08:19:22 20101108081922
      -ceil(dtm) 2 2010-11-01 08:18:22 20101101081822
      -ceil(dtm) 3 2010-10-25 08:17:22 20101025081722
      -ceil(dtm) 4 2010-10-18 08:16:22 20101018081622
      -ceil(dtm) 5 2010-10-11 08:15:22 20101011081522
      11:14
      But in 1.5.4, we have
      11:14
      +ceil(dtm) 1 2010-11-08 08:19:22 0000-01-09 08:09:54
      +ceil(dtm) 2 2010-11-01 08:18:22 0000-01-09 08:09:47
      +ceil(dtm) 3 2010-10-25 08:17:22 0000-01-09 08:08:39
      +ceil(dtm) 4 2010-10-18 08:16:22 0000-01-09 08:08:32
      +ceil(dtm) 5 2010-10-11 08:15:22 0000-01-09 08:08:26

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              dleeyh Daniel Lee
              Reporter:
              David.Hall David Hall
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: