Re: [Question] Working with defaults in calcite.

2023-08-22 Thread stanilovsky evgeny
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,

Re: [Question] Working with defaults in calcite.

2023-08-14 Thread Julian Hyde
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]

[Question] Working with defaults in calcite.

2023-08-14 Thread stanilovsky evgeny
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