mirror of
https://github.com/GreptimeTeam/greptimedb.git
synced 2026-01-13 00:32:56 +00:00
314f2704d4
* 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>
71 lines
3.8 KiB
Plaintext
71 lines
3.8 KiB
Plaintext
-- SQLNESS REPLACE (\d+:\d+:\d+\.\d+) TIME
|
|
-- SQLNESS REPLACE [\s\-]+
|
|
select current_time();
|
|
|
|
++|current_time()|++|TIME|++
|
|
|
|
select GREATEST('1999-01-30', '2023-03-01');
|
|
|
|
+-------------------------------------------------+
|
|
| greatest(Utf8("1999-01-30"),Utf8("2023-03-01")) |
|
|
+-------------------------------------------------+
|
|
| 2023-03-01 |
|
|
+-------------------------------------------------+
|
|
|
|
select GREATEST('2000-02-11'::Date, '2020-12-30'::Date);
|
|
|
|
+-------------------------------------------------+
|
|
| greatest(Utf8("2000-02-11"),Utf8("2020-12-30")) |
|
|
+-------------------------------------------------+
|
|
| 2020-12-30 |
|
|
+-------------------------------------------------+
|
|
|
|
select to_timezone('2022-09-20T14:16:43.012345+08:00', 'Europe/Berlin');
|
|
|
|
+-----------------------------------------------------------------------------+
|
|
| to_timezone(Utf8("2022-09-20T14:16:43.012345+08:00"),Utf8("Europe/Berlin")) |
|
|
+-----------------------------------------------------------------------------+
|
|
| 2022-09-20 08:16:43.012345 |
|
|
+-----------------------------------------------------------------------------+
|
|
|
|
select to_timezone('2022-09-20T14:16:43.012345+08:00'::Timestamp, 'Europe/Berlin');
|
|
|
|
+------------------------------------------------------------------------------------------------------------------------------+
|
|
| to_timezone(arrow_cast(Utf8("2022-09-20T14:16:43.012345+08:00"),Utf8("Timestamp(Millisecond, None)")),Utf8("Europe/Berlin")) |
|
|
+------------------------------------------------------------------------------------------------------------------------------+
|
|
| 2022-09-20 08:16:43.012 |
|
|
+------------------------------------------------------------------------------------------------------------------------------+
|
|
|
|
select to_timezone('2024-03-29T14:16:43.012345Z', 'Asia/Shanghai');
|
|
|
|
+------------------------------------------------------------------------+
|
|
| to_timezone(Utf8("2024-03-29T14:16:43.012345Z"),Utf8("Asia/Shanghai")) |
|
|
+------------------------------------------------------------------------+
|
|
| 2024-03-29 22:16:43.012345 |
|
|
+------------------------------------------------------------------------+
|
|
|
|
select to_timezone('2024-03-29T14:16:43.012345Z'::Timestamp, 'Asia/Shanghai');
|
|
|
|
+-------------------------------------------------------------------------------------------------------------------------+
|
|
| to_timezone(arrow_cast(Utf8("2024-03-29T14:16:43.012345Z"),Utf8("Timestamp(Millisecond, None)")),Utf8("Asia/Shanghai")) |
|
|
+-------------------------------------------------------------------------------------------------------------------------+
|
|
| 2024-03-29 22:16:43.012 |
|
|
+-------------------------------------------------------------------------------------------------------------------------+
|
|
|
|
select to_timezone(1709992225, 'Asia/Shanghai');
|
|
|
|
+------------------------------------------------------+
|
|
| to_timezone(Int64(1709992225),Utf8("Asia/Shanghai")) |
|
|
+------------------------------------------------------+
|
|
| 1970-01-21 02:59:52.225 |
|
|
+------------------------------------------------------+
|
|
|
|
select to_timezone(1711508510000::INT64, 'Asia/Shanghai');
|
|
|
|
+-----------------------------------------------------------------------------------+
|
|
| to_timezone(arrow_cast(Int64(1711508510000),Utf8("Int64")),Utf8("Asia/Shanghai")) |
|
|
+-----------------------------------------------------------------------------------+
|
|
| 2024-03-27 11:01:50 |
|
|
+-----------------------------------------------------------------------------------+
|
|
|