mirror of
https://github.com/GreptimeTeam/greptimedb.git
synced 2026-01-11 07:42:54 +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>
78 lines
1.3 KiB
Plaintext
78 lines
1.3 KiB
Plaintext
DROP TABLE IF EXISTS foo;
|
|
|
|
Affected Rows: 0
|
|
|
|
create table foo (
|
|
host string,
|
|
ts timestamp DEFAULT '2023-04-29 00:00:00+00:00',
|
|
cpu double default 0,
|
|
TIME INDEX (ts),
|
|
PRIMARY KEY(host)
|
|
) engine=mito;
|
|
|
|
Affected Rows: 0
|
|
|
|
DROP TABLE IF EXISTS foo;
|
|
|
|
Affected Rows: 0
|
|
|
|
DROP TABLE IF EXISTS foo;
|
|
|
|
Affected Rows: 0
|
|
|
|
DROP TABLE IF EXISTS foo, bar;
|
|
|
|
Affected Rows: 0
|
|
|
|
create table foo (
|
|
host string,
|
|
ts timestamp DEFAULT '2024-06-01 00:00:00+00:00',
|
|
cpu double default 0,
|
|
TIME INDEX (ts),
|
|
PRIMARY KEY(host)
|
|
) engine=mito;
|
|
|
|
Affected Rows: 0
|
|
|
|
DROP TABLE foo, bar;
|
|
|
|
Error: 4001(TableNotFound), Table not found: greptime.public.bar
|
|
|
|
SHOW TABLES;
|
|
|
|
+------------------+
|
|
| Tables_in_public |
|
|
+------------------+
|
|
| foo |
|
|
| numbers |
|
|
+------------------+
|
|
|
|
DROP TABLE IF EXISTS foo, bar;
|
|
|
|
Affected Rows: 0
|
|
|
|
create table foo (
|
|
host string,
|
|
ts timestamp DEFAULT '2024-06-01 00:00:00+00:00',
|
|
cpu double default 0,
|
|
TIME INDEX (ts),
|
|
PRIMARY KEY(host)
|
|
) engine=mito;
|
|
|
|
Affected Rows: 0
|
|
|
|
create table bar (
|
|
host string,
|
|
ts timestamp DEFAULT '2024-06-01 00:00:00+00:00',
|
|
cpu double default 0,
|
|
TIME INDEX (ts),
|
|
PRIMARY KEY(host)
|
|
) engine=mito;
|
|
|
|
Affected Rows: 0
|
|
|
|
DROP TABLE foo, bar;
|
|
|
|
Affected Rows: 0
|
|
|