6 Commits

Author	SHA1	Message	Date
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
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
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
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