Lanqing Yang
485782af51
fix: ensure Create Or Replace and If Not Exist cannot coexist in create view ( #5003 )
...
ensure Create Or Replace and If Not Exist cannot coexist in create view statement
2024-11-17 07:08:30 +00:00
Weny Xu
4045298cb2
feat: add region_statistics table ( #4771 )
...
* refactor: introduce `region_statistic`
* refactor: move DatanodeStat related structs to common_meta
* chore: add comments
* feat: implement `list_region_stats` for `ClusterInfo` trait
* feat: add `region_statistics` table
* feat: add table_id and region_number fields
* chore: rename unused snafu
* chore: udpate sqlness results
* chore: avoid to print source in error msg
* chore: move `procedure_info` under `greptime` catalog
* chore: apply suggestions from CR
* Update src/common/meta/src/datanode.rs
Co-authored-by: jeremyhi <jiachun_feng@proton.me >
---------
Co-authored-by: jeremyhi <jiachun_feng@proton.me >
2024-09-27 09:54:52 +00:00
taobo
0c9b8eb0d2
feat: improve observability for procedure ( #4675 )
...
* feat: improve observability for procedure
* fix: test error
* test: add sqlness test for information_schema.procedure_info
* fix: sqlness test error
* fix: cr comment
* chore: update proto version
* fix: apply cr comment
* update version
* fix: cr comment
* optimize procedure type output format
* upgrade dep version
* fix: clippy error
* fix: `procedure` borrowed error
* fix: optimize code
2024-09-20 06:07:53 +00:00
JohnsonLee
a8477e4142
fix: table resolving logic related to pg_catalog ( #4580 )
...
* fix: table resolving logic related to pg_catalog
refer to
https://github.com/GreptimeTeam/greptimedb/issues/3560#issuecomment-2287794348
and #4543
* refactor: remove CatalogProtocol type
* fix: sqlness
* fix: forbid create database pg_catalog with mysql client
* refactor: use QueryContext as arguments rather than Channel
* refactor: pass None as default behaviour in information_schema
* test: fix test
2024-09-09 00:47:59 +00:00
JohnsonLee
9a5fa49955
feat: support pg_namespace, pg_class and related psql command ( #4428 )
...
* feat: add function 'pg_catalog.pg_table_is_visible'q
* feat: add 'pg_class' and 'pg_namespace', now we can run '\d' and '\dt'!
* refactor: move memory_table::tables to utils::tables
* refactor: move out predicate to system_schema to reuse it
* feat: predicates pushdown
* test: add pg_namespace, pg_class related sqlness test
* fix: typos and license header
* fix: sqlness test
* refactor: use `expect` instead of `unwrap` here
* refactor: remove the `information_schema::utils` mod
* doc: make the comment in pg_get_userbyid more precise
* doc: add TODO and comment in pg_catalog
* fix: typo
* fix: sqlness
* doc: change to comment on PGClassBuilder to TODO
2024-07-28 12:04:54 +00:00
dennis zhuang
db3a07804e
fix: information_schema tables and views column value ( #4438 )
2024-07-26 07:39:58 +00:00
discord9
9fa9156bde
feat: FLOWS table in information_schema&SHOW FLOWS ( #4386 )
...
* feat(WIP): flow info table
refactor: better err handling&log
feat: add flow metadata to info schema provider
feat(WIP): info_schema.flows
feat: info_schema.flows table
* fix: err after rebase
* fix: wrong comparsion op
* feat: SHOW FLOWS&tests
* refactor: per review
* chore: unused
* refactor: json error
* chore: per review
* test: sqlness
* chore: rm inline error
* refactor: per review
2024-07-19 09:29:36 +00:00
dennis zhuang
be3ea0fae7
feat: improve datafusion external error and mysql error ( #4362 )
...
* feat: improve datafusion external error and mysql error
* chore: address CR comments and fix tests
---------
Co-authored-by: evenyag <realevenyag@gmail.com >
2024-07-16 07:01:09 +00:00
JohnsonLee
072d7c2022
feat: introduce 'pg_catalog.pg_type' ( #4332 )
...
* WIP: pg_catalog
* refactor: move memory_table to crate public level to reuse it in pgcatalog
* refactor: new system_schema mod to manage implementation of information_schema and pg_catalog
* feat: pg_catalog.pg_type
* fix: remove unused code to avoid warning
* test: add pg_catalog sqlness test
* feat: pg_catalog_cache in system_catalog
* fix: integration test
* test: rollback unit test
* refactor: mix pg_catalog table_id with old ones
* fix: add todo information
* tests: rerun sqlness
---------
Co-authored-by: johnsonlee <johnsonlee@localhost.localdomain >
2024-07-15 17:41:08 +00:00
Yingwen
20d9c0a345
fix: scan hint checks order asc ( #4365 )
...
* fix: order by asc check
* feat: print selector in explain
* test: move last_value opt test to standalone
* test: sqlness remove space
* test: update regex for datetime
* test: fix partitioning
* chore: update comment
Co-authored-by: Ruihang Xia <waynestxia@gmail.com >
---------
Co-authored-by: Ruihang Xia <waynestxia@gmail.com >
2024-07-15 07:49:14 +00:00
Lanqing Yang
9501318ce5
feat: support show views statement ( #4360 )
...
This commit enables show view statement which will display a list of views
names.
2024-07-15 07:24:27 +00:00
Lanqing Yang
15ac8116ea
feat: adding information_schema.views table ( #4342 )
...
This commit introduces information_schema.views table. The VIEWS table provides
information about views in databases.
2024-07-14 09:50:19 +00:00
dennis zhuang
ab22bbac84
feat: impl drop view ( #4231 )
...
* 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 >
2024-07-11 19:53:54 +00:00
dennis zhuang
33ed745049
feat: show create view and creating view with columns ( #4086 )
...
* feat: parse column names when creating view
* feat: save the view definition into view info
* feat: supports view columns and show create view
* feat: save plan columns for validation
* fix: typo
* chore: comments and style
* chore: apply suggestions
* test: assert CreateView display result
* chore: style
Co-authored-by: Weny Xu <wenymedia@gmail.com >
* chore: avoid the clone
Co-authored-by: Weny Xu <wenymedia@gmail.com >
* fix: compile error after rebeasing
---------
Co-authored-by: Weny Xu <wenymedia@gmail.com >
2024-07-09 18:35:11 +00:00
Ning Sun
11cf9c827e
feat: dbeaver mysql compatibility, use statement and information_schema.tables ( #4218 )
...
* feat: add more placeholder field in information_schema.tables
* feat: make schema modifiable for use statement
* chore: add todo items
* fix: resolve lint issues after data type changes
* chore: update sqlness results
* refactor: patch for select database is no longer needed
* test: align tests and data types
* Apply suggestions from code review
Co-authored-by: dennis zhuang <killme2008@gmail.com >
* fix: use canonicalize_identifier for database name
* feat: add all columns for information_schema.tables
* test: remove vairables from sqlness results
* feat: add to_string impl for table options
---------
Co-authored-by: dennis zhuang <killme2008@gmail.com >
2024-07-03 01:31:13 +00:00
dennis zhuang
24612f62dd
feat: querying from view works ( #3952 )
...
* feat: querying from view works
* feat: use MemoryCatalogProviderList instead of DummyCatalogList
* refactor: revert src/query/src/dummy_catalog.rs
* chore: clean code
* fix: make clippy happy
* fix: toml format
* fix: sqlness
* fix: forgot files
* fix: make sqlness happy
* test: table source, serializer and decoder
* fix: fail to decode plan because of invalid table names
* test: adds more sqlness test for view
* chore: remove unused errors
* fix: comments
* fix: typo
* fix: invalidate view info cache after creating view successfully
* chore: apply suggestion
Co-authored-by: Ruihang Xia <waynestxia@gmail.com >
* chore: apply suggestion
Co-authored-by: Ruihang Xia <waynestxia@gmail.com >
* fix: compile error after rebeasing
* chore: style
Co-authored-by: Ruihang Xia <waynestxia@gmail.com >
* fix: don't export table_name in common-meta
* chore: change ViewInfo::new signature
* docs: leave a TODO for optimize param
---------
Co-authored-by: Ruihang Xia <waynestxia@gmail.com >
2024-05-30 21:45:56 +00:00
dennis zhuang
efd3f04b7c
feat: create view ( #3807 )
...
* add statement
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* feat: rebase with main
* fix: create flow
* feat: adds gRPC stuff
* feat: impl create_view ddl in operator
* feat: impl CreateViewProcedure
* chore: update cargo lock
* fix: format
* chore: compile error after rebasing main
* chore: refactor and test create view parser
* chore: fixed todo list and comments
* fix: compile error after rebeasing
* test: add create view test
* test: test view_info keys
* test: adds test for CreateViewProcedure and clean code
* test: adds more sqlness test for creating views
* chore: update cargo lock
* fix: don't replace normal table in CreateViewProcedure
* chore: apply suggestion
Co-authored-by: Jeremyhi <jiachun_feng@proton.me >
* chore: style
Co-authored-by: Jeremyhi <jiachun_feng@proton.me >
---------
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
Co-authored-by: Ruihang Xia <waynestxia@gmail.com >
Co-authored-by: Jeremyhi <jiachun_feng@proton.me >
2024-05-14 08:03:29 +00:00
