Skip to content

Inserting 2.4 into Nullable(Int8) leads to NULL #5610

@zlobober

Description

@zlobober
build02-myt.yt.yandex.net :) create table tmp5(a Nullable(UInt8)) engine = Memory()

CREATE TABLE tmp5
(
    `a` Nullable(UInt8)
)
ENGINE = Memory()

Ok.

0 rows in set. Elapsed: 0.063 sec. 

build02-myt.yt.yandex.net :) insert into tmp5 values (2.4)

INSERT INTO tmp5 VALUES

Ok.

1 rows in set. Elapsed: 0.007 sec. 

build02-myt.yt.yandex.net :) select * from tmp5

SELECT *
FROM tmp5 

┌────a─┐
│ ᴺᵁᴸᴸ │
└──────┘

I would expect inserting 2 here.

Server and client both have version 19.5.3 revision 54417.

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugConfirmed user-visible misbehaviour in official release

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions