dennis zhuang
f9e7762c5b
fix: add new column as primary key can't work ( #2876 )
2023-12-05 11:07:53 +00:00
tison
7d506b3c5f
feat: drop if exists ( #2859 )
...
* feat: drop if exists
Signed-off-by: tison <wander4096@gmail.com >
* sqlness cases
Signed-off-by: tison <wander4096@gmail.com >
---------
Signed-off-by: tison <wander4096@gmail.com >
2023-12-05 02:18:33 +00:00
Zhenchi
96e12e9ee5
fix: correct the previously unsuccessful decimal_ops sort result fix ( #2869 )
...
Signed-off-by: Zhenchi <zhongzc_arch@outlook.com >
2023-12-04 15:29:02 +00:00
Ruihang Xia
5f5dbe0172
fix: sort result of sqlness case decimal_ops ( #2867 )
...
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
2023-12-04 12:34:27 +00:00
Wei
dac7a41cbd
feat: sqlness for decimal128 ( #2822 )
2023-12-04 11:22:38 +00:00
Ruihang Xia
de416465a6
feat: support time() and related functions in PromQL ( #2854 )
...
* enhance empty_metric
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* implementation
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* fix lhs & rhs
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* fix clippy
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* fix typo, update sqlness
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* remove deadcode
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* add cast to bool modifier
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* update sqlness result
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
---------
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
2023-12-04 11:21:54 +00:00
WU Jingdi
806400caff
feat: add align to / interval support in range query ( #2842 )
...
* feat: add align to / interval support in range query
* chore: fix ci
* chore: simplify `parse_duration_expr`
* chore: change s to ms
2023-12-04 08:00:41 +00:00
Ruihang Xia
9ccd182109
feat: implement PromQL set op AND/UNLESS ( #2839 )
...
* initial impl
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* disable OR for now
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
---------
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
2023-11-30 03:17:57 +00:00
Ruihang Xia
92a9802343
feat: canonicalize all unquoted identifier to lowercase ( #2828 )
...
* feat: canonicalize all unquoted identifier to lowercase
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* add more tests
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* test altering table
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* primary key declare
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* fix primary key declare
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* partition by and time index
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* remove redundent call to canonicalize
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
---------
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
2023-11-29 06:40:10 +00:00
Weny Xu
e42767d500
fix: fix name verifying ( #2825 )
2023-11-28 02:47:03 +00:00
Yingwen
6100cb335a
fix(mito): do not check nullability of fields in delete requests ( #2815 )
...
* test: test for delete rows from table with non null columns
* test: test delete and reopen
* fix: allow deleting rows with non null column
2023-11-27 09:54:50 +00:00
Ruihang Xia
56fc77e573
fix: add missing error display message ( #2791 )
...
* fix: add missing error display message
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* update sqlness result
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
---------
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
2023-11-23 02:59:49 +00:00
Weny Xu
730a3faa02
fix: fix exits typos ( #2772 )
2023-11-20 02:07:01 +00:00
WU Jingdi
91820a8006
fix: empty by in range query ( #2770 )
...
* fix: empty by in range query
* Apply suggestions from code review
---------
Co-authored-by: Ruihang Xia <waynestxia@gmail.com >
2023-11-17 11:18:14 +00:00
Wei
ae27fbc7f2
feat: impl Vector, DataType traits for decimal128 ( #2727 )
...
* feat: decimal128 vector
* feat: Decimal128Type in datatypes
* refactor: cast function
* feat: decimal128 type in ConcreteDataType
* chore: decimal
* chore: sql_data_type_to_concrete_data_type
* chore: cr comment
Co-authored-by: Dennis Zhuang <killme2008@gmail.com >
Co-authored-by: Yingwen <realevenyag@gmail.com >
* chore: fix finish()
* chore: add debug_assert to new decimal128
---------
Co-authored-by: Dennis Zhuang <killme2008@gmail.com >
Co-authored-by: Yingwen <realevenyag@gmail.com >
2023-11-16 06:44:26 +00:00
taobo
a9e5b902fd
test: move sqlness env show test to common dir ( #2748 )
2023-11-14 15:05:53 +00:00
Ruihang Xia
8f3b299a45
fix: Normalize default constrain fn name ( #2737 )
...
* fix: normalize current_timestamp to current_timestamp()
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* add sqlness case
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* fix clippy lints
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
---------
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
2023-11-14 03:22:23 +00:00
tison
8fd0766754
fix: store raw objname internally ( #2719 )
...
* fix: store raw objname internally
Signed-off-by: tison <wander4096@gmail.com >
* add a utility
Signed-off-by: tison <wander4096@gmail.com >
* add a sqlness test case
Signed-off-by: tison <wander4096@gmail.com >
* cargo clippy
Signed-off-by: tison <wander4096@gmail.com >
---------
Signed-off-by: tison <wander4096@gmail.com >
2023-11-10 02:56:30 +00:00
Ruihang Xia
93f21b188d
chore: unify workspace dependencies and remove some unused ( #2713 )
...
* log-store
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* base64
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* udeps
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* snafu
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* snafu style
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* change the workspace deps' style
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
---------
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
2023-11-09 07:34:22 +00:00
dennis zhuang
f387a09535
fix: refactor and fix to_unixtime ( #2695 )
...
* fix: refactor and fix to_unixtime
* fix: sqlness tests
* feat: supports date type
* fix: test
* feat: supports datetime type
* refactor: convert_to_seconds
2023-11-06 11:00:14 +00:00
zyy17
cf94d3295f
feat: add '--server-addr' in sqlness runner ( #2692 )
...
* feat: add '--server-addr' and '--mode' in sqlness runner
* chore: remove '--mode'
* refactor: add 'connect_db()'
2023-11-06 10:56:04 +00:00
WU Jingdi
bbaae9223a
feat: enable empty range by ( #2697 )
2023-11-06 03:45:33 +00:00
Ruihang Xia
7323d727c9
feat: support current_timestamp and now as default constrains ( #2690 )
...
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
2023-11-03 08:32:02 +00:00
Ruihang Xia
a9137b77f0
fix: sort condition in HistogramFold ( #2674 )
...
* sort ts before le
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* add test case
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
---------
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
2023-11-01 08:28:53 +00:00
WU Jingdi
d2f3793d15
fix: explain range query ( #2664 )
...
* fix: explain range query
* chore: add comment
2023-10-30 13:21:25 +00:00
Ruihang Xia
5d8b0e8154
chore: bump dependencies ( #2659 )
...
* fix all hard error
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* fix nextest
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* trivial changes
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* fix order by
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* fix sql keyword and data type
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* fix range exec's input partitioning
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* fix cover input type
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* fix explain analyze
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* update distributed mode sqlness result
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* fix lints
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* update locks
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* downgrade dlv-list
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
---------
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
2023-10-26 12:24:14 +00:00
Ruihang Xia
f08a35d6b9
feat: implement histogram_quantile in PromQL ( #2651 )
...
* add to planner
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* impl evaluate_array
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* compute quantile
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* fix clippy
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* fix required input ordering
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* add more tests
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* todo to fixme
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
---------
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
2023-10-25 08:19:30 +00:00
Lei, HUANG
97897aaf9b
fix: predicate shall use real schema to create physical exprs ( #2642 )
...
* fix: prune predicate show use real schema to create physical exprs
* refactor: remove redundant results
* fix: unit tests
* test: add more sqlness cases
* test: add more sqlness cases
* fix: sqlness orderby
* chore: update log
* fix: cache physical expr in memtable iter
---------
Co-authored-by: Yingwen <realevenyag@gmail.com >
2023-10-24 03:41:25 +00:00
Ning Sun
0fbde48655
feat: hide internal error and unknown error message from end user ( #2544 )
...
* feat: use fixed error message for unknown error
* feat: return fixed message for internal error as well
* chore: include status code in error message
* test: update tests for asserts of error message
* feat: change status code of some datafusion error
* fix: make CollectRecordbatch an query error
* test: update sqlness results
2023-10-23 03:07:35 +00:00
Ruihang Xia
4d478658b5
fix: pass datanode config file in distributed mode sqlness ( #2631 )
...
* fix: pass datanode config file in distributed mode sqlness
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* fix clippy
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
---------
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
2023-10-20 10:57:23 +00:00
WU Jingdi
46e106bcc3
feat: allow nest range expr in Range Query ( #2557 )
...
* feat: eable range expr nest
* fix: change range expr rewrite format
* chore: organize range query tests
* chore: change range expr name(e.g. MAX(v) RANGE 5s FILL 6)
* chore: add range query test
* chore: fix code advice
* chore: fix ca
2023-10-18 07:03:26 +00:00
Weny Xu
cc83764331
fix: check table exists before allocating table id ( #2546 )
...
* fix: check table exists before allocating table_id
* chore: apply suggestions from CR
2023-10-09 11:40:10 +00:00
Yingwen
d68dd1f3eb
fix: schema validation is skipped once we need to fill a column ( #2548 )
...
* test: test different order
* test: add tests for missing and invalid columns
* fix: do not skip schema validation while missing columns
* chore: use field_columns()
* test: add tests for different column order
2023-10-09 09:20:51 +00:00
Ruihang Xia
d5e4fcaaff
feat: dist plan optimize part 2 ( #2543 )
...
* allow udf and scalar fn
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* put CountWildcardRule before dist planner
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* bump datafusion to fix first_value/last_value
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* update sqlness result
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* use retain instead
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
---------
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
2023-10-09 02:18:36 +00:00
Niwaka
04dbd835a1
feat: support greatest function ( #2490 )
...
* feat: support greatest function
* feat: make greatest take date_type as input
* fix: move sqlness test into common/function/time.sql
* fix: avoid using unwarp
* fix: use downcast
* refactor: simplify arrow cast
2023-09-28 10:25:09 +00:00
Ruihang Xia
10ecc30817
feat: pushdown aggr, limit and sort plan ( #2495 )
...
* check partition for aggr plan
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* handle empty partition rule
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* remove CheckPartition option
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* add test
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* update some valid sqlness result
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* opt-out promql plan and update sqlness
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* fix limit
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* fix insert select subquery
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* update unit test result
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* fix typo
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* Update src/query/src/dist_plan/analyzer.rs
Co-authored-by: Yingwen <realevenyag@gmail.com >
---------
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
Co-authored-by: Yingwen <realevenyag@gmail.com >
2023-09-28 06:35:45 +00:00
JeremyHi
52ac093110
fix: drop table 0 rows affected ( #2515 )
2023-09-28 06:21:18 +00:00
shuiyisong
ee8d472aae
chore: tune return msg ( #2506 )
...
* chore: test return msg
* fix: test_child_error
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* chore: fix test
* chore: minor fix grpc return value
* chore: format return msg
* chore: use root error as return value
* chore: fix empty err display
* chore: iter through external error
* chore: remove err msg
* chore: remove unused field
---------
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
Co-authored-by: Ruihang Xia <waynestxia@gmail.com >
2023-09-27 10:40:25 +00:00
Vanish
7fc9604735
feat: distribute truncate table in region server ( #2414 )
...
* feat: distribute truncate table
* chore: add metrics for truncate table
* test: add sqlness test
* chore: cr
* test: add multi truncate
* chore: add trace id to the header
2023-09-26 11:14:14 +00:00
Niwaka
f9351e4fb5
chore: add integration test for issue2437 ( #2481 )
2023-09-25 06:23:16 +00:00
Yingwen
c6e95ffe63
fix(mito): compaction scheduler schedules more tasks than expected ( #2466 )
...
* test: test on_compaction_finished
* fix: avoid submit same region to compact
* feat: persist and recover compaction time window
* test: fix test
* test: sort like result
2023-09-22 06:13:12 +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 122478b7c1 .
* disable windows for now
Signed-off-by: Ruihang Xia <waynestxia@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
Ruihang Xia
802229de87
fix: type cast bugs found by sqlness ( #2438 )
...
* update valid results
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* accomplish datatype
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* cast null
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* fix unit tests
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
---------
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
2023-09-19 08:20:41 +00:00
Weny Xu
43476e1ff9
refactor: rename coordination to require_lease_before_startup ( #2431 )
2023-09-18 11:07:42 +00:00
Ruihang Xia
fbbf3978d9
fix: render comment in SHOW CREATE TABLE ( #2427 )
...
* feat: add comment field to ColumnDef
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
* fix sqlness case
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
---------
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
2023-09-18 10:51:10 +00:00
dennis zhuang
b0c56a3e23
feat: type alias ( #2331 )
...
* fix: remove location from error msg
* feat: adds transformer for sqlparser statements
* feat: supports type alias
* fix: typo
* fix: license header
* test: adds timestamp_types test
* refactor: transform
* fix: rebase develop and fix tests
* fix: compile error
* chore: delete src/datanode/src/sql/create_external.rs
2023-09-18 09:43:02 +00:00
Zhenchi
73af1368bd
test: more integration test cases for external table ( #2429 )
...
Signed-off-by: Zhenchi <zhongzc_arch@outlook.com >
2023-09-18 09:21:51 +00:00
Weny Xu
2c3ff90dbc
feat: start services after first heartbeat response processed ( #2424 )
...
* feat: start services after first heartbeat response processed
* refactor: watch changes in RegionAliveKeeper
* feat: add coordination to DatanodeOptions
* chore: apply suggestions from CR
* chore: apply suggestions from CR
* chore: enable coordination in sqlness
2023-09-18 08:49:26 +00:00
Zhenchi
3a39215f11
feat: migrate file engine from table to reigon ( #2365 )
...
* feat: migrate file engine from table to reigon
Signed-off-by: Zhenchi <zhongzc_arch@outlook.com >
* Update src/file-engine/src/engine.rs
Co-authored-by: Ruihang Xia <waynestxia@gmail.com >
* feat: specify ts index for file engine
Signed-off-by: Zhenchi <zhongzc_arch@outlook.com >
* feat: handle time index for external table
Signed-off-by: Zhenchi <zhongzc_arch@outlook.com >
* fix: some integration testsg
Signed-off-by: Zhenchi <zhongzc_arch@outlook.com >
* feat: add file schema and table schema compatibility
Signed-off-by: Zhenchi <zhongzc_arch@outlook.com >
* feat: compatible file schema to region schema
Signed-off-by: Zhenchi <zhongzc_arch@outlook.com >
* feat: add error msg
Signed-off-by: Zhenchi <zhongzc_arch@outlook.com >
* fix: simplify close
Signed-off-by: Zhenchi <zhongzc_arch@outlook.com >
* fix: implement set_writable
Signed-off-by: Zhenchi <zhongzc_arch@outlook.com >
* fix: tests-integration compilation
Signed-off-by: Zhenchi <zhongzc_arch@outlook.com >
* fix: address comments
Signed-off-by: Zhenchi <zhongzc_arch@outlook.com >
---------
Signed-off-by: Zhenchi <zhongzc_arch@outlook.com >
Co-authored-by: Ruihang Xia <waynestxia@gmail.com >
Co-authored-by: zhongzc <zhongzc@zhongzcs-MacBook-Pro.local >
2023-09-18 08:02:43 +00:00
Ruihang Xia
92824d1c66
fix: update several sqlness results ( #2422 )
...
Signed-off-by: Ruihang Xia <waynestxia@gmail.com >
2023-09-17 11:33:40 +00:00