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 5797ad9bf73 [regression-test](VariantType) fix and disable unstable
case (#31269)
5797ad9bf73 is described below
commit 5797ad9bf73d7caa29877fead213bc0de50f7ffd
Author: lihangyu <[email protected]>
AuthorDate: Thu Feb 22 18:21:35 2024 +0800
[regression-test](VariantType) fix and disable unstable case (#31269)
---
.../test_double_write_when_schema_change.groovy | 4 +-
...heListOfTopRepositoriesChangedOverTheYears7.sql | 59 +++++++++++-----------
regression-test/suites/variant_p2/sql/sql08.sql | 2 +-
3 files changed, 33 insertions(+), 32 deletions(-)
diff --git
a/regression-test/suites/variant_p0/schema_change/test_double_write_when_schema_change.groovy
b/regression-test/suites/variant_p0/schema_change/test_double_write_when_schema_change.groovy
index 923f7ee49da..91e94fcc40a 100644
---
a/regression-test/suites/variant_p0/schema_change/test_double_write_when_schema_change.groovy
+++
b/regression-test/suites/variant_p0/schema_change/test_double_write_when_schema_change.groovy
@@ -110,7 +110,7 @@ suite("double_write_schema_change_with_variant") {
double_write.call()
qt_sql "select v['type'], v['id'], v['created_at'] from ${table_name}
where cast(v['id'] as bigint) != 25061216922 order by k, cast(v['id'] as
bigint) limit 10"
- createMV("create materialized view xxx as select k, sum(k) from
${table_name} group by k order by k;")
- qt_sql "select v['type'], v['id'], v['created_at'] from ${table_name}
where cast(v['id'] as bigint) != 25061216922 order by k, cast(v['id'] as
bigint) limit 10"
+ // createMV("create materialized view xxx as select k, sum(k) from
${table_name} group by k order by k;")
+ // qt_sql "select v['type'], v['id'], v['created_at'] from ${table_name}
where cast(v['id'] as bigint) != 25061216922 order by k, cast(v['id'] as
bigint) limit 10"
set_be_config.call("memory_limitation_per_thread_for_schema_change_bytes",
"2147483648")
}
diff --git
a/regression-test/suites/variant_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears7.sql
b/regression-test/suites/variant_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears7.sql
index 71ef817ecb4..49e38bd742d 100644
---
a/regression-test/suites/variant_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears7.sql
+++
b/regression-test/suites/variant_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears7.sql
@@ -1,29 +1,30 @@
-SELECT
- repo_name,
- year,
- cnt
-FROM
-(
- SELECT
- row_number() OVER (PARTITION BY year ORDER BY cnt DESC) AS r,
- repo_name,
- year,
- cnt
- FROM
- (
- SELECT
- lower(cast(repo["name"] as string)) AS repo_name,
- year(created_at) AS year,
- count() AS cnt
- FROM github_events
- WHERE (type = 'WatchEvent') AND (year(created_at) >= 2015)
- GROUP BY
- repo_name,
- year
- ) t
-) t2
-WHERE r <= 10
-ORDER BY
- year ASC,
- cnt DESC,
- repo_name
+-- SELECT
+-- repo_name,
+-- year,
+-- cnt
+-- FROM
+-- (
+-- SELECT
+-- row_number() OVER (PARTITION BY year ORDER BY cnt DESC) AS r,
+-- repo_name,
+-- year,
+-- cnt
+-- FROM
+-- (
+-- SELECT
+-- lower(cast(repo["name"] as string)) AS repo_name,
+-- year(created_at) AS year,
+-- count() AS cnt
+-- FROM github_events
+-- WHERE (type = 'WatchEvent') AND (year(created_at) >= 2015)
+-- GROUP BY
+-- repo_name,
+-- year
+-- ) t
+-- ) t2
+-- WHERE r <= 10
+-- ORDER BY
+-- year ASC,
+-- cnt DESC,
+-- repo_name
+--
\ No newline at end of file
diff --git a/regression-test/suites/variant_p2/sql/sql08.sql
b/regression-test/suites/variant_p2/sql/sql08.sql
index cfd3030b9e9..6ee54078c99 100644
--- a/regression-test/suites/variant_p2/sql/sql08.sql
+++ b/regression-test/suites/variant_p2/sql/sql08.sql
@@ -1 +1 @@
-SELECT payload["issue"].user FROM github_events WHERE
cast(payload["issue"]["state"] as string) = "open" and
cast(payload["issue"].locked as int) = 0 order by cast(repo["id"] as int), id
limit 10;
+-- SELECT payload["issue"].user FROM github_events WHERE
cast(payload["issue"]["state"] as string) = "open" and
cast(payload["issue"].locked as int) = 0 order by cast(repo["id"] as int), id
limit 10;
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
