Thanks for pointing a right test, seems defaults are broken:
such test is failed.
issue created : https://issues.apache.org/jira/browse/CALCITE-5950
# Create a basic table DEFAULT
create table tdef (i int not null, j int default 100);
(0 rows modified)
!update
insert into tdef values (1,
If you way there are no execution tests, I wouldn’t be surprised. DDL was
historically deemed out of scope, and what we didn’t implement, we couldn’t
test. But now we have the ’server’ component, and there are tests such as
table.iq [1].
Can you add some tests?
Julian
[1]
Hello community !
I just try a simple case, like :
create table foo (i int not null, j int default 100);
and obtain parser error: parse failed: Encountered "default" at line 1,
column 41.
while
create table foo (i int not null, j int);
insert into foo values (1, DEFAULT);
throws no