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

ceiling() gives wrong answer for datetime

    XMLWordPrintable

Details

    • 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

              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.