Re: Default scale and precision SQL data types

2024-03-12 Thread Timo Walther
Hi Sergei, please check with the SQL standard before. Most of these values have been derived from the standard. I don't like the default of TIMESTAMP(6) for timestamps but this is what the standard dictates. Same for not allowing VARCHAR(0) or VARCHAR defaulting to VARCHAR(1). Changes to

Re: Default scale and precision SQL data types

2024-03-07 Thread lorenzo . affetti
Hello Sergei! The proposal makes a lot of sense, and Martijn is right as well. Are you willing to drive the FLIP effort? Do you need any assistance with that? On Mar 4, 2024 at 01:48 +0100, Martijn Visser , wrote: > Hi, > > I think it would first require a FLIP, given it touches on the core type

Re: Default scale and precision SQL data types

2024-03-03 Thread Martijn Visser
Hi, I think it would first require a FLIP, given it touches on the core type system of SQL. Best regards, Martijn On Sat, Mar 2, 2024 at 5:34 PM Sergei Morozov wrote: > Hi there, > > org.apache.flink.table.api.DataTypes allows the creation of temporal data > types by specifying precision

Default scale and precision SQL data types

2024-03-02 Thread Sergei Morozov
Hi there, org.apache.flink.table.api.DataTypes allows the creation of temporal data types by specifying precision (e.g. TIME(3)) or omitting it (TIME()). The ability to omit precision for temporal types was introduced in apache/flink@36fef44