This is an automated email from the ASF dual-hosted git repository.
morningman pushed a commit to branch branch-1.2-lts
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/branch-1.2-lts by this push:
new b62e4a19b60 [branch1.2](test) fix test cases
b62e4a19b60 is described below
commit b62e4a19b6079de54ebf35d7d25638725313e32a
Author: morningman <[email protected]>
AuthorDate: Sun Oct 8 22:46:46 2023 +0800
[branch1.2](test) fix test cases
---
.../data/query_p0/union/test_union_decimal_agg.out | 4 ++--
regression-test/suites/correctness_p0/test_cast_null.groovy | 4 +---
.../test_inlineview_with_window_function.groovy | 12 ++++++------
regression-test/suites/query_p0/having/having.groovy | 6 ++----
4 files changed, 11 insertions(+), 15 deletions(-)
diff --git a/regression-test/data/query_p0/union/test_union_decimal_agg.out
b/regression-test/data/query_p0/union/test_union_decimal_agg.out
index 8766fa2a02a..03e06447557 100644
--- a/regression-test/data/query_p0/union/test_union_decimal_agg.out
+++ b/regression-test/data/query_p0/union/test_union_decimal_agg.out
@@ -1,7 +1,7 @@
-- This file is automatically generated. You should know what you did if you
want to edit this
-- !decimal_union_agg1 --
-4.80
+4.8071153846153845
-- !decimal_union_agg2 --
-4.80
+4.8071153846153845
diff --git a/regression-test/suites/correctness_p0/test_cast_null.groovy
b/regression-test/suites/correctness_p0/test_cast_null.groovy
index f6761c8b90b..66feeda8784 100644
--- a/regression-test/suites/correctness_p0/test_cast_null.groovy
+++ b/regression-test/suites/correctness_p0/test_cast_null.groovy
@@ -29,11 +29,9 @@ suite("test_cast_null") {
DISTRIBUTED BY HASH(`k1`) BUCKETS 1
PROPERTIES (
"replication_allocation" = "tag.location.default: 1",
- "is_being_synced" = "false",
"storage_format" = "V2",
"light_schema_change" = "true",
- "disable_auto_compaction" = "false",
- "enable_single_replica_compaction" = "false"
+ "disable_auto_compaction" = "false"
);
"""
sql """insert into test_table_t1 values(1.0);"""
diff --git
a/regression-test/suites/correctness_p0/test_inlineview_with_window_function.groovy
b/regression-test/suites/correctness_p0/test_inlineview_with_window_function.groovy
index cdeb65e9ec5..811d87cacf3 100644
---
a/regression-test/suites/correctness_p0/test_inlineview_with_window_function.groovy
+++
b/regression-test/suites/correctness_p0/test_inlineview_with_window_function.groovy
@@ -76,7 +76,7 @@ suite("test_inlineview_with_window_function") {
sql """CREATE TABLE `test_table_aaa` (
`ordernum` varchar(65533) NOT NULL ,
`dnt` datetime NOT NULL ,
- `data` json NULL
+ `data` jsonb NULL
) ENGINE=OLAP
DUPLICATE KEY(`ordernum`, `dnt`)
COMMENT 'OLAP'
@@ -136,11 +136,11 @@ suite("test_inlineview_with_window_function") {
max(fzl)*1600*0.278 solar
from(
select ordernum,dnt,
- cast(if(json_extract(data,'\$.LJRL1')=0 or
json_extract(data,'\$.LJRL1') like '%E%',null,json_extract(data,'\$.LJRL1')) as
double) ljrl1,
- cast(if(json_extract(data,'\$.LJRL2')=0 or
json_extract(data,'\$.LJRL2') like '%E%',null,json_extract(data,'\$.LJRL2')) as
double) ljrl2,
- first_value(cast(if(json_extract(data,'\$.FZL')=0
or json_extract(data,'\$.FZL') like '%E%',null,
- json_extract(data,'\$.FZL')) as double)) over
(partition by ordernum order by dnt desc) fzl,
- cast(if(json_extract(data,'\$.DB1')=0 or
json_extract(data,'\$.DB1') like '%E%',null,json_extract(data,'\$.DB1')) as
double) db1
+ cast(if(jsonb_extract_double(data,'\$.LJRL1')=0 or
jsonb_extract_double(data,'\$.LJRL1') like
'%E%',null,jsonb_extract_double(data,'\$.LJRL1')) as double) ljrl1,
+ cast(if(jsonb_extract_double(data,'\$.LJRL2')=0 or
jsonb_extract_double(data,'\$.LJRL2') like
'%E%',null,jsonb_extract_double(data,'\$.LJRL2')) as double) ljrl2,
+
first_value(cast(if(jsonb_extract_double(data,'\$.FZL')=0 or
jsonb_extract_double(data,'\$.FZL') like '%E%',null,
+ jsonb_extract_double(data,'\$.FZL')) as double))
over (partition by ordernum order by dnt desc) fzl,
+ cast(if(jsonb_extract_double(data,'\$.DB1')=0 or
jsonb_extract_double(data,'\$.DB1') like
'%E%',null,jsonb_extract_double(data,'\$.DB1')) as double) db1
from test_table_aaa
)a1
group by ordernum
diff --git a/regression-test/suites/query_p0/having/having.groovy
b/regression-test/suites/query_p0/having/having.groovy
index 2cb0755d542..cf5813ec22f 100644
--- a/regression-test/suites/query_p0/having/having.groovy
+++ b/regression-test/suites/query_p0/having/having.groovy
@@ -35,15 +35,13 @@ suite("having") {
DISTRIBUTED BY HASH(`s_suppkey`) BUCKETS 12
PROPERTIES (
"replication_allocation" = "tag.location.default: 1",
- "is_being_synced" = "false",
"storage_format" = "V2",
"light_schema_change" = "true",
- "disable_auto_compaction" = "false",
- "enable_single_replica_compaction" = "false"
+ "disable_auto_compaction" = "false"
); """
sql """explain
select count(*)
from supplier s
group by s_nationkey,s_suppkey
having s_nationkey=1 or s_suppkey=1;"""
-}
\ No newline at end of file
+}
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
