This is an automated email from the ASF dual-hosted git repository.
yiguolei pushed a commit to branch branch-2.1
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/branch-2.1 by this push:
new b662b346fda branch-2.1: [fix](test) fix regression test same table
name in one database #50737 (#50779)
b662b346fda is described below
commit b662b346fdaea659a51637cdd86e83a03087afe9
Author: github-actions[bot]
<41898282+github-actions[bot]@users.noreply.github.com>
AuthorDate: Sat May 10 12:18:35 2025 +0800
branch-2.1: [fix](test) fix regression test same table name in one database
#50737 (#50779)
Cherry-picked from #50737
Co-authored-by: feiniaofeiafei <[email protected]>
---
.../eliminate_constant_gby_key.groovy | 26 +++++++++++-----------
1 file changed, 13 insertions(+), 13 deletions(-)
diff --git
a/regression-test/suites/nereids_rules_p0/eliminate_gby_key/eliminate_constant_gby_key.groovy
b/regression-test/suites/nereids_rules_p0/eliminate_gby_key/eliminate_constant_gby_key.groovy
index 3158e2ceded..87c7ec377e4 100644
---
a/regression-test/suites/nereids_rules_p0/eliminate_gby_key/eliminate_constant_gby_key.groovy
+++
b/regression-test/suites/nereids_rules_p0/eliminate_gby_key/eliminate_constant_gby_key.groovy
@@ -16,8 +16,8 @@
// under the License.
suite("eliminate_constant_gby_key") {
- sql """DROP TABLE IF EXISTS t1;"""
- sql """CREATE TABLE t1 (
+ sql """DROP TABLE IF EXISTS eliminate_constant_gby_key_t;"""
+ sql """CREATE TABLE eliminate_constant_gby_key_t (
c1 INT,
c2 VARCHAR(50),
c3 DECIMAL(10,2),
@@ -25,7 +25,7 @@ suite("eliminate_constant_gby_key") {
c5 BOOLEAN
) distributed by hash(c1) properties("replication_num"="1");"""
- sql """INSERT INTO t1 (c1, c2, c3, c4, c5) VALUES
+ sql """INSERT INTO eliminate_constant_gby_key_t (c1, c2, c3, c4, c5)
VALUES
(1, 'Apple', 10.50, '2023-01-01 10:00:00', true),
(2, 'Banana', 20.75, '2023-01-02 11:30:00', false),
(3, 'Cherry', 15.25, '2023-01-03 09:15:00', true),
@@ -53,7 +53,7 @@ suite("eliminate_constant_gby_key") {
${funA} AS funA,
c1,
${funA} + c1 AS 'funA+c1'
- FROM t1
+ FROM eliminate_constant_gby_key_t
GROUP BY ${funA}, c1
ORDER BY 1, 2, 3
""" }],
@@ -64,7 +64,7 @@ suite("eliminate_constant_gby_key") {
${funA} AS funA,
c1,
${funA} + c1 AS 'funA+c1'
- FROM t1
+ FROM eliminate_constant_gby_key_t
GROUP BY ${funA}, c1, ${funA} + c1
ORDER BY 1, 2, 3
""" }],
@@ -75,7 +75,7 @@ suite("eliminate_constant_gby_key") {
COUNT(DISTINCT ${funA}) AS 'count(distinct funA)',
${funA} AS funA,
c1
- FROM t1
+ FROM eliminate_constant_gby_key_t
GROUP BY ${funA}, c1
ORDER BY 1, 2, 3
""" }],
@@ -86,7 +86,7 @@ suite("eliminate_constant_gby_key") {
COUNT(${funA}) AS 'count(funA)',
${funA} AS funA,
c1
- FROM t1
+ FROM eliminate_constant_gby_key_t
GROUP BY ${funA}, c1
ORDER BY 1, 2, 3
""" }],
@@ -97,7 +97,7 @@ suite("eliminate_constant_gby_key") {
COUNT(DISTINCT ${funA} + 1) AS 'count(distinct funA+1)',
${funA} AS funA,
c1
- FROM t1
+ FROM eliminate_constant_gby_key_t
GROUP BY ${funA}, c1
ORDER BY 1, 2, 3
""" }],
@@ -108,7 +108,7 @@ suite("eliminate_constant_gby_key") {
MAX(${funA} + 1) AS 'max(funA+1)',
${funA} AS funA,
c1
- FROM t1
+ FROM eliminate_constant_gby_key_t
GROUP BY ${funA}, c1
ORDER BY 1, 2, 3
""" }],
@@ -119,7 +119,7 @@ suite("eliminate_constant_gby_key") {
MAX(${funA} + c1) AS 'max(funA+c1)',
${funA} AS funA,
c2
- FROM t1
+ FROM eliminate_constant_gby_key_t
GROUP BY ${funA}, c2
ORDER BY 1, 2, 3
""" }]
@@ -138,7 +138,7 @@ suite("eliminate_constant_gby_key") {
count(DISTINCT from_unixtime(1742860744.003242)) AS 'max(distinct
funA)',
from_unixtime(1742860744.003242) AS funA,
c1
- FROM t1
+ FROM eliminate_constant_gby_key_t
GROUP BY from_unixtime(1742860744.003242), c1
order by 1,2,3
"""
@@ -152,7 +152,7 @@ suite("eliminate_constant_gby_key") {
WHEN (c4 < '2024-01-01') THEN '2026-02-18'
ELSE DATE_ADD(c4, INTERVAL 365 DAY) END))
c1
- FROM t1
+ FROM eliminate_constant_gby_key_t
GROUP BY from_unixtime(1742860744.003242), (TO_DATE(CASE
WHEN ('2024-01-08' < '2024-02-18') THEN '2023-12-19'
WHEN (c4 < '2024-01-01') THEN '2026-02-18'
@@ -165,7 +165,7 @@ suite("eliminate_constant_gby_key") {
from_unixtime(1742860744.003242),
from_unixtime(1742860744.003242)
c1
- FROM t1
+ FROM eliminate_constant_gby_key_t
GROUP BY from_unixtime(1742860744.003242),
from_unixtime(1742860744.003242),'abc',c1
order by 1,2,3,4
"""
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
