This is an automated email from the ASF dual-hosted git repository.
yiguolei pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/master by this push:
new 9aecd517b0 [test](Nereids) turn on all test in scalar function w
(#17269)
9aecd517b0 is described below
commit 9aecd517b0e14a11478ec71af376c6612305bd65
Author: morrySnow <[email protected]>
AuthorDate: Sat Mar 4 08:23:50 2023 +0800
[test](Nereids) turn on all test in scalar function w (#17269)
turn on all test case in scalar function W except width_bucket(fix be bug
in next PR)
turn off all test case for group_concat(distinct order by)
fix return nullable in TimestampArithmetic
---
.../trees/expressions/TimestampArithmetic.java | 4 +-
.../data/nereids_function_p0/scalar_function/W.out | 264 ++++++++++-----------
.../conditional_functions/test_query_in.out | 4 +-
.../nereids_function_p0/agg_function/agg.groovy | 68 +++---
.../nereids_function_p0/scalar_function/W.groovy | 78 +++---
5 files changed, 209 insertions(+), 209 deletions(-)
diff --git
a/fe/fe-core/src/main/java/org/apache/doris/nereids/trees/expressions/TimestampArithmetic.java
b/fe/fe-core/src/main/java/org/apache/doris/nereids/trees/expressions/TimestampArithmetic.java
index 1da77201c9..ad4dcfbd44 100644
---
a/fe/fe-core/src/main/java/org/apache/doris/nereids/trees/expressions/TimestampArithmetic.java
+++
b/fe/fe-core/src/main/java/org/apache/doris/nereids/trees/expressions/TimestampArithmetic.java
@@ -19,7 +19,7 @@ package org.apache.doris.nereids.trees.expressions;
import org.apache.doris.analysis.ArithmeticExpr.Operator;
import org.apache.doris.nereids.exceptions.UnboundException;
-import org.apache.doris.nereids.trees.expressions.functions.PropagateNullable;
+import
org.apache.doris.nereids.trees.expressions.functions.PropagateNullableOnDateLikeV2Args;
import org.apache.doris.nereids.trees.expressions.literal.Interval.TimeUnit;
import org.apache.doris.nereids.trees.expressions.shape.BinaryExpression;
import org.apache.doris.nereids.trees.expressions.visitor.ExpressionVisitor;
@@ -41,7 +41,7 @@ import java.util.Objects;
* Example: '1996-01-01' + INTERVAL '3' month;
* TODO: we need to rethink this, and maybe need to add a new type of Interval
then implement IntervalLiteral as others
*/
-public class TimestampArithmetic extends Expression implements
BinaryExpression, PropagateNullable {
+public class TimestampArithmetic extends Expression implements
BinaryExpression, PropagateNullableOnDateLikeV2Args {
private final String funcName;
private final boolean intervalFirst;
diff --git a/regression-test/data/nereids_function_p0/scalar_function/W.out
b/regression-test/data/nereids_function_p0/scalar_function/W.out
index c02d8da7ed..5a08c0727c 100644
--- a/regression-test/data/nereids_function_p0/scalar_function/W.out
+++ b/regression-test/data/nereids_function_p0/scalar_function/W.out
@@ -1784,18 +1784,18 @@
1
-- !sql_width_bucket_TinyInt_TinyInt_TinyInt_TinyInt_notnull --
-2
-2
-2
-2
-2
-2
-2
-2
-2
-2
-2
-2
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
-- !sql_width_bucket_SmallInt_SmallInt_SmallInt_SmallInt --
\N
@@ -1813,18 +1813,18 @@
1
-- !sql_width_bucket_SmallInt_SmallInt_SmallInt_SmallInt_notnull --
-2
-2
-2
-2
-2
-2
-2
-2
-2
-2
-2
-2
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
-- !sql_width_bucket_Integer_Integer_Integer_Integer --
\N
@@ -1842,18 +1842,18 @@
1
-- !sql_width_bucket_Integer_Integer_Integer_Integer_notnull --
-2
-2
-2
-2
-2
-2
-2
-2
-2
-2
-2
-2
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
-- !sql_width_bucket_BigInt_BigInt_BigInt_BigInt --
\N
@@ -1871,18 +1871,18 @@
1
-- !sql_width_bucket_BigInt_BigInt_BigInt_BigInt_notnull --
-2
-2
-2
-2
-2
-2
-2
-2
-2
-2
-2
-2
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
-- !sql_width_bucket_Float_Float_Float_TinyInt --
\N
@@ -1900,18 +1900,18 @@
1
-- !sql_width_bucket_Float_Float_Float_TinyInt_notnull --
-2
-2
-2
-2
-2
-2
-2
-2
-2
-2
-2
-2
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
-- !sql_width_bucket_Double_Double_Double_TinyInt --
\N
@@ -1929,18 +1929,18 @@
1
-- !sql_width_bucket_Double_Double_Double_TinyInt_notnull --
-2
-2
-2
-2
-2
-2
-2
-2
-2
-2
-2
-2
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
-- !sql_width_bucket_DecimalV2_DecimalV2_DecimalV2_TinyInt --
\N
@@ -1958,18 +1958,18 @@
1
-- !sql_width_bucket_DecimalV2_DecimalV2_DecimalV2_TinyInt_notnull --
-2
-2
-2
-2
-2
-2
-2
-2
-2
-2
-2
-2
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
-- !sql_width_bucket_Date_Date_Date_TinyInt --
\N
@@ -1987,18 +1987,18 @@
1
-- !sql_width_bucket_Date_Date_Date_TinyInt_notnull --
-2
-2
-2
-2
-2
-2
-2
-2
-2
-2
-2
-2
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
-- !sql_width_bucket_DateV2_DateV2_DateV2_TinyInt --
\N
@@ -2016,18 +2016,18 @@
1
-- !sql_width_bucket_DateV2_DateV2_DateV2_TinyInt_notnull --
-2
-2
-2
-2
-2
-2
-2
-2
-2
-2
-2
-2
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
-- !sql_width_bucket_DateTime_DateTime_DateTime_TinyInt --
\N
@@ -2045,18 +2045,18 @@
1
-- !sql_width_bucket_DateTime_DateTime_DateTime_TinyInt_notnull --
-2
-2
-2
-2
-2
-2
-2
-2
-2
-2
-2
-2
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
-- !sql_width_bucket_DateTimeV2_DateTimeV2_DateTimeV2_TinyInt --
\N
@@ -2074,16 +2074,16 @@
1
-- !sql_width_bucket_DateTimeV2_DateTimeV2_DateTimeV2_TinyInt_notnull --
-2
-2
-2
-2
-2
-2
-2
-2
-2
-2
-2
-2
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
diff --git
a/regression-test/data/nereids_p0/sql_functions/conditional_functions/test_query_in.out
b/regression-test/data/nereids_p0/sql_functions/conditional_functions/test_query_in.out
index 708d80d45f..c4977ab256 100644
---
a/regression-test/data/nereids_p0/sql_functions/conditional_functions/test_query_in.out
+++
b/regression-test/data/nereids_p0/sql_functions/conditional_functions/test_query_in.out
@@ -17,6 +17,8 @@ false 1 1989 1001 11011902 123.123 true
1989-03-21 1989-03-21T13:00 wangjuoo4 0.
-- !in6 --
-- !in7 --
+false 1 1989 1001 11011902 123.123 true 1989-03-21
1989-03-21T13:00 wangjuoo4 0.1 6.333 string12345
170141183460469231731687303715884105727
+false 2 1986 1001 11011903 1243.500 false
1901-12-31 1989-03-21T13:00 wangynnsf 20.268 789.25
string12345 -170141183460469231731687303715884105727
-- !in8 --
@@ -46,8 +48,6 @@ false 2 1986 1001 11011903 1243.500
false 1901-12-31 1989-03-21T13:00 wangynnsf
false 3 1989 1002 11011905 24453.325 false
2012-03-14 2000-01-01T00:00 yunlj8@nk 78945.0 3654.0
string12345 0
-- !in15 --
-false 1 1989 1001 11011902 123.123 true 1989-03-21
1989-03-21T13:00 wangjuoo4 0.1 6.333 string12345
170141183460469231731687303715884105727
-false 2 1986 1001 11011903 1243.500 false
1901-12-31 1989-03-21T13:00 wangynnsf 20.268 789.25
string12345 -170141183460469231731687303715884105727
false 3 1989 1002 11011905 24453.325 false
2012-03-14 2000-01-01T00:00 yunlj8@nk 78945.0 3654.0
string12345 0
-- !in16 --
diff --git a/regression-test/suites/nereids_function_p0/agg_function/agg.groovy
b/regression-test/suites/nereids_function_p0/agg_function/agg.groovy
index 74b30f6a82..ae96819939 100644
--- a/regression-test/suites/nereids_function_p0/agg_function/agg.groovy
+++ b/regression-test/suites/nereids_function_p0/agg_function/agg.groovy
@@ -994,44 +994,44 @@ suite("nereids_agg_fn") {
qt_sql_group_bitmap_xor_Bitmap_agg_phase_4_notnull '''
select
/*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT,
TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id),
group_bitmap_xor(bitmap_hash(kbint)) from fn_test'''
- qt_sql_group_concat_Varchar_gb '''
- select group_concat(distinct cast(abs(kint) as varchar) order
by abs(ksint)) from fn_test group by kbool order by kbool'''
+ // qt_sql_group_concat_Varchar_gb '''
+ // select group_concat(distinct cast(abs(kint) as varchar) order
by abs(ksint)) from fn_test group by kbool order by kbool'''
// qt_sql_group_concat_Varchar '''
// select group_concat(distinct cast(abs(kint) as varchar) order
by abs(ksint)) from fn_test'''
- qt_sql_group_concat_Varchar_agg_phase_1 '''
- select count(id), group_concat(distinct cast(abs(kint) as
varchar) order by abs(ksint)) from fn_test group by id order by id'''
- qt_sql_group_concat_Varchar_gb_notnull '''
- select group_concat(distinct cast(abs(kint) as varchar) order
by abs(ksint)) from fn_test_not_nullable group by kbool order by kbool'''
+ // qt_sql_group_concat_Varchar_agg_phase_1 '''
+ // select count(id), group_concat(distinct cast(abs(kint) as
varchar) order by abs(ksint)) from fn_test group by id order by id'''
+ // qt_sql_group_concat_Varchar_gb_notnull '''
+ // select group_concat(distinct cast(abs(kint) as varchar) order
by abs(ksint)) from fn_test_not_nullable group by kbool order by kbool'''
// qt_sql_group_concat_Varchar_notnull '''
// select group_concat(distinct cast(abs(kint) as varchar) order
by abs(ksint)) from fn_test_not_nullable'''
- qt_sql_group_concat_Varchar_agg_phase_1_notnull '''
- select count(id), group_concat(distinct cast(abs(kint) as
varchar) order by abs(ksint)) from fn_test_not_nullable group by id order by
id'''
-
- qt_sql_group_concat_Varchar_AnyData_gb '''
- select group_concat(distinct cast(abs(kint) as varchar) order
by abs(ksint), kdt) from fn_test group by kbool order by kbool'''
-// qt_sql_group_concat_Varchar_AnyData '''
-// select group_concat(distinct cast(abs(kint) as varchar) order
by abs(ksint), kdt) from fn_test'''
- qt_sql_group_concat_Varchar_AnyData_agg_phase_1 '''
- select count(id), group_concat(distinct cast(abs(kint) as
varchar) order by abs(ksint), kdt) from fn_test group by id order by id'''
- qt_sql_group_concat_Varchar_AnyData_gb_notnull '''
- select group_concat(distinct cast(abs(kint) as varchar) order
by abs(ksint), kdt) from fn_test_not_nullable group by kbool order by kbool'''
-// qt_sql_group_concat_Varchar_AnyData_notnull '''
-// select group_concat(distinct cast(abs(kint) as varchar) order
by abs(ksint), kdt) from fn_test_not_nullable'''
- qt_sql_group_concat_Varchar_AnyData_agg_phase_1_notnull '''
- select count(id), group_concat(distinct cast(abs(kint) as
varchar) order by abs(ksint), kdt) from fn_test_not_nullable group by id order
by id'''
-
- qt_sql_group_concat_Varchar_Varchar_AnyData_gb '''
- select group_concat(distinct cast(abs(kint) as varchar), '_x_'
order by abs(ksint), kdt) from fn_test group by kbool order by kbool'''
-// qt_sql_group_concat_Varchar_Varchar_AnyData '''
-// select group_concat(distinct cast(abs(kint) as varchar), '_x_'
order by abs(ksint), kdt) from fn_test'''
- qt_sql_group_concat_Varchar_Varchar_AnyData_agg_phase_1 '''
- select count(id), group_concat(distinct cast(abs(kint) as
varchar), '_x_' order by abs(ksint), kdt) from fn_test group by id order by
id'''
- qt_sql_group_concat_Varchar_Varchar_AnyData_gb_notnull '''
- select group_concat(distinct cast(abs(kint) as varchar), '_x_'
order by abs(ksint), kdt) from fn_test_not_nullable group by kbool order by
kbool'''
-// qt_sql_group_concat_Varchar_Varchar_AnyData_notnull '''
-// select group_concat(distinct cast(abs(kint) as varchar), '_x_'
order by abs(ksint), kdt) from fn_test_not_nullable'''
- qt_sql_group_concat_Varchar_Varchar_AnyData_agg_phase_1_notnull '''
- select count(id), group_concat(distinct cast(abs(kint) as
varchar), '_x_' order by abs(ksint), kdt) from fn_test_not_nullable group by id
order by id'''
+ // qt_sql_group_concat_Varchar_agg_phase_1_notnull '''
+ // select count(id), group_concat(distinct cast(abs(kint) as
varchar) order by abs(ksint)) from fn_test_not_nullable group by id order by
id'''
+
+ // qt_sql_group_concat_Varchar_AnyData_gb '''
+ // select group_concat(distinct cast(abs(kint) as varchar) order
by abs(ksint), kdt) from fn_test group by kbool order by kbool'''
+ // qt_sql_group_concat_Varchar_AnyData '''
+ // select group_concat(distinct cast(abs(kint) as varchar) order
by abs(ksint), kdt) from fn_test'''
+ // qt_sql_group_concat_Varchar_AnyData_agg_phase_1 '''
+ // select count(id), group_concat(distinct cast(abs(kint) as
varchar) order by abs(ksint), kdt) from fn_test group by id order by id'''
+ // qt_sql_group_concat_Varchar_AnyData_gb_notnull '''
+ // select group_concat(distinct cast(abs(kint) as varchar) order
by abs(ksint), kdt) from fn_test_not_nullable group by kbool order by kbool'''
+ // qt_sql_group_concat_Varchar_AnyData_notnull '''
+ // select group_concat(distinct cast(abs(kint) as varchar) order
by abs(ksint), kdt) from fn_test_not_nullable'''
+ // qt_sql_group_concat_Varchar_AnyData_agg_phase_1_notnull '''
+ // select count(id), group_concat(distinct cast(abs(kint) as
varchar) order by abs(ksint), kdt) from fn_test_not_nullable group by id order
by id'''
+
+ // qt_sql_group_concat_Varchar_Varchar_AnyData_gb '''
+ // select group_concat(distinct cast(abs(kint) as varchar), '_x_'
order by abs(ksint), kdt) from fn_test group by kbool order by kbool'''
+ // qt_sql_group_concat_Varchar_Varchar_AnyData '''
+ // select group_concat(distinct cast(abs(kint) as varchar), '_x_'
order by abs(ksint), kdt) from fn_test'''
+ // qt_sql_group_concat_Varchar_Varchar_AnyData_agg_phase_1 '''
+ // select count(id), group_concat(distinct cast(abs(kint) as
varchar), '_x_' order by abs(ksint), kdt) from fn_test group by id order by
id'''
+ // qt_sql_group_concat_Varchar_Varchar_AnyData_gb_notnull '''
+ // select group_concat(distinct cast(abs(kint) as varchar), '_x_'
order by abs(ksint), kdt) from fn_test_not_nullable group by kbool order by
kbool'''
+ // qt_sql_group_concat_Varchar_Varchar_AnyData_notnull '''
+ // select group_concat(distinct cast(abs(kint) as varchar), '_x_'
order by abs(ksint), kdt) from fn_test_not_nullable'''
+ // qt_sql_group_concat_Varchar_Varchar_AnyData_agg_phase_1_notnull '''
+ // select count(id), group_concat(distinct cast(abs(kint) as
varchar), '_x_' order by abs(ksint), kdt) from fn_test_not_nullable group by id
order by id'''
sql '''
select histogram(kbool) from fn_test group by kbool order by
kbool'''
diff --git
a/regression-test/suites/nereids_function_p0/scalar_function/W.groovy
b/regression-test/suites/nereids_function_p0/scalar_function/W.groovy
index fb06077d54..329020cc23 100644
--- a/regression-test/suites/nereids_function_p0/scalar_function/W.groovy
+++ b/regression-test/suites/nereids_function_p0/scalar_function/W.groovy
@@ -34,51 +34,51 @@ suite("nereids_scalar_fn_W") {
qt_sql_week_ceil_DateTime "select week_ceil(kdtm) from fn_test order by
kdtm"
qt_sql_week_ceil_DateTime_notnull "select week_ceil(kdtm) from
fn_test_not_nullable order by kdtm"
qt_sql_week_ceil_DateTimeV2 "select week_ceil(kdtmv2s1) from fn_test
order by kdtmv2s1"
- // qt_sql_week_ceil_DateTimeV2_notnull "select week_ceil(kdtmv2s1) from
fn_test_not_nullable order by kdtmv2s1"
+ qt_sql_week_ceil_DateTimeV2_notnull "select week_ceil(kdtmv2s1) from
fn_test_not_nullable order by kdtmv2s1"
qt_sql_week_ceil_DateV2 "select week_ceil(kdtv2) from fn_test order by
kdtv2"
- // qt_sql_week_ceil_DateV2_notnull "select week_ceil(kdtv2) from
fn_test_not_nullable order by kdtv2"
+ qt_sql_week_ceil_DateV2_notnull "select week_ceil(kdtv2) from
fn_test_not_nullable order by kdtv2"
qt_sql_week_ceil_DateTime_DateTime "select week_ceil(kdtm, kdtm) from
fn_test order by kdtm, kdtm"
qt_sql_week_ceil_DateTime_DateTime_notnull "select week_ceil(kdtm,
kdtm) from fn_test_not_nullable order by kdtm, kdtm"
qt_sql_week_ceil_DateTime_Integer "select week_ceil(kdtm, kint) from
fn_test order by kdtm, kint"
qt_sql_week_ceil_DateTime_Integer_notnull "select week_ceil(kdtm, kint)
from fn_test_not_nullable order by kdtm, kint"
qt_sql_week_ceil_DateTimeV2_DateTimeV2 "select week_ceil(kdtmv2s1,
kdtmv2s1) from fn_test order by kdtmv2s1, kdtmv2s1"
- // qt_sql_week_ceil_DateTimeV2_DateTimeV2_notnull "select
week_ceil(kdtmv2s1, kdtmv2s1) from fn_test_not_nullable order by kdtmv2s1,
kdtmv2s1"
+ qt_sql_week_ceil_DateTimeV2_DateTimeV2_notnull "select
week_ceil(kdtmv2s1, kdtmv2s1) from fn_test_not_nullable order by kdtmv2s1,
kdtmv2s1"
qt_sql_week_ceil_DateTimeV2_Integer "select week_ceil(kdtmv2s1, kint)
from fn_test order by kdtmv2s1, kint"
- // qt_sql_week_ceil_DateTimeV2_Integer_notnull "select
week_ceil(kdtmv2s1, kint) from fn_test_not_nullable order by kdtmv2s1, kint"
+ qt_sql_week_ceil_DateTimeV2_Integer_notnull "select week_ceil(kdtmv2s1,
kint) from fn_test_not_nullable order by kdtmv2s1, kint"
qt_sql_week_ceil_DateV2_DateV2 "select week_ceil(kdtv2, kdtv2) from
fn_test order by kdtv2, kdtv2"
- // qt_sql_week_ceil_DateV2_DateV2_notnull "select week_ceil(kdtv2,
kdtv2) from fn_test_not_nullable order by kdtv2, kdtv2"
+ qt_sql_week_ceil_DateV2_DateV2_notnull "select week_ceil(kdtv2, kdtv2)
from fn_test_not_nullable order by kdtv2, kdtv2"
qt_sql_week_ceil_DateV2_Integer "select week_ceil(kdtv2, kint) from
fn_test order by kdtv2, kint"
- // qt_sql_week_ceil_DateV2_Integer_notnull "select week_ceil(kdtv2,
kint) from fn_test_not_nullable order by kdtv2, kint"
+ qt_sql_week_ceil_DateV2_Integer_notnull "select week_ceil(kdtv2, kint)
from fn_test_not_nullable order by kdtv2, kint"
qt_sql_week_ceil_DateTime_Integer_DateTime "select week_ceil(kdtm,
kint, kdtm) from fn_test order by kdtm, kint, kdtm"
qt_sql_week_ceil_DateTime_Integer_DateTime_notnull "select
week_ceil(kdtm, kint, kdtm) from fn_test_not_nullable order by kdtm, kint, kdtm"
qt_sql_week_ceil_DateTimeV2_Integer_DateTimeV2 "select
week_ceil(kdtmv2s1, kint, kdtmv2s1) from fn_test order by kdtmv2s1, kint,
kdtmv2s1"
- // qt_sql_week_ceil_DateTimeV2_Integer_DateTimeV2_notnull "select
week_ceil(kdtmv2s1, kint, kdtmv2s1) from fn_test_not_nullable order by
kdtmv2s1, kint, kdtmv2s1"
+ qt_sql_week_ceil_DateTimeV2_Integer_DateTimeV2_notnull "select
week_ceil(kdtmv2s1, kint, kdtmv2s1) from fn_test_not_nullable order by
kdtmv2s1, kint, kdtmv2s1"
qt_sql_week_ceil_DateV2_Integer_DateV2 "select week_ceil(kdtv2, kint,
kdtv2) from fn_test order by kdtv2, kint, kdtv2"
- // qt_sql_week_ceil_DateV2_Integer_DateV2_notnull "select
week_ceil(kdtv2, kint, kdtv2) from fn_test_not_nullable order by kdtv2, kint,
kdtv2"
+ qt_sql_week_ceil_DateV2_Integer_DateV2_notnull "select week_ceil(kdtv2,
kint, kdtv2) from fn_test_not_nullable order by kdtv2, kint, kdtv2"
qt_sql_week_floor_DateTime "select week_floor(kdtm) from fn_test order
by kdtm"
qt_sql_week_floor_DateTime_notnull "select week_floor(kdtm) from
fn_test_not_nullable order by kdtm"
qt_sql_week_floor_DateTimeV2 "select week_floor(kdtmv2s1) from fn_test
order by kdtmv2s1"
- // qt_sql_week_floor_DateTimeV2_notnull "select week_floor(kdtmv2s1)
from fn_test_not_nullable order by kdtmv2s1"
+ qt_sql_week_floor_DateTimeV2_notnull "select week_floor(kdtmv2s1) from
fn_test_not_nullable order by kdtmv2s1"
qt_sql_week_floor_DateV2 "select week_floor(kdtv2) from fn_test order
by kdtv2"
- // qt_sql_week_floor_DateV2_notnull "select week_floor(kdtv2) from
fn_test_not_nullable order by kdtv2"
+ qt_sql_week_floor_DateV2_notnull "select week_floor(kdtv2) from
fn_test_not_nullable order by kdtv2"
qt_sql_week_floor_DateTime_DateTime "select week_floor(kdtm, kdtm) from
fn_test order by kdtm, kdtm"
- // qt_sql_week_floor_DateTime_DateTime_notnull "select week_floor(kdtm,
kdtm) from fn_test_not_nullable order by kdtm, kdtm"
+ qt_sql_week_floor_DateTime_DateTime_notnull "select week_floor(kdtm,
kdtm) from fn_test_not_nullable order by kdtm, kdtm"
qt_sql_week_floor_DateTime_Integer "select week_floor(kdtm, kint) from
fn_test order by kdtm, kint"
qt_sql_week_floor_DateTime_Integer_notnull "select week_floor(kdtm,
kint) from fn_test_not_nullable order by kdtm, kint"
qt_sql_week_floor_DateTimeV2_DateTimeV2 "select week_floor(kdtmv2s1,
kdtmv2s1) from fn_test order by kdtmv2s1, kdtmv2s1"
- // qt_sql_week_floor_DateTimeV2_DateTimeV2_notnull "select
week_floor(kdtmv2s1, kdtmv2s1) from fn_test_not_nullable order by kdtmv2s1,
kdtmv2s1"
+ qt_sql_week_floor_DateTimeV2_DateTimeV2_notnull "select
week_floor(kdtmv2s1, kdtmv2s1) from fn_test_not_nullable order by kdtmv2s1,
kdtmv2s1"
qt_sql_week_floor_DateTimeV2_Integer "select week_floor(kdtmv2s1, kint)
from fn_test order by kdtmv2s1, kint"
- // qt_sql_week_floor_DateTimeV2_Integer_notnull "select
week_floor(kdtmv2s1, kint) from fn_test_not_nullable order by kdtmv2s1, kint"
+ qt_sql_week_floor_DateTimeV2_Integer_notnull "select
week_floor(kdtmv2s1, kint) from fn_test_not_nullable order by kdtmv2s1, kint"
qt_sql_week_floor_DateV2_DateV2 "select week_floor(kdtv2, kdtv2) from
fn_test order by kdtv2, kdtv2"
- // qt_sql_week_floor_DateV2_DateV2_notnull "select week_floor(kdtv2,
kdtv2) from fn_test_not_nullable order by kdtv2, kdtv2"
+ qt_sql_week_floor_DateV2_DateV2_notnull "select week_floor(kdtv2,
kdtv2) from fn_test_not_nullable order by kdtv2, kdtv2"
qt_sql_week_floor_DateV2_Integer "select week_floor(kdtv2, kint) from
fn_test order by kdtv2, kint"
- // qt_sql_week_floor_DateV2_Integer_notnull "select week_floor(kdtv2,
kint) from fn_test_not_nullable order by kdtv2, kint"
+ qt_sql_week_floor_DateV2_Integer_notnull "select week_floor(kdtv2,
kint) from fn_test_not_nullable order by kdtv2, kint"
qt_sql_week_floor_DateTime_Integer_DateTime "select week_floor(kdtm,
kint, kdtm) from fn_test order by kdtm, kint, kdtm"
qt_sql_week_floor_DateTime_Integer_DateTime_notnull "select
week_floor(kdtm, kint, kdtm) from fn_test_not_nullable order by kdtm, kint,
kdtm"
qt_sql_week_floor_DateTimeV2_Integer_DateTimeV2 "select
week_floor(kdtmv2s1, kint, kdtmv2s1) from fn_test order by kdtmv2s1, kint,
kdtmv2s1"
- // qt_sql_week_floor_DateTimeV2_Integer_DateTimeV2_notnull "select
week_floor(kdtmv2s1, kint, kdtmv2s1) from fn_test_not_nullable order by
kdtmv2s1, kint, kdtmv2s1"
+ qt_sql_week_floor_DateTimeV2_Integer_DateTimeV2_notnull "select
week_floor(kdtmv2s1, kint, kdtmv2s1) from fn_test_not_nullable order by
kdtmv2s1, kint, kdtmv2s1"
qt_sql_week_floor_DateV2_Integer_DateV2 "select week_floor(kdtv2, kint,
kdtv2) from fn_test order by kdtv2, kint, kdtv2"
- // qt_sql_week_floor_DateV2_Integer_DateV2_notnull "select
week_floor(kdtv2, kint, kdtv2) from fn_test_not_nullable order by kdtv2, kint,
kdtv2"
+ qt_sql_week_floor_DateV2_Integer_DateV2_notnull "select
week_floor(kdtv2, kint, kdtv2) from fn_test_not_nullable order by kdtv2, kint,
kdtv2"
qt_sql_weekday_DateTime "select weekday(kdtm) from fn_test order by
kdtm"
qt_sql_weekday_DateTime_notnull "select weekday(kdtm) from
fn_test_not_nullable order by kdtm"
qt_sql_weekday_DateTimeV2 "select weekday(kdtmv2s1) from fn_test order
by kdtmv2s1"
@@ -141,26 +141,26 @@ suite("nereids_scalar_fn_W") {
qt_sql_weeks_sub_DateTimeV2_Integer_notnull "select weeks_sub(kdtmv2s1,
kint) from fn_test_not_nullable order by kdtmv2s1, kint"
qt_sql_weeks_sub_DateV2_Integer "select weeks_sub(kdtv2, kint) from
fn_test order by kdtv2, kint"
qt_sql_weeks_sub_DateV2_Integer_notnull "select weeks_sub(kdtv2, kint)
from fn_test_not_nullable order by kdtv2, kint"
-// qt_sql_width_bucket_TinyInt_TinyInt_TinyInt_TinyInt "select
width_bucket(ktint, ktint, ktint, ktint) from fn_test order by ktint, ktint,
ktint, ktint"
-// qt_sql_width_bucket_TinyInt_TinyInt_TinyInt_TinyInt_notnull "select
width_bucket(ktint, ktint, ktint, ktint) from fn_test_not_nullable order by
ktint, ktint, ktint, ktint"
-// qt_sql_width_bucket_SmallInt_SmallInt_SmallInt_SmallInt "select
width_bucket(ksint, ksint, ksint, ksint) from fn_test order by ksint, ksint,
ksint, ksint"
-// qt_sql_width_bucket_SmallInt_SmallInt_SmallInt_SmallInt_notnull "select
width_bucket(ksint, ksint, ksint, ksint) from fn_test_not_nullable order by
ksint, ksint, ksint, ksint"
-// qt_sql_width_bucket_Integer_Integer_Integer_Integer "select
width_bucket(kint, kint, kint, kint) from fn_test order by kint, kint, kint,
kint"
-// qt_sql_width_bucket_Integer_Integer_Integer_Integer_notnull "select
width_bucket(kint, kint, kint, kint) from fn_test_not_nullable order by kint,
kint, kint, kint"
-// qt_sql_width_bucket_BigInt_BigInt_BigInt_BigInt "select
width_bucket(kbint, kbint, kbint, kbint) from fn_test order by kbint, kbint,
kbint, kbint"
-// qt_sql_width_bucket_BigInt_BigInt_BigInt_BigInt_notnull "select
width_bucket(kbint, kbint, kbint, kbint) from fn_test_not_nullable order by
kbint, kbint, kbint, kbint"
-// qt_sql_width_bucket_Float_Float_Float_TinyInt "select
width_bucket(kfloat, kfloat, kfloat, ktint) from fn_test order by kfloat,
kfloat, kfloat, ktint"
-// qt_sql_width_bucket_Float_Float_Float_TinyInt_notnull "select
width_bucket(kfloat, kfloat, kfloat, ktint) from fn_test_not_nullable order by
kfloat, kfloat, kfloat, ktint"
-// qt_sql_width_bucket_Double_Double_Double_TinyInt "select
width_bucket(kdbl, kdbl, kdbl, ktint) from fn_test order by kdbl, kdbl, kdbl,
ktint"
-// qt_sql_width_bucket_Double_Double_Double_TinyInt_notnull "select
width_bucket(kdbl, kdbl, kdbl, ktint) from fn_test_not_nullable order by kdbl,
kdbl, kdbl, ktint"
-// qt_sql_width_bucket_DecimalV2_DecimalV2_DecimalV2_TinyInt "select
width_bucket(kdcmls1, kdcmls1, kdcmls1, ktint) from fn_test order by kdcmls1,
kdcmls1, kdcmls1, ktint"
-// qt_sql_width_bucket_DecimalV2_DecimalV2_DecimalV2_TinyInt_notnull
"select width_bucket(kdcmls1, kdcmls1, kdcmls1, ktint) from
fn_test_not_nullable order by kdcmls1, kdcmls1, kdcmls1, ktint"
-// qt_sql_width_bucket_Date_Date_Date_TinyInt "select width_bucket(kdt,
kdt, kdt, ktint) from fn_test order by kdt, kdt, kdt, ktint"
-// qt_sql_width_bucket_Date_Date_Date_TinyInt_notnull "select
width_bucket(kdt, kdt, kdt, ktint) from fn_test_not_nullable order by kdt, kdt,
kdt, ktint"
-// qt_sql_width_bucket_DateV2_DateV2_DateV2_TinyInt "select
width_bucket(kdtv2, kdtv2, kdtv2, ktint) from fn_test order by kdtv2, kdtv2,
kdtv2, ktint"
-// qt_sql_width_bucket_DateV2_DateV2_DateV2_TinyInt_notnull "select
width_bucket(kdtv2, kdtv2, kdtv2, ktint) from fn_test_not_nullable order by
kdtv2, kdtv2, kdtv2, ktint"
-// qt_sql_width_bucket_DateTime_DateTime_DateTime_TinyInt "select
width_bucket(kdtm, kdtm, kdtm, ktint) from fn_test order by kdtm, kdtm, kdtm,
ktint"
-// qt_sql_width_bucket_DateTime_DateTime_DateTime_TinyInt_notnull "select
width_bucket(kdtm, kdtm, kdtm, ktint) from fn_test_not_nullable order by kdtm,
kdtm, kdtm, ktint"
-// qt_sql_width_bucket_DateTimeV2_DateTimeV2_DateTimeV2_TinyInt "select
width_bucket(kdtmv2s1, kdtmv2s1, kdtmv2s1, ktint) from fn_test order by
kdtmv2s1, kdtmv2s1, kdtmv2s1, ktint"
-// qt_sql_width_bucket_DateTimeV2_DateTimeV2_DateTimeV2_TinyInt_notnull
"select width_bucket(kdtmv2s1, kdtmv2s1, kdtmv2s1, ktint) from
fn_test_not_nullable order by kdtmv2s1, kdtmv2s1, kdtmv2s1, ktint"
+// qt_sql_width_bucket_TinyInt_TinyInt_TinyInt_TinyInt "select
width_bucket(ktint, ktint, ktint + 1, 1) from fn_test order by ktint, ktint,
ktint, ktint"
+// qt_sql_width_bucket_TinyInt_TinyInt_TinyInt_TinyInt_notnull "select
width_bucket(ktint, ktint, ktint + 1, 1) from fn_test_not_nullable order by
ktint, ktint, ktint, ktint"
+// qt_sql_width_bucket_SmallInt_SmallInt_SmallInt_SmallInt "select
width_bucket(ksint, ksint, ksint + 1, 1) from fn_test order by ksint, ksint,
ksint, ksint"
+// qt_sql_width_bucket_SmallInt_SmallInt_SmallInt_SmallInt_notnull "select
width_bucket(ksint, ksint, ksint + 1, 1) from fn_test_not_nullable order by
ksint, ksint, ksint, ksint"
+// qt_sql_width_bucket_Integer_Integer_Integer_Integer "select
width_bucket(kint, kint, kint + 1, 1) from fn_test order by kint, kint, kint,
kint"
+// qt_sql_width_bucket_Integer_Integer_Integer_Integer_notnull "select
width_bucket(kint, kint, kint + 1, 1) from fn_test_not_nullable order by kint,
kint, kint, kint"
+// qt_sql_width_bucket_BigInt_BigInt_BigInt_BigInt "select
width_bucket(kbint, kbint, kbint + 1, 1) from fn_test order by kbint, kbint,
kbint, kbint"
+// qt_sql_width_bucket_BigInt_BigInt_BigInt_BigInt_notnull "select
width_bucket(kbint, kbint, kbint + 1, 1) from fn_test_not_nullable order by
kbint, kbint, kbint, kbint"
+// qt_sql_width_bucket_Float_Float_Float_TinyInt "select
width_bucket(kfloat, kfloat, kfloat + 1, 1) from fn_test order by kfloat,
kfloat, kfloat, ktint"
+// qt_sql_width_bucket_Float_Float_Float_TinyInt_notnull "select
width_bucket(kfloat, kfloat, kfloat + 1, 1) from fn_test_not_nullable order by
kfloat, kfloat, kfloat, ktint"
+// qt_sql_width_bucket_Double_Double_Double_TinyInt "select
width_bucket(kdbl, kdbl, kdbl + 1, 1) from fn_test order by kdbl, kdbl, kdbl,
ktint"
+// qt_sql_width_bucket_Double_Double_Double_TinyInt_notnull "select
width_bucket(kdbl, kdbl, kdbl + 1, 1) from fn_test_not_nullable order by kdbl,
kdbl, kdbl, ktint"
+// qt_sql_width_bucket_DecimalV2_DecimalV2_DecimalV2_TinyInt "select
width_bucket(kdcmls1, kdcmls1, kdcmls1 + 1, 1) from fn_test order by kdcmls1,
kdcmls1, kdcmls1, ktint"
+// qt_sql_width_bucket_DecimalV2_DecimalV2_DecimalV2_TinyInt_notnull
"select width_bucket(kdcmls1, kdcmls1, kdcmls1 + 1, 1) from
fn_test_not_nullable order by kdcmls1, kdcmls1, kdcmls1, ktint"
+// qt_sql_width_bucket_Date_Date_Date_TinyInt "select width_bucket(kdt,
kdt, kdt + interval 1 day, 1) from fn_test order by kdt, kdt, kdt, ktint"
+// qt_sql_width_bucket_Date_Date_Date_TinyInt_notnull "select
width_bucket(kdt, kdt, kdt + interval 1 day, 1) from fn_test_not_nullable order
by kdt, kdt, kdt, ktint"
+// qt_sql_width_bucket_DateV2_DateV2_DateV2_TinyInt "select
width_bucket(kdtv2, kdtv2, kdtv2 + interval 1 day, 1) from fn_test order by
kdtv2, kdtv2, kdtv2, ktint"
+// qt_sql_width_bucket_DateV2_DateV2_DateV2_TinyInt_notnull "select
width_bucket(kdtv2, kdtv2, kdtv2 + interval 1 day, 1) from fn_test_not_nullable
order by kdtv2, kdtv2, kdtv2, ktint"
+// qt_sql_width_bucket_DateTime_DateTime_DateTime_TinyInt "select
width_bucket(kdtm, kdtm, kdtm + interval 1 day, 1) from fn_test order by kdtm,
kdtm, kdtm, ktint"
+// qt_sql_width_bucket_DateTime_DateTime_DateTime_TinyInt_notnull "select
width_bucket(kdtm, kdtm, kdtm + interval 1 day, 1) from fn_test_not_nullable
order by kdtm, kdtm, kdtm, ktint"
+// qt_sql_width_bucket_DateTimeV2_DateTimeV2_DateTimeV2_TinyInt "select
width_bucket(kdtmv2s1, kdtmv2s1, kdtmv2s1 + interval 1 day, 1) from fn_test
order by kdtmv2s1, kdtmv2s1, kdtmv2s1, ktint"
+// qt_sql_width_bucket_DateTimeV2_DateTimeV2_DateTimeV2_TinyInt_notnull
"select width_bucket(kdtmv2s1, kdtmv2s1, kdtmv2s1 + interval 1 day, 1) from
fn_test_not_nullable order by kdtmv2s1, kdtmv2s1, kdtmv2s1, ktint"
}
\ No newline at end of file
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
