dennis zhuang

Fuzz test for deleting rows from tables

10

### What type of enhancement is this? Tech debt reduction, Other ### What does the enhancement do? Looks like we missing the fuzz test for deleting rows from tables. It's...

Extensions to SHOW Statements for information_schema tables

4

### What type of enhancement is this? API improvement, User experience ### What does the enhancement do? MySQL supports `SHOW XXXX from [table]` or `SHOW FULL XXX from [table]` to...

Proposal: within time range syntax

6

### What type of enhancement is this? API improvement, User experience ### What does the enhancement do? If the user wants to query the rows in a given year, date,...

Checksum for manifests

8

### What type of enhancement is this? Tech debt reduction, Other ### What does the enhancement do? The manifest doesn't have any checksum for data validation. We need a way...

Invalidate compiled script cache when it is updated

18

### What type of enhancement is this? User experience, API ### What does the enhancement do? We have to invalidate other frontend's compiled python script cache when the script is...

Alter table supports rename columns

6

### What problem does the new feature solve? GreptimeDB already supports altering table schema by adding, removing columns or renaming the table name. But we don't support renaming columns. For...

Supports drop schema/database statement

11

### What problem does the new feature solve? The greptimedb doesn't support `drop [schema | database] [name]` right now: ```sql CREATE SCHEMA test; Affected Rows: 1 DROP SCHEMA test; Failed...

### What type of enhancement is this? API improvement, Configuration, User experience, Other ### What does the enhancement do? Information Schema provides an ANSI-standard way of viewing system metadata. But...

PG's timezone set syntax is different from other variables

2

I just realized PG's timezone is different from other variables: https://www.postgresql.org/docs/current/sql-set.html ```sql SET TIME ZONE '+08:00'; SET TIME ZONE 'Asia/Shanghai'; ``` Maybe we need another PR to align this behavior...

Migrates more tests from duckdb

8

### What type of enhancement is this? Tech debt reduction, Other ### What does the enhancement do? We already migrate [some tests](https://github.com/GreptimeTeam/greptimedb/tree/develop/tests) from duckdb's SQL test: https://github.com/duckdb/duckdb/tree/master/test/sql. And it already...