mirror of
https://github.com/GreptimeTeam/greptimedb.git
synced 2026-01-10 23:32:55 +00:00
75d85f9915
* feat: impl table_constraints table for information_schema * test: update information_schema sqlness test * test: adds table_constraints sqlness test
18 lines
458 B
SQL
18 lines
458 B
SQL
--- test information_schema.table_constraints ----
|
|
|
|
USE INFORMATION_SCHEMA;
|
|
|
|
DESC TABLE TABLE_CONSTRAINTS;
|
|
|
|
SELECT * FROM TABLE_CONSTRAINTS ORDER BY TABLE_NAME, CONSTRAINT_NAME;
|
|
|
|
CREATE TABLE test(i double, j string, ts timestamp time index, primary key(j));
|
|
|
|
SELECT * FROM TABLE_CONSTRAINTS ORDER BY TABLE_NAME, CONSTRAINT_NAME;
|
|
|
|
SELECT * FROM TABLE_CONSTRAINTS WHERE TABLE_NAME = 'test' ORDER BY TABLE_NAME, CONSTRAINT_NAME;
|
|
|
|
DROP TABLE test;
|
|
|
|
USE public;
|