This is an automated email from the ASF dual-hosted git repository.
lijibing 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 92d580b6e52 [fix](p0)Fix point query case (#53488)
92d580b6e52 is described below
commit 92d580b6e5290399beeb062d2cdda387f0609863
Author: James <[email protected]>
AuthorDate: Fri Jul 18 18:05:27 2025 +0800
[fix](p0)Fix point query case (#53488)
### What problem does this PR solve?
Fix point query case
---
.../data/point_query_p0/test_point_query.out | Bin 9946 -> 9949 bytes
.../suites/point_query_p0/test_point_query.groovy | 13 +++++++++++++
2 files changed, 13 insertions(+)
diff --git a/regression-test/data/point_query_p0/test_point_query.out
b/regression-test/data/point_query_p0/test_point_query.out
index 60aff86a589..72dc8c310f1 100644
Binary files a/regression-test/data/point_query_p0/test_point_query.out and
b/regression-test/data/point_query_p0/test_point_query.out differ
diff --git a/regression-test/suites/point_query_p0/test_point_query.groovy
b/regression-test/suites/point_query_p0/test_point_query.groovy
index 04afed2ed74..dc8a7f01679 100644
--- a/regression-test/suites/point_query_p0/test_point_query.groovy
+++ b/regression-test/suites/point_query_p0/test_point_query.groovy
@@ -204,6 +204,7 @@ suite("test_point_query", "nonConcurrent") {
"""
sleep(1);
nprep_sql """ INSERT INTO ${tableName} VALUES(1235,
120939.11130, "a ddd", "laooq", "2030-01-02", "2020-01-01 12:36:38", 22.822,
"7022-01-01 11:30:38", 1, 1.1111299, [119291.19291], ["111", "222", "333"], 1)
"""
+ stmt = prepareStatement "select /*+
SET_VAR(enable_nereids_planner=true) */ * from ${tableName} where k1 = ? and k2
= ? and k3 = ?"
stmt.setBigDecimal(1, 1235)
stmt.setBigDecimal(2, new BigDecimal("120939.11130"))
stmt.setString(3, "a ddd")
@@ -218,11 +219,19 @@ suite("test_point_query", "nonConcurrent") {
nprep_sql """
ALTER table ${tableName} ADD COLUMN new_column1 INT default
"0";
"""
+ stmt = prepareStatement "select /*+
SET_VAR(enable_nereids_planner=true) */ * from ${tableName} where k1 = ? and k2
= ? and k3 = ?"
+ stmt.setBigDecimal(1, 1235)
+ stmt.setBigDecimal(2, new BigDecimal("120939.11130"))
+ stmt.setString(3, "a ddd")
qe_point_select stmt
qe_point_select stmt
nprep_sql """
ALTER table ${tableName} DROP COLUMN new_column1;
"""
+ stmt = prepareStatement "select /*+
SET_VAR(enable_nereids_planner=true) */ * from ${tableName} where k1 = ? and k2
= ? and k3 = ?"
+ stmt.setBigDecimal(1, 1235)
+ stmt.setBigDecimal(2, new BigDecimal("120939.11130"))
+ stmt.setString(3, "a ddd")
qe_point_select stmt
qe_point_select stmt
@@ -230,6 +239,10 @@ suite("test_point_query", "nonConcurrent") {
ALTER table ${tableName} ADD COLUMN new_column1 INT default
"0";
"""
sql "select 1"
+ stmt = prepareStatement "select /*+
SET_VAR(enable_nereids_planner=true) */ * from ${tableName} where k1 = ? and k2
= ? and k3 = ?"
+ stmt.setBigDecimal(1, 1235)
+ stmt.setBigDecimal(2, new BigDecimal("120939.11130"))
+ stmt.setString(3, "a ddd")
qe_point_select stmt
}
// disable useServerPrepStmts
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
