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

[CX] Fix integer types constructors handling of floating-point string

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 7.0.0
    • 7.1.0
    • analytics
    • Untriaged
    • 1
    • Unknown
    • CX Sprint 273

    Description

      The integer type constructors need to handle a floating-point string expression similar to a floating-point number expression instead of returning NULL.

       bigint(expr), to_bigint(expr)
      e.g bigint(4.1) and bigint("4.1")

      Attachments

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

        Activity

          dmitry.lychagin Dmitry Lychagin added a comment - Open source tracking issue: https://issues.apache.org/jira/browse/ASTERIXDB-2992
          dmitry.lychagin Dmitry Lychagin added a comment - Open source change: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/14283
          umang.agrawal Umang added a comment -

          Dmitry Lychagin Can you please provide steps to verify this?

          umang.agrawal Umang added a comment - Dmitry Lychagin Can you please provide steps to verify this?

          Umang , you need to check the following 2 functions: to_bigint() and bigint() 

          1. select tobigint("1.5")  – used to return NULL, now returns 1
          2. select bigint("1.5") - also returns 1. This is a new function in 7.1.
          dmitry.lychagin Dmitry Lychagin added a comment - Umang , you need to check the following 2 functions: to_bigint() and bigint()  select tobigint("1.5")  – used to return NULL, now returns 1 select bigint("1.5") - also returns 1. This is a new function in 7.1.
          umang.agrawal Umang added a comment -

          Verified with Enterprise Edition 7.1.0 build 2246

          umang.agrawal Umang added a comment - Verified with Enterprise Edition 7.1.0 build 2246

          People

            umang.agrawal Umang
            ali.alsuliman Ali Alsuliman
            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