Skip to content

Add a setting insert_select_null_as_default #22832

@alexey-milovidov

Description

@alexey-milovidov

Use case

CREATE TABLE default_test (s String DEFAULT 'Hello') ENGINE = Memory;

-- works, see the `input_format_null_as_default` setting.
INSERT INTO default_test VALUES ('World'), (NULL);

-- does not work but I want it to work:
INSERT INTO default_test SELECT 'World' UNION ALL SELECT NULL;

Metadata

Metadata

Assignees

Labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions