type mismatch during creation table with default values

[dcherednik]

local=> CREATE TABLE alert_configuration (
local(> id integer NOT NULL,
local(> alertmanager_configuration text NOT NULL,
local(> configuration_version character varying(3) NOT NULL,
local(> created_at integer NOT NULL,
local(> "default" boolean DEFAULT false NOT NULL,
local(> org_id bigint DEFAULT 0 NOT NULL,
local(> configuration_hash character varying(32) DEFAULT 'not-yet-calculated'::character varying NOT NULL,
local(> PRIMARY KEY (id)
local(> );
Status: GENERIC_ERROR
Issues:

: Error: Type annotation, code: 1030 :1:1: Error: At function: KiCreateTable! :1:1: Error: Default expr org_id type mismatch, expected: pgint8, actual: pgint4

if write explicit cast works fine

local=> CREATE TABLE alert_configuration (
id integer NOT NULL,
alertmanager_configuration text NOT NULL,
configuration_version character varying(3) NOT NULL,
created_at integer NOT NULL,
"default" boolean DEFAULT false NOT NULL,
org_id bigint DEFAULT CAST(0 AS int8) NOT NULL,
configuration_hash character varying(32) DEFAULT 'not-yet-calculated'::character varying NOT NULL,
PRIMARY KEY (id)
);
CREATE TABLE

[dcherednik]

"Default expr Value2 type mismatch, expected: Int64, actual: Int32"

in case of " Int64 NOT NULL DEFAULT 1" during table creation

[gridnevvvit]

fixed in #4085 and in #4046