This is an automated email from the ASF dual-hosted git repository.
eldenmoon 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 c529564f6b7 [regression-test](cases) fix some unstable cases (#41935)
c529564f6b7 is described below
commit c529564f6b70cbf61d4a9f56ee5761c431486df0
Author: lihangyu <[email protected]>
AuthorDate: Thu Oct 17 23:49:00 2024 +0800
[regression-test](cases) fix some unstable cases (#41935)
---
.../data/variant_p0/variant_hirachinal.out | 6 ++---
.../suites/point_query_p0/test_rowstore_ck.groovy | 10 +++----
regression-test/suites/variant_p0/load.groovy | 31 +++++++++++-----------
.../suites/variant_p0/variant_hirachinal.groovy | 6 ++---
4 files changed, 27 insertions(+), 26 deletions(-)
diff --git a/regression-test/data/variant_p0/variant_hirachinal.out
b/regression-test/data/variant_p0/variant_hirachinal.out
index 24bf01e52cb..7e988ee5e9b 100644
--- a/regression-test/data/variant_p0/variant_hirachinal.out
+++ b/regression-test/data/variant_p0/variant_hirachinal.out
@@ -12,7 +12,7 @@
6 {"a":1234,"xxxx":"kaana"}
-- !sql --
-[1,2,3]
+[1, 2, 3]
{"c":456,"d":"null","e":7.111}
-- !sql --
@@ -21,11 +21,11 @@
-- !sql1 --
12345
-[1,2,3]
+[1, 2, 3]
{"c":456,"d":"null","e":7.111}
-- !sql2 --
12345
-[1,2,3]
+[1, 2, 3]
{"c":456,"d":"null","e":7.111}
diff --git a/regression-test/suites/point_query_p0/test_rowstore_ck.groovy
b/regression-test/suites/point_query_p0/test_rowstore_ck.groovy
index bee9f634b88..82968e2aae5 100644
--- a/regression-test/suites/point_query_p0/test_rowstore_ck.groovy
+++ b/regression-test/suites/point_query_p0/test_rowstore_ck.groovy
@@ -314,10 +314,10 @@ suite("test_rowstore_ck", "p0,nonConcurrent") {
insert into rs_query_ck values (1, 'abc', 1111919.12345678919), (2,
'abc', 1111919.12345678919);
analyze table rs_query_ck with sync;
"""
- explain {
- sql("select * from rs_query_ck order by k1 limit 1")
- contains "TOPN OPT"
- }
+ // explain {
+ // sql("select * from rs_query_ck order by k1 limit 1")
+ // contains "TOPN OPT"
+ // }
qt_sql """select * from rs_query_ck order by k1 limit 1"""
sql """
@@ -336,7 +336,7 @@ suite("test_rowstore_ck", "p0,nonConcurrent") {
sql "set global enable_short_circuit_query_access_column_store = false"
test {
- sql "select * from table_with_column_group where k1 = 1"
+ sql "select * from table_with_column_group_ck where k1 = 1"
exception("Not support column store")
}
sql "set global enable_short_circuit_query_access_column_store = true"
diff --git a/regression-test/suites/variant_p0/load.groovy
b/regression-test/suites/variant_p0/load.groovy
index 8f4b9a3cee5..e79a58f8a7a 100644
--- a/regression-test/suites/variant_p0/load.groovy
+++ b/regression-test/suites/variant_p0/load.groovy
@@ -446,22 +446,23 @@ suite("regression_test_variant", "p0"){
exception("Invalid type for variant column: 36")
}
- test {
- sql """
- create table var(
- `key` int,
- `content` variant
- )
- DUPLICATE KEY(`key`)
- distributed by hash(`key`) buckets 8
- properties(
- "replication_allocation" = "tag.location.default: 1",
- "light_schema_change" = "false"
- );
- """
- exception("errCode = 2, detailMessage = Variant type rely on light
schema change")
+ if (!isCloudMode()) {
+ test {
+ sql """
+ create table var(
+ `key` int,
+ `content` variant
+ )
+ DUPLICATE KEY(`key`)
+ distributed by hash(`key`) buckets 8
+ properties(
+ "replication_allocation" = "tag.location.default: 1",
+ "light_schema_change" = "false"
+ );
+ """
+ exception("errCode = 2, detailMessage = Variant type rely on
light schema change")
+ }
}
-
} finally {
// reset flags
}
diff --git a/regression-test/suites/variant_p0/variant_hirachinal.groovy
b/regression-test/suites/variant_p0/variant_hirachinal.groovy
index b06d0ec6702..a942150e57f 100644
--- a/regression-test/suites/variant_p0/variant_hirachinal.groovy
+++ b/regression-test/suites/variant_p0/variant_hirachinal.groovy
@@ -43,9 +43,9 @@ suite("regression_test_variant_hirachinal", "variant_type"){
sql """insert into ${table_name} select -2, '{"a": 11245, "b" : [123,
{"xx" : 1}], "c" : {"c" : 456, "d" : "null", "e" : 7.111}}' as json_str
union all select -1, '{"a": 1123}' as json_str union all select
*, '{"a" : 1234, "xxxx" : "kaana"}' as json_str from numbers("number" = "4096")
limit 4096 ;"""
qt_sql "select * from ${table_name} order by k limit 10"
- qt_sql "select v['c'] from ${table_name} where k = -3 or k = -2 order by k"
+ qt_sql "select cast(v['c'] as string) from ${table_name} where k = -3 or k
= -2 order by k"
qt_sql "select v['b'] from ${table_name} where k = -3 or k = -2"
sql """insert into ${table_name} values (-3, '{"c" : 12345}')"""
- order_qt_sql1 "select v['c'] from var_rs where k = -3 or k = -2 or k = -4
or (k = 1 and v['c'] = 1024) order by k"
- order_qt_sql2 "select v['c'] from var_rs where k = -3 or k = -2 or k = 1
order by k, cast(v['c'] as text) limit 3"
+ order_qt_sql1 "select cast(v['c'] as string) from var_rs where k = -3 or k
= -2 or k = -4 or (k = 1 and v['c'] = 1024) order by k"
+ order_qt_sql2 "select cast(v['c'] as string) from var_rs where k = -3 or k
= -2 or k = 1 order by k, cast(v['c'] as text) limit 3"
}
\ No newline at end of file
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
