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