LFC
314f2704d4
build(deps): update datafusion to latest and arrow to 51.0 ( #3661 )
...
* chore: update datafusion
* update sqlness case of time.sql
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* fix: adjust range query partition
* fix: hisogram incorrect result
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* fix: ignore filter pushdown temporarily
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* fix: update limit sqlness result
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* fix: histogram with wrong distribution
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* fix: update negative ordinal sqlness case
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* feat: bump df to cd7a00b
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* resolve conflicts
* ignore test_range_filter
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* fix promql exec panic
* fix "select count(*)" exec error
* re-enable the "test_range_filter" test since the filter push down seems not necessary to be removed
* fix: range query schema error
* update sqlness results
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* resolve conflicts
* update datafusion, again
* fix pyo3 compile error, and update some sqlness results
* update decimal sqlness cases
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* fix: promql literal
* fix udaf tests
* fix filter pushdown sqlness tests
* fix?: test_cast
* fix: rspy test fail due to datafusion `sin` signature change
* rebase main to see if there are any failed tests
* debug ci
* debug ci
* debug ci
* enforce input partition
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* debug ci
* fix ci
* fix ci
* debug ci
* debug ci
* debug ci
* fix sqlness
* feat: do not return error while creating a filter
* chore: remove array from error
* chore: replace todo with unimplemented
* Update src/flow/clippy.toml
Co-authored-by: Yingwen <realevenyag@gmail.com >
---------
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
Co-authored-by: Ruihang Xia <waynestxia@gmail.com >
Co-authored-by: WUJingdi <taylor-lagrange@qq.com >
Co-authored-by: discord9 <discord9@163.com >
Co-authored-by: evenyag <realevenyag@gmail.com >
Co-authored-by: tison <wander4096@gmail.com >
2024-04-18 12:07:18 +00:00
JohnsonLee
d6b2d1dfb8
feat: Support outputting various date styles for postgresql ( #3602 )
...
* test: add integration_test for datetime style
* feat: support various datestyle for postgres
* doc: rewrite the comment about merge_datestyle_value
* test: add more test to illustrate valid datestyle input
2024-04-01 07:31:36 +00:00
JohnsonLee
83643eb195
feat: Support printing postgresql's bytea data type in its "hex" and "escape" format ( #3567 )
...
* feat: support set variable statement of session
* feat: support printing postgresql's bytea data type in its "hex" and "escape" format in ugly way
* refactor: add 'SessionConfigValue' type and unify the name
* doc: add license header
* refactor: confine coupling with 'sql::ast::Value' in SessionConfigValue
* refactor: move all bytea wrapper into bytea.rs
* fix: remove unused import in context.rs and postgres.rs
* refactor: rename 'set_configuration_parameter' to 'set_session_config'
rename 'set_configuration_parameter' in statement_.rs to 'set_session_config'
* refactor: use mod to organize options via macro
* refactor: re-model the session config value with static type
* test: add integration test
* refactor: move the encode bytea by format type logic into encoder
refactor: use Arc<DashMap> instead of DashMap in QueryContext
refactor: use Arc<DashMap> instead of DashMap in QueryContext
Avoid expensive clone
refactor: use unreachable!() instead of unimplemented!()
refactor: move the encode bytea by format type logic into encoder
test: add binary format integration test case
* test: add ut for byte related type
* doc: remove TODO of bytea_output
* refactor: simplify the implementation with simple struct instead of complex typing
* fix: typo of 'Available'
* fix compile
Signed-off-by: tison <wander4096@gmail.com >
---------
Signed-off-by: tison <wander4096@gmail.com >
Co-authored-by: tison <wander4096@gmail.com >
2024-03-27 01:54:41 +00:00
x³u³
24886b9530
test: add a parameter type mismatch test case to sql integration test ( #3568 )
2024-03-22 17:43:20 +00:00
Weny Xu
a309cd018a
fix: fix incorrect COM_STMT_PREPARE reply ( #3463 )
...
* fix: fix incorrect `COM_STMT_PREPARE` reply
* chore: use column name instead of index
2024-03-08 07:31:20 +00:00
WU Jingdi
816d94892c
feat: support HTTP&gRPC&pg set timezone ( #3125 )
...
* feat: support HTTP&gRPC&pg set timezone
* chore: fix code advice
* chore: fix code advice
2024-01-15 06:29:31 +00:00
WU Jingdi
d1ee1ba56a
feat: support set timezone in db ( #2992 )
...
* feat: support set timezone in db
* chore: fix ci
* chore: fix code advice
* fix: rename `time_zone` to `timezone`
2023-12-27 09:19:39 +00:00
LFC
c7b36779c1
fix: correctly decode mysql timestamp binary value ( #2946 )
...
* fix: correctly decode mysql timestamp binary value
* fix: ut
* fix: resolve PR comments
2023-12-19 11:05:28 +00:00
Ning Sun
85eebcb16f
fix: correct mysql timestamp encoding for binary protocol ( #2797 )
...
* fix: correct mysql timestamp encoding for binary protocol
* test: add tests for mysql timestamp encoding
2023-11-23 18:54:59 +00:00
Ning Sun
0ad3fb6040
fix: mysql timezone settings ( #2534 )
...
* fix: restore time zone settings for mysql
* test: add integration test for time zone
* test: fix unit test for check
2023-10-07 10:21:32 +00:00
Ruihang Xia
e352fb4495
fix: check for table scan before expanding ( #2491 )
...
* fix: check for table scan before expanding
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* change assert_ok to unwrap
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* fix clippy warning
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* update sqlness result
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* don't skip dml
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* uncomment ignored tests
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
---------
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
2023-09-26 12:12:08 +00:00
Ruihang Xia
34d6288945
feat: bring back sqlness and integration tests ( #2448 )
...
* enable integration test
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* update sqlness result
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* disable sqlness region failover
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* enable sqlness in CI
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* sort unstable result
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* set require_lease_before_startup to true
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* fix: fix inconsistent cache
* replace windows path chars
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* ignore some integration cases in windows
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* Revert "ignore some integration cases in windows"
This reverts commit 122478b7c1waynestxia@gmail.com >
* fix: fix close region bug in RegionHeartbeatResponseHandler
* disable failover tests
---------
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
Co-authored-by: WenyXu <wenymedia@gmail.com >
2023-09-20 09:17:30 +00:00
LFC
4b13c88752
fix: resolve more integration tests ( #2406 )
...
* fix: resolve more integration tests
* Update tests-integration/tests/http.rs
Co-authored-by: Weny Xu <wenymedia@gmail.com >
---------
Co-authored-by: Weny Xu <wenymedia@gmail.com >
2023-09-15 09:43:16 +00:00
JeremyHi
58d07e0e62
feat: v04 rm unused exprs ( #2285 )
...
* feat: rm compact and flush exprs
* refactor: continue to rm compact and flush
2023-09-12 07:57:15 -05:00
shuiyisong
7f51141ed0
refactor: auth crate ( #2148 )
...
* chore: move user_info to auth crate
* chore: temp commit before resolving tests compile error
* chore: fix compile issue
* chore: minor fix
* chore: tmp save
* chore: change user_info to trait
* chore: minor change & use auth result user info in pg session setup
* chore: add as_any to user_info
* chore: rename user_info
* chore: remove ice file
* chore: add permission checker
* chore: add grpc permission check
* chore: add session spawn user_info to query_ctx
* chore: minor update
* chore: add permission checker to sql handler & temp save
* chore: add permission checker to prometheus handler
* chore: add permission checker to opentsdb handler
* chore: add permission checker to other handlers
* chore: add test
* chore: add user_info setting on http entrance
* chore: fix toml
* chore: remove box in permission req
* chore: cr issue
* chore: cr issue
2023-08-14 02:51:26 +00:00
Ning Sun
d18eb18b32
feat: use server inferenced types on statement describe ( #2032 )
...
* feat: use server inferenced types on statement describe
* feat: add support for server inferenced type
* feat: allow parameter type inferencing
* chore: update comments
* fix: lint issue
* style: comfort rustfmt
* Update src/servers/src/postgres/types.rs
Co-authored-by: Yingwen <realevenyag@gmail.com >
---------
Co-authored-by: Yingwen <realevenyag@gmail.com >
2023-08-09 02:57:56 +00:00
shuiyisong
5eb2c609a3
fix: auth in grpc ( #2056 )
...
* fix: auth in grpc
* fix: change to return err
* fix: add grpc test
* fix: add http test
* fix: add mysql and pg test
2023-08-01 15:18:31 +00:00
Ning Sun
f293126315
feat: add logical plan based prepare statement for postgresql ( #1813 )
...
* feat: add logical plan based prepare statement for postgresql
* refactor: correct more types
* Update src/servers/src/postgres/types.rs
Co-authored-by: LFC <bayinamine@gmail.com >
* fix: address review issues
* test: add datetime in integration tests
---------
Co-authored-by: LFC <bayinamine@gmail.com >
2023-07-11 11:07:18 +08:00
Lei, HUANG
f287d3115b
chore: replace result assertions ( #1840 )
...
* s/assert!\((.*)\.is_ok\(\)\);/\1.unwrap\(\);/g
* s/assert!\((.*)\.is_some\(\)\);/\1.unwrap\(\);/g
2023-06-27 19:14:48 +08:00
LFC
fcff66e039
chore: deny unused results ( #1825 )
...
* chore: deny unused results
* rebase
2023-06-27 15:33:53 +08:00
dennis zhuang
034564fd27
feat: make blob(binary) type working ( #1818 )
...
* feat: test blob type
* feat: make blob type working
* chore: comment
* Update src/sql/src/statements/insert.rs
Co-authored-by: Lei, HUANG <6406592+v0y4g3r@users.noreply.github.com >
* chore: by CR comments
* fix: comment
* Update src/sql/src/statements/insert.rs
Co-authored-by: Ruihang Xia <waynestxia@gmail.com >
* Update src/sql/src/statements/insert.rs
Co-authored-by: Ruihang Xia <waynestxia@gmail.com >
* fix: test
---------
Co-authored-by: Lei, HUANG <6406592+v0y4g3r@users.noreply.github.com >
Co-authored-by: Ruihang Xia <waynestxia@gmail.com >
2023-06-26 08:49:04 +00:00
dennis zhuang
30472cebae
feat: prepare supports caching logical plan and infering param types ( #1776 )
...
* feat: change do_describe function signature
* feat: infer param type and cache logical plan for msyql prepared statments
* fix: convert_value
* fix: forgot helper
* chore: comments
* fix: typo
* test: add more tests and test date, datatime in mysql
* chore: fix CR comments
* chore: add location
* chore: by CR comments
* Update tests-integration/tests/sql.rs
Co-authored-by: Ruihang Xia <waynestxia@gmail.com >
* chore: remove the trace
---------
Co-authored-by: Ruihang Xia <waynestxia@gmail.com >
2023-06-20 04:07:28 +00:00
Ning Sun
e7a410573b
test: fix sqlx compatibility and adds integration test for sqlx ( #1686 )
...
* test: fix sqlx compatibility and adds integration test for sqlx
* test: correct insert statements
2023-06-01 15:43:13 +08:00
dennis zhuang
ae8203fafa
fix: prepare statement doesn't support insert clause ( #1680 )
...
* fix: insert clause doesn't support prepare statement
* fix: manifeste dir
* fix: format
* fix: temp path
2023-05-31 20:14:58 +08:00
