mirror of
https://github.com/GreptimeTeam/greptimedb.git
synced 2025-12-28 00:42:56 +00:00
ab22bbac84
* feat: impl drop view * fix: metric name * fix: comments * test: add DropViewProcedure test * test: drop view meets a table * test: update sqlness tests by drop view * feat: apply suggestion from AI * chore: apply suggestion Co-authored-by: Jeremyhi <jiachun_feng@proton.me> * chore: apply suggestion Co-authored-by: Jeremyhi <jiachun_feng@proton.me> * chore: apply suggestion Co-authored-by: Jeremyhi <jiachun_feng@proton.me> * fix: TYPE_NAME for DropFlowProcedure --------- Co-authored-by: Jeremyhi <jiachun_feng@proton.me>
42 lines
760 B
SQL
42 lines
760 B
SQL
CREATE TABLE t1(a INT, b STRING, c TIMESTAMP TIME INDEX);
|
|
|
|
INSERT INTO t1 VALUES (41, "hello", 1), (42, "world", 2), (43, "greptime", 3);
|
|
|
|
CREATE VIEW v1 AS SELECT a, b FROM t1;
|
|
|
|
SELECT * FROM v1;
|
|
|
|
SELECT a FROM v1;
|
|
|
|
INSERT INTO t1 VALUES (44, "greptimedb", 4);
|
|
|
|
SELECT * FROM v1;
|
|
|
|
SHOW CREATE VIEW v1;
|
|
|
|
CREATE OR REPLACE VIEW v1 AS SELECT a, b, c FROM t1 WHERE a > 43;
|
|
|
|
SHOW CREATE VIEW v1;
|
|
|
|
SELECT * FROM v1;
|
|
|
|
--- if not exists, so it doesn't change at all ---
|
|
CREATE VIEW IF NOT EXISTS v1 AS SELECT c FROM t1;
|
|
|
|
SHOW CREATE VIEW v1;
|
|
|
|
SELECT * FROM v1;
|
|
|
|
--- if not exists with replace, so it changes ---
|
|
CREATE OR REPLACE VIEW IF NOT EXISTS v1 AS SELECT c FROM t1;
|
|
|
|
SHOW CREATE VIEW v1;
|
|
|
|
SELECT * FROM v1;
|
|
|
|
DROP VIEW v1;
|
|
|
|
DROP TABLE t1;
|
|
|
|
SHOW CREATE VIEW v1;
|