mirror of
https://github.com/GreptimeTeam/greptimedb.git
synced 2026-01-07 05:42:57 +00:00
1f91422bae
* feat(mysql): add SHOW WARNINGS support and return warnings for unsupported SET variables Signed-off-by: Dennis Zhuang <killme2008@gmail.com> * feat(function): add MySQL IF() function and PostgreSQL description functions for connector compatibility Signed-off-by: Dennis Zhuang <killme2008@gmail.com> * fix: show tables for mysql Signed-off-by: Dennis Zhuang <killme2008@gmail.com> * fix: partitions table in information_schema and add starrocks external catalog compatibility Signed-off-by: Dennis Zhuang <killme2008@gmail.com> * refactor: async udf Signed-off-by: Dennis Zhuang <killme2008@gmail.com> * fix: set warnings Signed-off-by: Dennis Zhuang <killme2008@gmail.com> * feat: impl pg_my_temp_schema and make description functions simple Signed-off-by: Dennis Zhuang <killme2008@gmail.com> * test: add test for issue 7313 Signed-off-by: Dennis Zhuang <killme2008@gmail.com> * feat: apply suggestions Signed-off-by: Dennis Zhuang <killme2008@gmail.com> * fix: partition_expression and partition_description Signed-off-by: Dennis Zhuang <killme2008@gmail.com> * fix: test Co-authored-by: Copilot <175728472+Copilot@users.noreply.github.com> Signed-off-by: Dennis Zhuang <killme2008@gmail.com> * fix: unit tests Signed-off-by: Dennis Zhuang <killme2008@gmail.com> * fix: saerch_path only works for pg Signed-off-by: Dennis Zhuang <killme2008@gmail.com> * feat: improve warnings processing Signed-off-by: Dennis Zhuang <killme2008@gmail.com> * fix: warnings while writing affected rows and refactor Signed-off-by: Dennis Zhuang <killme2008@gmail.com> * chore: improve ShobjDescriptionFunction signature Signed-off-by: Dennis Zhuang <killme2008@gmail.com> * refactor: array_to_boolean Signed-off-by: Dennis Zhuang <killme2008@gmail.com> --------- Signed-off-by: Dennis Zhuang <killme2008@gmail.com> Co-authored-by: Copilot <175728472+Copilot@users.noreply.github.com>
98 lines
1.8 KiB
Plaintext
98 lines
1.8 KiB
Plaintext
-- From: https://github.com/duckdb/duckdb/blob/main/test/sql/catalog/view/test_view.test --
|
|
CREATE TABLE t1(i TIMESTAMP TIME INDEX);
|
|
|
|
Affected Rows: 0
|
|
|
|
INSERT INTO t1 VALUES (41), (42), (43);
|
|
|
|
Affected Rows: 3
|
|
|
|
CREATE VIEW v1 AS SELECT
|
|
i AS j
|
|
FROM t1 WHERE i < 43;
|
|
|
|
Affected Rows: 0
|
|
|
|
SELECT * FROM v1;
|
|
|
|
+-------------------------+
|
|
| j |
|
|
+-------------------------+
|
|
| 1970-01-01T00:00:00.041 |
|
|
| 1970-01-01T00:00:00.042 |
|
|
+-------------------------+
|
|
|
|
SELECT j FROM v1 WHERE j > 41;
|
|
|
|
+-------------------------+
|
|
| j |
|
|
+-------------------------+
|
|
| 1970-01-01T00:00:00.042 |
|
|
+-------------------------+
|
|
|
|
SELECT x FROM v1 t1(x) WHERE x > 41;
|
|
|
|
+-------------------------+
|
|
| x |
|
|
+-------------------------+
|
|
| 1970-01-01T00:00:00.042 |
|
|
+-------------------------+
|
|
|
|
INSERT INTO v1 VALUES (1);
|
|
|
|
Error: 1004(InvalidArguments), Invalid SQL, error: column count mismatch, columns: 0, values: 1
|
|
|
|
DROP VIEW v1;
|
|
|
|
Affected Rows: 0
|
|
|
|
-- substrait can't process such query currently
|
|
-- CREATE VIEW v1 AS SELECT 'whatever';
|
|
-- SELECT * FROM v1;
|
|
-- substrait can't process such query currently
|
|
-- CREATE OR REPLACE VIEW v1 AS SELECT 42;
|
|
-- SELECT * FROM v1;
|
|
CREATE VIEW v1 AS SELECT * FROM dontexist;
|
|
|
|
Error: 4001(TableNotFound), Failed to plan SQL: Table not found: greptime.public.dontexist
|
|
|
|
SHOW VIEWS;
|
|
|
|
++
|
|
++
|
|
|
|
DROP VIEW v1;
|
|
|
|
Error: 4001(TableNotFound), Table not found: greptime.public.v1
|
|
|
|
SELECT * FROM v1;
|
|
|
|
Error: 4001(TableNotFound), Failed to plan SQL: Table not found: greptime.public.v1
|
|
|
|
--- view not exists ---
|
|
DROP VIEW v2;
|
|
|
|
Error: 4001(TableNotFound), Table not found: greptime.public.v2
|
|
|
|
DROP VIEW IF EXISTS v2;
|
|
|
|
Affected Rows: 0
|
|
|
|
DROP TABLE t1;
|
|
|
|
Affected Rows: 0
|
|
|
|
SHOW TABLES;
|
|
|
|
+------------------+
|
|
| Tables_in_public |
|
|
+------------------+
|
|
| numbers |
|
|
+------------------+
|
|
|
|
SHOW VIEWS;
|
|
|
|
++
|
|
++
|
|
|