Files
greptimedb/tests/cases/standalone/common/create/current_timestamp.sql
Ruihang Xia 8f3b299a45 fix: Normalize default constrain fn name (#2737)
* fix: normalize current_timestamp to current_timestamp()

Signed-off-by: Ruihang Xia <waynestxia@gmail.com>

* add sqlness case

Signed-off-by: Ruihang Xia <waynestxia@gmail.com>

* fix clippy lints

Signed-off-by: Ruihang Xia <waynestxia@gmail.com>

---------

Signed-off-by: Ruihang Xia <waynestxia@gmail.com>
2023-11-14 03:22:23 +00:00

18 lines
370 B
SQL

create table t1 (ts timestamp time index default CURRENT_TIMESTAMP);
show create table t1;
create table t2 (ts timestamp time index default currEnt_tImEsTamp());
show create table t2;
create table t3 (ts timestamp time index default now());
show create table t3;
create table t4 (ts timestamp time index default now);
drop table t1;
drop table t2;
drop table t3;