This is an automated email from the ASF dual-hosted git repository.
dataroaring 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 e66491df22a [fix](partition) Fix test partition regression case
unstabitily (#37439)
e66491df22a is described below
commit e66491df22a575430ae13d2833c501bdd74240b1
Author: deardeng <[email protected]>
AuthorDate: Mon Jul 8 17:38:58 2024 +0800
[fix](partition) Fix test partition regression case unstabitily (#37439)
---
.../multi_partition/test_multi_partition.groovy | 16 ++++++++--------
.../multi_partition/test_range_partition.groovy | 12 ++++++------
2 files changed, 14 insertions(+), 14 deletions(-)
diff --git
a/regression-test/suites/partition_p0/multi_partition/test_multi_partition.groovy
b/regression-test/suites/partition_p0/multi_partition/test_multi_partition.groovy
index 3dd698c03da..18e3a09fdc1 100644
---
a/regression-test/suites/partition_p0/multi_partition/test_multi_partition.groovy
+++
b/regression-test/suites/partition_p0/multi_partition/test_multi_partition.groovy
@@ -469,7 +469,7 @@ suite("test_multi_partition") {
// create one table without datetime partition, but with date string
sql """set enable_fallback_to_original_planner=false"""
sql """
- CREATE TABLE IF NOT EXISTS range_date_cast_to_datetime (
+ CREATE TABLE IF NOT EXISTS range_date_cast_to_datetime_multi_partition
(
id int,
name string,
pdate DATETIME )
@@ -478,18 +478,18 @@ suite("test_multi_partition") {
)
DISTRIBUTED BY HASH(id) BUCKETS 1 properties("replication_num" = "1")
"""
- result1 = sql "show tables like 'range_date_cast_to_datetime'"
+ result1 = sql "show tables like
'range_date_cast_to_datetime_multi_partition'"
logger.info("${result1}")
assertEquals(result1.size(), 1)
- result2 = sql "show partitions from range_date_cast_to_datetime"
+ result2 = sql "show partitions from
range_date_cast_to_datetime_multi_partition"
logger.info("${result2}")
assertEquals(result2.size(), 4)
assertTrue(result2[1][1].startsWith("p_"))
- sql "drop table range_date_cast_to_datetime"
+ sql "drop table range_date_cast_to_datetime_multi_partition"
sql """set enable_fallback_to_original_planner=true"""
sql """
- CREATE TABLE IF NOT EXISTS range_date_cast_to_datetime (
+ CREATE TABLE IF NOT EXISTS range_date_cast_to_datetime_multi_partition
(
id int,
name string,
pdate DATETIME )
@@ -498,12 +498,12 @@ suite("test_multi_partition") {
)
DISTRIBUTED BY HASH(id) BUCKETS 1 properties("replication_num" = "1")
"""
- result1 = sql "show tables like 'range_date_cast_to_datetime'"
+ result1 = sql "show tables like
'range_date_cast_to_datetime_multi_partition'"
logger.info("${result1}")
assertEquals(result1.size(), 1)
- result2 = sql "show partitions from range_date_cast_to_datetime"
+ result2 = sql "show partitions from
range_date_cast_to_datetime_multi_partition"
logger.info("${result2}")
assertEquals(result2.size(), 4)
assertTrue(result2[1][1].startsWith("p_"))
- sql "drop table range_date_cast_to_datetime"
+ sql "drop table range_date_cast_to_datetime_multi_partition"
}
diff --git
a/regression-test/suites/partition_p0/multi_partition/test_range_partition.groovy
b/regression-test/suites/partition_p0/multi_partition/test_range_partition.groovy
index c9e75718e38..ca58653b75b 100644
---
a/regression-test/suites/partition_p0/multi_partition/test_range_partition.groovy
+++
b/regression-test/suites/partition_p0/multi_partition/test_range_partition.groovy
@@ -299,7 +299,7 @@ suite("test_range_partition", "p0") {
// create one table without datetime partition, but with date string
sql """set enable_fallback_to_original_planner=false"""
sql """
- CREATE TABLE IF NOT EXISTS range_date_cast_to_datetime (
+ CREATE TABLE IF NOT EXISTS range_date_cast_to_datetime_range_partition
(
id int,
name string,
pdate DATETIME )
@@ -308,12 +308,12 @@ suite("test_range_partition", "p0") {
)
DISTRIBUTED BY HASH(id) BUCKETS 1 properties("replication_num" = "1")
"""
- sql "insert into range_date_cast_to_datetime values (1, 'name',
'2023-04-19 08:08:30')"
- sql "drop table range_date_cast_to_datetime"
+ sql "insert into range_date_cast_to_datetime_range_partition values (1,
'name', '2023-04-19 08:08:30')"
+ sql "drop table range_date_cast_to_datetime_range_partition"
sql """set enable_fallback_to_original_planner=true"""
sql """
- CREATE TABLE IF NOT EXISTS range_date_cast_to_datetime (
+ CREATE TABLE IF NOT EXISTS range_date_cast_to_datetime_range_partition
(
id int,
name string,
pdate DATETIME )
@@ -322,6 +322,6 @@ suite("test_range_partition", "p0") {
)
DISTRIBUTED BY HASH(id) BUCKETS 1 properties("replication_num" = "1")
"""
- sql "insert into range_date_cast_to_datetime values (1, 'name',
'2023-04-19 08:08:30')"
- sql "drop table range_date_cast_to_datetime"
+ sql "insert into range_date_cast_to_datetime_range_partition values (1,
'name', '2023-04-19 08:08:30')"
+ sql "drop table range_date_cast_to_datetime_range_partition"
}
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
