You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Chenjian (Jira)" <ji...@apache.org> on 2023/02/17 05:13:00 UTC
[jira] [Created] (IGNITE-18829) Ignite add not-null column to non-empty table does not get default value
Chenjian created IGNITE-18829:
---------------------------------
Summary: Ignite add not-null column to non-empty table does not get default value
Key: IGNITE-18829
URL: https://issues.apache.org/jira/browse/IGNITE-18829
Project: Ignite
Issue Type: Bug
Components: sql
Reporter: Chenjian
Add the not null column to the non-empty table should be given the default values.
Reproduce:
# create table t (id bigint primary key, a varchar, b int)
# insert into t values(1, 'a', 1)
# alter t add column x int not null.
# select * from t. expected get "1, 'a', 1, 0", but got "1, 'a', 1, NULL"
--
This message was sent by Atlassian Jira
(v8.20.10#820010)