Uploaded image for project: 'Couchbase Server'
  1. Couchbase Server
  2. MB-27862

DATE_TRUNC_STR gives incorrect results for boundary conditions

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 4.6.4, 5.1.0, 5.5.0
    • 5.5.0
    • query
    • Untriaged
    • Unknown

    Description

      Issue is, when golang parses the location it should default to UTC instead of the system timezone. We need to be able to explicitly set the timezoneto UTC if we wish to override this. 

       

      Attachments

        No reviews matched the request. Check your Options in the drop-down menu of this sections header.

        Activity

          isha Isha Kandaswamy (Inactive) created issue -
          isha Isha Kandaswamy (Inactive) made changes -
          Field Original Value New Value
          Link This issue relates to CBSE-4687 [ CBSE-4687 ]
          isha Isha Kandaswamy (Inactive) made changes -
          Summary Date_trunc_str incorrectly converts all times to UTC and hence gives wrong results DATE_TRUNC_STR gives incorrect results for boundary conditions
          isha Isha Kandaswamy (Inactive) made changes -
          Description Issue is golang when parsing the location defaults to UTC instead of the system timezone. We need to be able to explicitly set the timezone if we wish to override this. 

          Hence the DATE_TRUNC_STR function will contain a new optional argument for timezone 
          Issue is, when golang parses the location it should default to UTC instead of the system timezone. We need to be able to explicitly set the timezoneto UTC if we wish to override this. 

           
          isha Isha Kandaswamy (Inactive) made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          isha Isha Kandaswamy (Inactive) made changes -
          Status In Progress [ 3 ] Open [ 1 ]
          isha Isha Kandaswamy (Inactive) made changes -
          Assignee Isha Kandaswamy [ isha ] Ajay Bhullar [ ajay.bhullar ]
          Resolution Fixed [ 1 ]
          Status Open [ 1 ] Resolved [ 5 ]
          Sitaram.Vemulapalli Sitaram Vemulapalli made changes -
          Affects Version/s 4.6.4 [ 14607 ]
          Affects Version/s 5.1.0 [ 14611 ]
          ajay.bhullar Ajay Bhullar made changes -
          Status Resolved [ 5 ] Closed [ 6 ]

          People

            ajay.bhullar Ajay Bhullar
            isha Isha Kandaswamy (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty