search

Tencent / TBase

TBase is an enterprise-level distributed HTAP database. Through a single database cluster to provide users with highly consistent distributed database services and high-performance data warehouse services, a set of integrated enterprise-level solutions is formed.
Other
1.38k stars 262 forks source link

insert into a tables with not enough data columns, it should not work, but is inserted #65

Closed l1t1 closed 3 years ago

l1t1 commented 4 years ago

test=> create table test_in(id int,v1 int,v2 int); -- 3 cols CREATE TABLE test=> insert into test_in values(1,2); --2 cols INSERT 0 1 test=> select * from test_in; id | v1 | v2 ----+----+---- 1 | 2 |

JennyJennyChen commented 4 years ago

column v2 has no insert value, of course it is null. It's OK!

JennyJennyChen commented 3 years ago

User misunderstood