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 772e5907f2 [enhancement](test) add some p0 cases (#12240)
772e5907f2 is described below
commit 772e5907f2a111a311cfe3b53341e2a2eb05c92e
Author: Yongqiang YANG <[email protected]>
AuthorDate: Wed Sep 7 09:10:42 2022 +0800
[enhancement](test) add some p0 cases (#12240)
---
.../correctness_p0/test_char_implicit_cast.out | 19 +
.../data/correctness_p0/test_lag_lead_window.out | 22 +-
.../test_outer_join_with_window_function.out | 4 +
.../data/correctness_p0/test_select_constant.out | 6 +
.../test_select_stddev_variance_window.out | 1021 ++++++++++++++++++++
.../test_select_with_predicate_like.out | 21 +
.../correctness_p0/test_stddev_variance_window.csv | 15 +
.../convertion_functions/sql/castAccessible.out | 4 +
.../sql/dateTimeOperatorsAccessible.out | 4 +
.../horology_functions/sql/extractAccessible.out | 4 +
.../data/rollup_p0/test_materialized_view.out | Bin 1399 -> 1399 bytes
.../org/apache/doris/regression/suite/Suite.groovy | 1 +
.../correctness_p0/test_char_implicit_cast.groovy | 25 +
.../correctness_p0/test_lag_lead_window.groovy | 32 +-
.../test_outer_join_with_window_function.groovy | 289 ++++++
.../correctness_p0/test_select_constant.groovy | 21 +
.../test_select_stddev_variance_window.groovy | 158 +++
.../test_select_with_predicate_like.groovy | 35 +
.../convertion_functions/sql/castAccessible.sql | 2 +
.../sql/atTimeZoneAccessible.sql | 5 +
.../sql/dateTimeOperatorsAccessible.sql | 7 +
.../horology_functions/sql/extractAccessible.sql | 2 +
.../suites/rollup_p0/test_materialized_view.groovy | 3 +-
23 files changed, 1683 insertions(+), 17 deletions(-)
diff --git a/regression-test/data/correctness_p0/test_char_implicit_cast.out
b/regression-test/data/correctness_p0/test_char_implicit_cast.out
new file mode 100644
index 0000000000..59f5d47377
--- /dev/null
+++ b/regression-test/data/correctness_p0/test_char_implicit_cast.out
@@ -0,0 +1,19 @@
+-- This file is automatically generated. You should know what you did if you
want to edit this
+-- !test_dayofweek_varchar --
+7
+
+-- !test_dayofweek_char --
+7
+
+-- !test_timediff_varchar --
+-24:00:00
+
+-- !test_timediff_char --
+-24:00:00
+
+-- !test_money_format_varchar --
+123,456.00
+
+-- !test_money_format_char --
+123,456.00
+
diff --git a/regression-test/data/correctness_p0/test_lag_lead_window.out
b/regression-test/data/correctness_p0/test_lag_lead_window.out
index ce24131517..c2a4258c0b 100644
--- a/regression-test/data/correctness_p0/test_lag_lead_window.out
+++ b/regression-test/data/correctness_p0/test_lag_lead_window.out
@@ -1,11 +1,21 @@
-- This file is automatically generated. You should know what you did if you
want to edit this
-- !select_default --
-/wyyt-image/2021/11/13/595345040188712460.jpg
-/wyyt-image/2022/04/13/1434607674511761493.jpg
-/wyyt-image/2022/04/13/1434607674511761493.jpg
/wyyt-image/2022/04/13/1434607674511761493.jpg
+a aa /wyyt-image/2021/11/13/595345040188712460.jpg unknown
+b aa /wyyt-image/2022/04/13/1434607674511761493.jpg unknown
+c cc /wyyt-image/2022/04/13/1434607674511761493.jpg
/wyyt-image/2022/04/13/1434607674511761493.jpg
-- !select_default2 --
-/wyyt-image/2021/11/13/595345040188712460.jpg
-/wyyt-image/2022/04/13/1434607674511761493.jpg
/wyyt-image/2022/04/13/1434607674511761493.jpg
-/wyyt-image/2022/04/13/1434607674511761493.jpg
+a aa /wyyt-image/2021/11/13/595345040188712460.jpg
+b aa /wyyt-image/2022/04/13/1434607674511761493.jpg
/wyyt-image/2022/04/13/1434607674511761493.jpg
+c cc /wyyt-image/2022/04/13/1434607674511761493.jpg
+
+-- !select_default --
+a aa /wyyt-image/2021/11/13/595345040188712460.jpg unknown
+b aa /wyyt-image/2022/04/13/1434607674511761493.jpg unknown
+c cc /wyyt-image/2022/04/13/1434607674511761493.jpg
/wyyt-image/2022/04/13/1434607674511761493.jpg
+
+-- !select_default2 --
+a aa /wyyt-image/2021/11/13/595345040188712460.jpg
+b aa /wyyt-image/2022/04/13/1434607674511761493.jpg
/wyyt-image/2022/04/13/1434607674511761493.jpg
+c cc /wyyt-image/2022/04/13/1434607674511761493.jpg
diff --git
a/regression-test/data/correctness_p0/test_outer_join_with_window_function.out
b/regression-test/data/correctness_p0/test_outer_join_with_window_function.out
new file mode 100644
index 0000000000..e0d7861228
--- /dev/null
+++
b/regression-test/data/correctness_p0/test_outer_join_with_window_function.out
@@ -0,0 +1,4 @@
+-- This file is automatically generated. You should know what you did if you
want to edit this
+-- !select --
+abc xyz 1577946288488507 1492704224 421001 421001
2020-01-19T11:15:21 9999-12-30 00:00:00 9999-12-30T00:00 -
- -
+
diff --git a/regression-test/data/correctness_p0/test_select_constant.out
b/regression-test/data/correctness_p0/test_select_constant.out
new file mode 100644
index 0000000000..e0dff3a57e
--- /dev/null
+++ b/regression-test/data/correctness_p0/test_select_constant.out
@@ -0,0 +1,6 @@
+-- This file is automatically generated. You should know what you did if you
want to edit this
+-- !select1 --
+100 test 2021-01-02
+
+-- !select_geo1 --
+POINT (123.123456789 89.123456789)
diff --git
a/regression-test/data/correctness_p0/test_select_stddev_variance_window.out
b/regression-test/data/correctness_p0/test_select_stddev_variance_window.out
new file mode 100644
index 0000000000..b3a9ee95e5
--- /dev/null
+++ b/regression-test/data/correctness_p0/test_select_stddev_variance_window.out
@@ -0,0 +1,1021 @@
+-- This file is automatically generated. You should know what you did if you
want to edit this
+-- !select_default --
+1 10887.581821431579
+2 19879.492787402174
+3 19879.492787402174
+4 19879.492787402174
+5 10887.581821431579
+6 10887.581821431579
+7 19879.492787402174
+8 10887.581821431579
+9 11616.726911608488
+10 21153.67606592388
+11 12502.185191397542
+12 22705.953345616945
+13 24652.592905412606
+14 23184.696218626632
+15 751.5664890746526
+
+-- !select_default --
+1 \N
+2 \N
+3 0.0
+4 1.5
+5 0.0
+6 2.0
+7 2.0548046676563256
+8 14509.831241839674
+9 14935.247526126464
+10 16384.606949478188
+11 14933.950939609607
+12 16385.07833365468
+13 26770.601404442812
+14 26770.60140444281
+15 817.8872511266792
+
+-- !select_default --
+1 2.0
+2 1.5
+3 2.0548046676563256
+4 15049.645234606029
+5 14509.831241839674
+6 13596.522128838684
+7 13902.500120481925
+8 12502.835735944067
+9 12502.835735944067
+10 20746.59631264849
+11 12502.185191397542
+12 24751.734420036104
+13 24652.592905412606
+14 23184.696218626632
+15 751.5664890746526
+
+-- !select_default --
+1 0.0
+2 0.0
+3 0.0
+4 0.0
+5 0.0
+6 0.0
+7 0.0
+8 0.0
+9 0.0
+10 0.0
+11 0.0
+12 0.0
+13 0.0
+14 0.0
+15 0.0
+
+-- !select_default --
+1 10887.581821431579
+2 19879.492787402174
+3 21153.67606592388
+4 22705.953345616945
+5 11616.726911608488
+6 12502.185191397542
+7 24652.592905412606
+8 751.5664890746526
+9 1.247219128924647
+10 23184.696218626632
+11 1.5
+12 26754.41351752392
+13 16511.0
+14 0.0
+15 0.0
+
+-- !select_default --
+1 0.0
+2 0.0
+3 1.5
+4 2.0548046676563256
+5 2.0
+6 14509.831241839674
+7 15049.645234606029
+8 13596.522128838684
+9 12502.835735944067
+10 13902.500120481925
+11 11616.935190583712
+12 18941.26337230146
+13 21209.57875727909
+14 19879.492787402174
+15 10887.581821431579
+
+-- !select_default --
+1 11759.932436232868
+2 21252.07172380075
+3 21252.07172380075
+4 21252.07172380075
+5 11759.932436232868
+6 11759.932436232868
+7 21252.07172380075
+8 11759.932436232868
+9 12725.486747730582
+10 22848.58156689486
+11 13977.867977628062
+12 24873.125674108593
+13 27562.436779065818
+14 26771.381205807567
+15 867.8342295623053
+
+-- !select_default --
+1 \N
+2 \N
+3 \N
+4 2.1213203435596424
+5 \N
+6 2.8284271247461903
+7 2.5166114784235836
+8 17770.84139820059
+9 18291.867810587304
+10 20066.963331140396
+11 18290.27982290047
+12 20067.540656493013
+13 32787.156774159805
+14 32787.156774159805
+15 1001.703216193965
+
+-- !select_default --
+1 2.8284271247461903
+2 2.1213203435596424
+3 2.5166114784235836
+4 17377.83345481632
+5 17770.84139820059
+6 15699.911422255434
+7 15543.467663298301
+8 13978.595308542272
+9 13978.595308542272
+10 23195.39982841425
+11 13977.86797762806
+12 27673.28036211103
+13 27562.436779065814
+14 26771.381205807567
+15 867.8342295623053
+
+-- !select_default --
+1 \N
+2 \N
+3 \N
+4 \N
+5 \N
+6 \N
+7 \N
+8 \N
+9 \N
+10 \N
+11 \N
+12 \N
+13 \N
+14 \N
+15 \N
+
+-- !select_default --
+1 11759.932436232868
+2 21252.07172380075
+3 22848.58156689486
+4 24873.125674108593
+5 12725.486747730582
+6 13977.867977628062
+7 27562.436779065818
+8 867.8342295623053
+9 1.5275252316519468
+10 26771.381205807567
+11 2.1213203435596424
+12 32767.330742677226
+13 23350.08012834217
+14 \N
+15 \N
+
+-- !select_default --
+1 \N
+2 \N
+3 2.1213203435596424
+4 2.5166114784235836
+5 2.8284271247461903
+6 17770.84139820059
+7 17377.83345481632
+8 15699.911422255434
+9 13978.595308542272
+10 15543.467663298301
+11 12725.71490591655
+12 20749.114433311766
+13 22908.963374730905
+14 21252.071723800753
+15 11759.932436232868
+
+-- !select_default --
+1 1.1853943791836736E8
+2 3.95194233484375E8
+3 3.95194233484375E8
+4 3.95194233484375E8
+5 1.1853943791836736E8
+6 1.1853943791836736E8
+7 3.95194233484375E8
+8 1.1853943791836736E8
+9 1.349483441388889E8
+10 4.474780111020408E8
+11 1.5630463456E8
+12 5.155603173333333E8
+13 6.0775033696E8
+14 5.3753013875E8
+15 564852.1875
+
+-- !select_default --
+1 \N
+2 \N
+3 0.0
+4 2.25
+5 0.0
+6 4.0
+7 4.222222222222222
+8 2.1053520266666666E8
+9 2.2306161866666666E8
+10 2.684553448888889E8
+11 2.2302289066666666E8
+12 2.68470792E8
+13 7.166650995555555E8
+14 7.166650995555553E8
+15 668939.5555555556
+
+-- !select_default --
+1 4.0
+2 2.25
+3 4.222222222222222
+4 2.2649182168749997E8
+5 2.1053520266666666E8
+6 1.84865414E8
+7 1.9327950959999996E8
+8 1.5632090144E8
+9 1.5632090144E8
+10 4.3042125855999994E8
+11 1.5630463456E8
+12 6.126483568E8
+13 6.077503369599999E8
+14 5.3753013875E8
+15 564852.1875
+
+-- !select_default --
+1 0.0
+2 0.0
+3 0.0
+4 0.0
+5 0.0
+6 0.0
+7 0.0
+8 0.0
+9 0.0
+10 0.0
+11 0.0
+12 0.0
+13 0.0
+14 0.0
+15 0.0
+
+-- !select_default --
+1 1.1853943791836736E8
+2 3.95194233484375E8
+3 4.474780111020408E8
+4 5.155603173333333E8
+5 1.349483441388889E8
+6 1.5630463456E8
+7 6.0775033696E8
+8 564852.1875
+9 1.5555555555555556
+10 5.3753013875E8
+11 2.25
+12 7.157986426666666E8
+13 2.72613121E8
+14 0.0
+15 0.0
+
+-- !select_default --
+1 0.0
+2 0.0
+3 2.25
+4 4.222222222222222
+5 4.0
+6 2.1053520266666666E8
+7 2.2649182168749997E8
+8 1.84865414E8
+9 1.5632090144E8
+10 1.9327950959999996E8
+11 1.3495318322222224E8
+12 3.587714581388889E8
+13 4.498462310612245E8
+14 3.9519423348437506E8
+15 1.1853943791836736E8
+
+-- !select_default --
+1 1.382960109047619E8
+2 4.516505525535714E8
+3 4.516505525535714E8
+4 4.516505525535714E8
+5 1.382960109047619E8
+6 1.382960109047619E8
+7 4.516505525535714E8
+8 1.382960109047619E8
+9 1.6193801296666667E8
+10 5.2205767961904764E8
+11 1.9538079320000002E8
+12 6.186723808E8
+13 7.596879212E8
+14 7.167068516666666E8
+15 753136.25
+
+-- !select_default --
+1 \N
+2 \N
+3 \N
+4 4.5
+5 \N
+6 8.0
+7 6.333333333333334
+8 3.15802804E8
+9 3.34592428E8
+10 4.026830173333333E8
+11 3.34534336E8
+12 4.02706188E8
+13 1.0749976493333333E9
+14 1.074997649333333E9
+15 1003409.3333333334
+
+-- !select_default --
+1 8.0
+2 4.5
+3 6.333333333333334
+4 3.019890955833333E8
+5 3.15802804E8
+6 2.4648721866666666E8
+7 2.4159938699999997E8
+8 1.954011268E8
+9 1.954011268E8
+10 5.380265731999999E8
+11 1.953807932E8
+12 7.658104459999999E8
+13 7.596879211999999E8
+14 7.167068516666666E8
+15 753136.25
+
+-- !select_default --
+1 \N
+2 \N
+3 \N
+4 \N
+5 \N
+6 \N
+7 \N
+8 \N
+9 \N
+10 \N
+11 \N
+12 \N
+13 \N
+14 \N
+15 \N
+
+-- !select_default --
+1 1.382960109047619E8
+2 4.516505525535714E8
+3 5.2205767961904764E8
+4 6.186723808E8
+5 1.6193801296666667E8
+6 1.9538079320000002E8
+7 7.596879212E8
+8 753136.25
+9 2.3333333333333335
+10 7.167068516666666E8
+11 4.5
+12 1.073697964E9
+13 5.45226242E8
+14 \N
+15 \N
+
+-- !select_default --
+1 \N
+2 \N
+3 4.5
+4 6.333333333333334
+5 8.0
+6 3.15802804E8
+7 3.019890955833333E8
+8 2.4648721866666666E8
+9 1.954011268E8
+10 2.4159938699999997E8
+11 1.6194381986666667E8
+12 4.305257497666667E8
+13 5.2482060290476197E8
+14 4.516505525535715E8
+15 1.382960109047619E8
+
+-- !select_default --
+1 10887.581821431579
+2 19879.492787402174
+3 19879.492787402174
+4 19879.492787402174
+5 10887.581821431579
+6 10887.581821431579
+7 19879.492787402174
+8 10887.581821431579
+9 11616.726911608488
+10 21153.67606592388
+11 12502.185191397542
+12 22705.953345616945
+13 24652.592905412606
+14 23184.696218626632
+15 751.5664890746526
+
+-- !select_default --
+1 \N
+2 \N
+3 0.0
+4 1.5
+5 0.0
+6 2.0
+7 2.0548046676563256
+8 14509.831241839674
+9 14935.247526126464
+10 16384.606949478188
+11 14933.950939609607
+12 16385.07833365468
+13 26770.601404442812
+14 26770.601404442812
+15 817.8872511266792
+
+-- !select_default --
+1 2.0
+2 1.5
+3 2.0548046676563256
+4 15049.645234606029
+5 14509.831241839674
+6 13596.522128838684
+7 13902.500120481925
+8 12502.835735944067
+9 12502.835735944067
+10 20746.596312648493
+11 12502.185191397542
+12 24751.734420036104
+13 24652.592905412606
+14 23184.696218626632
+15 751.5664890746526
+
+-- !select_default --
+1 0.0
+2 0.0
+3 0.0
+4 0.0
+5 0.0
+6 0.0
+7 0.0
+8 0.0
+9 0.0
+10 0.0
+11 0.0
+12 0.0
+13 0.0
+14 0.0
+15 0.0
+
+-- !select_default --
+1 10887.581821431579
+2 19879.492787402174
+3 21153.67606592388
+4 22705.953345616945
+5 11616.726911608488
+6 12502.185191397542
+7 24652.592905412606
+8 751.5664890746526
+9 1.247219128924647
+10 23184.696218626632
+11 1.5
+12 26754.41351752392
+13 16511.0
+14 0.0
+15 0.0
+
+-- !select_default --
+1 0.0
+2 0.0
+3 1.5
+4 2.0548046676563256
+5 2.0
+6 14509.831241839674
+7 15049.645234606029
+8 13596.522128838684
+9 12502.835735944067
+10 13902.500120481925
+11 11616.935190583712
+12 18941.26337230146
+13 21209.57875727909
+14 19879.492787402174
+15 10887.581821431579
+
+-- !select_default --
+1 11759.932436232868
+2 21252.07172380075
+3 21252.07172380075
+4 21252.07172380075
+5 11759.932436232868
+6 11759.932436232868
+7 21252.07172380075
+8 11759.932436232868
+9 12725.486747730582
+10 22848.58156689486
+11 13977.867977628062
+12 24873.125674108593
+13 27562.436779065818
+14 26771.381205807567
+15 867.8342295623053
+
+-- !select_default --
+1 \N
+2 \N
+3 \N
+4 2.1213203435596424
+5 \N
+6 2.8284271247461903
+7 2.5166114784235836
+8 17770.84139820059
+9 18291.867810587304
+10 20066.963331140396
+11 18290.27982290047
+12 20067.540656493013
+13 32787.156774159805
+14 32787.156774159805
+15 1001.703216193965
+
+-- !select_default --
+1 2.8284271247461903
+2 2.1213203435596424
+3 2.5166114784235836
+4 17377.83345481632
+5 17770.84139820059
+6 15699.911422255434
+7 15543.467663298301
+8 13978.595308542272
+9 13978.595308542272
+10 23195.399828414254
+11 13977.86797762806
+12 27673.28036211103
+13 27562.436779065818
+14 26771.381205807567
+15 867.8342295623053
+
+-- !select_default --
+1 \N
+2 \N
+3 \N
+4 \N
+5 \N
+6 \N
+7 \N
+8 \N
+9 \N
+10 \N
+11 \N
+12 \N
+13 \N
+14 \N
+15 \N
+
+-- !select_default --
+1 11759.932436232868
+2 21252.07172380075
+3 22848.58156689486
+4 24873.125674108593
+5 12725.486747730582
+6 13977.867977628062
+7 27562.436779065818
+8 867.8342295623053
+9 1.5275252316519468
+10 26771.381205807567
+11 2.1213203435596424
+12 32767.330742677226
+13 23350.08012834217
+14 \N
+15 \N
+
+-- !select_default --
+1 \N
+2 \N
+3 2.1213203435596424
+4 2.5166114784235836
+5 2.8284271247461903
+6 17770.84139820059
+7 17377.83345481632
+8 15699.911422255434
+9 13978.595308542272
+10 15543.467663298301
+11 12725.71490591655
+12 20749.114433311766
+13 22908.963374730905
+14 21252.071723800753
+15 11759.932436232868
+
+-- !select_default --
+1 1.1853943791836736E8
+2 3.95194233484375E8
+3 3.95194233484375E8
+4 3.95194233484375E8
+5 1.1853943791836736E8
+6 1.1853943791836736E8
+7 3.95194233484375E8
+8 1.1853943791836736E8
+9 1.349483441388889E8
+10 4.474780111020408E8
+11 1.5630463456E8
+12 5.155603173333333E8
+13 6.0775033696E8
+14 5.3753013875E8
+15 564852.1875
+
+-- !select_default --
+1 \N
+2 \N
+3 0.0
+4 2.25
+5 0.0
+6 4.0
+7 4.222222222222222
+8 2.1053520266666666E8
+9 2.2306161866666666E8
+10 2.684553448888889E8
+11 2.2302289066666666E8
+12 2.68470792E8
+13 7.166650995555555E8
+14 7.166650995555555E8
+15 668939.5555555556
+
+-- !select_default --
+1 4.0
+2 2.25
+3 4.222222222222222
+4 2.2649182168749997E8
+5 2.1053520266666666E8
+6 1.84865414E8
+7 1.9327950959999996E8
+8 1.5632090144E8
+9 1.5632090144E8
+10 4.3042125856000006E8
+11 1.5630463456E8
+12 6.126483568E8
+13 6.0775033696E8
+14 5.3753013875E8
+15 564852.1875
+
+-- !select_default --
+1 0.0
+2 0.0
+3 0.0
+4 0.0
+5 0.0
+6 0.0
+7 0.0
+8 0.0
+9 0.0
+10 0.0
+11 0.0
+12 0.0
+13 0.0
+14 0.0
+15 0.0
+
+-- !select_default --
+1 1.1853943791836736E8
+2 3.95194233484375E8
+3 4.474780111020408E8
+4 5.155603173333333E8
+5 1.349483441388889E8
+6 1.5630463456E8
+7 6.0775033696E8
+8 564852.1875
+9 1.5555555555555556
+10 5.3753013875E8
+11 2.25
+12 7.157986426666666E8
+13 2.72613121E8
+14 0.0
+15 0.0
+
+-- !select_default --
+1 0.0
+2 0.0
+3 2.25
+4 4.222222222222222
+5 4.0
+6 2.1053520266666666E8
+7 2.2649182168749997E8
+8 1.84865414E8
+9 1.5632090144E8
+10 1.9327950959999996E8
+11 1.3495318322222224E8
+12 3.587714581388889E8
+13 4.498462310612245E8
+14 3.9519423348437506E8
+15 1.1853943791836736E8
+
+-- !select_default --
+1 1.382960109047619E8
+2 4.516505525535714E8
+3 4.516505525535714E8
+4 4.516505525535714E8
+5 1.382960109047619E8
+6 1.382960109047619E8
+7 4.516505525535714E8
+8 1.382960109047619E8
+9 1.6193801296666667E8
+10 5.2205767961904764E8
+11 1.9538079320000002E8
+12 6.186723808E8
+13 7.596879212E8
+14 7.167068516666666E8
+15 753136.25
+
+-- !select_default --
+1 \N
+2 \N
+3 \N
+4 4.5
+5 \N
+6 8.0
+7 6.333333333333334
+8 3.15802804E8
+9 3.34592428E8
+10 4.026830173333333E8
+11 3.34534336E8
+12 4.02706188E8
+13 1.0749976493333333E9
+14 1.0749976493333333E9
+15 1003409.3333333334
+
+-- !select_default --
+1 8.0
+2 4.5
+3 6.333333333333334
+4 3.019890955833333E8
+5 3.15802804E8
+6 2.4648721866666666E8
+7 2.4159938699999997E8
+8 1.954011268E8
+9 1.954011268E8
+10 5.380265732E8
+11 1.953807932E8
+12 7.65810446E8
+13 7.596879212E8
+14 7.167068516666666E8
+15 753136.25
+
+-- !select_default --
+1 \N
+2 \N
+3 \N
+4 \N
+5 \N
+6 \N
+7 \N
+8 \N
+9 \N
+10 \N
+11 \N
+12 \N
+13 \N
+14 \N
+15 \N
+
+-- !select_default --
+1 1.382960109047619E8
+2 4.516505525535714E8
+3 5.2205767961904764E8
+4 6.186723808E8
+5 1.6193801296666667E8
+6 1.9538079320000002E8
+7 7.596879212E8
+8 753136.25
+9 2.3333333333333335
+10 7.167068516666666E8
+11 4.5
+12 1.073697964E9
+13 5.45226242E8
+14 \N
+15 \N
+
+-- !select_default --
+1 \N
+2 \N
+3 4.5
+4 6.333333333333334
+5 8.0
+6 3.15802804E8
+7 3.019890955833333E8
+8 2.4648721866666666E8
+9 1.954011268E8
+10 2.4159938699999997E8
+11 1.6194381986666667E8
+12 4.305257497666667E8
+13 5.2482060290476197E8
+14 4.516505525535715E8
+15 1.382960109047619E8
+
+-- !select_default --
+1 1991.8000000000002
+2 1991.0
+3 1991.0
+4 1991.0
+5 1991.8000000000002
+6 1991.8000000000002
+7 1991.0
+8 1991.8000000000002
+9 1992.0
+10 1991.0
+11 8147.0000000000055
+12 1991.0
+13 8146.200000000006
+14 14301.40000000001
+15 1991.4
+
+-- !select_default --
+1 \N
+2 \N
+3 1986.0
+4 1988.4
+5 1989.0
+6 1988.1999999999998
+7 1990.1999999999998
+8 20455.800000000003
+9 20454.200000000004
+10 1990.1999999999998
+11 20456.600000000006
+12 1991.0
+13 20456.600000000006
+14 20456.600000000006
+15 1990.1999999999998
+
+-- !select_default --
+1 1988.1999999999998
+2 1988.4
+3 1990.1999999999998
+4 1989.7999999999997
+5 20455.800000000003
+6 14300.200000000012
+7 1991.0
+8 8146.200000000006
+9 8146.200000000006
+10 8146.200000000006
+11 8147.0000000000055
+12 8146.200000000006
+13 8146.200000000006
+14 14301.40000000001
+15 1991.4
+
+-- !select_default --
+1 1989.0
+2 1986.0
+3 1989.0
+4 1991.0
+5 1985.0
+6 32767.0
+7 -32767.0
+8 255.0
+9 1991.0
+10 1991.0
+11 1989.0
+12 32767.0
+13 -32767.0
+14 255.0
+15 1992.0
+
+-- !select_default --
+1 1991.8000000000002
+2 1991.0
+3 1991.0
+4 1991.0
+5 1992.0
+6 8147.0000000000055
+7 8146.200000000006
+8 1991.4
+9 1991.6000000000001
+10 14301.40000000001
+11 1991.4
+12 19762.200000000004
+13 -6349.399999999999
+14 255.0
+15 1992.0
+
+-- !select_default --
+1 1989.0
+2 1986.0
+3 1988.4
+4 1990.1999999999998
+5 1988.1999999999998
+6 20455.800000000003
+7 1989.7999999999997
+8 14300.200000000012
+9 8146.200000000006
+10 1991.0
+11 1991.0
+12 1991.0
+13 1991.0
+14 1991.0
+15 1991.8000000000002
+
+-- !select_default --
+1 5069.4970703125
+2 1991.0
+3 1991.0
+4 1991.0
+5 5069.4970703125
+6 5069.4970703125
+7 1991.0
+8 5069.4970703125
+9 11224.505859375
+10 5068.5966796875
+11 17379.5
+12 11223.8056640625
+13 17379.0
+14 23534.203125
+15 1991.7000732421875
+
+-- !select_default --
+1 \N
+2 \N
+3 1986.0
+4 1989.0
+5 1989.0
+6 1989.0
+7 1990.7999267578125
+8 29689.203125
+9 29688.802734375
+10 1990.7999267578125
+11 29689.40234375
+12 1991.0
+13 29689.40234375
+14 29689.40234375
+15 1990.7999267578125
+
+-- !select_default --
+1 1989.0
+2 1989.0
+3 1990.7999267578125
+4 1990.39990234375
+5 29689.203125
+6 23533.6015625
+7 1991.0
+8 17379.0
+9 17379.0
+10 17379.0
+11 17379.5
+12 17379.0
+13 17379.0
+14 23534.203125
+15 1991.7000732421875
+
+-- !select_default --
+1 1989.0
+2 1986.0
+3 1989.0
+4 1991.0
+5 1985.0
+6 32767.0
+7 -32767.0
+8 255.0
+9 1991.0
+10 1991.0
+11 1989.0
+12 32767.0
+13 -32767.0
+14 255.0
+15 1992.0
+
+-- !select_default --
+1 5069.4970703125
+2 1991.0
+3 5068.5966796875
+4 11223.8056640625
+5 11224.505859375
+6 17379.5
+7 17379.0
+8 1991.7000732421875
+9 1991.9000244140625
+10 23534.203125
+11 1992.0
+12 29515.802734375
+13 255.0
+14 255.0
+15 1992.0
+
+-- !select_default --
+1 1989.0
+2 1986.0
+3 1989.0
+4 1990.7999267578125
+5 1989.0
+6 29689.203125
+7 1990.39990234375
+8 23533.6015625
+9 17379.0
+10 1991.0
+11 11223.8056640625
+12 11223.8056640625
+13 5068.5966796875
+14 1991.0
+15 5069.4970703125
+
diff --git
a/regression-test/data/correctness_p0/test_select_with_predicate_like.out
b/regression-test/data/correctness_p0/test_select_with_predicate_like.out
new file mode 100644
index 0000000000..887fc1ab47
--- /dev/null
+++ b/regression-test/data/correctness_p0/test_select_with_predicate_like.out
@@ -0,0 +1,21 @@
+-- This file is automatically generated. You should know what you did if you
want to edit this
+-- !select_default --
+1
+
+-- !select_default2 --
+1
+
+-- !select_default3 --
+
+-- !select_default4 --
+
+-- !select_default --
+1
+
+-- !select_default2 --
+1
+
+-- !select_default3 --
+
+-- !select_default4 --
+
diff --git
a/regression-test/data/correctness_p0/test_stddev_variance_window.csv
b/regression-test/data/correctness_p0/test_stddev_variance_window.csv
new file mode 100644
index 0000000000..20c6349bba
--- /dev/null
+++ b/regression-test/data/correctness_p0/test_stddev_variance_window.csv
@@ -0,0 +1,15 @@
+6 32767 3021 123456 604587.000 true 2014-11-11
2015-03-13 12:36:38 yanhuiacng01 0.1 80699
+10 1991 5014 9223372036854775807 -258.369 false
2015-04-02 2013-04-02 15:16:52 wangyu14 -123456.54 0.235
+12 32767 -2147483647 9223372036854775807 243.325 false
1991-08-11 2013-04-02 15:16:52 liuyuantuo -564.898
3.1415927
+1 1989 1001 11011902 123.123 true 1989-03-21
1989-03-21 13:00:00 wangjing04 0.1 6.333
+2 1986 1001 11011903 1243.500 false 1901-12-31
1989-03-21 13:00:00 wangyu14 20.268 789.25
+4 1991 3021 -11011907 243243.325 false 3124-10-10
2015-03-13 10:30:00 yanhuicang01 2.06 -0.001
+5 1985 5014 -11011903 243.325 true 2015-01-01
2015-03-13 12:36:38 duyunkai@123 -0 -365
+15 1992 3021 11011920 0.000 true 9999-12-12
2015-04-02 00:00:00 3.141592653 20.456
+3 1989 1002 11011905 24453.325 false 2012-03-14
2000-01-01 00:00:00 yuanyuan06 78945 3654
+7 -32767 1002 7210457 3.141 false 1988-03-21 1901-01-01
00:00:00 jingyong 0 6058
+8 255 2147483647 11011920 -0.123 true 1989-03-21
9999-11-11 12:12:00 wangjing05 987456.123 12.14
+9 1991 -2147483647 11011902 -654.654 true
1991-08-11 1989-03-21 13:11:00 wangjing04 0 69.123
+11 1989 25699 -9223372036854775807 0.666 true 2015-04-02
1989-03-21 13:11:00 yuanyuan06 -987.001 4.336
+13 -32767 2147483647 -9223372036854775807 100.001 false
2015-04-02 2015-04-02 00:00:00 weike01 123.456 3.1415927
+14 255 103 11011902 0.000 false 2015-04-02
2015-04-02 00:00:00 3.141592654 2.036
diff --git
a/regression-test/data/query_p0/sql_functions/convertion_functions/sql/castAccessible.out
b/regression-test/data/query_p0/sql_functions/convertion_functions/sql/castAccessible.out
new file mode 100644
index 0000000000..bdfb2ed07e
--- /dev/null
+++
b/regression-test/data/query_p0/sql_functions/convertion_functions/sql/castAccessible.out
@@ -0,0 +1,4 @@
+-- This file is automatically generated. You should know what you did if you
want to edit this
+-- !castAccessible --
+10
+
diff --git
a/regression-test/data/query_p0/sql_functions/horology_functions/sql/dateTimeOperatorsAccessible.out
b/regression-test/data/query_p0/sql_functions/horology_functions/sql/dateTimeOperatorsAccessible.out
new file mode 100644
index 0000000000..bfac26aba9
--- /dev/null
+++
b/regression-test/data/query_p0/sql_functions/horology_functions/sql/dateTimeOperatorsAccessible.out
@@ -0,0 +1,4 @@
+-- This file is automatically generated. You should know what you did if you
want to edit this
+-- !dateTimeOperatorsAccessible --
+2012-08-10T00:00 2012-08-09T06:00 2012-11-30T01:00
2012-08-06T00:00 2012-08-06T20:00 2012-09-30T01:00
+
diff --git
a/regression-test/data/query_p0/sql_functions/horology_functions/sql/extractAccessible.out
b/regression-test/data/query_p0/sql_functions/horology_functions/sql/extractAccessible.out
new file mode 100644
index 0000000000..0caeb29700
--- /dev/null
+++
b/regression-test/data/query_p0/sql_functions/horology_functions/sql/extractAccessible.out
@@ -0,0 +1,4 @@
+-- This file is automatically generated. You should know what you did if you
want to edit this
+-- !extractAccessible --
+22
+
diff --git a/regression-test/data/rollup_p0/test_materialized_view.out
b/regression-test/data/rollup_p0/test_materialized_view.out
index 6c679aa19c..c390165cf8 100644
Binary files a/regression-test/data/rollup_p0/test_materialized_view.out and
b/regression-test/data/rollup_p0/test_materialized_view.out differ
diff --git
a/regression-test/framework/src/main/groovy/org/apache/doris/regression/suite/Suite.groovy
b/regression-test/framework/src/main/groovy/org/apache/doris/regression/suite/Suite.groovy
index 5b73eb4116..184422e1f5 100644
---
a/regression-test/framework/src/main/groovy/org/apache/doris/regression/suite/Suite.groovy
+++
b/regression-test/framework/src/main/groovy/org/apache/doris/regression/suite/Suite.groovy
@@ -408,6 +408,7 @@ class Suite implements GroovyInterceptable {
throw new IllegalStateException("Check tag '${tag}' failed,
sql:\n${sql}", t)
}
if (errorMsg != null) {
+ logger.warn("expect results: " + expectCsvResults +
"\nrealResults: " + realResults)
throw new IllegalStateException("Check tag '${tag}'
failed:\n${errorMsg}\n\nsql:\n${sql}")
}
}
diff --git
a/regression-test/suites/correctness_p0/test_char_implicit_cast.groovy
b/regression-test/suites/correctness_p0/test_char_implicit_cast.groovy
new file mode 100644
index 0000000000..6dd2ace36a
--- /dev/null
+++ b/regression-test/suites/correctness_p0/test_char_implicit_cast.groovy
@@ -0,0 +1,25 @@
+// Licensed to the Apache Software Foundation (ASF) under one
+// or more contributor license agreements. See the NOTICE file
+// distributed with this work for additional information
+// regarding copyright ownership. The ASF licenses this file
+// to you under the Apache License, Version 2.0 (the
+// "License"); you may not use this file except in compliance
+// with the License. You may obtain a copy of the License at
+//
+// http://www.apache.org/licenses/LICENSE-2.0
+//
+// Unless required by applicable law or agreed to in writing,
+// software distributed under the License is distributed on an
+// "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+// KIND, either express or implied. See the License for the
+// specific language governing permissions and limitations
+// under the License.
+
+suite("test_char_implicit_cast") {
+ qt_test_dayofweek_varchar 'select dayofweek("2012-12-01");'
+ qt_test_dayofweek_char 'select dayofweek(cast("2012-12-01" as char(16)));'
+ qt_test_timediff_varchar 'select timediff("2010-01-01 01:00:00",
"2010-01-02 01:00:00");'
+ qt_test_timediff_char 'select timediff("2010-01-01 01:00:00",
cast("2010-01-02 01:00:00" as char));'
+ qt_test_money_format_varchar 'select money_format("123456");'
+ qt_test_money_format_char 'select money_format(cast("123456" as char));'
+}
diff --git a/regression-test/suites/correctness_p0/test_lag_lead_window.groovy
b/regression-test/suites/correctness_p0/test_lag_lead_window.groovy
index 365700c4d6..d269b1621d 100644
--- a/regression-test/suites/correctness_p0/test_lag_lead_window.groovy
+++ b/regression-test/suites/correctness_p0/test_lag_lead_window.groovy
@@ -31,13 +31,27 @@ suite("test_lag_lead_window") {
('b','aa','/wyyt-image/2022/04/13/1434607674511761493.jpg'),
('c','cc','/wyyt-image/2022/04/13/1434607674511761493.jpg') """
- // not_vectorized
sql """ set enable_vectorized_engine = false """
-
- qt_select_default """ select min(t.cc) over(PARTITION by t.cc order by
t.aa) ,
- lag(t.cc,1,'') over (PARTITION by t.cc order by
t.aa) as l1 from ${tableName} t order by aa, bb, cc; """
-
- qt_select_default2 """ select min(t.cc) over(PARTITION by t.cc order by
t.aa) ,
- lead(t.cc,1,'') over (PARTITION by t.cc order by
t.aa) as l1 from ${tableName} t order by aa, bb, cc; """
-
-}
\ No newline at end of file
+ qt_select_default """
+ select aa, bb, min(cc) over(PARTITION by cc order by aa) ,
+ lag(cc,1,'unknown') over (PARTITION by cc order by aa) as lag_cc
+ from ${tableName}
+ order by aa; """
+
+ qt_select_default2 """ select aa, bb, min(cc) over(PARTITION by cc order
by aa) ,
+ lead(cc,1,'') over (PARTITION by cc order
by aa) as lead_cc
+ from ${tableName}
+ order by aa; """
+
+ sql """ set enable_vectorized_engine = true """
+ qt_select_default """
+ select aa, bb, min(cc) over(PARTITION by cc order by aa) ,
+ lag(cc,1,'unknown') over (PARTITION by cc order by aa) as lag_cc
+ from ${tableName}
+ order by aa; """
+
+ qt_select_default2 """ select aa, bb, min(cc) over(PARTITION by cc order
by aa) ,
+ lead(cc,1,'') over (PARTITION by cc order
by aa) as lead_cc
+ from ${tableName}
+ order by aa; """
+}
diff --git
a/regression-test/suites/correctness_p0/test_outer_join_with_window_function.groovy
b/regression-test/suites/correctness_p0/test_outer_join_with_window_function.groovy
new file mode 100644
index 0000000000..ce6f79edf7
--- /dev/null
+++
b/regression-test/suites/correctness_p0/test_outer_join_with_window_function.groovy
@@ -0,0 +1,289 @@
+// Licensed to the Apache Software Foundation (ASF) under one
+// or more contributor license agreements. See the NOTICE file
+// distributed with this work for additional information
+// regarding copyright ownership. The ASF licenses this file
+// to you under the Apache License, Version 2.0 (the
+// "License"); you may not use this file except in compliance
+// with the License. You may obtain a copy of the License at
+//
+// http://www.apache.org/licenses/LICENSE-2.0
+//
+// Unless required by applicable law or agreed to in writing,
+// software distributed under the License is distributed on an
+// "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+// KIND, either express or implied. See the License for the
+// specific language governing permissions and limitations
+// under the License.
+
+suite("test_outer_join_with_with_window_function") {
+ sql """
+ drop table if exists dwd_online_detail;
+ """
+
+ sql """
+ CREATE TABLE `dwd_online_detail` (
+ `logout_time` datetime NOT NULL DEFAULT "9999-12-30 00:00:00",
+ `login_time` datetime NOT NULL DEFAULT "9999-12-30 00:00:00",
+ `game_code` varchar(50) NOT NULL DEFAULT "-",
+ `plat_code` varchar(50) NOT NULL DEFAULT "-",
+ `account` varchar(255) NOT NULL DEFAULT "-",
+ `playerid` varchar(255) NOT NULL DEFAULT "-",
+ `userid` varchar(255) NOT NULL DEFAULT "-",
+ `pid_code` varchar(50) NOT NULL DEFAULT "-",
+ `gid_code` varchar(50) NOT NULL DEFAULT "-",
+ `org_sid` int(11) NOT NULL DEFAULT "0",
+ `ct_sid` int(11) NOT NULL DEFAULT "0",
+ `next_login_time` datetime NOT NULL DEFAULT "9999-12-30 00:00:00"
+ ) ENGINE=OLAP
+ DUPLICATE KEY(`logout_time`, `login_time`, `game_code`, `plat_code`,
`account`, `playerid`, `userid`)
+ PARTITION BY RANGE(`logout_time`)
+ (PARTITION p99991230 VALUES [('9999-12-30 00:00:00'), ('9999-12-31
00:00:00')))
+ DISTRIBUTED BY HASH(`game_code`, `plat_code`) BUCKETS 4
+ PROPERTIES (
+ "replication_allocation" = "tag.location.default: 1",
+ "colocate_with" = "gp_group"
+ );
+ """
+
+ sql """
+ drop table if exists ods_logout;
+ """
+
+ sql """
+ CREATE TABLE `ods_logout` (
+ `day` date NULL COMMENT "",
+ `game` varchar(500) NULL COMMENT "",
+ `plat` varchar(500) NULL COMMENT "",
+ `dt` datetime NULL COMMENT "",
+ `time` bigint(20) NULL COMMENT "",
+ `sid` int(11) NULL COMMENT "",
+ `pid` varchar(500) NULL COMMENT "",
+ `gid` varchar(500) NULL COMMENT "",
+ `account` varchar(500) NULL COMMENT "",
+ `playerid` varchar(500) NULL COMMENT "",
+ `prop` varchar(500) NULL COMMENT "",
+ `p01` varchar(500) NULL COMMENT "",
+ `p02` varchar(500) NULL COMMENT "",
+ `p03` varchar(500) NULL COMMENT "",
+ `p04` varchar(500) NULL COMMENT "",
+ `p05` varchar(500) NULL COMMENT "",
+ `p06` varchar(500) NULL COMMENT "",
+ `p07` varchar(500) NULL COMMENT "",
+ `p08` varchar(500) NULL COMMENT "",
+ `p09` varchar(500) NULL COMMENT "",
+ `p10` varchar(500) NULL COMMENT "",
+ `p11` varchar(500) NULL COMMENT "",
+ `p12` varchar(500) NULL COMMENT "",
+ `p13` varchar(500) NULL COMMENT "",
+ `p14` varchar(500) NULL COMMENT "",
+ `p15` varchar(500) NULL COMMENT ""
+ ) ENGINE=OLAP
+ DUPLICATE KEY(`day`, `game`, `plat`)
+ PARTITION BY RANGE(`day`)
+ (PARTITION p201907 VALUES [('2019-07-01'), ('2019-08-01')))
+ DISTRIBUTED BY HASH(`game`, `plat`) BUCKETS 4
+ PROPERTIES (
+ "replication_allocation" = "tag.location.default: 1"
+ );
+ """
+
+ sql """
+ drop table if exists dim_account_userid_mapping;
+ """
+
+ sql """
+ CREATE TABLE `dim_account_userid_mapping` (
+ `end_time` datetime NOT NULL DEFAULT "9999-12-30 00:00:00",
+ `start_time` datetime NOT NULL DEFAULT "9999-12-30 00:00:00",
+ `game_code` varchar(50) NOT NULL,
+ `plat_code` varchar(50) NOT NULL,
+ `userkey` varchar(255) NOT NULL,
+ `userid` varchar(255) NOT NULL,
+ `account` varchar(255) NOT NULL,
+ `pid_code` varchar(50) NOT NULL DEFAULT "-",
+ `gid_code` varchar(50) NOT NULL DEFAULT "-",
+ `region` varchar(50) NOT NULL DEFAULT "-"
+ ) ENGINE=OLAP
+ DUPLICATE KEY(`end_time`, `start_time`, `game_code`, `plat_code`,
`userkey`)
+ PARTITION BY RANGE(`end_time`)
+ (PARTITION p20190705 VALUES [('2019-07-05 00:00:00'), ('2019-07-06
00:00:00')))
+ DISTRIBUTED BY HASH(`game_code`, `plat_code`) BUCKETS 4
+ PROPERTIES (
+ "replication_allocation" = "tag.location.default: 1",
+ "colocate_with" = "gp_group"
+ );
+ """
+
+ sql """
+ drop table if exists ods_login;
+ """
+
+ sql """
+ CREATE TABLE `ods_login` (
+ `day` date NULL COMMENT "",
+ `game` varchar(500) NULL COMMENT "",
+ `plat` varchar(500) NULL COMMENT "",
+ `dt` datetime NULL COMMENT "",
+ `time` bigint(20) NULL COMMENT "",
+ `sid` int(11) NULL COMMENT "",
+ `pid` varchar(500) NULL COMMENT "",
+ `gid` varchar(500) NULL COMMENT "",
+ `account` varchar(500) NULL COMMENT "",
+ `playerid` varchar(500) NULL COMMENT "",
+ `prop` varchar(500) NULL COMMENT "",
+ `p01` varchar(500) NULL COMMENT "",
+ `p02` varchar(500) NULL COMMENT "",
+ `p03` varchar(500) NULL COMMENT "",
+ `p04` varchar(500) NULL COMMENT "",
+ `p05` varchar(500) NULL COMMENT "",
+ `p06` varchar(500) NULL COMMENT "",
+ `p07` varchar(500) NULL COMMENT "",
+ `p08` varchar(500) NULL COMMENT "",
+ `p09` varchar(500) NULL COMMENT "",
+ `p10` varchar(500) NULL COMMENT "",
+ `p11` varchar(500) NULL COMMENT "",
+ `p12` varchar(500) NULL COMMENT "",
+ `p13` varchar(500) NULL COMMENT "",
+ `p14` varchar(500) NULL COMMENT "",
+ `p15` varchar(500) NULL COMMENT ""
+ ) ENGINE=OLAP
+ DUPLICATE KEY(`day`, `game`, `plat`)
+ COMMENT "登录ods"
+ PARTITION BY RANGE(`day`)
+ (PARTITION p201803 VALUES [('2018-03-01'), ('2018-04-01')),
+ PARTITION p201804 VALUES [('2018-04-01'), ('2018-05-01')),
+ PARTITION p201805 VALUES [('2018-05-01'), ('2018-06-01')),
+ PARTITION p201806 VALUES [('2018-06-01'), ('2018-07-01')),
+ PARTITION p201807 VALUES [('2018-07-01'), ('2018-08-01')),
+ PARTITION p201808 VALUES [('2018-08-01'), ('2018-09-01')),
+ PARTITION p201809 VALUES [('2018-09-01'), ('2018-10-01')),
+ PARTITION p201810 VALUES [('2018-10-01'), ('2018-11-01')),
+ PARTITION p201811 VALUES [('2018-11-01'), ('2018-12-01')),
+ PARTITION p201812 VALUES [('2018-12-01'), ('2019-01-01')),
+ PARTITION p201901 VALUES [('2019-01-01'), ('2019-02-01')),
+ PARTITION p201902 VALUES [('2019-02-01'), ('2019-03-01')),
+ PARTITION p201903 VALUES [('2019-03-01'), ('2019-04-01')),
+ PARTITION p201904 VALUES [('2019-04-01'), ('2019-05-01')),
+ PARTITION p201905 VALUES [('2019-05-01'), ('2019-06-01')),
+ PARTITION p201906 VALUES [('2019-06-01'), ('2019-07-01')),
+ PARTITION p201907 VALUES [('2019-07-01'), ('2019-08-01')),
+ PARTITION p201908 VALUES [('2019-08-01'), ('2019-09-01')),
+ PARTITION p201909 VALUES [('2019-09-01'), ('2019-10-01')),
+ PARTITION p201910 VALUES [('2019-10-01'), ('2019-11-01')),
+ PARTITION p201911 VALUES [('2019-11-01'), ('2019-12-01')),
+ PARTITION p201912 VALUES [('2019-12-01'), ('2020-01-01')),
+ PARTITION p202001 VALUES [('2020-01-01'), ('2020-02-01')),
+ PARTITION p202002 VALUES [('2020-02-01'), ('2020-03-01')),
+ PARTITION p202003 VALUES [('2020-03-01'), ('2020-04-01')),
+ PARTITION p202004 VALUES [('2020-04-01'), ('2020-05-01')),
+ PARTITION p202005 VALUES [('2020-05-01'), ('2020-06-01')),
+ PARTITION p202006 VALUES [('2020-06-01'), ('2020-07-01')),
+ PARTITION p202007 VALUES [('2020-07-01'), ('2020-08-01')),
+ PARTITION p202008 VALUES [('2020-08-01'), ('2020-09-01')),
+ PARTITION p202009 VALUES [('2020-09-01'), ('2020-10-01')),
+ PARTITION p202010 VALUES [('2020-10-01'), ('2020-11-01')),
+ PARTITION p202011 VALUES [('2020-11-01'), ('2020-12-01')),
+ PARTITION p202012 VALUES [('2020-12-01'), ('2021-01-01')),
+ PARTITION p202101 VALUES [('2021-01-01'), ('2021-02-01')),
+ PARTITION p202102 VALUES [('2021-02-01'), ('2021-03-01')),
+ PARTITION p202103 VALUES [('2021-03-01'), ('2021-04-01')),
+ PARTITION p202104 VALUES [('2021-04-01'), ('2021-05-01')),
+ PARTITION p202105 VALUES [('2021-05-01'), ('2021-06-01')),
+ PARTITION p202106 VALUES [('2021-06-01'), ('2021-07-01')),
+ PARTITION p202107 VALUES [('2021-07-01'), ('2021-08-01')),
+ PARTITION p202108 VALUES [('2021-08-01'), ('2021-09-01')),
+ PARTITION p202109 VALUES [('2021-09-01'), ('2021-10-01')),
+ PARTITION p202110 VALUES [('2021-10-01'), ('2021-11-01')),
+ PARTITION p202111 VALUES [('2021-11-01'), ('2021-12-01')),
+ PARTITION p202112 VALUES [('2021-12-01'), ('2022-01-01')),
+ PARTITION p202201 VALUES [('2022-01-01'), ('2022-02-01')),
+ PARTITION p202202 VALUES [('2022-02-01'), ('2022-03-01')),
+ PARTITION p202203 VALUES [('2022-03-01'), ('2022-04-01')),
+ PARTITION p202204 VALUES [('2022-04-01'), ('2022-05-01')),
+ PARTITION p202205 VALUES [('2022-05-01'), ('2022-06-01')),
+ PARTITION p202206 VALUES [('2022-06-01'), ('2022-07-01')),
+ PARTITION p202207 VALUES [('2022-07-01'), ('2022-08-01')),
+ PARTITION p202208 VALUES [('2022-08-01'), ('2022-09-01')),
+ PARTITION p202209 VALUES [('2022-09-01'), ('2022-10-01')))
+ DISTRIBUTED BY HASH(`game`, `plat`) BUCKETS 4
+ PROPERTIES (
+ "replication_allocation" = "tag.location.default: 1",
+ "dynamic_partition.enable" = "true",
+ "dynamic_partition.time_unit" = "MONTH",
+ "dynamic_partition.time_zone" = "Asia/Shanghai",
+ "dynamic_partition.start" = "-2147483648",
+ "dynamic_partition.end" = "3",
+ "dynamic_partition.prefix" = "p",
+ "dynamic_partition.replication_allocation" = "tag.location.default: 1",
+ "dynamic_partition.buckets" = "4",
+ "dynamic_partition.create_history_partition" = "true",
+ "dynamic_partition.history_partition_num" = "50",
+ "dynamic_partition.hot_partition_num" = "2",
+ "dynamic_partition.reserved_history_periods" = "NULL",
+ "dynamic_partition.start_day_of_month" = "1",
+ "in_memory" = "false",
+ "storage_format" = "V2");
+ """
+
+ sql """
+ insert into ods_logout(day, game, plat, playerid, dt)
values('2019-07-05', 'abc', 'xyz', '1136638398824557', '2019-07-05 00:00:00');
+ """
+
+ sql """
+ insert into dwd_online_detail(game_code, plat_code, playerid, account,
org_sid, ct_sid, login_time, logout_time, pid_code,gid_code)
+ values('abc', 'xyz', '1577946288488507', '1492704224', '421001',
'421001', '2020-01-19 11:15:21', '9999-12-30 00:00:00', '-', '-');
+ """
+
+ qt_select """
+ SELECT
online_detail.game_code,online_detail.plat_code,online_detail.playerid,online_detail.account,online_detail.org_sid
, online_detail.ct_sid ,
+ online_detail.login_time,if(online_detail.logout_time='9999-12-30
00:00:00',coalesce(logout.dt,online_detail.next_login_time),online_detail.logout_time)
logout_time ,online_detail.next_login_time,online_detail.userid
+ ,online_detail.pid_code,online_detail.gid_code
+ from
+ (select
+
tmp.game_code,tmp.plat_code,tmp.playerid,tmp.account,tmp.org_sid,tmp.ct_sid,tmp.login_time,tmp.logout_time,
+ LEAD(tmp.login_time,1, '9999-12-30 00:00:00') over
(partition by tmp.game_code,tmp.plat_code,tmp.playerid order by tmp.login_time)
next_login_time,
+ COALESCE (mp.userid,'-') userid,COALESCE
(mp.pid_code,'-') pid_code,COALESCE (mp.gid_code,'-') gid_code
+ from
+ (select * from dim_account_userid_mapping
+ where start_time < convert_tz(date_add('2019-07-05
00:00:00',INTERVAL 1 day),'Asia/Shanghai','Asia/Shanghai')
+ and end_time >= convert_tz('2019-07-05
00:00:00','Asia/Shanghai','Asia/Shanghai')
+ and game_code ='abc' and plat_code='xyz'
+ ) mp
+ right join
+ (
+ select *,concat_ws('_',pid_code,gid_code,account) userkey
from
+ (select
game_code,plat_code,playerid,account,org_sid,ct_sid,login_time,logout_time,pid_code,gid_code
+ from dwd_online_detail where logout_time='9999-12-30
00:00:00' and game_code='abc' and plat_code ='xyz'
+ union all
+ select game game_code,plat plat_code,playerid,account,sid
org_sid,cast(p08 as int) ct_sid,dt login_time,'9999-12-30 00:00:00'
logout_time,pid pid_code,gid gid_code
+ from ods_login
+ where game='abc' and `plat` = 'xyz'
+ AND dt BETWEEN convert_tz('2019-07-05
00:00:00','Asia/Shanghai','Asia/Shanghai')
+ and convert_tz('2019-07-05
23:59:59','Asia/Shanghai','Asia/Shanghai')
+ and day BETWEEN date_sub('2019-07-05',INTERVAL 1 DAY )
and date_add('2019-07-05',INTERVAL 1 DAY )
+ group by 1,2,3,4,5,6,7,8,9,10
+ ) t
+ ) tmp
+ on mp.game_code=tmp.game_code and mp.plat_code =
tmp.plat_code and mp.userkey = tmp.userkey
+ and tmp.login_time >= mp.start_time and tmp.login_time
< mp.end_time
+ ) online_detail
+ left JOIN
+ (select day,game game_code,plat plat_code,playerid, dt
+ from ods_logout dlt
+ where game='abc' and `plat` = 'xyz'
+ and dt BETWEEN convert_tz('2019-07-05
00:00:00','Asia/Shanghai','Asia/Shanghai')
+ and convert_tz('2019-07-05
23:59:59','Asia/Shanghai','Asia/Shanghai')
+ and day BETWEEN date_sub('2019-07-05',INTERVAL
1 DAY ) and date_add('2019-07-05',INTERVAL 1 DAY )
+ group by 1,2,3,4,5
+ ) logout
+ on online_detail.game_code=logout.game_code and
online_detail.plat_code=logout.plat_code
+ and online_detail.playerid=logout.playerid
+ and logout.dt>online_detail.login_time and logout.dt <
online_detail.next_login_time
+ union all
+ select
game_code,plat_code,playerid,account,org_sid,ct_sid,login_time,logout_time,next_login_time,userid,pid_code,gid_code
+ from dwd_online_detail
+ where logout_time BETWEEN convert_tz('2019-07-05
00:00:00','Asia/Shanghai','Asia/Shanghai')
+ and convert_tz('2019-07-05
23:59:59','Asia/Shanghai','Asia/Shanghai')
+ and not (game_code='abc' and `plat_code` = 'xyz' );
+ """
+}
diff --git a/regression-test/suites/correctness_p0/test_select_constant.groovy
b/regression-test/suites/correctness_p0/test_select_constant.groovy
new file mode 100644
index 0000000000..6015e19576
--- /dev/null
+++ b/regression-test/suites/correctness_p0/test_select_constant.groovy
@@ -0,0 +1,21 @@
+// Licensed to the Apache Software Foundation (ASF) under one
+// or more contributor license agreements. See the NOTICE file
+// distributed with this work for additional information
+// regarding copyright ownership. The ASF licenses this file
+// to you under the Apache License, Version 2.0 (the
+// "License"); you may not use this file except in compliance
+// with the License. You may obtain a copy of the License at
+//
+// http://www.apache.org/licenses/LICENSE-2.0
+//
+// Unless required by applicable law or agreed to in writing,
+// software distributed under the License is distributed on an
+// "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+// KIND, either express or implied. See the License for the
+// specific language governing permissions and limitations
+// under the License.
+
+suite("test_select_constant") {
+ qt_select1 'select 100, "test", date("2021-01-02");'
+ qt_select_geo1 'SELECT
ST_AsText(ST_Point(123.12345678901234567890,89.1234567890));'
+}
diff --git
a/regression-test/suites/correctness_p0/test_select_stddev_variance_window.groovy
b/regression-test/suites/correctness_p0/test_select_stddev_variance_window.groovy
new file mode 100644
index 0000000000..17bfeaa9e1
--- /dev/null
+++
b/regression-test/suites/correctness_p0/test_select_stddev_variance_window.groovy
@@ -0,0 +1,158 @@
+// Licensed to the Apache Software Foundation (ASF) under one
+// or more contributor license agreements. See the NOTICE file
+// distributed with this work for additional information
+// regarding copyright ownership. The ASF licenses this file
+// to you under the Apache License, Version 2.0 (the
+// "License"); you may not use this file except in compliance
+// with the License. You may obtain a copy of the License at
+//
+// http://www.apache.org/licenses/LICENSE-2.0
+//
+// Unless required by applicable law or agreed to in writing,
+// software distributed under the License is distributed on an
+// "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+// KIND, either express or implied. See the License for the
+// specific language governing permissions and limitations
+// under the License.
+suite("test_select_stddev_variance_window") {
+ def tableName = "stddev_variance_window"
+
+ sql """ DROP TABLE IF EXISTS ${tableName} """
+ sql """
+ CREATE TABLE `${tableName}` (
+ `k1` tinyint(4) NULL COMMENT "",
+ `k2` smallint(6) NULL COMMENT "",
+ `k3` int(11) NULL COMMENT "",
+ `k4` bigint(20) NULL COMMENT "",
+ `k5` decimal(9, 3) NULL COMMENT "",
+ `k6` char(5) NULL COMMENT "",
+ `k10` date NULL COMMENT "",
+ `k11` datetime NULL COMMENT "",
+ `k7` varchar(20) NULL COMMENT "",
+ `k8` double NULL COMMENT "",
+ `k9` float NULL COMMENT ""
+ ) ENGINE=OLAP
+ DUPLICATE KEY(`k1`, `k2`, `k3`, `k4`, `k5`, `k6`, `k10`, `k11`,
`k7`)
+ COMMENT "OLAP"
+ DISTRIBUTED BY HASH(`k1`) BUCKETS 5
+ PROPERTIES (
+ "replication_allocation" = "tag.location.default: 1",
+ "in_memory" = "false",
+ "storage_format" = "V2"
+ );
+ """
+ streamLoad {
+ table tableName
+
+ // default label is UUID:
+ // set 'label' UUID.randomUUID().toString()
+
+ // default column_separator is specify in doris fe config, usually is
'\t'.
+ // this line change to ','
+ set 'column_separator', '\t'
+
+ // relate to
${DORIS_HOME}/regression-test/data/demo/streamload_input.csv.
+ // also, you can stream load a http stream, e.g. http://xxx/some.csv
+ file 'test_stddev_variance_window.csv'
+
+ time 10000 // limit inflight 10s
+
+ // stream load action will check result, include Success status, and
NumberTotalRows == NumberLoadedRows
+
+ // if declared a check callback, the default check condition will
ignore.
+ // So you must check all condition
+ check { result, exception, startTime, endTime ->
+ if (exception != null) {
+ throw exception
+ }
+ log.info("Stream load result: ${result}".toString())
+ def json = parseJson(result)
+ assertEquals("success", json.Status.toLowerCase())
+ assertEquals(json.NumberTotalRows, json.NumberLoadedRows)
+ assertTrue(json.NumberLoadedRows > 0 && json.LoadBytes > 0)
+ }
+ }
+
+ sql "sync"
+
+ // Not Vectorized
+ sql """ set enable_vectorized_engine = false """
+
+ qt_select_default "select k1, stddev_pop(k2) over (partition by k6 order
by k1 rows between 3 preceding and unbounded following) from ${tableName}
order by k1;"
+ qt_select_default "select k1, stddev_pop(k2) over (partition by k6 order
by k1 rows between 3 preceding and 1 preceding) from ${tableName} order by
k1;"
+ qt_select_default "select k1, stddev_pop(k2) over (partition by k6 order
by k1 rows between 3 preceding and 1 following) from ${tableName} order by
k1;"
+ qt_select_default "select k1, stddev_pop(k2) over (partition by k6 order
by k1 rows between current row and current row) from ${tableName} order by
k1;"
+ qt_select_default "select k1, stddev_pop(k2) over (partition by k6 order
by k1 rows between current row and unbounded following) from ${tableName}
order by k1;"
+ qt_select_default "select k1, stddev_pop(k2) over (partition by k6 order
by k1) from ${tableName} order by k1;"
+
+ qt_select_default "select k1, stddev_samp(k2) over (partition by k6 order
by k1 rows between 3 preceding and unbounded following) from ${tableName}
order by k1;"
+ qt_select_default "select k1, stddev_samp(k2) over (partition by k6 order
by k1 rows between 3 preceding and 1 preceding) from ${tableName} order by
k1;"
+ qt_select_default "select k1, stddev_samp(k2) over (partition by k6 order
by k1 rows between 3 preceding and 1 following) from ${tableName} order by
k1;"
+ qt_select_default "select k1, stddev_samp(k2) over (partition by k6 order
by k1 rows between current row and current row) from ${tableName} order by
k1;"
+ qt_select_default "select k1, stddev_samp(k2) over (partition by k6 order
by k1 rows between current row and unbounded following) from ${tableName}
order by k1;"
+ qt_select_default "select k1, stddev_samp(k2) over (partition by k6 order
by k1) from ${tableName} order by k1;"
+
+ qt_select_default "select k1, variance_pop(k2) over (partition by k6
order by k1 rows between 3 preceding and unbounded following) from
${tableName} order by k1;"
+ qt_select_default "select k1, variance_pop(k2) over (partition by k6
order by k1 rows between 3 preceding and 1 preceding) from ${tableName} order
by k1;"
+ qt_select_default "select k1, variance_pop(k2) over (partition by k6
order by k1 rows between 3 preceding and 1 following) from ${tableName} order
by k1;"
+ qt_select_default "select k1, variance_pop(k2) over (partition by k6
order by k1 rows between current row and current row) from ${tableName} order
by k1;"
+ qt_select_default "select k1, variance_pop(k2) over (partition by k6
order by k1 rows between current row and unbounded following) from
${tableName} order by k1;"
+ qt_select_default "select k1, variance_pop(k2) over (partition by k6
order by k1) from ${tableName} order by k1;"
+
+ qt_select_default "select k1, variance_samp(k2) over (partition by k6
order by k1 rows between 3 preceding and unbounded following) from
${tableName} order by k1;"
+ qt_select_default "select k1, variance_samp(k2) over (partition by k6
order by k1 rows between 3 preceding and 1 preceding) from ${tableName} order
by k1;"
+ qt_select_default "select k1, variance_samp(k2) over (partition by k6
order by k1 rows between 3 preceding and 1 following) from ${tableName} order
by k1;"
+ qt_select_default "select k1, variance_samp(k2) over (partition by k6
order by k1 rows between current row and current row) from ${tableName} order
by k1;"
+ qt_select_default "select k1, variance_samp(k2) over (partition by k6
order by k1 rows between current row and unbounded following) from
${tableName} order by k1;"
+ qt_select_default "select k1, variance_samp(k2) over (partition by k6
order by k1) from ${tableName} order by k1;"
+
+ // vectorized
+ sql """ set enable_vectorized_engine = true """
+
+ qt_select_default "select k1, stddev_pop(k2) over (partition by k6 order
by k1 rows between 3 preceding and unbounded following) from ${tableName} order
by k1;"
+ qt_select_default "select k1, stddev_pop(k2) over (partition by k6 order
by k1 rows between 3 preceding and 1 preceding) from ${tableName} order by k1;"
+ qt_select_default "select k1, stddev_pop(k2) over (partition by k6 order
by k1 rows between 3 preceding and 1 following) from ${tableName} order by k1;"
+ qt_select_default "select k1, stddev_pop(k2) over (partition by k6 order
by k1 rows between current row and current row) from ${tableName} order by k1;"
+ qt_select_default "select k1, stddev_pop(k2) over (partition by k6 order
by k1 rows between current row and unbounded following) from ${tableName} order
by k1;"
+ qt_select_default "select k1, stddev_pop(k2) over (partition by k6 order
by k1) from ${tableName} order by k1;"
+
+ qt_select_default "select k1, stddev_samp(k2) over (partition by k6 order
by k1 rows between 3 preceding and unbounded following) from ${tableName} order
by k1;"
+ qt_select_default "select k1, stddev_samp(k2) over (partition by k6 order
by k1 rows between 3 preceding and 1 preceding) from ${tableName} order by k1;"
+ qt_select_default "select k1, stddev_samp(k2) over (partition by k6 order
by k1 rows between 3 preceding and 1 following) from ${tableName} order by k1;"
+ qt_select_default "select k1, stddev_samp(k2) over (partition by k6 order
by k1 rows between current row and current row) from ${tableName} order by k1;"
+ qt_select_default "select k1, stddev_samp(k2) over (partition by k6 order
by k1 rows between current row and unbounded following) from ${tableName} order
by k1;"
+ qt_select_default "select k1, stddev_samp(k2) over (partition by k6 order
by k1) from ${tableName} order by k1;"
+
+ qt_select_default "select k1, variance_pop(k2) over (partition by k6
order by k1 rows between 3 preceding and unbounded following) from ${tableName}
order by k1;"
+ qt_select_default "select k1, variance_pop(k2) over (partition by k6
order by k1 rows between 3 preceding and 1 preceding) from ${tableName} order
by k1;"
+ qt_select_default "select k1, variance_pop(k2) over (partition by k6
order by k1 rows between 3 preceding and 1 following) from ${tableName} order
by k1;"
+ qt_select_default "select k1, variance_pop(k2) over (partition by k6
order by k1 rows between current row and current row) from ${tableName} order
by k1;"
+ qt_select_default "select k1, variance_pop(k2) over (partition by k6
order by k1 rows between current row and unbounded following) from ${tableName}
order by k1;"
+ qt_select_default "select k1, variance_pop(k2) over (partition by k6
order by k1) from ${tableName} order by k1;"
+
+ qt_select_default "select k1, variance_samp(k2) over (partition by k6
order by k1 rows between 3 preceding and unbounded following) from ${tableName}
order by k1;"
+ qt_select_default "select k1, variance_samp(k2) over (partition by k6
order by k1 rows between 3 preceding and 1 preceding) from ${tableName} order
by k1;"
+ qt_select_default "select k1, variance_samp(k2) over (partition by k6
order by k1 rows between 3 preceding and 1 following) from ${tableName} order
by k1;"
+ qt_select_default "select k1, variance_samp(k2) over (partition by k6
order by k1 rows between current row and current row) from ${tableName} order
by k1;"
+ qt_select_default "select k1, variance_samp(k2) over (partition by k6
order by k1 rows between current row and unbounded following) from ${tableName}
order by k1;"
+ qt_select_default "select k1, variance_samp(k2) over (partition by k6
order by k1) from ${tableName} order by k1;"
+
+ qt_select_default "select k1, percentile(k2,0.8) over (partition by k6
order by k1 rows between 3 preceding and unbounded following) from ${tableName}
order by k1;"
+ qt_select_default "select k1, percentile(k2,0.8) over (partition by k6
order by k1 rows between 3 preceding and 1 preceding) from ${tableName} order
by k1;"
+ qt_select_default "select k1, percentile(k2,0.8) over (partition by k6
order by k1 rows between 3 preceding and 1 following) from ${tableName} order
by k1;"
+ qt_select_default "select k1, percentile(k2,0.8) over (partition by k6
order by k1 rows between current row and current row) from ${tableName} order
by k1;"
+ qt_select_default "select k1, percentile(k2,0.8) over (partition by k6
order by k1 rows between current row and unbounded following) from ${tableName}
order by k1;"
+ qt_select_default "select k1, percentile(k2,0.8) over (partition by k6
order by k1) from ${tableName} order by k1;"
+
+ qt_select_default "select k1, percentile_approx(k2,0.8,4096) over
(partition by k6 order by k1 rows between 3 preceding and unbounded following)
from ${tableName} order by k1;"
+ qt_select_default "select k1, percentile_approx(k2,0.8,4096) over
(partition by k6 order by k1 rows between 3 preceding and 1 preceding) from
${tableName} order by k1;"
+ qt_select_default "select k1, percentile_approx(k2,0.8,4096) over
(partition by k6 order by k1 rows between 3 preceding and 1 following) from
${tableName} order by k1;"
+ qt_select_default "select k1, percentile_approx(k2,0.8,4096) over
(partition by k6 order by k1 rows between current row and current row) from
${tableName} order by k1;"
+ qt_select_default "select k1, percentile_approx(k2,0.8,4096) over
(partition by k6 order by k1 rows between current row and unbounded following)
from ${tableName} order by k1;"
+ qt_select_default "select k1, percentile_approx(k2,0.8,4096) over
(partition by k6 order by k1) from ${tableName} order by k1;"
+}
+
+
+
+
+
diff --git
a/regression-test/suites/correctness_p0/test_select_with_predicate_like.groovy
b/regression-test/suites/correctness_p0/test_select_with_predicate_like.groovy
new file mode 100644
index 0000000000..9491c4271c
--- /dev/null
+++
b/regression-test/suites/correctness_p0/test_select_with_predicate_like.groovy
@@ -0,0 +1,35 @@
+// Licensed to the Apache Software Foundation (ASF) under one
+// or more contributor license agreements. See the NOTICE file
+// distributed with this work for additional information
+// regarding copyright ownership. The ASF licenses this file
+// to you under the Apache License, Version 2.0 (the
+// "License"); you may not use this file except in compliance
+// with the License. You may obtain a copy of the License at
+//
+// http://www.apache.org/licenses/LICENSE-2.0
+//
+// Unless required by applicable law or agreed to in writing,
+// software distributed under the License is distributed on an
+// "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+// KIND, either express or implied. See the License for the
+// specific language governing permissions and limitations
+// under the License.
+suite("test_select_with_predicate_like") {
+ def tables=["test_basic_agg"]
+
+ for (String table in tables) {
+ sql """drop table if exists ${table};"""
+ sql new File("""regression-test/common/table/${table}.sql""").text
+ sql new File("""regression-test/common/load/${table}.sql""").text
+ }
+
+
+ qt_select_default "select 1 from test_basic_agg where 1998 like '1%';"
+ qt_select_default2 "select 1 from test_basic_agg where '1998' like '1%';"
+ qt_select_default3 "select 1 from test_basic_agg where 2998 like '1%';"
+ qt_select_default4 "select 1 from test_basic_agg where '2998' like '1%';"
+ qt_select_default "select 1 from test_basic_agg where 199.8 like '1%';"
+ qt_select_default2 "select 1 from test_basic_agg where '199.8' like '1%';"
+ qt_select_default3 "select 1 from test_basic_agg where 299.8 like '1%';"
+ qt_select_default4 "select 1 from test_basic_agg where '299.8' like '1%';"
+}
\ No newline at end of file
diff --git
a/regression-test/suites/query_p0/sql_functions/convertion_functions/sql/castAccessible.sql
b/regression-test/suites/query_p0/sql_functions/convertion_functions/sql/castAccessible.sql
new file mode 100644
index 0000000000..5f544ab0ed
--- /dev/null
+++
b/regression-test/suites/query_p0/sql_functions/convertion_functions/sql/castAccessible.sql
@@ -0,0 +1,2 @@
+-- database: presto; groups: qe, conversion_functions
+SELECT CAST(10 as VARCHAR)
diff --git
a/regression-test/suites/query_p0/sql_functions/horology_functions/sql/atTimeZoneAccessible.sql
b/regression-test/suites/query_p0/sql_functions/horology_functions/sql/atTimeZoneAccessible.sql
new file mode 100644
index 0000000000..17e6c490c6
--- /dev/null
+++
b/regression-test/suites/query_p0/sql_functions/horology_functions/sql/atTimeZoneAccessible.sql
@@ -0,0 +1,5 @@
+/*
+-- database: presto; groups: qe, horology_functions
+SELECT timezone_hour(TIMESTAMP '2001-08-22 03:04:05.321' at time zone
'Asia/Oral'),
+ timezone_minute(TIMESTAMP '2001-08-22 03:04:05.321' at time zone
'Asia/Oral')
+*/
diff --git
a/regression-test/suites/query_p0/sql_functions/horology_functions/sql/dateTimeOperatorsAccessible.sql
b/regression-test/suites/query_p0/sql_functions/horology_functions/sql/dateTimeOperatorsAccessible.sql
new file mode 100644
index 0000000000..47da54a552
--- /dev/null
+++
b/regression-test/suites/query_p0/sql_functions/horology_functions/sql/dateTimeOperatorsAccessible.sql
@@ -0,0 +1,7 @@
+-- database: presto; groups: qe, horology_functions
+SELECT date '2012-08-08' + interval '2' day,
+ timestamp '2012-08-08 01:00' + interval '29' hour,
+ timestamp '2012-10-31 01:00' + interval '1' month,
+ date '2012-08-08' - interval '2' day,
+ timestamp '2012-08-08 01:00' - interval '29' hour,
+ timestamp '2012-10-31 01:00' - interval '1' month
diff --git
a/regression-test/suites/query_p0/sql_functions/horology_functions/sql/extractAccessible.sql
b/regression-test/suites/query_p0/sql_functions/horology_functions/sql/extractAccessible.sql
new file mode 100644
index 0000000000..4bba9ae39a
--- /dev/null
+++
b/regression-test/suites/query_p0/sql_functions/horology_functions/sql/extractAccessible.sql
@@ -0,0 +1,2 @@
+-- database: presto; groups: qe, horology_functions
+SELECT extract(day from TIMESTAMP '2001-08-22 03:04:05.321')
\ No newline at end of file
diff --git a/regression-test/suites/rollup_p0/test_materialized_view.groovy
b/regression-test/suites/rollup_p0/test_materialized_view.groovy
index 24014407aa..e37ab9064a 100644
--- a/regression-test/suites/rollup_p0/test_materialized_view.groovy
+++ b/regression-test/suites/rollup_p0/test_materialized_view.groovy
@@ -105,7 +105,7 @@ suite("test_materialized_view") {
}
}
sql "SELECT store_id, count(sale_amt) FROM ${tbName1} GROUP BY store_id;"
- qt_sql "DESC ${tbName1} ALL;"
+ order_qt_sql "DESC ${tbName1} ALL;"
qt_sql "SELECT store_id, count(sale_amt) FROM ${tbName1} GROUP BY
store_id;"
@@ -116,5 +116,4 @@ suite("test_materialized_view") {
sql "DROP TABLE ${tbName1} FORCE;"
sql "DROP TABLE ${tbName2} FORCE;"
-
}
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
