Skip to content

nulls are returned as 0s #188

@sateesh-kadiyala-procore

Description

For decimal datatypes if the value is null in database, it returns the value as 0

Example:

In Database
(
            true,
            127,
            32000,
            4000000,
            372036854775807,
            1.22333333333,
            2.2222322222222222,
            null, //Decimal, value inserted into DB
            'data',
            '2014-01-17 00:17:13',
            'data',
            'a',
            'b',
            '2014-01-17'
        )

Output by this library by reading from database looks like below

  {
    bool: true,
    tiny_int: 127,
    small_int: 32000,
    int_type: 4000000,
    big_int: 372036854775807,
    flt: 1.2233333587646484,
    dbl: 2.2222322222222224,
    dec: 0, //Returned value
    str: 'data',
    ts: 2014-01-17T00:17:13.000Z,
    bin: <Buffer 64 61 74 61>,
    chr: 'a',
    vchr: 'b',
    dat: 2014-01-17T00:00:00.000Z
  }

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions