mirror of
https://github.com/GreptimeTeam/greptimedb.git
synced 2026-01-05 12:52:57 +00:00
71 lines
2.7 KiB
Plaintext
71 lines
2.7 KiB
Plaintext
create table t1 (ts timestamp time index default CURRENT_TIMESTAMP);
|
|
|
|
Affected Rows: 0
|
|
|
|
show create table t1;
|
|
|
|
+-------+-----------------------------------------------------------+
|
|
| Table | Create Table |
|
|
+-------+-----------------------------------------------------------+
|
|
| t1 | CREATE TABLE IF NOT EXISTS "t1" ( |
|
|
| | "ts" TIMESTAMP(3) NOT NULL DEFAULT current_timestamp(), |
|
|
| | TIME INDEX ("ts") |
|
|
| | ) |
|
|
| | |
|
|
| | ENGINE=mito |
|
|
| | |
|
|
+-------+-----------------------------------------------------------+
|
|
|
|
create table t2 (ts timestamp time index default currEnt_tImEsTamp());
|
|
|
|
Affected Rows: 0
|
|
|
|
show create table t2;
|
|
|
|
+-------+-----------------------------------------------------------+
|
|
| Table | Create Table |
|
|
+-------+-----------------------------------------------------------+
|
|
| t2 | CREATE TABLE IF NOT EXISTS "t2" ( |
|
|
| | "ts" TIMESTAMP(3) NOT NULL DEFAULT current_timestamp(), |
|
|
| | TIME INDEX ("ts") |
|
|
| | ) |
|
|
| | |
|
|
| | ENGINE=mito |
|
|
| | |
|
|
+-------+-----------------------------------------------------------+
|
|
|
|
create table t3 (ts timestamp time index default now());
|
|
|
|
Affected Rows: 0
|
|
|
|
show create table t3;
|
|
|
|
+-------+---------------------------------------------+
|
|
| Table | Create Table |
|
|
+-------+---------------------------------------------+
|
|
| t3 | CREATE TABLE IF NOT EXISTS "t3" ( |
|
|
| | "ts" TIMESTAMP(3) NOT NULL DEFAULT now(), |
|
|
| | TIME INDEX ("ts") |
|
|
| | ) |
|
|
| | |
|
|
| | ENGINE=mito |
|
|
| | |
|
|
+-------+---------------------------------------------+
|
|
|
|
create table t4 (ts timestamp time index default now);
|
|
|
|
Error: 1001(Unsupported), Unsupported default constraint for column: 'ts', reason: expr 'now' not supported
|
|
|
|
drop table t1;
|
|
|
|
Affected Rows: 0
|
|
|
|
drop table t2;
|
|
|
|
Affected Rows: 0
|
|
|
|
drop table t3;
|
|
|
|
Affected Rows: 0
|
|
|